[class] php mysql curd

download


$db = new Database();
$db->connect();

insert:
$insert=array($class, $category, mysql_real_escape_string($title), $filename, 'Alice', date('Y-m-d'));
$row=" class ,category ,title ,file ,writer ,commit_date ";
$db->select('km_sop','* , count( km_sop.sop_id ) AS comments','left join km_feedback on km_sop.sop_id=km_feedback.km_id',$sql,'km_sop.sop_id'); //原本的又加上一些條件

update:
$row=array("file"=>$filename,"re_writer"=>"NANA","re_commit_date"=>date('Y-m-d'));
$where=array('sop_id='.$km_id);


$db->update('km_sop',$row,$where);

本來的說明好像哪裡怪怪的, 所以MARK一下