Koristim ovu dinamicku javascript/html formu i svaku tekstualnu vrednost u rastavi na reci.
Prihvatam na sledeci nacin:
Code:
$sql="";
$jedan=$_POST['jedan'];
$dva=$_POST['dva'];
for($i=0;$i<50;$i++)
{
$sql.="INSERT INTO `tabela` (`jedan`,`dva`) VALUES ('$jedan','$dva');";
}
$sql="";
$jedan=$_POST['jedan'];
$dva=$_POST['dva'];
for($i=0;$i<50;$i++)
{
$sql.="INSERT INTO `tabela` (`jedan`,`dva`) VALUES ('$jedan','$dva');";
}
Kao rezultat u bazu mi upisuje ovako:
Code:
$jedan = 0135456;
$dva="Neki tekst";
$sql.="INSERT INTO `tabela` (`jedan`,`dva`) VALUES ('0135456','N')";
$sql.="INSERT INTO `tabela` (`jedan`,`dva`) VALUES ('0135456','e')";
$sql.="INSERT INTO `tabela` (`jedan`,`dva`) VALUES ('0135456','k')";
$sql.="INSERT INTO `tabela` (`jedan`,`dva`) VALUES ('0135456','i')";
$sql.="INSERT INTO `tabela` (`jedan`,`dva`) VALUES ('0135456','t')";
$sql.="INSERT INTO `tabela` (`jedan`,`dva`) VALUES ('0135456','e')";
$sql.="INSERT INTO `tabela` (`jedan`,`dva`) VALUES ('0135456','k')";
$sql.="INSERT INTO `tabela` (`jedan`,`dva`) VALUES ('0135456','s')";
$sql.="INSERT INTO `tabela` (`jedan`,`dva`) VALUES ('0135456','t')";
$jedan = 0135456;
$dva="Neki tekst";
$sql.="INSERT INTO `tabela` (`jedan`,`dva`) VALUES ('0135456','N')";
$sql.="INSERT INTO `tabela` (`jedan`,`dva`) VALUES ('0135456','e')";
$sql.="INSERT INTO `tabela` (`jedan`,`dva`) VALUES ('0135456','k')";
$sql.="INSERT INTO `tabela` (`jedan`,`dva`) VALUES ('0135456','i')";
$sql.="INSERT INTO `tabela` (`jedan`,`dva`) VALUES ('0135456','t')";
$sql.="INSERT INTO `tabela` (`jedan`,`dva`) VALUES ('0135456','e')";
$sql.="INSERT INTO `tabela` (`jedan`,`dva`) VALUES ('0135456','k')";
$sql.="INSERT INTO `tabela` (`jedan`,`dva`) VALUES ('0135456','s')";
$sql.="INSERT INTO `tabela` (`jedan`,`dva`) VALUES ('0135456','t')";
Umesto
Code:
$sql.="INSERT INTO `tabela` (`jedan`,`dva`) VALUES ('0135456','Neki tekst')";
$sql.="INSERT INTO `tabela` (`jedan`,`dva`) VALUES ('0135456','Neki tekst')";
--
With The Best Regards,
Daniel Dulić, Web System Development
http://www.citysuteam.com
Telefon: +381 (0) 64 / 364 - 65 - 91
E-Mail: [email protected]
CitySu team, Web Services Company
Antona Aškerca 44/50,
24000 Subotica
CitySu team