insertion is not happening in php and mysql form

Question

My database fields are: id,name,email_id,address,phone_no,username,password,category,date

<?php
     include_once('connect_to_mysql.php');

     if(isset($_POST["submit"])){
        $a=mysql_real_escape_string($_POST["name"]);
        $b=mysql_real_escape_string($_POST["email"]);
        $c=mysql_real_escape_string($_POST["address"]);
        $d=mysql_real_escape_string($_POST["phoneno"]);
        $e=mysql_real_escape_string($_POST["user"]);
        $f=mysql_real_escape_string($_POST["pass"]);
        $g=mysql_real_escape_string($_POST["category"]);

        $res=mysql_query("insert into reg(name, email_id, address, phone_no, username, password, category, date ) values ( '$a', '$b', '$c', '$d', '$e', 'md5[$f]', '$g', now() )")  or die (mysql_error() );
        $id = mysql_insert_id();
    }
?>

There's no error reported when using the submit button, but found data is not inserted into database. I don't know what causes this.

  <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  <html xmlns="http://www.w3.org/1999/xhtml">
  <head>
      <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
      <title> Register </title>

  </head>

   <body>

       <div id="heading12"><?php //include_once("header.html") ?></div>
           <br /><br /><br /><br /><br /><br /><br />
       <div id="mainWrapper" style="background-color:#ECEEFB">

       <div align="center" id="pageContent" style="background-image:url(back3.png); width:1000px;"><br /><br /><br />
       <div align="center" style="color:#000000;">
       <h2 style="font-size:36px">Please Fill Your all Details to Register</h2>
       <br /><br />
       <form id="form" name="form" method="post" action="register.php">
         <h2 style="padding-right:200px;"> Name:</h2>
         <input name="name" type="text" id="name" size="40" style="height:30px; font-size:20px " required placeholder="Enter NAME"/>
           <br /><br />

        <h2 style="padding-right:200px;">Email Address:</h2>
        <input name="email" type="text" id="email" size="40" style="height:30px; font-size:20px " required placeholder="Enter Email Address"/>
           <br /><br />

        <h2 style="padding-right:200px;">Address</h2>
        <textarea name="address" id="address" cols="44" rows="6" style="font-size:19px " required placeholder="Enter Address"></textarea>
   <br /><br />

        <h2 style="padding-right:200px;">Phone No.</h2>
        <input name="phoneno" type="text" id="phoneno" size="40" style="height:30px; font-size:20px" required placeholder="Enter Phone No."/>
        <br /><br />

        <h2 style="padding-right:200px;">User Name:</h2>
        <input name="user" type="text" id="user" size="40" style="height:30px; font-size:20px" required placeholder="Enter UserName"/>
        <br /><br />

        <h2 style="padding-right:210px;">Password:</h2>
        <input name="pass" type="password" id="pass" size="40" style="height:30px; font-size:20px" required placeholder="Enter Password"/>
        <br /> <br />

        <h2 style="padding-right:250px;">Category:</h2> 
        <select name="category" id="category" style="height:30px; font-size:20px; padding-right:290px;" required placeholder="Enter The Value" >
           <option value="none">Choose Any</option>
           <option value="product buyer">Product Buyer</option>
           <option value="product seller">Product Seller</option>
       </select>
       <br /> <br />

       <img style="padding-right:280px;" src="generate.php"><br /><br />
       <input type="text" name="secure" size="10" required placeholder="Enter The Value" style="padding-right:290px; height:30px; font-size:20px">
       <br />  <br /> <br />
       <input type="submit" name="log" id="log" value="Register"  style="padding-right:40px; font-size:20px" />

    </form>
    <p>&nbsp; </p>
 </div>
   <br />
  <br />
   <br />
    </div>

    </div>
      </body>
    </html>

One problem is that the datetime is not enclosed in quotes: `now()` — juergen d, Aug 14 '15 at 15:16
Since you say there is no error, I'll just assume it works fine. — Jack M., Aug 14 '15 at 15:17
You can try my answer here in http://stackoverflow.com/questions/31937421/trying-to-input-data-into-sql-table-using-php-html-from-registration-form/31937479#31937479 using mysqli — aldrin27, Aug 14 '15 at 15:27

score 2 · Accepted Answer · answered Aug 14 '15 at 15:18

2

you have nothing with a name of "submit". $_POST['submit'] is never set, and your if function never runs.

answered Aug 14 '15 at 15:18

Tyler Collins

127
10

ahhh okk what about this.. this is not submit – komal deep singh chahal Aug 14 '15 at 15:25
Yes, that is your submit button, but its name is "log", which would set $_POST['log']. you need an input field with a name of 'submit' for that if statement to execute. Or, change the if statement to isset($_POST['log']) – Tyler Collins Aug 14 '15 at 15:27
ahh okk.. let me check this bro – komal deep singh chahal Aug 14 '15 at 15:28

score 1 · Answer 2 · answered Aug 14 '15 at 15:32

1

your condition is looking for $_POST['submit']

$_POST['submit'] is not present

replace $_POST['submit'] by $_POST and it gets your all data

one more thing Php eliminate mysql for some reason, use mysqli for database connections and query's

answered Aug 14 '15 at 15:32

Faraz Ali

28
1
7

score 1 · Answer 3 · answered Aug 14 '15 at 16:17

Please look at the HTML for the submit button -> input type="submit"

In your php code, you're checking if a submit button with a name "submit" exists, but actually, the name of the submit button is "log"

if(isset($_POST["submit"])) needs to be changed to if(isset($_POST["log"]))

That's all! :)

insertion is not happening in php and mysql form

3 Answers3