Maison > Article > développement back-end > php 数据库连接 编码设置问题
我先在本地运行PHP网站,环境已经搭配好啦,数据库也导进去啦,在IIS 浏览时出现错误,弹出一个提示框,“.$str.”
错误就是这段。有没有大神帮忙看看。
public function show_error($message='',$sql=''){
echo "
代码贴出来....
代码贴出来....
能帮忙看看吗?搞一上午了这个问题。
你先截个图看看,感觉不是你认为的地方
把你那块的代码拿来看看,你那段错误信息没有明显的指出错误的地方
把你那块的代码拿来看看,你那段错误信息没有明显的指出错误的地方
这是数据库连接的那段代码!
class mysql{
private $db_host;
private $db_user;
private $db_pwd;
private $db_database;
private $conn;
private $sql;
private $result;
private $coding;
private $show_error = true;
public function __construct($db_host="localhost", $db_user="root", $db_pwd="admin", $db_database="likang", $coding = 'utf-8'){
$this->db_host = $db_host;
$this->db_user = $db_user;
$this->db_pwd = $db_pwd;
$this->db_database = $db_database;
$this->coding = $coding;
$this->connect();
}
private function connect(){
$this->conn = @mysql_connect($this->db_host,$this->db_user,$this->db_pwd);
if(!$this->conn){
if($this->show_error){
$this->show_error('错误提示:链接数据库失败!');
}
}
if(!@mysql_select_db($this->db_database, $this->conn)){
if($this->show_error){
$this->show_error('错误提示:打开数据库失败!');
}
}
if(!@mysql_query("SET NAMES $this->coding")){
if($this->show_error){
$this->show_error('错误提示:设置编码失败!');
}
}
}
public function query($sql){
$this->sql = $sql;
$result = mysql_query($this->sql, $this->conn);
if(!$result){
$this->show_error('错误的SQL语句:', $this->sql);
}else{
return $this->result = $result;
}
}
public function close()
{
return mysql_close();
} //关闭数据库连接
public function show_databases(){
$this->query("show databases");
echo '现有数据库:' . mysql_num_rows($this->result);
echo "
";
$i = 1;
while($row=mysql_fetch_array($this->result)){
echo "$i $row[Database]" . "
";
$i++;
}
}
public function show_tables(){
$this->query("show tables");
echo "数据库{$this->db_database}共有". mysql_num_rows($this->result) . "张表:";
echo "
";
$column_name = "Tables_in_" . $this->db_database;
$i = 1;
while($row=mysql_fetch_array($this->result)){
echo "$i $row[$column_name]" . "
";
$i++;
}
}
public function fetch_array($result=''){
if($this->result){
return mysql_fetch_array($this->result);
}else{
return mysql_fetch_array($result);
}
}
public function findall($table, $field = '*') {
return $this->query("SELECT $field FROM $table");
}
public function delete($table, $condition) {
return $this->query("DELETE FROM $table WHERE $condition");
}
public function insert($table, $field, $value) {
$i= $this->query("INSERT INTO $table ($field) VALUES ('$value')");
return $i;
}
public function update($table, $update_content, $condition) {
// echo "UPDATE $table SET $update_content WHERE $condition";
return $this->query("UPDATE $table SET $update_content WHERE $condition");
}
public function insert_id() {
return mysql_insert_id();
}
public function num_rows() {
if ($this->result == null) {
if ($this->show_error) {
$this->show_error('SQL语句错误', '请检查是否已经使用了query()方法,并成功查询且返回了资源标识符?');
}
} else {
return mysql_num_rows($this->result);
}
}
public function num_fields($table) {
$this->query("select * from $table");
echo "
";
echo '字段数:' . $total = mysql_num_fields($this->result);
echo "
"; <br> for ($i = 0; $i print_r(mysql_fetch_field($this->result, $i)); <br> } <br> echo "";
你先截个图看看,感觉不是你认为的地方
我点击index.php 的时候它出来的是数据库连接的代码和两个连着弹窗 “.$str.”,弹窗的后面就是我贴上的那段代码其中这块显示红色
public function show_error($message='',$sql=''){
echo "
这是PHP配置环境 mysql没有值 跟这个有关系吗?wordpress phpMyAdmin 都装了 这些地方都没有问题。