检查名称是否已经存在 [英] checking if name already exists

问题描述

大家好，
我正在尝试检查mysql表是否已经存在该名称:这是代码

Hey Guys,
I am trying to check mysql table if the name already exists: this is the code

if (mysql_num_rows(mysql_query('SELECT COUNT(*) FROM table WHERE FirstName=\'' . $firstname . '\' AND LastName=\'' . $lastname . '\' LIMIT 1')) == 0)
    {
        
        $query = "INSERT INTO table(FirstName,LastName, number)VALUES('$firstname', '$lastname', 'number')";
        mysql_query($query,$con);
        echo " uploaded";

    }

    else
    {
        echo "Record already exists";
    }

但是我一直在获得记录，并且一直没有插入任何内容.如何解决此问题，请帮忙.

but i am getting record already exists all the time and it isn''t inserting anything. How to fix this please help.

推荐答案

firstname. ' \ ' AND LastName = \''.

firstname . '\' AND LastName=\'' .

姓氏. ' \ ' LIMIT 1')))==

lastname . '\' LIMIT 1')) == 0) {

查询 = "

query = "INSERT INTO table(FirstName,LastName, number)VALUES('

这篇关于检查名称是否已经存在的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！