using php with a database

[thumbelina]

ok i'm trying to find the basic syntax for inserting info from my webpage into a table in the database. can u believe that i can't find it. it's a mysql database and the input is coming from a textbox only i don't know what to do next. anyway any help would be greatly appereacted, and if anyone knows of any sources that explain php explictly i would be interested in that too cause most of what i have found is very cryptic.
thanks again.

 

[steijssen]

Okay,

inserting data from a textbox into a mysql database using php is pretty simple. On one page you have the form. Now, this form refers to another php page (which is the simplest way):
<form name=&quot;form1&quot; method=&quot;post&quot; action=&quot;otherpage.php&quot;>
<input type=&quot;text&quot; name=&quot;textbox&quot;>
<input type=&quot;submit&quot; value=&quot;submit&quot;>
</form>

The textbox is named &quot;textbox&quot;. When you submit the form, it sends the data from &quot;textbox&quot; to &quot;otherpage.php&quot;.

In otherpage.php you insert the data into the database:

<?php
mysql_connect(&quot;localhost&quot;,&quot;username&quot;,&quot;password&quot;
mysql_select_db(&quot;databasename&quot;
mysql_query(&quot;INSERT INTO fieldname VALUES '$textbox'&quot;
?>

That's all there is to it

For more info see

http://www.mysql.com

,

http://www.php.net

,

http://alt-php-faq.org