zend/db.php,Zend_Db 数据库操作

//实例化数据库对象

$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();

?>