DaniWeb Forum Index > Web Development > PHP

how to enter data in database from HTML form

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Aug 2009

Posts: 2

Reputation: duraid121 is an unknown quantity at this point

Solved Threads: 0

duraid121

Offline

Newbie Poster

how to enter data in database from HTML form

Aug 18th, 2009

I am trying to use this script to enter data into my database from an html form. this code is not working. plz tell me where the error is
form is

 Help with Code Tags 
 html Syntax (Toggle Plain Text) 
<html>
 
<head>
    <title> Review, Ratings, Opinions Site </title>
</head>
 
<body text="green" >
<form action="register processing.php" method="post" >
        First name: <input type="text" name="fname" value="empty" />           <br/>
        Last name:  <input type="text" name="lname" value="empty" />            <br/> 
        Gender:<br/><input type="radio" name="sex" value="male" />   MALE 
                    <input type="radio" name="sex" value="female" />  FEMALE              <br/>      
        Email id:   <input type="text" name="email" value="empty" />       <br/>
        Username:   <input type="text" name="username" value="empty" />          <br/> 
        password:   <input type="password" name="password" value="empty" />      <br/>
                    <input type="submit" name="submit" value="submit" />
    </form>
 
</body>
 
</html>
<html>
    
<head>
    <title> Review, Ratings, Opinions Site </title>
</head>
 
<body text="green" >
<form action="register processing.php" method="post" >
        First name: <input type="text" name="fname" value="empty" />           <br/>
        Last name:  <input type="text" name="lname" value="empty" />            <br/> 
        Gender:<br/><input type="radio" name="sex" value="male" />   MALE 
                    <input type="radio" name="sex" value="female" />  FEMALE              <br/>      
        Email id:   <input type="text" name="email" value="empty" />       <br/>
        Username:   <input type="text" name="username" value="empty" />          <br/> 
        password:   <input type="password" name="password" value="empty" />      <br/>
                    <input type="submit" name="submit" value="submit" />
    </form>
    
</body>

</html>

and the action file is

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
<?php
      $handle = mysql_connect("localhost", "root");
      if(!$handle)
        die("mysql connection failed due to :" . mysql_error());
 
 
      $db = mysql_select_db ("review_site" , $handle );
      if(!db)
       die("database selection failed due to :" . mysql_error());
?>
<html>
<head>
    <title> server side proceesing </title>
</head>
 
<body>
    <?php
     $fname = $_REQUEST['fname'];
     $lname = $_REQUEST['lname'];
     $sex =   $_REQUEST['sex'];
     $email=  $_REQUEST['email'];
     $username=$_REQUEST['username'];
     $password= $_REQUEST['password'];
     $v= 1;
     $sql = "INSERT INTO users(fname,lname,sex,email,username,password,visible)
      VALUES($fname,$lname,$sex,$email,$username,$password,$v)" ;   
      if($result = mysql_query ($sql, $handle ))
        {echo "welcome " . $fname . "<br/>";}
     ?>    
</body>     
</html>
<?php
      $handle = mysql_connect("localhost", "root");
      if(!$handle)
        die("mysql connection failed due to :" . mysql_error());


      $db = mysql_select_db ("review_site" , $handle );
      if(!db)
       die("database selection failed due to :" . mysql_error());
?>
<html>
<head>
    <title> server side proceesing </title>
</head>

<body>
    <?php
     $fname = $_REQUEST['fname'];
     $lname = $_REQUEST['lname'];
     $sex =   $_REQUEST['sex'];
     $email=  $_REQUEST['email'];
     $username=$_REQUEST['username'];
     $password= $_REQUEST['password'];
     $v= 1;
     $sql = "INSERT INTO users(fname,lname,sex,email,username,password,visible)
      VALUES($fname,$lname,$sex,$email,$username,$password,$v)" ;   
      if($result = mysql_query ($sql, $handle ))
        {echo "welcome " . $fname . "<br/>";}
     ?>    
</body>     
</html>

Last edited by Ezzaral; Aug 18th, 2009 at 4:39 pm. Reason: Added [code] [/code] tags. Please use them to format any code that you post.

•

Join Date: Apr 2009

Posts: 254

Reputation: BzzBee is an unknown quantity at this point

Solved Threads: 37

BzzBee

Offline

Posting Whiz in Training

Re: how to enter data in database from HTML form

Aug 19th, 2009

why r you using php code with in the body tags. are you connected with database?

if yes, then echo your query and paste it in phpmyadmin query area and then check your query is right or wrong.

BzzBee

http://www.homenwomen.com/