public function DB_Connect() { @mysql_connect($this->DB_HOSTIP,$this->$DB_HOSTNAME,$this->$DB_HOSTPWD) or die(mysql_error()); mysql_select_db($this->DB_NAME); mysql_query("set names 'uft8'"); }
public function __destruct() { $this->Close(); }
public function Close() { if( $this->DB_LINK != NULL ) { mysql_close(); $this->DB_LINK = NULL; } }
public function Query($sql) { $rs = mysql_query($sql); if( !$rs ) throw new Exception( "Error, failed to execute query '".$sql."', " . mysql_error()); return $rs; } public function Select($field, $tbl_name) { $sql = "select ".$field." from `".$tbl_name."`"; $this->Query($sql); } public function Insert($table_name = "", $field, $value) { //$field格式:`field1`,`field2` //$value格式:'field1','field2' //建议$field, $value合成一个数组,$field为key, $value为值 //语句可以是insert into tablename set `field1`='value1',`field2`='value2'(和update一样) $sql= "insert into `".$table_name."`(".$field.") values(".$value.");"; $this->Query($sql); }
我用了你说的那个 @mysql_connect($this->DB_HOSTIP,$this->$DB_HOSTNAME,$this->$DB_HOSTPWD) or die(mysql_error()); mysql_select_db($this->DB_NAME); mysql_query("set names 'uft8'"); 提示:Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in C:\wwwroot\test\kblog\var\model\kblog_db.php on line 64
我用了你说的那个 @mysql_connect($this->DB_HOSTIP,$this->$DB_HOSTNAME,$this->$DB_HOSTPWD) or die(mysql_error()); mysql_select_db($this->DB_NAME); mysql_query("set names 'uft8'"); 提示:Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in C:\wwwroot\test\kblog\var\model\kblog_db.php on line 64 LZ还是没有注意到刚才那个问题。 原:@mysql_connect($this->DB_HOSTIP,$this->$DB_HOSTNAME,$this->$DB_HOSTPWD) or die(mysql_error()); 改为: @mysql_connect($this->DB_HOSTIP,$this->DB_HOSTNAME,$this->DB_HOSTPWD) or die(mysql_error());
@mysql_connect($this->DB_HOSTIP,$this->$DB_HOSTNAME,$this->$DB_HOSTPWD) or die(mysql_error());这里要改了,@mysql_connect($this->DB_HOSTIP,$this->DB_HOSTNAME,$this->DB_HOSTPWD) or die(mysql_error());我也粗心,呵呵!
还是不行,提示Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in C:\wwwroot\test\kblog\var\model\kblog_db.php on line 64大哥能不能帮我看下,为什么不能正常添加记录啊?
$this->DB_LINK = mysql_connect($this->DB_HOSTIP,$this->DB_HOSTNAME,$this->DB_HOSTPWD);
public function DB_Connect()
{
@mysql_connect($this->DB_HOSTIP,$this->$DB_HOSTNAME,$this->$DB_HOSTPWD) or die(mysql_error());
mysql_select_db($this->DB_NAME);
mysql_query("set names 'uft8'");
}
public function __destruct()
{
$this->Close();
}
public function Close()
{
if( $this->DB_LINK != NULL )
{
mysql_close();
$this->DB_LINK = NULL;
}
}
public function Query($sql)
{
$rs = mysql_query($sql);
if( !$rs ) throw new Exception( "Error, failed to execute query '".$sql."', " . mysql_error());
return $rs;
} public function Select($field, $tbl_name)
{
$sql = "select ".$field." from `".$tbl_name."`";
$this->Query($sql);
} public function Insert($table_name = "", $field, $value)
{
//$field格式:`field1`,`field2`
//$value格式:'field1','field2'
//建议$field, $value合成一个数组,$field为key, $value为值
//语句可以是insert into tablename set `field1`='value1',`field2`='value2'(和update一样)
$sql= "insert into `".$table_name."`(".$field.") values(".$value.");";
$this->Query($sql);
}
<?php
$db = new kblog_class;
$db->DB_Connect();
$field = "user,password,power,IP";
$value = "'heshuang','heshuang','1','".$_SERVER['REMOTE_ADDR']."'";
$db->Insert(admin, $field, $value);
echo "<script>alert('success');</script>";
?>
不能成功添加。求解下
@mysql_connect($this->DB_HOSTIP,$this->$DB_HOSTNAME,$this->$DB_HOSTPWD) or die(mysql_error());
mysql_select_db($this->DB_NAME);
mysql_query("set names 'uft8'"); 提示:Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in C:\wwwroot\test\kblog\var\model\kblog_db.php on line 64
$this->DB_LINK = mysql_connect($this->DB_HOSTIP,$this->DB_HOSTNAME,$this->DB_HOSTPWD);
lz太粗心了!
@mysql_connect($this->DB_HOSTIP,$this->$DB_HOSTNAME,$this->$DB_HOSTPWD) or die(mysql_error());
mysql_select_db($this->DB_NAME);
mysql_query("set names 'uft8'"); 提示:Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in C:\wwwroot\test\kblog\var\model\kblog_db.php on line 64
LZ还是没有注意到刚才那个问题。
原:@mysql_connect($this->DB_HOSTIP,$this->$DB_HOSTNAME,$this->$DB_HOSTPWD) or die(mysql_error());
改为:
@mysql_connect($this->DB_HOSTIP,$this->DB_HOSTNAME,$this->DB_HOSTPWD) or die(mysql_error());