Code Forums - View Single Post - How to insert HTML form data into mysql database ?

idx · 02-06-2005, 07:39 AM

Just set the html form to post to itself or another PHP page.

in the php page, grab the post vars and run the necessary mysql commands.

PHP Code:


			
$id = $_POST['id'];

$html_data = $_POST['foo'];



// mysql connect /etc..



$sql = "INSERT INTO table_name (id, data) VALUES ('{$id}', '{$html_data}');";

mysql_query($sql);

Also, no need for 3 crossposts..

-r

02-06-2005, 07:39 AM	#3 (permalink)
idx Senior Grasshopper Join Date: Jun 2003 Location: FL Posts: 317	Just set the html form to post to itself or another PHP page. in the php page, grab the post vars and run the necessary mysql commands. PHP Code: `$id = $_POST['id']; $html_data = $_POST['foo']; // mysql connect /etc.. $sql = "INSERT INTO table_name (id, data) VALUES ('{$id}', '{$html_data}');"; mysql_query($sql);` Also, no need for 3 crossposts.. -r