By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,966 Members | 812 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,966 IT Pros & Developers. It's quick & easy.

Insert into MySQL database using html form and php

P: n/a
I am a big novice with MySQL and PHP. I need a script that enters
information from a html form into a MySQL database. Can anyone tell me
where I can find one that I can just replace the table and database
name? PLEASE I NEED IT ASAP!!!

Jul 17 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
> I am a big novice with MySQL and PHP. I need a script that enters
information from a html form into a MySQL database. Can anyone tell me
where I can find one that I can just replace the table and database
name? PLEASE I NEED IT ASAP!!!

form.htm
<html><head><title>Your title</title></head><body>
<form name="form1" method="post" action="input.php">
<input type=text name=001>
<input type=text name=002>
<input type=text name=003>
etc. etc.
Submit button
</form>
</body></html>
end of form.htm

input.php
<?php
$db = mysql_connect("server","username","password") or die("Cannot connect
to server");
mysql_select_db("databasename",$db) or die("Cannot find database");
$sql = mysql_query("INSERT INTO tablenam (field1, field2, field3, the names
of your fields in the table) VALUES('$001', '$002', '$003', 'the names of
the input types you want to insert in the fields in your database')") or die
(mysql_error());

?>
end of input.php

Martijn
Jul 17 '05 #2

P: n/a
Astonishing! Dogs scampered and hid under sideboards, hamsters stopped
turning in their wheels, and silence fell as RotterdamStudents paused,
put down his Happy Meal, and blurted:
I am a big novice with MySQL and PHP. I need a script that enters
information from a html form into a MySQL database. Can anyone tell
me where I can find one that I can just replace the table and
database name? PLEASE I NEED IT ASAP!!!
form.htm
<html><head><title>Your title</title></head><body>
<form name="form1" method="post" action="input.php">
<input type=text name=001>
<input type=text name=002>
<input type=text name=003>
etc. etc.
Submit button
</form>
</body></html>
end of form.htm

input.php
<?php


You might want to put something like this here:

$001 = htmlspecialchars($_POST['001']);
$002 = htmlspecialchars($_POST['002']);
$003 = htmlspecialchars($_POST['003']);

$db = mysql_connect("server","username","password") or die("Cannot
connect
to server");
mysql_select_db("databasename",$db) or die("Cannot find database");
$sql = mysql_query("INSERT INTO tablenam (field1, field2, field3, the
names of your fields in the table) VALUES('$001', '$002', '$003', 'the
names of the input types you want to insert in the fields in your
database')") or die (mysql_error());

?>
end of input.php

Martijn


--

You read too far. You should stop the moment you see Von Heler." Archangel
"long lunged + acting 'interesting' = Von Heler" Football Commentator


Jul 17 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.