Example #1
0
<?php

header('Content-Type: text/html; charset=utf-8');
include 'class/QueryStatement.php';
include 'class/ErrorHandler.php';
include 'class/DbConnection.php';
/*$stm=DbConnection::query('SELECT * FROM  content');
while ($tmp=$stm->fetch()){
	var_dump($tmp);
}
$stm=DbConnection::query('SELECT * FROM  content');
var_dump('==========',$stm->fetchAll());
$stm=DbConnection::query('SELECT * FROM  content 000');
var_dump(DbConnection::getErrorMsg());
$sql='INSERT INTO content (str) VALUES (\''.time().'\')';
$rst=DbConnection::exec($sql);
$id=DbConnection::getLastId();
var_dump($rst,$id);*/
$arr = array(array('str' => 'a'), array('str' => 'b'), array('str' => 'c'), array('str' => 'd'));
var_dump(DbConnection::insertArrs('content', $arr));
$data = array('str' => 'abcde');
var_dump(DbConnection::insert('content', $data));
$updateData = array('str' => '333');
var_dump(DbConnection::update('content', $data, 'WHERE id=4'));