Mysql Table Not Populating

mcallon

Hi all. I am a newbie who has been working hard to get my first table populated, and it's just not happening. I have poured through a number of tutorials, two books, asked my ISP, and tried every combination I can thiink of to get a single table populated to no avail.

I am sending five variables from a FLASH form using the POST method. I wrote a simple PHP script to then write the variables into a table. The script runs with no errors, but then when I check the table in phpmyadmin, the data has not actually been inserted. Can anyone help?

Here's the code:

<?php

$dbhost="localhost";
$dbusername="vecmxcco_mcallon";
$dbpassword="072599";
$dbname="vecmxcco_people";

$connect = mysql_connect($dbhost, $dbusername, $dbpassword);

mysql_select_db($dbname,$connect) or die ("Could not select database");

$firstname = $POST['firstname'];
$lastname = $POST['lastname'];
$email = $POST['email'];
$usrname = $POST['usrname'];
$pass = $_POST['pass'];

$sql = "INSERT INTO login (record, firstname, lastname, email, usrname, pass)
VALUES (1, '$firstname', '$lastname', '$email', '$usrname', '$pass')" ;

echo "Data has been inserted!";
?>

</html>

jannoy

look

$sql = "INSERT INTO login (record, firstname, lastname, email, usrname, pass)
VALUES (1, '$firstname', '$lastname', '$email', '$usrname', '$pass')" ;

echo "Data has been inserted!";

after $sql="insert....";
execute with
$s=mysql_query($sql);
if ($s) { echo " not inserted";} else { echo "inserted";}

jannoy

sorry there is a logical expression error in my if ($s)

should be if (!$s) { } else { }

mcallon

jannoy:

Thanks for your response! I really do appreciate it! I tried your suggestion, and now the table adds a new row each time the script is run, but the variables that I want to be stored in the table still are not appearing. At least now I can see that the auto increment is working, but still no data! 😃

Any more ideas?

Here's the altered script I used with your suggestion:

<html>

<?php

$dbhost="localhost";
$dbusername="vecmxcco_mcallon";
$dbpassword="072599";
$dbname="vecmxcco_people";

$connect = mysql_connect($dbhost, $dbusername, $dbpassword);

mysql_select_db($dbname,$connect) or die ("Could not select database");

$firstname = $POST['firstname'];
$lastname = $POST['lastname'];
$email = $POST['email'];
$usrname = $POST['usrname'];
$pass = $_POST['pass'];

$sql = "INSERT INTO login (firstname, lastname, email, usrname, pass)
VALUES ('$firstname', '$lastname', '$email', '$usrname', '$pass')" ;

$s=mysql_query($sql);
if (!$s) { echo " not inserted";}
else { echo "inserted";}
?>
</html>

jannoy

was this in your first form or first file ???

$firstname = $POST['firstname'];
$lastname = $POST['lastname'];
$email = $POST['email'];
$usrname = $POST['usrname'];
$pass = $_POST['pass'];
eg.
<form name="m" method="post" action="yoursavefile.php">

</form>
<!!----------------------------------------------------- copy n paste --->>>

if (isset($_POST['Submit'])) {
$dbhost="localhost";
$dbusername="vecmxcco_mcallon";
$dbpassword="072599";
$dbname="vecmxcco_people";

$connect = mysql_connect($dbhost, $dbusername, $dbpassword);

mysql_select_db($dbname,$connect) or die ("Could not select database");

$firstname = $POST['firstname'];
$lastname = $POST['lastname'];
$email = $POST['email'];
$usrname = $POST['usrname'];
$pass = $_POST['pass'];

$sql = "INSERT INTO login (firstname, lastname, email, usrname, pass)
VALUES ('$firstname', '$lastname', '$email', '$usrname', '$pass')" ;

$s=mysql_query($sql);
if (!$s) { echo " not inserted";}
else { echo "inserted";}

}
?>

<form name="form1" method="post" action="">
<table width="494" border="1">
<tr>
<td width="130">First name </td>
<td width="348"><input type="text" name="firstname"></td>
</tr>
<tr>
<td>last name </td>
<td><input type="text" name="lastname"></td>
</tr>
<tr>
<td>Email</td>
<td><input type="text" name="email"></td>
</tr>
<tr>
<td>Username</td>
<td><input type="text" name="usrname"></td>
</tr>
<tr>
<td>Password</td>
<td><input type="text" name="password"></td>
</tr>
<tr>
<td><input type="submit" name="Submit" value="Submit"></td>
<td> </td>
</tr>
</table>
</form>

mcallon

Well, my form was actually made in FLASH, and I used Actionscript command "getURL" with the POST option to send the variables over to the file with the script we've been discussing. The variables are being sent, because I have a PHP script that displays once they are sent from FLASH.; they're just not making it into the table for some reason. . .

Does this make sense?

Thanks again for your time here, jannoy.

mcallon

OMG! 😃

I found out what the problem is, and I think it was a silly error on my part. The entire time I have been testing this script I have been using Flash's TEST MOVIE option on my local machine. Since it actually CAN connect to the net during local test, I thought it wouldn't matter if I didn't upload the file to my remote server for testing. Hence, it would go through the motions of passing the variables. . .When I uploaded the flash files to my server and tried it, VOILA! The table is populating as it should.

Thanks for all your help, jannoy. I appreciate it so much! :p

And to think I have been hitting this brick wall for about three days now! lol :glare:

jannoy

no problem dude