多用户注册MYSQL

Question

所以我有这个api脚本，人们将拥有HWID，当他们打开一个程序时，它必须将他们的信息添加到他们的帐户中，但是当有多个用户具有相同的HWID时，它就会搞砸，没有将他们的信息添加到帐户中，下面是我使用的代码：

$cpukey = mysql_escape_string($_GET['cpukey']);
    $ip = mysql_escape_string($_GET['ip']);
    $pcname = mysql_escape_string($_GET['pcname']);
    $con = mysql_connect($host,$username,$password);
    mysql_select_db("$db_name", $con);
    $sql="SELECT * FROM $table WHERE cpukey = '$cpukey'";
    $result=mysql_query($sql);
    $count=mysql_num_rows($result);
    if($count == 1){
        $result = mysql_query("SELECT * FROM $table") or die(mysql_error()); 
        while($row = mysql_fetch_array( $result )) {
        $time = time();
        if ($row['ip'] = '-' and $row['pcname'] = '-'){
            mysql_query("UPDATE $table SET pcname = '$pcname'
            WHERE cpukey = '$cpukey' AND pcname = '-'");
            mysql_query("UPDATE $table SET ip = '$ip'
            WHERE cpukey = '$cpukey' AND pcname = '$pcname'");
            if ( $row['expire'] > $time) {
                $str1 = "NOT EXPIRED";
            }else{
                $str1 = "EXPIRED";
                mysql_query("UPDATE $table SET expired = 'Yes'
                WHERE cpukey = '$cpukey' AND pcname = '$pcname'");
                mysql_query("UPDATE $table SET banned = '1'
                WHERE cpukey = '$cpukey' AND pcname = '$pcname'");
            }
            echo $str1;
        } else {
            mysql_query("UPDATE $table SET pcname = '$pcname'
            WHERE cpukey = '$cpukey' AND pcname = '$pcname'");
            mysql_query("UPDATE $table SET ip = '$ip'
            WHERE cpukey = '$cpukey' AND pcname = '$pcname'");
            if ( $row['expire'] > $time) {
                $str1 = "NOT EXPIRED";
            }else{
                $str1 = "EXPIRED";
                mysql_query("UPDATE $table SET expired = 'Yes'
                WHERE cpukey = '$cpukey' AND pcname = '$pcname'");
                mysql_query("UPDATE $table SET banned = '1'
                WHERE cpukey = '$cpukey' AND pcname = '$pcname'");
            }
            echo $str1;
            }
        }
    }
    mysql_close($con);
    mysql_connect($host, $username, $password) or die(mysql_error());
    mysql_select_db($db_name) or die(mysql_error());
    $result = mysql_query("SELECT * FROM $table") or die(mysql_error()); 
    while($row = mysql_fetch_array( $result )) {
    if ( $cpukey == $row['cpukey'] ) {
       if ( $row['banned'] == 0) {
        $str = "Not Banned";
            break;
       }else{
            $str = "Banned";}
            break;
    } else {
            $str = "Don't Exist";} 
    }
    echo $str;

现在我希望代码添加用户的信息，如果他们的信息还没有输入，他们的信息将是"-“，然后当他们打开程序时，它会改变他们的信息到其他东西…换句话说，在人们可以拥有相同的HWID的情况下，它不会产生任何错误……

Answer 1

这就是你的问题：

if ($row['ip'] = '-' and $row['pcname'] = '-'){

它应该是

if ($row['ip'] == '-' and $row['pcname'] == '-'){