Page 1 of 1

Hm.. parse error..

Posted: Sun Oct 26, 2003 1:36 pm
by nick2

Code: Select all

<?php

if ((!$_POST[username]) || (!$_POST[password]) || (!$_POST[password2]) || (!$_POST[password2]) || (!$_POST[question]) || (!$_POST[answer]) || (!$_POST[email])) {
 Print ("Please hit the back button and make sure you filled in the feilds correctly");
}

##starting create user##
#variables#
$db_address = "localhost"
$db_name = "slices_net";
$table_name = "ebayuser";
$db_user = "slics";
$db_pass = "1";

#connection#
$connection  = @mysql_connect($db_address, $db_user, $db_pass) or die(mysql_error());

#insert data#
$sql = "INSERT INTO $table_name (username, password, question, answer, email) VALUES ('$_POST[username]', '$_POST[password]', '$_POST[question]', '$_POST[answer]', '$_POST[email]');

#results#
$result = @mysql_query($sql, $connection) or die(mysql_error());

#print results#
Print $result
?>

on line 10 it says parse error any ideas? :oops:

Posted: Sun Oct 26, 2003 2:04 pm
by Kriek
**********************************************************

Code: Select all

<?php
    extract($_POST);
    if(empty($username) || empty($password) || empty($question) || empty($answer) || empty($email)) &#123;
        echo 'Please hit the back button and make sure you filled in the fields correctly';
    &#125; else &#123;
        $db_address = 'localhost';
        $db_name = 'slices_net';
        $table_name = 'ebayuser';
        $db_user = 'slics';
        $db_pass = 1;
        $connection = mysql_connect($db_address, $db_user, $db_pass) or die(mysql_error());
        mysql_select_db($db_name) or die(mysql_error());
        $sql = "INSERT INTO $table_name(username, password, question, answer, email) VALUES('" . $username . "', '" . $password . "', '" . $question . "', '" . $answer . "', '" . $email . "')";
        $result = mysql_query($sql, $connection) or die(mysql_error());
        echo $result;
        mysql_free_result($result) or die(mysql_error());
        mysql_close($connection) or die(mysql_error());
    &#125;
?>
**********************************************************
nick2 wrote:$db_address = "localhost"
Absent semi-colon.

Code: Select all

$db_address = 'localhost';
**********************************************************
nick2 wrote:$sql = "INSERT INTO $table_name (username, password, question, answer, email) VALUES ('$_POST[username]', '$_POST[password]', '$_POST[question]', '$_POST[answer]', '$_POST[email]');
Absent trailing/closing double-quote.

Code: Select all

$sql = "INSERT INTO $table_name(username, password, question, answer, email) VALUES('$_POST&#1111;username]', '$_POST&#1111;password]', '$_POST&#1111;question]', '$_POST&#1111;answer]', '$_POST&#1111;email]')";
**********************************************************
nick2 wrote:Print $result
Yet another absent semi-colon.

Code: Select all

print $result;
**********************************************************

Select the database.

Code: Select all

mysql_select_db($db_name) or die(mysql_error());

**********************************************************
nick2 wrote:$connection = @mysql_connect($db_address, $db_user, $db_pass) or die(mysql_error());
Absolutely pointless.

Code: Select all

$connection = mysql_connect($db_address, $db_user, $db_pass) or die(mysql_error());
**********************************************************
nick2 wrote:$result = @mysql_query($sql, $connection) or die(mysql_error());


Again - absolutely pointless.

Code: Select all

$result = mysql_query($sql, $connection) or die(mysql_error());
**********************************************************