Ievieto tekstu datubāzē!

[zintis8789]

Es meiģinu ievietot .csv failu tur ir iekšā vārds: D'Agostini .Vins to nesaprot un man uzmet erroru:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\AppServ\www\csv\index.php on line 24
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Agostini Matt','MTL','Player','1','13:39','0','0','0','-2','0','0','0','3','0')' at line 1

Bet parejos vārdus vinš iemet datubāzē.

Edited November 17, 2009 by zintis8789

[rATRIJS]

Pirms mešanas datu bāzē vajadzētu izdarīt tādu mazu lietiņu kā - mysql_real_escape_string()

[zintis8789]

Tagad man met šādu erroru:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\AppServ\www\csv\index.php on line 24

[Aleksejs]

papildini

mysql_query(...);

ar:

mysql_query(...) or die(mysql_error());

[zintis8789]

Es pieliku klāt: mysql_real_escape_string()

Bet tikuntā man rāda:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'not,team,name,note) values('1','Period','Time','Goal/Penalty','Team','Player Nam' at line 1

[Val]

ieliec te pilnu sql insertu.

[zintis8789]

     while (($data2 = fgetcsv($handle2, 1000, ",")) != FALSE)

    {

$ccm12 = mysql_real_escape_string($data2[2]);
$ccm1 = mysql_real_escape_string($data2[4]);
$ccm121 = mysql_real_escape_string($data2[5]);
$time = mysql_real_escape_string($data2[1]);
$kpp = mysql_real_escape_string($data2[3]);
$per = mysql_real_escape_string($data2[0]);


      $import2="INSERT into teamstat(id,per,time,not,team,name,note) values('$nr1','$per','$time','$ccm12','$kpp','$ccm1','$ccm121')";

      mysql_query($import2) or die(mysql_error());
      mysql_query("DELETE FROM teamstat WHERE team='Team'");
}

[Val]

biju domājis

echo $import2;

id ņem ārā, un labāk pieliec tai kolonnai autoincrement un netaisi problēmas, kur tās nav.

[zintis8789]

Izņemu arā Id bet tikuntā tas pats errors!

Edited November 18, 2009 by zintis8789

[Val]

ar $nr tas pats. un izlasi vēlreiz manu iepriekšējo postu.

[zintis8789]

Daru visu ko tu saki bet tā pat radas tas errors :(

[zintis8789]

Mazus uzlabojumus veicu un viss aizgāja ..