检查身份证号码在我的数据库中 [英] check ID number is in my database

问题描述

大家好，



i需要获取有关我的申请表格的一些信息。如果用户填写需要检查插入的号码已经在我的database.can你能给我解决这个问题的建议

这是代码的一部分

hi all,

i need to get some information abouth my application form.i have NIC number if user fill it need to check that inserted number is already in my database.can you please give me the suggestion to solve this problem
this is the part of the code

$nic_vali = mysql_quary("SELECT nic FROM application WHERE nic='$nic'");
		
		if(mysql_num_rows($nic_val) > 0) {
                
                 echo '<script type="text/javascript">alert("NIC number already in System.please check again");</script>';
		
		}

这是我用过的代码。但它不是检查和数据也没有如果我单击添加按钮，则插入数据库。

this is the code that i have used.but it is not checking and data also not inserting the database if i click the add button.

推荐答案

nic_vali = mysql_quary（ SELECT nic FROM application WHERE nic ='

nic_vali = mysql_quary("SELECT nic FROM application WHERE nic='

nic'）;

if（mysql_num_rows（

nic'"); if(mysql_num_rows(

nic_val）> 0）{

echo ' < script type =text / javascript> alert（已在System.please中的网卡号再次检查）;< / script>';

}

nic_val) > 0) { echo '<script type="text/javascript">alert("NIC number already in System.please check again");</script>'; }

这是我用过的代码。但它不是检查和数据也没有如果我单击添加按钮，则插入数据库。

this is the code that i have used.but it is not checking and data also not inserting the database if i click the add button.

这篇关于检查身份证号码在我的数据库中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！