Jump to content

No data inserted into database. Am I wrongdoing it?

- - - - -

This topic has been archived. This means that you cannot reply to this topic.
2 replies to this topic

#1
faith89

faith89

    Newbie

  • Members
  • PipPip
  • 14 posts
I have a form named:"RegistrationForm.php". when i click the "submit button", there's a data inserted in the database (the prove is, there a new row in the database),
but there's no value from user textfield(ic_no,name,email...) that have been inserted.
It means like there's a row of data inserted but without value..

p/s- however, when i click the submit button, it successfully directed me to the "BookingForm.php" with all the session value...it's just that there's no data inserted into the database.

can someone straighten this up for me? am i doing wrong with the coding with the submit button?
here's the code



<?php

session_start();

$_SESSION['ic_no']=$ic_no;

$_SESSION['name']=$name;

$_SESSION['address']=$address;

$_SESSION['tel_no']=$tel_no;

$_SESSION['email']=$email;

?>



<html>

<body>


<form action="BookingForm.php" method="post">

  <p><strong>REGISTRATION FORM</strong></p>

  <table width="285" border="1">

    <tr>

      <th width="120" scope="row">Ic No :</th>

      <td width="149"><label>

        <input type="text" name="ic_no" id="ic_no" value="<?php $ic_no; ?>">

      </label></td>

    </tr>

    <tr>

      <th scope="row">Name :</th>

      <td><label>

        <input type="text" name="name" id="name" value="<?php $name; ?>">

      </label></td>

    </tr>

    <tr>

      <th scope="row">Address :</th>

      <td><label>

        <input type="text" name="address" id="address" value="<?php $address; ?>" >

      </label></td>

    </tr>

    <tr>

      <th scope="row">Contact No :</th>

      <td><label>

        <input type="text" name="tel_no" id="tel_no" value="<?php $tel_no; ?>">

      </label></td>

    </tr>

    <tr>

      <th scope="row">Email :</th>

      <td><label>

        <input type="text" name="email" id="email"  value="<?php $email; ?>">

      </label></td>

    </tr>

  </table>

  <input type="submit" name="submit" id="submit" value="Submit">

  <?php

$con = mysql_connect("localhost","root","password");

if (!$con)

  {

  die('Could not connect: ' . mysql_error());

  }


mysql_select_db("ambos", $con);


mysql_query("INSERT INTO customer (ic_no, name, address, tel_no, email)

VALUES ('$_POST[ic_no]', '$_POST[name]', '$_POST[address]','$_POST[tel_no]','$_POST[email]')");

mysql_close($con);


</form>

 </body>

</html>



any ideas is really appreciated

#2
hasher

hasher

    Newbie

  • Members
  • Pip
  • 3 posts
Maybe your database is configured wrong, for example the length of varchar in the individual fields.

#3
John

John

    Writes binary right handed and hex left handed

  • Moderators
  • 6,321 posts
$_POST[ic_no] is an invalid syntax (ic_no ect... is not a constant). You must use $_POST['ic_no']. Change your query appropriately.