为什么获胜'；我的mysqli插入/更新工作 - Why won't my mysqli insert/update work

Why won't my mysqli insert/update work

我的编码出了什么问题，因为它不起作用？

$empsql("SELECT * FROM employees WHERE e_id ='$ed_id' ");
if($rows > 0)  {
    $empsql('UPDATE employees SET name = "'.$name.'" , description = "'.$description.'" , telephone = "'.$telephone.'" , email = "'.$email.'" WHERE e_id = "'.$ed_id.'" ');
}
else
{
    $empsql("INSERT INTO employees (name,description,telephone,email) VALUES ('$name','$description','$telephone','$email') ");
}

您应该真正坚持基础知识，因为您的语法毫无意义。这个代码更有意义。

$empsql = "SELECT * FROM employees WHERE e_id ='$ed_id'";
$rows = mysql_fetch_array(mysql_query($empsql));
if(!empty($rows))  {
    mysql_query('UPDATE employees SET name = "'.$name.'" , description = "'.$description.'" , telephone = "'.$telephone.'" , email = "'.$email.'" WHERE e_id = "'.$ed_id.'" ');
}
else
{
    mysql_query("REPLACE INTO employees (name,description,telephone,email) VALUES ('$name','$description','$telephone','$email') ");
}