How do I create a textbox that stores values in a database?

[drew22299]

Hey,

I have created a mysql database using phpmyadmin on the hosts server, and have entered the fields and defined the primary key.

These fields are for members details, or for people that have subscribed to the mailing list. I have some questions,

1) Is this the same as creating a php file that tells the database what fields to make and store them?
2) How do I make a text box that takes an email address and stores it in the database? Can anyone suggest some code?

Drew,

[welstein]

your HTML :
<FORM action="test.php" method="post">
<INPUT type="text" value="this is a text" name"txtInput" id="txtInput" />
</FORM>

then in your test.php
<?php
// if the method="get" then you have to change to $_GET
extract($_POST);
print($txtInput); // print your text value

$db = mysql_connect("localhost", "root", "123");
mysql_select_db("mydb", $db) or die(mysql_errno() . ": " . mysql_error() . "<br>");


$sql = " INSERT INTO test VALUES('$txtInput') ";
$result = mysql_query($sql, $db);
if(!$result){
echo mysql_error();
exit;
}
// close the connection
mysql_free_result($result);
mysql_close();
?>

[drew22299]

Thanx,

For this to work do you need to have setup a database with the required fields? For example, if you are taking someones email address you need to have a field in your database called emailaddress?

Is there a way of using PHP so that it creates the fields when it is executed?

Drew,

[Formula]

The best thing for you is to create a table with these fields:
user_id
user_name
user_email

and insert the emails to this table.

Assaf