Add Record to DB

jn148

I am new to PHP and am trying to write a page that contains a form that will allow a user to add a record to my Database...

Any help would be appreciated!

bastien

//uses a separate file to hold the db connection info
//good for security

require("dbconn.php");

if(!$submit){
//show form
echo "<html><body><form name=\'test\' action=PHP_SELF

method=\'post\'>
<table><tr><td>input name</td><td>
<input type=\'text\' name=\'yourname\' size = 20>
</td></tr><tr><td><input type=\'submit\'
value=\'submit\'></table></form></body></html>";

}else{
//if the submit button has been pressed then insert the data
//create the sql query
$sql="insert into mytable values($yourname)";
//get the result (confirm insert)
//$conn is the database connection info from the dbconn.php pg
$result = mysql_query($sql, $conn) or die("can't connect");
if (!$result){
echo "insert failed";
}else{
echo "insert successful";
}
}
?>

hth

mad27

The previous reply doesn't seem very useful to me. If you want to make what you're asking for, then you'll have to learn some basic PHP and MySQL (assuming you use that database).
On this site (PHPbuilder) and other sites (for instance devarticles.com) there are good examples and tutorials taking you through the basic steps.