ODSKOK JINDE
ean explode sklad
Kategorie: ostatni
include("db.php");
if (isset($_POST['data']))
{
$radky= explode(PHP_EOL, $_POST['data']);
while(list($index, $s) = each($radky)){
$i++;
$s=preg_replace('!\s+!', ' ', $s);
$t=explode(" ",$s);
$ean=$t[0];
$pocet=$t[1]*1;
if ( (strlen($ean) > 2 ) and ($pocet <>0))
{
$sql= "UPDATE zbozi SET pocet = ".$pocet." WHERE ean = '".$ean."' limit 1";
mysql_query($sql);
//echo mysql_affected_rows();
$nazev=sql("SELECT nazev FROM zbozi WHERE ean = '".$ean."' limit 1","nazev");
echo $i.". ".$ean." - ".$pocet." ks"." ".$nazev."
";
}
}
}
?>
14.1.2020 18:59:39