复制代码
- <?php
- class db {
- private $linkId;
- private $pconnect = 1;
- public function connect($dbhost, $dbuser, $dbpwd, $dbname, $dbchar) {
- $func = $this->pconnect ? 'mysql_pconnect' : 'mysql_connect';
- $this->linkId = $func($dbhost, $dbuser, $dbpwd);
- if(!$this->linkId) {
- echo mysql_errno.':Can not connect to mySQL';
- exit();
- } else {
- if(!$this->dbSelect($dbname, $this->linkId)) {
- echo mysql_errno.':Can not open the '.$dbname.' database';
- exit();
- }
- }
- $this->query('SET NAMES'.$dbchar);
- }
- public function dbSelect($dbname) {
- return mysql_select_db($dbname);
- }
- public function query($sql) {
- return mysql_query($sql);
- }
- public function fetch_array($sql, $result_type='MYSQL_ASSOC') {
- $query = $this->query($sql);
- return mysql_fetch_array($query, $result_type);
- }
- public function fetch_all($sql, $data) {
- $query = $this->query($sql);
- while($arr = $this->fetch_array($query)) {
- $data[] = $arr;
- }
- return $data;
- }
- public function insert($post) {
- $tbname = $post[0][0];
- $field = "";
- $data = "";
- foreach($post[1] as $key=>$val) {
- $field .= $key.', ';
- $data .= "\"".$val."\"".', ';
- }
- return "INSERT INTO ".$tbname."(".substr($field, 0, -2).")VALUES(".substr($data, 0, -2).")";
- }
- public function update($post) {
- $tbname = $post[0][0];
- $set = "";
- foreach($post[1] as $key=>$val) {
- $set .= $key.'='."\"".$val."\"". ' AND ';
- }
- return "UPDATE ".$tbname." SET ".substr($set, 0, -5)." WHERE ".$post[2][0];
- }
- }
|
office 2019专业增强版最新2021版激活秘钥/序列号/激活码推荐 附激活工具
如何安装mysql8.0
Word快速设置标题样式步骤详解
20+道必知必会的Vue面试题（附答案解析）
HTML如何制作表单
百词斩可以改天数吗？当然可以，4个步骤轻松修改天数！
ET文件格式和XLS格式文件之间如何转化？
react和vue的区别及优缺点是什么
支付宝人脸识别如何关闭?
腾讯微云怎么修改照片或视频备份路径?
