代码 复制 - 运行
class SqlHelper {
private $mysqli;
private static $host = "localhost";
private static $user = "dbuser";
private static $pwd = "dbpwd";
private static $db = "dbname";
public function __construct() {
$this->mysqli = new mysqli ( self::$host, self::$user, self::$pwd, self::$db );
if ($this->mysqli->connect_error) {
die ( "连接失败" . $this->mysqli->connect_error );
}
$this->mysqli->query ( "SET NAMES gbk;" );
}
public function exec_dql($sql) {
$res = $this->mysqli->query ( $sql ) or die ( "操作失败dql" . $this->mysqli->error );
return $res;
}
public function exec_dml($sql) {
$res = $this->mysqli->query ( $sql ) or die ( "操作失败dml" . $this->mysqli->error );
if (! $res) {
return 0; //表示失败
} else {
if ($this->mysqli->affected_rows > 0) {
return 1; //成功
} else {
return 2; //无影响
}
}
}
}