Insert data using webpage

gmitra

Can anyone please explain to me how to create a webpage w/ a form that I could use to insert data into my mysql database. I want to make a page with a form that I could easily use to submit data such as...

date
time

subject

article

Any help would be much appreciated. Thanks.

sharjilj

Firstly, here's the code for the webpage:

<form name="fm1" action="postform.php" method="post">
<p>Date: <input type="text" size="30" name="date1" /></p>
<p>Time: <input type="text" size="30" name="time1" /></p>
<p>Subject: <input type="text" size="30" name="subject1" /></p>
<p>Article: <input type="text" size="30" name="article1" /></p>
<p><input type="submit" value="Submit Form" />  <input type="reset" value="Reset Form" /></p>
</form>

</body>

</html>

The postform.php file is as under:

<?php

$conn = mysql_connect ("localhost","yourusername","yourpassword")
or die ("Connection to mySQL database failed!");

$db = mysql_select_db ("databasename", $conn)
or die ("Cannot connect to database!");

$query = "insert into mydata values ('$date1', '$time1', '$subject1', '$article1')";

$ex = mysql_query($query,$conn)
or die ("Query execution failed");

echo "$query";

?>

Of course, this assumes that you have created a table named MYDATA in your mySQL database.

gmitra

Thank you very much! Your script was so much simpler than all the other ones that I've tried and failed. 😃

iclaudius

From the perspective of a newbie - thanks - that was indeed a simple form.

I'm wondering how one would go about inputting data from a form that was to be sent to another table to make a link between the primary table (new row created) and link that table to another category table?

i.e.
table 1: products (form submits a new product)
table 2: categories (you can select one in the form)
table 3: products_categories (form creates new entry tying the new product to one category)

thanks for any suggestions!
:p

kevinsequeira

.
.
.
 $query = "insert into products (product_name,.....)values ('$product_name',........)"; 
	$result = mysql_query($query) or die("error:".mysql_error());
	// now we have inserted the value into first table, change the query to include the rest of the fields
// assuming that the products table has primary key called id which is AUTO INCREMENT.
	$product_id = mysql_insert_id();//id should be auto-increment
	 $query = "insert into products_categories (product_id,category_id) values ($product_id, $category_id)";// got $category_id from form
		$result = mysql_query($query) or die("error:".mysql_error());
		.
		.
		.

u might want to use $_POST['product_name'] intstead of $product_name and so on for values that you are getting from the form

reg
kevin