how 2 get value from a form into a MySQL db?

[gsf600y]

Basically im looking for some example code so I can see how it is done.

What I want is code which will display a form with one input box.
In that input box the user will put a name, say Joe, and then hit submit.
This name then gets added to a table with 2 columns - one is the index number, and the 2nd is the column with the names.

Any help appreciated 🙂
Thanks

[kevinsequeira]

if this is the php page

test.php

<form name="test_form" method="post" action="test.php">
<input type=text name=user>
<input type=submit>
</form>
<?php
if(isSet($_POST['user'])){
$username = "your_username";
$pwd = "your_password";
$host = "your_host";
$db = "your_database_name";
$table = "your_table_name";

mysql_connect($host,$username,$pwd);
mysql_select_db($db);
if(mysql_error())
echo mysql_error();
$query = "insert into $table (index_number,name) values (1,'$_POST['user']')";
mysql_query($query);

if(mysql_error())
echo mysql_error();
}
?>

this should get you going, i suggest you look up some tutorials to learn more

reg
kevin

[gsf600y]

many thanks for that Kevin 🙂

I cant quite get the script to completely work though

QUOTE]$query = "insert into $table (index_number,name) values (1,'$_POST['user']')"; [/QUOTE]

The value 1 gets entered into the index_number column ok, but the $_POST['user'] gets entered into the name column as blanks.
I have that column set to varchar (have tried a few others).

I added a print $_POST['user']; after the mysql_query just to prove that it is picking up the input from the form ok, and it is.

Any ideas?

Thanks.

[kevinsequeira]

$user = $_POST['user'];
$query = "insert into $table (index_number,name) values (1,'".$user."')";

try this ...

reg
kevin

[gsf600y]

that done it 🙂
Thanks again!