php-mysql code doensn't work? - PHP-Editors

shams · #1 (**permalink**) 2006-04-16, 03:32 AM

hi
this is php conde for enter values to the mysql table:
<html>
<body>
<?php
$db = mysql_connect("localhost", "root");
mysql_select_db("mydb",$db);
$query="INSERT INTO student4 VALUES (NULL, "zubair", "second", 500)";

$rt=mysql_query($query);
echo mysql_error();

if($rt){echo " Command is successful ";}
else {echo " Command is not successful ";}
?>
</html>
</body>
this is the student4 table with previous entry:
mysql> select * from student4;
+----+---------+-------+------+
| id | name | class | mark |
+----+---------+-------+------+
| 1 | shakeel | first | 500 |
+----+---------+-------+------+
1 row in set (0.08 sec)
any help please?

Deus_m1k3 · #2 (**permalink**) 2006-06-16, 05:20 PM

As far as I can read everithin' I think it's ok, but why don't U try another approach??

$conection= @mysql_connect($server,$user,$pass) or die("Error [0.0]: ". mysql_error()." <br>");
@mysql_select_db($database,$conection) or die("Error [0.1]: ". mysql_error());

$sql_ins = "INSERT INTO student4 VALUES ('', "zubair", "second", 500)";
mysql_query ($sql_ins) or die ("Error [1]: ".mysql_error ());

or

$sql_ins = "INSERT INTO student4 VALUES (, "zubair", "second", 500)";
mysql_query ($sql_ins) or die ("Error [1]: ".mysql_error ());

If the id field is auto_incremet & also PK you shouldn't force it to NULL it'll create inconsistent data, hope this could help

READ YA

flann · #3 (**permalink**) 2006-07-04, 05:32 PM

I've gotten in the good habit of always listing the fields that I want to insert into, this practice eliminates a lot of bugs.

PHP Code:


			
INSERT INTO table (field1, field2, field3)
       VALUES ('$var1', '$var2', '$var3');



Sponsored by NuSphere - PHP Software for PHP Application Developers - On Sale This Week for $100