ช่วยดูโค๊ด เช็คข้อมูลกับอีเมล์ซ้ำให้หน่อยครับแบบ sqli
จากบทความ https://www.thaicreate.com/community/jquery-auto-fill-textbox.html Code (PHP) <?
$objConnect = mysqli_connect("localhost","root","123456789") or die("ERROE DB");
$objDB = mysqli_select_db($objConnect,"like");
$strSQL = "SELECT * FROM customer WHERE 1 AND CustomerID = '".$_POST["sCusID"]."' OR Email = '".$_POST["eMail"]."' ";
$objQuery = mysqli_query($objConnect,$strSQL) or die ("ERROR SEELECT");
$intNumField = mysqli_num_fields($objQuery);
$resultArray = array();
while($obResult = mysqli_fetch_array($objQuery))
{
$arrCol = array();
for($i=0;$i<$intNumField;$i )
{
$arrCol[mysql_field_name($objQuery,$i)] = $obResult[$i];
}
array_push($resultArray,$arrCol);
}
mysqli_close($objConnect);
echo json_encode($resultArray);
?>
Code (PHP) <html>
<head>
<title>####</title>
<script src="http://code.jquery.com/jquery-latest.js"></script>
<script type="text/javascript">
$(document).ready(function(){
$("#txtCustomerID,#txtEmail").change(function(){
$("#sCusID").empty();
$("#sEmail").empty();
$.ajax({
url: "returnCustomer1.php" ,
type: "POST",
data: 'sCusID=' $("#txtCustomerID").val() '&eMail=' $("#txtEmail").val()
})
.success(function(result) {
var obj = jQuery.parseJSON(result);
if(obj != '')
{
$.each(obj, function(key, inval) {
if($("#txtCustomerID").val() == inval["CustomerID"])
{
$("#sCusID").html(" <font color='red'>รหัสลูกค้านี้มีอยู่แล้ว</font>");
}
if($("#txtEmail").val() == inval["Email"])
{
$("#sEmail").html(" <font color='red'>อีเมล์นี้มีอยู่แล้ว</font>");
}
});
}
});
});
});
</script>
</head>
<body>
<h2>jQuery ตรวจสอบข้อมูลซ้ำ</h2>
<table width="399" border="1">
<tr>
<td width="114">CustomerID <font color="red">*</font></td>
<td width="309"><input type="text" id="txtCustomerID" name="txtCustomerID" size="5">
<span id="sCusID"></span>
</td>
</tr>
<tr>
<td>Name</td>
<td><input type="text" id="txtName" name="txtName" size="20"></td>
</tr>
<tr>
<td>Email <font color="red">*</font></td>
<td><input type="text" id="txtEmail" name="txtEmail" size="25">
<span id="sEmail"></span>
</td>
</tr>
<tr>
<td>CountryCode</td>
<td><input type="text" id="txtCountryCode" name="txtCountryCode" size="2"></td>
</tr>
<tr>
<td>Budget</td>
<td><input type="text" id="txtBudget" name="txtBudget" size="5"></td>
</tr>
<tr>
<td>Used</td>
<td><input type="text" id="txtUsed" name="txtUsed" size="5"></td>
</tr>
</table>
</body>
</html>
-- phpMyAdmin SQL Dump[email protected] ', 'TH', 1000000, 600000),[email protected] ', 'EN', 2000000, 800000),[email protected] ', 'US', 3000000, 600000),[email protected] ', 'US', 4000000, 100000); Tag PHP, JavaScript, Ajax, jQuery, JAVA
ประวัติการแก้ไข
Date :
2016-07-01 01:11:34By :
PermloginView :
1246Reply :
5
ศึกษา validate remote สิ
Date :
2016-07-01 08:06:04By :
fossil31
คล้ายกับของผมนะ แต่ php ของผมให้เช็คว่า query แล้วเจอข้อมูลไหม ใช้ num_rows ถ้า query แล้ว เจอข้อมูลแถวมันจะมากกว่า 0Code (PHP) public static function unique($table,$field,$value,$code){
$DB=conDB::Con_DB();
$sql = "SELECT $field FROM $table ";
$sql .= " WHERE $field='$value' AND user_id='$code'";
$charset = $DB->query("SET NAMES UTF8");
$result = $DB->query($sql);
$NumR = $result->num_rows;
if (!$result) {
return false;
} else {
if ($NumR > 0) {
return false;
} else {
return true;
}
$result->free();
}
mysqli_close($DB);
}
Code (PHP) $unique = class::unique($table,$field,$value,$code);
if($unique){
$sql = "INSERT into tablet";
echo "{\"response\":\"success\"}";
}else{
echo "{\"response\":\"false\"}";
}
Code (JavaScript)
$.ajax({
url: "URL",
dataType: "json",
success: function (data) {
if (data.response == 'success') {
$("#Success").jqxNotification("open");//ใส่ action ที่ต้องการ
} else {
$("#Warning").jqxNotification("open");//ใส่ action ที่ต้องการ
}
Date :
2016-07-01 10:00:40By :
thesin18598
Server 01
Load balance : Server 01
Quote:
