How to insert HTML form data into mysql database ?

[plomon]

hi there,

In my website(built usind Dreamweaver), I created a form having certain fields. My site is being hosted by "www.freefronthost.com" website. A personal mySQL database is given to me by the host specified above. I know the commands of mySQL sufficiently. Please help me insert the form data into the mySQL database using PHP. I know nothing about PHP, but I know JSP, Javascripting and HTML coding. So, if anybody could provide me the HTML code embedded with PHP to insert the form details into mySQL, I will try grasp it, and it will be a great help for me.

[technobard]

There are a lot of tutorials out on the web that cover this pretty well. Check out http://webmonkey.wired.com/webmonkey...tutorial4.html
Lesson 2 covers forms.

[idx]

Just set the html form to post to itself or another PHP page.

in the php page, grab the post vars and run the necessary mysql commands.

PHP Code:

$id = $_POST['id'];
$html_data = $_POST['foo'];

// mysql connect /etc..

$sql = "INSERT INTO table_name (id, data) VALUES ('{$id}', '{$html_data}');";
mysql_query($sql); 


Also, no need for 3 crossposts..

-r

[plomon]

hello idx,

Can you give me the complete script of posting(say) three fields namely "name","age","email" into a mySQL database located at a remote server(not localhost) using PHP coding.

Another doubt, since, I built the "form" in Dreamweaver as a HTML page, so, by introducing php script in between the HTML tags using <? ... >, will the page be saved as .php page or .html page on clicking the save button.

[idx]

You just need to specify the remote host in your mysql_connect() command.

PHP Code:

mysql_connect('remote_host_or_ip', 'username', 'password'); 


Then from there construct a similar SQL statement to my example above. Just grab the different var name from $_POST such as $_POST['email'] (if that is your html field name), $_POST['age'], etc..


As far as dreamweaver, it will probably be saved as .html unless it's smart enough to see the php tags and rename. One problem with that is that [typically] the webserver isn't setup to parse .htm/.html files with the PHP processor. So you'll need to rename the html file yourself..

-r

[sde]

hey plomon, the concept is a lot like jsp. one thing not showed is the connect to mysql. just fill in the information in the mysql_connect string here. if it is a remote server, just put in the ip.

PHP Code:

<?
if (!$dbcnx = mysql_connect("server", "user", "password"))
  die("Could not connect to MySQL DB: " . mysql_error());
?>

this should probably be at the top of the page. now, idx gave you a good example, and if you know jsp, then i assume you may also have a grasp on the sql language ( so i wont' go into details on your sql insert )

$id = $_POST['id']; is exactly the same thing as you using: String id = request.getParameter("id"); in jsp.

if you needed to access the variable 'age' from your form, then you would use $_POST['age']

let us know how it goes.