解决方案 »
- 关于 array_pad函数的疑问
- php读取pdf或者doc
- phpmyadmin配置好了總提示錯誤(如圖)
- 解析csv文件,并把值写到数据库的不同表中,急急
- 请帮忙提供下合适的LAMP面试题目
- 再问一个关于free discuz!论坛的问题. 解决者再送100分!!!
- 我在自己的机子上配了APACHE,可是用PHP连接MYSQL却连不上,请问为什么?
- session在window.open()的窗口中使用
- select的where子句可否有两个查询条件?如何写?
- 分页问题
- 求一个查询语句 字段use是一个数组1,12,13 怎样查询1在里面的记录
- 请问配置mysql的问题!报错:无法载入 mysql 扩展
$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());