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