โค้ด: เลือกทั้งหมด
class MyDb extends Zend_Db_Table
{
protected $_name = 'mydb' ;
function MySearch($mytable1, $mysearch)
{
$config = new Zend_Config_Ini('../application/config.ini', 'general');
$db = new Zend_Db_Adapter_Pdo_Mysql(array(
'host' => $config->db->params->host ,
'username' => $config->db->params->username,
'password' => $config->db->params->password,
'dbname' =>$config->db->params->dbname,
'driver_options' => array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES \'tis620\'')
));
$sql = "SELECT * FROM $mytable1 WHERE studentid='$mysearch' ";
$result = $db->fetchAll($sql, 2);
return $result ;
}//end_func_Search
}
function insertdata($mytable, $data)
{
$config = new Zend_Config_Ini('../application/config.ini', general);
$db = new Zend_Db_Adapter_Pdo_Mysql(array(
'host' => $config->db->params->host ,
'username' => $config->db->params->username,
'password' => $config->db->params->password,
'dbname' =>$config->db->params->dbname,
'driver_options' => array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES \'tis620\'')
));
$n = $db->insert($mytable, $data);
return $n ; // 1 success , 0 fail;
}//end_insert_items
function deletedata($mytable, $where)
{
$config = new Zend_Config_Ini('../application/config.ini', 'general');
$db = new Zend_Db_Adapter_Pdo_Mysql(array(
'host' => $config->db->params->host ,
'username' => $config->db->params->username,
'password' => $config->db->params->password,
'dbname' =>$config->db->params->dbname,
'driver_options' => array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES \'tis620\'')
));
$n = $db->delete($mytable, $where);
return $n ; // 1 success , 0 fail;
}//end_func_updatecatagory
function update($mytable, $data, $where)
{
$config = new Zend_Config_Ini('../application/config.ini', 'general');
$db = new Zend_Db_Adapter_Pdo_Mysql(array(
'host' => $config->db->params->host ,
'username' => $config->db->params->username,
'password' => $config->db->params->password,
'dbname' =>$config->db->params->dbname,
'driver_options' => array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES \'tis620\'')
));
$n = $db->update($data, $where);
return $n ; // 1 success , 0 fail;
}//end_func_updatecatagory