在TP中直接写sql语句:
我举例说明,你举一反三即可
直接查询:
public function v(){
$Form=M();
$sql="select * from news ";
$list =$Form->query($sql);
$this->assign('list',$list);
$this->display();
}
条件查询:
public function v(){
$id=$_GET['i'];
$Form=M();
$sql="select * from news where id=".$id."";
$list =$Form->query($sql);
$this->assign('list',$list);
$this->display();
}
分页查询:
public function l(){
import("@.ORG.Page"); //导入分页类
$Form=M();
$sql="select * from goods order by id asc";
$list =$Form->query($sql);
$count = count($list); //计算总数
$p = new Page ($count, 5);
$up=$p->firstRow; //开始条数
$down=$p->listRows;//结束条数
$sql=$sql.' limit '.$up.','.$down.' ';
$list =$Form->query($sql);
$page = $p->show ();
$this->assign ( "page", $page );
$this->assign ( "list", $list );
$this->display();
}
select * from student inner join course on student.ID=course.ID
//新闻批量删除
public function newsDel(){
$ids=$_POST['ids'];
$condition['picName']=array('in',$ids);
foreach($condition['picName'][1] as $k => $v){
$file="./web/Uploads/PPT/{$v}";
if (!unlink($file))
{
echo ("Error deleting $file");
}
}
foreach($condition['picName'][1] as $k => $v){
$file="./web/Uploads/PPT/thumb_{$v}";
if (!unlink($file))
{
echo ("Error deleting $file");
}
}