$query = "INSERT INTO `$this->table_name` ($fields) VALUES ($values)"; $this->table_name`要用{}括起来
解决方案 »
- 如何截取前三个数字或都文字
- 如何读取配置文件(php的)中的数组值?
- php 4 绑定变量问题
- 关于sql语句判断与程序判断,哪个更省时省力?
- 请PHP大侠推荐一本好的PHP教程书籍
- Mysql错误..Illegal mix of collations (utf8_bin,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation ' IN '
- 我要用PHP做一个统计图(柱状图、折线图)有做过的吗?
- 敢问高手们谈谈学习PHP的方法
- 请问如何对待有人恶意的进行刷新
- 简繁体的问题,欢迎大家都来讨论
- mysql多表查询问题。
- php4和php5的差异大吗??
因为这个是由别的一个类(PDO连接数据库)改过来的
麻烦哪位高手帮忙修正下上边的这个类。。
class BasicModel{
protected $table_name = NULL;
protected $_primary = NULL;
protected $_fieldList = NULL; //字段设置
protected function set_primary($var_name){
$this->_primary = $var_name;
}
protected function set_field_list($fieldList){
$this->_fieldList = $fieldList;
}
protected function set_table_name($table_name){
$this->table_name = $table_name;
}
protected function get_a_db_ob(){
$db_host = "localhost";
$db_username = "root";
$db_password = "111111";
$db_name = "mytestdb";
try{
$this->DB = new mysqli("$db_host", "$db_username", "$db_password","$db_name");
$this->DB->query("SET Names 'UTF8'");
$this->DB->query("set autocommit=0");
return true;
}catch(DBException $e){
$this->is_error = true;
$this->error_msg = $e->getMessage();
return false;
} }
protected function insert_into_DB(){
foreach ($this->_fieldList as $field){
$fields .= "`$field`,";
$values .= "'".$this->$field."',";
} $fields = trim($fields,',');
$values = trim($values,',');
$query = "INSERT INTO `$this->table_name` ($fields) VALUES ($values)";
mysql_query($query,$conn) or die ("更新数据失败: ".mysql_error());
} protected function update_to_DB(){
$primary = $this->_primary;
foreach ($this->_fieldList as $field){
$update .= "`$field`='".$this->$field."',";
}
$update = trim($update,',');
$query = "UPDATE $this->table_name SET $update WHERE `$primary`='".$this->$primary."'";
mysql_query($query,$conn) or die ("更新数据失败: ".mysql_error());
}
function __destruct(){
$this->disconnect();
}}
?>
<?php
class BasicModel
{
protected $table_name=NULL;
protected $_primary=NULL;
protected $_fieldList=NULL;
public $mysql_server_name='localhost';
public $mysql_username='root';
public $mysql_password='';
public $mysql_database='test';
function __construct()
{
mysql_connect($mysql_server_name,$mysql_username,$mysql_password,$mysql_database);
}
protected function set_primary($var_name)
{
$this->_primary=$var_name;
}
protected function set_field_list($fieldList){
$this->_fieldList=$fieldList;
}
protected function set_table_name($table_name){
$this->table_name=$table_name;
}
protected function insert_into_DB(){
foreach ($this->_fieldList as $field){
$fields.="`$field`,";
$values.="'".$this->$field."',";
}$fields=trim($fields,',');
$values=trim($values,',');
$query="INSERT INTO `$this->table_name` ($fields) VALUES ($values)";
mysql_query($query,$conn) or die ("更新数据失败: ".mysql_error());
}protected function update_to_DB(){
$primary=$this->_primary;
foreach ($this->_fieldList as $field){
$update.="`$field`='".$this->$field."',";
}
$update=trim($update,',');
$query="UPDATE $this->table_name SET $update WHERE `$primary`='".$this->$primary."'";
mysql_query($query,$conn) or die ("更新数据失败: ".mysql_error());
}function __destruct(){
$this->disconnect();
}}
?>
class BasicModel
{
protected $table_name=NULL;
protected $_primary=NULL;
protected $_fieldList=NULL;
private $mysql_server_name='localhost';
private $mysql_username='root';
private $mysql_password='root1234';
private $mysql_database='we54hddb';
function __construct()
{
mysql_connect($mysql_server_name,$mysql_username,$mysql_password,$mysql_database);
}
protected function set_primary($var_name)
{
$this->_primary=$var_name;
}
protected function set_field_list($fieldList){
$this->_fieldList=$fieldList;
}
protected function set_table_name($table_name){
$this->table_name=$table_name;
}
protected function insert_into_DB(){
foreach ($this->_fieldList as $field){
$fields.="`$field`,";
$values.="'".$this->$field."',";
}$fields=trim($fields,',');
$values=trim($values,',');
$query="INSERT INTO `$this->table_name` ($fields) VALUES ($values)";
mysql_query($query,$conn) or die ("更新数据失败: ".mysql_error());
}protected function update_to_DB(){
$primary=$this->_primary;
foreach ($this->_fieldList as $field){
$update.="`$field`='".$this->$field."',";
}
$update=trim($update,',');
$query="UPDATE $this->table_name SET $update WHERE `$primary`='".$this->$primary."'";
mysql_query($query,$conn) or die ("更新数据失败: ".mysql_error());
}function __destruct(){
$this->disconnect();
}}
?>