Question

在表格中插入新的记录。谁会帮助?

<?php include( config.php ); ?>
<?php 

if(!empty($_POST[ forename ]) && !empty($_POST[ surname ]) && !empty($_POST[ email ]) && !empty($_POST[ emailconfirm ]) && !empty($_POST[ password ])) {
    if($_POST[ email ] == $_POST[ emailconfirm ]) {
        $forename = mysql_real_escape_string($_POST[ forename ]);
        $surname = mysql_real_escape_string($_POST[ surname ]);
        $email = mysql_real_escape_string($_POST[ email ]);
        $password = md5(mysql_real_escape_string($_POST[ password ]));
        register();
    }
    else { $errormessage = "Emails do not match"; }
}
else { $errormessage = "Not all fields filled"; }

function register() {
$check = mysql_query("SELECT * FROM Users WHERE EmailAddress =  ".$email." ");
    if (mysql_num_rows($check) == 1) {
        $errormessage = "Account already exists with the email address provided";
    }
    else {
        $register = mysql_query("INSERT INTO Users (EmailAddress, Password, Forename, Surname) VALUES( ".$email." ,  ".$password." ,  ".$forename." ,  ".$surname." )");
        $errormessage = "Account Added";
    }
}
?>

我认为,问题在于我的SQL Query声明?

Answer 1

您的<代码>登记<>/代码>功能中的变量不属于范围。需要将其全球化。

function register() {
    global $email, $password, $forename, $surname, $errormessage;

    $check = mysql_query("SELECT * FROM Users WHERE EmailAddress =  ".$email." ");
    if (mysql_num_rows($check) == 1) {
        $errormessage = "Account already exists with the email address provided";
    }
    else {
        $register = mysql_query("INSERT INTO Users (EmailAddress, Password, Forename, Surname) VALUES( ".$email." ,  ".$password." ,  ".$forename." ,  ".$surname." )");
        $errormessage = "Account Added";
    }
}

Answer 2

No params pass to the function register()?? In this file, you want to use register() to add record to the sql. But how could the register() know what value should be use for $mail variable? You can use global in register() in this way:

global  $email, $password, $forename, $surname, $errormessage;

也可将<代码>register()重新编号。

function register($email, $password, $forename, $surname, $errormessage){....}

并将斜线通过<条码>登记(电子邮箱:$email,$spassword,$ename,$surname,$errormessage)。

友情链接