//实例化数据库对象
$db = new Zend_Db_Adapter_Pdo_Mysql(array(
‘host’ => $DB_HOST,
‘username’ => $DB_USER,
‘password’ => $DB_PASSWD,
‘dbname’ => $DB_REPLDB,
‘driver_options’ => array(PDO::MYSQL_ATTR_INIT_COMMAND => ‘SET NAMES \’utf8\”)
));
//插入操作
$filename=’filename.jpg’;
$mimetype=’jpg’;
$DATA=’data’;
$row = array (
‘timestamp’ => date(“Y-m-d H:i:s”,time()),
‘filename’ => $filename,
‘mimetype’ => $mimetype,
‘DATA’ => $DATA
);
// 插入数据的数据表
$table = ‘upload’;
// i插入数据行并返回影响行数
$rows_affected = $db->insert($table, $row);
// 返回最后的id
$last_insert_id = $db->lastInsertId();
//更新操作
$id=2;
$filename=’filename2.jpg’;
$mimetype=’jpg’;
$DATA=’data22′;
$row = array (
‘timestamp’ => date(“Y-m-d H:i:s”,time()),
‘filename’ => $filename,
‘mimetype’ => $mimetype,
‘DATA’ => $DATA
);
$where = $db->quoteInto(‘id = ?’, $id);
//返回影响的行数
$rows_affected = $db->update($table, $row, $where);
//删除操作
// where条件语句
$where = $db->quoteInto(‘id = ?’, $id);
// 删除数据并得到影响的行数
$rows_affected = $db->delete($table, $where);
//查找操作
$result = $db->query(“SELECT * FROM {$table} order by id desc “);
//获取所有记录
while($row = $result->fetch()){
print_r($row);
}
//获取一条记录
$row = $result->fetch();
?>