21,886
社区成员
发帖
与我相关
我的任务
分享
public function setGBK() {
$sql = sprintf( "set names 'gbk'" );
$this->conn->exec( $sql );
}
public function setBinary() {
$sql = sprintf( "set character_set_client=binary" );
$this->conn->exec( $sql );
}
public function doExec($sql){
$sql = sprintf($sql);
$this->conn->exec( $sql );
}
public function query( $sql, $param ) {
if( empty( $sql ) || empty( $this->conn ) )
{
return array();
}
$result = $this->conn->prepare( $sql );
if ( false == $result->execute($param) )
{
return array();
}
$result->setFetchMode( PDO::FETCH_ASSOC );
$row = $result->fetch();
if( $row )
{
return $row;
}else {
return array();
}
}
public function querys( $sql, $param ) {
if( empty( $sql ) || empty( $this->conn ) )
{
return array();
}
$result = $this->conn->prepare( $sql );
if ( false == $result->execute($param) )
{
return array();
}
$result->setFetchMode( PDO::FETCH_ASSOC );
$rows = $result->fetchAll();
return $rows;
}