How do I get a web form to write to a MySQL database using PHP myAdmin?

Question

I am trying to use a webform to post data to my MySQL database. I have all of this set up on my website that is hosted on yahoo. I have php MyAdmin installed on the server to manage the database. For some reason, I can't get my webform to post the info to my database. Can anyone help?

Answer 1

// assuming you are posting a field called 'first_name'
$first_name =$_POST['first_name'];


//use proper values for mysql_user and mysql_password
//use proper value for localhost, if you are not using local host.



$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}


//assuming you are entering this field in a table called 'myfriends'
$query = "INSERT INTO myfriends(first_name) VALUES('$first_name')";


mysql_query($query);

mysql_close($link);
?>

Answer 2

you will possibly desire to layout the database - that basically takes concept and, according to threat, paper and a pen. Designing the internet internet site demands graph paper. coming up the internet internet site desires paper. as quickly as you have executed all that, you enter the code for the internet site right into a record, create any photos and create the database and tables. coming up a internet website is something you do on your recommendations, no longer on a working laptop or pc. taking part in at internet layout is something you do without first coming up it.

Answer 3

try this
http://php.resourceindex.com/Documentation/Examples_and_Tutorials/Database_Manipulation/