Connecting Tech Pros Worldwide Help | Site Map

Insert into MySQL database using html form and php

  #1  
Old July 17th, 2005, 12:30 PM
aseaman@echoes.net
Guest
 
Posts: 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!!!

  #2  
Old July 17th, 2005, 12:30 PM
RotterdamStudents
Guest
 
Posts: n/a

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><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


  #3  
Old July 17th, 2005, 12:30 PM
Von Heler
Guest
 
Posts: n/a

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 RotterdamStudents 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><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[/color]

You might want to put something like this here:

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

[color=blue]
> $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
>
>[/color]



--

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




Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
Uploading files into a MySQL database using PHP Atli insights 69 October 19th, 2009 08:24 PM
Insert into MySQL Database with PHP POST Method ctrap answers 3 December 19th, 2007 03:47 PM
using forms to add records to mysql database - block submit on entering dirk answers 4 September 6th, 2007 06:05 PM
Help with populating an html form having more than one attribute fjm answers 8 June 20th, 2007 08:56 AM