File: /home/mostafedeg/public_html/erp/models/mysql/ext/MComreceiptimageMySqlExtDAO.class.php
<?php
/**
* Class that operate on table 'm_comreceiptimage'. Database Mysql.
*
* @author: http://phpdao.com
* @date: 2014-09-07 16:06
*/
class MComreceiptimageMySqlExtDAO extends MComreceiptimageMySqlDAO{
public function updateimage($mComreceiptimage){
$sql = 'UPDATE m_comreceiptimage SET receiptimage = ?, imagedate = ?, userid = ? WHERE comreceiptid = ?';
$sqlQuery = new SqlQuery($sql);
$sqlQuery->set($mComreceiptimage->receiptimage);
$sqlQuery->set($mComreceiptimage->imagedate);
$sqlQuery->setNumber($mComreceiptimage->userid);
$sqlQuery->setNumber($mComreceiptimage->comreceiptid);
return $this->executeUpdate($sqlQuery);
}
public function loadimage($id){
$sql = 'SELECT * FROM m_comreceiptimage WHERE comreceiptid = ?';
$sqlQuery = new SqlQuery($sql);
$sqlQuery->setNumber($id);
return $this->getRow($sqlQuery);
}
}
?>