Insert into MySQL database using html form and php

**RotterdamStudents** · Jul 17 '05, 11:30 AM

Re: Insert into MySQL database using html form and php

> I am a big novice with MySQL and PHP. I need a script that enters[color=blue]
> 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!!!
>[/color]
form.htm
<html><head><ti tle>Your title</title></head><body>
<form name="form1" method="post" action="input.p hp">
<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","userna me","password ") or die("Cannot connect
to server");
mysql_select_db ("databasename" ,$db) or die("Cannot find database");
$sql = mysql_query("IN SERT 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

**Von Heler** · Jul 17 '05, 11:30 AM

Re: Insert into MySQL database using html form and php

Astonishing! Dogs scampered and hid under sideboards, hamsters stopped
turning in their wheels, and silence fell as RotterdamStuden ts paused,
put down his Happy Meal, and blurted:
[color=blue][color=green]
>> 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!!!
>>[/color]
> form.htm
> <html><head><ti tle>Your title</title></head><body>
> <form name="form1" method="post" action="input.p hp">
> <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[/color]

You might want to put something like this here:

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

[color=blue]
> $db = mysql_connect(" server","userna me","password ") or die("Cannot
> connect
> to server");
> mysql_select_db ("databasename" ,$db) or die("Cannot find database");
> $sql = mysql_query("IN SERT 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
>
>[/color]

--

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