ThingkPHP對(duì)數(shù)據(jù)庫(kù)進(jìn)行改操作
2022-11-22 加入收藏
public function test_check(){
$Experiment = M("Experiment");//實(shí)例化Experiment對(duì)象。這個(gè)對(duì)象是跟數(shù)據(jù)庫(kù)的表對(duì)應(yīng)的。是對(duì)experiment表進(jìn)行增刪改查操作
//$sno = I('sno');
$sno = '130906008';
$RowCount = $Experiment -> where("sno = $sno") -> Count();//得到滿足條件的行數(shù)
//echo M("Experiment")->getLastSql(); //打印SQL語(yǔ)句到瀏覽器界面上
echo $RowCount;//打印滿足條件的行數(shù)
if($RowCount > 0){
$myModel = new \Think\Model();
$result=$myModel->query("select *from g_experiment where sno = $sno;");
$this ->ajaxReturn($result);
}