database error

Discussion in 'PHP' started by barnes, Apr 23, 2007.

  1. #1
    i modified above code.now it's working fine.records are added into database
    but following error is getting and e mail is empty.all other fields are added..

    Notice: Undefined index: email in c:\easyphp1-8\www\register1.php on line 12
    1 record added

    <html>
    <body >

    <table bgcolor="cyan" height="200"width="200" align="center">
    <tr align="center"><td><font size="3">UserRegisteration</font></td></tr>
    <form name="frmname" action="register1.php" method="post" enctype=""multipart/form-data">
    <tr><td>Username</td><td><input type="text" name="name"></td></tr><br>
    <tr><td>password</td><td><input type="password" name="pwd"></td></tr><br>
    <tr><td>E-mail</td><td><input type="text" name="email"></td></tr>
    <tr><td>Confirm E-mail</td><td><input type="text" name="cemail"></td></tr><br>
    <tr><td>Address:</td><td><input type="textarea" width="100" height="100" name="address"></td></tr><br>

    <tr><td>Phone no:</td><td><input type="Text" name="phone"></td></tr><br>
    <tr colspan="2" align="center"><td><input type="submit" name="submit" value="submit"></td></tr>
    </table>
    </body>
    </html>



    </form>
    </table>

    register1.php
    <?php

    $con = mysql_connect("localhost","root","");
    if (!$con)
    {
    die('Could not connect: ' . mysql_error());
    }

    mysql_select_db("user", $con);
    $username=mysql_real_escape_string($_POST['name']);
    $pwd=mysql_real_escape_string($_POST['pwd']);
    $email=mysql_real_escape_string($_POST['email']);
    $cemail=mysql_real_escape_string($_POST['cemail']);
    $add=mysql_real_escape_string($_POST['address']);
    $phone=mysql_real_escape_string($_POST['phone']);

    $sql="INSERT INTO user (username,password,email,confirmemail,Address,Phoneno)
    VALUES
    ('{$username}','{$pwd}','{$email}','{$cemail}','{$add}','{$phone}')";

    if (!mysql_query($sql,$con))
    {
    die('Error: ' . mysql_error());
    }
    echo "1 record added";

    mysql_close($con)
    ?>
     
    barnes, Apr 23, 2007 IP
  2. Subikar

    Subikar Active Member

    Messages:
    241
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    60
    #2
    Can we see the Table schema of "user" table.
     
    Subikar, Apr 23, 2007 IP
  3. barnes

    barnes Guest

    Messages:
    47
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    yes ..right.column names are

    Username
    password
    email
    Confirmemail
    Address
    Phoneno
     
    barnes, Apr 23, 2007 IP
  4. pepsipunk

    pepsipunk Well-Known Member

    Messages:
    208
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    108
    #4
    email isn't being sent from your form. make sure it's being submitted
    you can check that it's being sent with this code
    
    if(isset($_POST['email'] == TRUE)
    $email =  $_POST['email'];
    else
    $errors[]="email is not set";
    
    Code (markup):
     
    pepsipunk, Apr 24, 2007 IP