[ajs]

How do you enter information on an html page that sends the results through the php page to a db?

For example, let's say this is enter.html

PHP Code:

<form method="POST" action="test.php">

  <input type="text" name="T1" size="20"><input type="submit" value="Submit" name="B1">

</form> 

What would test.php include ? Obviously it would include

PHP Code:

<?

$username="user";

$password="pass";

$database="database";



mysql_connect(localhost,$username,$password);

@mysql_select_db($database) or die( "Unable to select database");

?>

but how do you handle the rest? Thanks

[NeverMind]

PHP Code:

<?

$username="user";

$password="pass";

$database="database";



$link = mysql_connect('localhost',$username,$password);

@mysql_select_db($database, $link) or die( "Unable to select database");



$t1 = addslashes(trim($_POST['T1'])); //because your field name is T1



mysql_query("INSERT INTO table_name (filed_name) VALUES ('$t1')", $link)or

die(mysql_error());



echo mysql_affected_rows($link) . ' row(s) was inserted';

?>

[ajs]

Thanks!

Another question, how would I pass along information that isn't in a entry box ? (ie: text called up based on a url such as www.site.com/items.php?id=1)

[NeverMind]

you get information from URL with $_GET array and in your example you get the id value with:

PHP Code:

$_GET['id'];