text box information between forms 3

mrobinson · Feb 17, 2004

i have set up my system with the apach server, mysql and php4.
I have followed various tutorials to set it up and test it all. However when i create a database and then try to add information to it via a form it updates the table but with blank entries where the was text entered. I then tried doing it so the data entered would be displayed on another page but it doesn't appear there either, it is just blank. Due to me downloading various tutorials and trying them using cut and paste and keep getting the same problem im pretty sure the code is ok.
Could anyone please help and tell me which possible setting needs changing

Thanks

Chacalinc · Feb 17, 2004

could you pls post the code used?

mrobinson · Feb 18, 2004

the php form i used is as follows:

<html>

<body>

<?php

if ($submit) {

// process form

$db = mysql_connect("localhost", "root&quot

;

mysql_select_db("mydb",$db);

$sql = "INSERT INTO employees (first,last,address,position) VALUES ('$first','$last','$address','$position')";

$result = mysql_query($sql);

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

} else{

// display form

?>

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

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

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

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

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

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

</form>

<?php

} // end if

?>

</body>

</html>

The mysql seems to be working as i can insert information directly with SQL and the php can read information from the tables and display it. Hope you can help

herman75 · Feb 18, 2004

Big chance that Register Globals is turned off. In that case your form variables are available in $_POST or $_GET. Try putting this before your query.

$first = $_POST['first'];
$last = $_POST['last'];
etc.

DRJ478 · Feb 18, 2004

Some advice:

1. Set a password for MySQL root user and create a new user for your Web activities. You might work locally now, but you don't want to keep the door open like that. There is a whole chapter about this in the MySQL manual (

http://www.mysql.com/doc/en/Default_privileges.html)

2. Read over the register globals chapter in the PHP manual (

http://www.php.net/register_globals).

Chacalinc · Feb 18, 2004

Take a look to herman75's post, he hit it..

1. $sql = "INSERT INTO employees (first,last,address,position) VALUES ('$first','$last','$address','$position')";

if you have register global off yo must have before the line:

$first=$_POST['first'];
$last=$_POST['last'];
$address=$_POST['address'];
$position=$_POST['position'];

2. try always to use "or die" in the mysql_query function:

$result = mysql_query($sql) or die ("Error:".mysql_error());

so, if you have a Mysql error, you will know it.

Cheers.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

text box information between forms 3

mrobinson

MIS

Chacalinc

Vendor

mrobinson

MIS

herman75

Programmer

DRJ478

IS-IT--Management

Chacalinc

Vendor

Similar threads

Part and Inventory Search

Sponsor