21,886
社区成员
发帖
与我相关
我的任务
分享
<form id="form1" name="form1" method="post" action="action.php?act=add" onsubmit="return check()">
<div class="hang_tit">Customer Information</div>
<div class="hang_item">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>Customer No.:<span class="khxx"><input name="kehu" type="text" id="kehu" size="10" placeholder="" onblur="khxx(this)"/></span></td>
<td>Category:<span class="Category"></span></td>
<td>Grade:<span class="Grade"></span></td>
</tr>
<tr>
<td>Customer Name: <span class="khname"></span></td>
<td>Address: <span class="address"></span></td>
<td> </td>
</tr>
<tr>
<td>Contact Person: <span class="Person"></span></td>
<td>Email:: <span class="email"></span></td>
<td><span class=""></span></td>
</tr>
</table>
function khxx(obj){
khid=$(obj).attr("value");
//console.log(khid);
$.post("action.php?act=getKehu", { "khid": khid },
function(data){
//console.log(khid);
//$(obj).parents('tr').find('.pname').html(data.data[0].pname);
$(".Category").html(data.data[0].Category);
$(".Grade").html(data.data[0].Grade);
$(".khname").html(data.data[0].khname);
$(".address").html(data.data[0].address);
$("#d_address").val(data.data[0].address);
$(".Person").html(data.data[0].Person);
$(".email").html(data.data[0].email);
}, "json");
}
if($act=="getKehu"){
$sql_kh="select * from customer where CustomerNo='$khid'";
$result_kh=mysqli_query($GLOBALS['conn'], $sql_kh);
$info_kh=mysqli_fetch_array($result_kh);
$Category=$info_kh['Category'];
$Grade=$info_kh['Grade'];
$khname=$info_kh[2];
$address=$info_kh['Address'];
$Person=$info_kh['ContactPerson'];
$email=$info_kh['Email'];
echo '{"status" : 0 ,"msg" : "SUCCESS","data" :[{"Category":"'.$Category.'" ,"Grade" : "'.$Grade.'","khname" : "'.$khname.'","address" : "'.$address.'","Person" : "'.$Person.'","email" : "'.$email.'"},{"id" : 2,"name" : "xiaoming"}]}';
}