Help for the script

Discussion in 'PHP' started by yoursanjay, Jul 6, 2008.

0
  1. #1
    Hi.. I am new in php.. I have written a script for user input to the database and having an error "Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in C:\xampp\htdocs\TEST\bluebell.php on line 43"..

    <!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=iso-8859-1" />
    <title>User Input to the database</title>
    </head>

    <body>
    <?php
    $database="bluebell";
    $username="root";
    $password="";


    function write_form()
    {
    print<<<EOF
    <form method="post" action={$_SERVER['PHP_SELF']}>

    <p><input type="text" name="user_name">Your User Name:</p>
    <p><input type="password" name="password">Your Password:</p>
    <p><select name="prefix">
    <option value="Mr."></option>
    <option value="Mrs."></option>
    <option value="Dr."></option>
    </select></p>
    <p><input type="text" name="first_name">Your First Name:</p>
    <p><input type="text" name="last_name">Your Last Name:</p>
    <p><input type="text" name="email">Your Email Id:</p>
    <p><input type="text" name="address1">Your Address Line1:</p>
    <p><input type="text" name="address2">Your Address Line2:</p>
    <p><input type="text" name="city">Your City:</p>
    <p><input type="text" name="state">Your State:</p>
    <p><input type="text" name="code">Your Postal Code:</p>
    <p><input type="text" name="country">Your Country:</p>
    <p><input type="text" name="phone">Your Phone Number:</p>

    <p><input type="submit" value="Submit"></p>
    </form>
    FORM;
    }

    if (!empty($_REQUEST['user_name']) && !empty($_REQUEST['password']) && !empty($_REQUEST['prefix']) && !empty($_REQUEST['first_name']) && !empty($_REQUEST['last_name']) && !empty($_REQUEST['email']) && !empty($_REQUEST['address1']) && !empty($_REQUEST['address2']) && !empty($_REQUEST['city']) && !empty($_REQUEST['state']) && !empty($_REQUEST['code']) && !empty($_REQUEST['country']) && !empty($_REQUEST['phone']))
    {
    $dberror="";
    $ret=add_to_database($_REQUEST['user_name'],$_REQUEST['password'],$_REQUEST['prefix'],$_REQUEST['first_name'],$_REQUEST['last_name'],$_REQUEST['email'],$_REQUEST['address1'],$_REQUEST['address2'],$_REQUEST['city'],$_REQUEST['state'],$_REQUEST['code'],$_REQUEST['country'],$_REQUEST['phone'],$dberror);

    if(!$ret)
    {
    print "Error:$dberror<br/>\n";
    }
    else
    {
    print "Thank you very much!!";
    }
    }
    else
    {
    write_form();
    }

    function add_to_database($user_name,$password,$prefix,$first_name,$last_name,$email,$address1,$address2,$city,$state,$code,$country,$phone,&$dberror)
    {
    $user_name=mysql_real_escape_string($user_name);
    $password=mysql_real_escape_string($password);
    $prefix=mysql_real_escape_string($prefix) ;
    $first_name=mysql_real_escape_string($first_name);
    $last_name=mysql_real_escape_string($last_name);
    $email=mysql_real_escape_string($email);
    $address1=mysql_real_escape_string($address1);
    $address2=mysql_real_escape_string($address2);
    $city=mysql_real_escape_string($city);
    $state=mysql_real_escape_string($state);
    $code=mysql_real_escape_string($code);
    $country=mysql_real_escape_string($country);
    $phone=mysql_real_escape_string($phone);

    $connect=mysql_connect("localhost",$username,$password);
    if(!$connect)
    {
    $dberror=mysql_error();
    return false;
    }

    if(!mysql_select_db($database,$connect))
    {
    $dberror=mysql_error();
    return false;
    }

    $query="insert into user (user_name,password,prefix,first_name,last_name,email,address1,address2,city,state,code,country,phone) values ($user_name,$password,$prefix,$first_name,$last_name,$email,$address1,$address2,$city,$state,$code,$country,$phone)";

    if(!mysql_query($query,$connect))
    {
    $dberror=mysql_error();
    return false
    }
    return true;
    }
    ?>
    </body>
    </html>


    plz make me understand the error....
     
    yoursanjay, Jul 6, 2008 IP
  2. Danltn

    Danltn Well-Known Member

    Messages:
    679
    Likes Received:
    36
    Best Answers:
    0
    Trophy Points:
    120
    #2
    Oh look! A window! *Chuck* Bye Bye MVC!

    *Sigh*

    <!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=iso-8859-1" />
<title>User Input to the database</title>
</head>

<body>
<?php
$database = "bluebell";
$username = "root";
$password = "";

function write_form()
{
    print <<< EOF
<form method="post" action={$_SERVER['PHP_SELF']}>

<p><input type="text" name="user_name">Your User Name:</p>
<p><input type="password" name="password">Your Password:</p>
<p><select name="prefix">
<option value="Mr."></option>
<option value="Mrs."></option>
<option value="Dr."></option>
</select></p>
<p><input type="text" name="first_name">Your First Name:</p>
<p><input type="text" name="last_name">Your Last Name:</p>
<p><input type="text" name="email">Your Email Id:</p>
<p><input type="text" name="address1">Your Address Line1:</p>
<p><input type="text" name="address2">Your Address Line2:</p>
<p><input type="text" name="city">Your City:</p>
<p><input type="text" name="state">Your State:</p>
<p><input type="text" name="code">Your Postal Code:</p>
<p><input type="text" name="country">Your Country:</p>
<p><input type="text" name="phone">Your Phone Number:</p>

<p><input type="submit" value="Submit"></p>
</form>
EOF;
}

if ( !empty($_REQUEST['user_name']) && !empty($_REQUEST['password']) && !empty($_REQUEST['prefix']) && !empty($_REQUEST['first_name']) && !empty($_REQUEST['last_name']) && !empty($_REQUEST['email']) && !empty($_REQUEST['address1']) && !empty($_REQUEST['address2']) && !empty($_REQUEST['city']) && !empty($_REQUEST['state']) && !empty($_REQUEST['code']) && !empty($_REQUEST['country']) && !empty($_REQUEST['phone']) )
{
    $dberror = "";
    $ret = add_to_database( $_REQUEST['user_name'], $_REQUEST['password'], $_REQUEST['prefix'], $_REQUEST['first_name'], $_REQUEST['last_name'], $_REQUEST['email'], $_REQUEST['address1'], $_REQUEST['address2'], $_REQUEST['city'], $_REQUEST['state'], $_REQUEST['code'], $_REQUEST['country'], $_REQUEST['phone'], $dberror );

    if ( !$ret )
    {
        print "Error:$dberror<br/>\n";
    }
    else
    {
        print "Thank you very much!!";
    }
}
else
{
    write_form();
}

function add_to_database( $user_name, $password, $prefix, $first_name, $last_name, $email, $address1, $address2, $city, $state, $code, $country, $phone, &$dberror )
{
    $user_name = mysql_real_escape_string( $user_name );
    $password = mysql_real_escape_string( $password );
    $prefix = mysql_real_escape_string( $prefix );
    $first_name = mysql_real_escape_string( $first_name );
    $last_name = mysql_real_escape_string( $last_name );
    $email = mysql_real_escape_string( $email );
    $address1 = mysql_real_escape_string( $address1 );
    $address2 = mysql_real_escape_string( $address2 );
    $city = mysql_real_escape_string( $city );
    $state = mysql_real_escape_string( $state );
    $code = mysql_real_escape_string( $code );
    $country = mysql_real_escape_string( $country );
    $phone = mysql_real_escape_string( $phone );

    $connect = mysql_connect( "localhost", $username, $password );
    if ( !$connect )
    {
        $dberror = mysql_error();
        return false;
    }

    if ( !mysql_select_db($database, $connect) )
    {
        $dberror = mysql_error();
        return false;
    }

    $query = "insert into user (user_name,password,prefix,first_name,last_name,email,address1,address2,city,state,code,country,phone) values ($user_name,$password,$prefix,$first_name,$last_name,$email,$address1,$address2,$city,$state,$code,$country,$phone)";

    if ( !mysql_query($query, $connect) )
    {
        $dberror = mysql_error();
        return false;
    }
    return true;
}
?>
</body>
</html>
    PHP:
    Beautified as well.
     
    Danltn, Jul 6, 2008 IP