1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

database error

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

0
  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