php wont insert into ...
Posted: Sun Feb 01, 2009 7:37 pm
Hello:
I am trying to get my insert into mysql to work and it just plain does not work. I have copied the insert part into a text file and manually executed the code via source and it works but for some reason it won't via php. Is there someting I am missing or not getting?
<?php
// Loop to pass the variables from previous script
//
foreach (array_keys($_POST) as $key)
{
$$key = $_POST[$key];
//print "$key is ${$key}<br />";
print "$key ==> ${$key}<br />";
}
//
//
mysql_connect("localhost", "root", "xxxxxxxxx") or die('Could not connect: ');
mysql_select_db("test") or die('Could not connect again: ');
//
$sql = ("INSERT INTO tblnadda (tblNADA_User01,tblNADA_User02) VALUES ('namef','namem')") or die('Could not add records ');
$result = mysql_query("SELECT * FROM tblnadda");
$num_rows = mysql_num_rows($result);
echo "$num_rows Rows\n";
//
?>
I am trying to get my insert into mysql to work and it just plain does not work. I have copied the insert part into a text file and manually executed the code via source and it works but for some reason it won't via php. Is there someting I am missing or not getting?
<?php
// Loop to pass the variables from previous script
//
foreach (array_keys($_POST) as $key)
{
$$key = $_POST[$key];
//print "$key is ${$key}<br />";
print "$key ==> ${$key}<br />";
}
//
//
mysql_connect("localhost", "root", "xxxxxxxxx") or die('Could not connect: ');
mysql_select_db("test") or die('Could not connect again: ');
//
$sql = ("INSERT INTO tblnadda (tblNADA_User01,tblNADA_User02) VALUES ('namef','namem')") or die('Could not add records ');
$result = mysql_query("SELECT * FROM tblnadda");
$num_rows = mysql_num_rows($result);
echo "$num_rows Rows\n";
//
?>