欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  后端开发

php 数据库连接 编码设置问题

程序员文章站 2022-06-11 10:29:33
...
我先在本地运行PHP网站,环境已经搭配好啦,数据库也导进去啦,在IIS 浏览时出现错误,弹出一个提示框,“.$str.”

错误就是这段。有没有大神帮忙看看。

public function show_error($message='',$sql=''){
echo "
";
echo "错误信息提示:
";
echo "
";
echo '错误原因:'. mysql_error() . "

";
echo "
";
echo "" . $message . "";
echo "
";
echo "
" . $sql . "
";
echo "
";
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 "

";  
for ($i = 0; $i print_r(mysql_fetch_field($this->result, $i));
}
echo "
";
echo "
";
}

public function show_error($message='',$sql=''){
echo "
";
echo "错误信息提示:
";
echo "
";
echo '错误原因:'. mysql_error() . "

";
echo "
";
echo "" . $message . "";
echo "
";
echo "
" . $sql . "
";
echo "
";
echo "
";
}


}

?>

你先截个图看看,感觉不是你认为的地方

我点击index.php 的时候它出来的是数据库连接的代码和两个连着弹窗 “.$str.”,弹窗的后面就是我贴上的那段代码其中这块显示红色
public function show_error($message='',$sql=''){
echo "

";
echo "错误信息提示:
";
echo "
";
echo '错误原因:'. mysql_error() . "

";
echo "
";
echo "" . $message . "";
echo "
";
echo "
" . $sql . "
";
echo "
";
echo "
";

点完 确定 就显示无法找个该页的。

这是PHP配置环境 mysql没有值 跟这个有关系吗?wordpress phpMyAdmin 都装了 这些地方都没有问题。