inserting data in mysql

zuessh · 05-16-2003, 09:07 AM

I posted this on phpbuilder but didn't get much help so I knew this was the best place. I am trying to insert data into mysql database. Below is the code, any suggestions, it does not return any errors and takes me straight back to the form page, but does not insert data.

<html>

<body>

<?php

if ($submit) {

// process form

$db = mysql_connect("localhost", "testphp", "test") or die("couldnt connect");

mysql_select_db("php",$db);

$sql = "INSERT INTO phptest (id,name,address,phone) VALUES ($id,'$name','$address','$phone')"
;

$result = mysql_query($sql);

echo $sql;
if(mysql_error()){
echo mysql_error();
}

echo "Thank you! Information entered.\n";

} else{

// display form

?>

<form method="post" action="<?php echo $PHP_SELF?>">

id:<input type="Text" name="id"><br>

name:<input type="Text" name="name"><br>

address:<input type="Text" name="address"><br>

phone:<input type="Text" name="phone"><br>

<input type="Submit" name="submit" value="Enter information">

</form>

<?php

} // end if

?>

</body>

</html>

cyber · 05-16-2003, 09:54 AM

if it takes you right back to the form page then "if ($submit)" can't work like you want it to,.,. try to put <input type="hidden" name="check" value="1"> and do a "if ($check == 1)".

acid_kewpie · 05-16-2003, 10:17 AM

you can't access those values as global variables, i'm not too hot on PHP, but i think you either need $data["address"] or $_POST["address"]

vous · 05-16-2003, 10:34 AM

....or

$_REQUEST["address"]

in this way, it doesn't matter if they are posts or gets....

zuessh · 05-19-2003, 01:00 PM

I still do not understand, is the problem with the php script or with the form? Would it be best to change the php script or the form?