最受欢迎

编写sql查询，查找数据库中的重复行

Yii: Write sql query find duplicate rows in database

本文关键字：数据库 sql 查询查找编写 | 更新日期: 2023-09-27

我有一个sql查询，无法找出如何在yii中编写它

$con=mysqli_connect('localhost','user','pwd','db_name');
$check = mysqli_query($con,"select * from tbl where cmail='$mail' and ename='$ename' ");
if(mysqli_num_rows($check)>0)
{
   //do nothing;
}
else
{ 
   //insert row to db
}

我试着用下面的方法做了，但还是找不到我的错误

$cmd1 = Yii::app()->db->createCommand("select * from tbl where cmail='$mail' and      ename='$ename' ");
$cmd1->execute();
if(mysqli_num_rows($cmd1)>0)
{
//...
}
else
{
 //...
}

$results = Yii::app()->db
    ->createCommand("select * from tbl where cmail='$mail' and ename='$ename'")
    ->queyAll();

相关文章：

最新更新