Ad:

PHP Discussion Thread
Unsolved
Views: 4188

Dec 15th, 2008

Php page containing html form to sql database

Expand Post »

Happy Holidays!

I have a one field form. Upon submission with the submit button, I wish to drive this field value into my SQL database table called MEMBERS and field called NAMES, thus adding a new record.

Can this be done with an OnSubmit() call to a function, in the HEAD of the HTML form page, which contains a series of statements opening the database, entering the data, and closing the database?

PHP Syntax (Toggle Plain Text)
<tr>
	<td class="mystyle">Your Full Name:</td>
	<td><input type="text" name="Name" size="30"></td>
</tr>
<tr>
	<td class="mystyle">Your Full Name:</td>
	<td><input type="text" name="Name" size="30"></td>
</tr>

Similar Threads

AJAX comment form in JavaScript / DHTML / AJAX
PHP help in creating profile thingy in PHP
php login page problem in PHP
php drop down menu to search multiple sql tables in PHP
get html element value using php in PHP

squarkman

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

42 posts
since Nov 2008

Permalink

Dec 15th, 2008

Re: Php page containing html form to sql database

Create table in mysql--

create database in mysql with name db_name

PHP Syntax (Toggle Plain Text)
CREATE TABLE `table_user` (
  `user_id` int(2) NOT NULL auto_increment,
  `user_fname` varchar(10) NOT NULL,
  `user_lname` varchar(10) NOT NULL,
 
  PRIMARY KEY  (`user_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1123 ;
CREATE TABLE `table_user` (
  `user_id` int(2) NOT NULL auto_increment,
  `user_fname` varchar(10) NOT NULL,
  `user_lname` varchar(10) NOT NULL,
  
  PRIMARY KEY  (`user_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1123 ;

in your php file you have to write like

PHP Syntax (Toggle Plain Text)
$con = mysql_connect("localhost","root","");
	if (!$con)
	  {
	  die('Could not connect: ' . mysql_error());
	  }
	  else
	  {
	 // echo('Connected with Mysql');
	  }
 
@mysql_select_db("db_name", $con);// connect to database db_name
 
 
	if (isset($_POST['Submit']))
	{
$sql="INSERT INTO table_user (user_fname, user_lname)	VALUES('$_POST[user_fname]','$_POST[user_lname]')";
		@mysql_query($sql,$con);
$con = mysql_connect("localhost","root","");
	if (!$con)
	  {
	  die('Could not connect: ' . mysql_error());
	  }
	  else
	  {
	 // echo('Connected with Mysql');
	  }

@mysql_select_db("db_name", $con);// connect to database db_name


	if (isset($_POST['Submit']))
	{
$sql="INSERT INTO table_user (user_fname, user_lname)	VALUES('$_POST[user_fname]','$_POST[user_lname]')";
		@mysql_query($sql,$con);

your form structure like this

PHP Syntax (Toggle Plain Text)
<table>
 <td width="141" align="left" valign="top" >First Name</td>
                          <td width="163" align="left" valign="top"><input name="user_fname" type="text" id="user_fname"></td>
<td align="left" valign="top" >Last Name</td>
                          <td colspan="4" align="left" valign="top"><input name="user_lname" type="text" id="user_lname">
 
<input name="Submit" type="submit" value="Submit" >
</table>
<table>
 <td width="141" align="left" valign="top" >First Name</td>
                          <td width="163" align="left" valign="top"><input name="user_fname" type="text" id="user_fname"></td>
<td align="left" valign="top" >Last Name</td>
                          <td colspan="4" align="left" valign="top"><input name="user_lname" type="text" id="user_lname">

<input name="Submit" type="submit" value="Submit" >
</table>

Last edited by Aamit; Dec 15th, 2008 at 8:51 am.

Aamit

Reputation Points: 3

Solved Threads: 15

Posting Whiz

Offline

341 posts
since Apr 2008

Permalink

Dec 15th, 2008

Re: Php page containing html form to sql database

Thank! Great response. How would you define the 'root' or do I leave the word 'root' as is. Where do I define the url to the server?

squarkman

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

42 posts
since Nov 2008

Permalink

Dec 15th, 2008

Re: Php page containing html form to sql database

Oh, also...where is the connection script placed? Is that PHP or Javascript or HTML? Can I place it anywhere in the code?
Thx

squarkman

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

42 posts
since Nov 2008

Permalink

Dec 15th, 2008

Re: Php page containing html form to sql database

for localhost default user name and password
user name--root
password--"" (blank)

if you want run on server
create user name and password on server & use it

Aamit

Reputation Points: 3

Solved Threads: 15

Posting Whiz

Offline

341 posts
since Apr 2008

Permalink

Dec 15th, 2008

Re: Php page containing html form to sql database

use at top..so make easy for you..

Aamit

Reputation Points: 3

Solved Threads: 15

Posting Whiz

Offline

341 posts
since Apr 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: PHP Date always returns 0

Next Thread in PHP Forum Timeline: Testing

DaniWeb Message

Cancel Changes

User Name
Password