mysql连接成功但提示mysql_query未定义
mysql php
情景描述:查询两台服务器上的数据库,提取用户数据。
① 将数据列表显示,已成功
<?php/* Filename[book.php] */require_once("header.php");#连接另一台数据库$mysql_ = new MySqlList();#获取通讯录$addrPersons= empty($_SESSION['uid'])?null:$mysql->getAddrPerson($_SESSION['uid']); //个人//个人通讯录$dataPers = (empty($addrPersons['addrperson']))?array():json_decode(base64_decode($addrPersons['addrperson']),true);//$addrPersons array();#获取公司通讯录$stafflists = $mysql->getDomainUserList($domain);$stafflists_ = $mysql_->getDomainUserList($domain);debug(count($stafflists)); //29debug(count($stafflists_)); //57
② 提供搜索,在单独的搜索页再次提取两台服务器上的用户数据,并根据关键词进行过滤。
此时PHP终止,Fatal error: Call to undefined function mysql_query()
<?php/* Filename[book_search.php] */date_default_timezone_set('PRC');Header("content=text/html; charset=UTF-8");session_start();require_once (dirname(__FILE__) . "/../classes/action/initialize.php");require_once (dirname(__FILE__) . "/../classes/mode/xmlparse.inc");require_once (dirname(__FILE__) . "/../classes/mode/mysql_mode_class.php");require_once (dirname(__FILE__) . "/../classes/mode/mysql_list_class.php");#连接本地数据库$mysql = new MySqlModeMail();#连接另一台数据库//$othersql = new MySqlList();#获取通讯录$addrPersons= empty($_SESSION['uid'])?null:$mysql->getAddrPerson($_SESSION['uid']); //个人$dataPers = (empty($addrPersons['addrperson']))?array():json_decode(base64_decode($addrPersons['addrperson']),true);//$addrPersons null#获取公司通讯录$stafflists = $mysql->getDomainUserList($domain);//$stafflists_ = $othersql->getDomainUserList($domain);debug($stafflists);exit;//debug($stafflists_);
可能是哪一步出错?
回复讨论(解决方案)
在你贴出的代码中,没有看到 mysql_query
你只能根据错误信息指示的行号排查错误
php代码中数据库的密码要和电脑里的数据库中的密码一样
require_once (dirname(__FILE__) . "/../classes/mode/mysql_mode_class.php");require_once (dirname(__FILE__) . "/../classes/mode/mysql_list_class.php");//这两行也有在header.php中包含//这两个类中的执行函数是一样的 class MySqlList { //sql params public $server; public $username; public $password; public $database; public $code; function MySqlList(){ global $webpost;// include("xmlparse.inc"); $sqlist = parse_xml_config($webpost['path']['sqlist'],"sqlist"); if(!empty($sqlist) && is_array($sqlist)){ foreach($sqlist['list'] as $list){ if(strcmp($list['server'],$_SERVER['SERVER_ADDR'])){ $config = $list; } }//end for }//end if if(empty($config)) die("读取MySql配置出错。"); $this->server = $config['server']; $this->username = $config['username']; $this->password = $config['password']; $this->database = $config['database']; } //connect sql function connect(){ $connect = mysql_connect($this->server, $this->username, $this->password); if (!$connect){ die("服务器连接失败:".mysql_error()); } $conn = mysql_select_db($this->database,$connect) or die("数据库连接失败!<br/>"); mysql_query("set names utf8"); return $connect; } //execute sql function querySql($sql,$array=2,$fail=false,$succe=false,$suc_href=false,$type=MYSQL_ASSOC){ global $webpost; $result = mysql_query($sql,$this->connect()); //提示在这里终止 if(!$result) die("SQL: {$sql} <br>Error: " . mysql_error() ); if (mysql_affected_rows() >0){// write_sys_log("success SQL:".$sql); switch($array){ case 1: $arry = array(); while($arr = @mysql_fetch_array($result,$type)){ array_push($arry,$arr); } return $arry; case 2: $arr = @mysql_fetch_array($result,$type); return $arr; default: return 1; } }elseif(mysql_affected_rows() == 0 && !mysql_errno()){// write_sys_log("empty SQL:".$sql); return false; }elseif(mysql_errno()){// write_sys_log("failed SQL:".$sql); return 0; } mysql_close(); } #获取另一台数据库的用户数据 function getDomainUserList($domain){ $sql = "SELECT m.id,m.did,m.code,username,realname,domain FROM table_a m ". "JOIN table_b d ON m.did=d.id WHERE domain='{$domain}'"; return $this->querySql($sql,1); } }
思路上大概哪里有问题?
除 mysql_query 外,其他 mysql 族函数均没有报错
只能说 mysql 扩展安装(编译)错误
但是,我在提取用户数据后,是可以列表显示的。
只是在单独的搜索页却出现这个问题。
你提供的信息太少
不排除个别应用中单词拼写错误
终于排查出来了,是因为单独的搜索页没有获取到$_SESSION。
但是我加session_start()了,而且是由前面的列表页,通过$.ajax获取搜索页的内容。
为什么搜索页的$_SESSION是空的?
在 $_SESSION 为空的程序中检查 get_included_files 返回的文件列表
通常 session_start() 宜放在全局的公共文件中
况且 php 5.4 还会检查该函数是否被执行过,如执行过将会产生警告信息
问题解决了。
原因:在搜索页的包含页中,header()和session_start()的位置搞错了。把包含页中的header注掉就好了。

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics











In PHP, password_hash and password_verify functions should be used to implement secure password hashing, and MD5 or SHA1 should not be used. 1) password_hash generates a hash containing salt values to enhance security. 2) Password_verify verify password and ensure security by comparing hash values. 3) MD5 and SHA1 are vulnerable and lack salt values, and are not suitable for modern password security.

PHP type prompts to improve code quality and readability. 1) Scalar type tips: Since PHP7.0, basic data types are allowed to be specified in function parameters, such as int, float, etc. 2) Return type prompt: Ensure the consistency of the function return value type. 3) Union type prompt: Since PHP8.0, multiple types are allowed to be specified in function parameters or return values. 4) Nullable type prompt: Allows to include null values and handle functions that may return null values.

PHP is mainly procedural programming, but also supports object-oriented programming (OOP); Python supports a variety of paradigms, including OOP, functional and procedural programming. PHP is suitable for web development, and Python is suitable for a variety of applications such as data analysis and machine learning.

Using preprocessing statements and PDO in PHP can effectively prevent SQL injection attacks. 1) Use PDO to connect to the database and set the error mode. 2) Create preprocessing statements through the prepare method and pass data using placeholders and execute methods. 3) Process query results and ensure the security and performance of the code.

PHP and Python have their own advantages and disadvantages, and the choice depends on project needs and personal preferences. 1.PHP is suitable for rapid development and maintenance of large-scale web applications. 2. Python dominates the field of data science and machine learning.

PHP uses MySQLi and PDO extensions to interact in database operations and server-side logic processing, and processes server-side logic through functions such as session management. 1) Use MySQLi or PDO to connect to the database and execute SQL queries. 2) Handle HTTP requests and user status through session management and other functions. 3) Use transactions to ensure the atomicity of database operations. 4) Prevent SQL injection, use exception handling and closing connections for debugging. 5) Optimize performance through indexing and cache, write highly readable code and perform error handling.

PHP is used to build dynamic websites, and its core functions include: 1. Generate dynamic content and generate web pages in real time by connecting with the database; 2. Process user interaction and form submissions, verify inputs and respond to operations; 3. Manage sessions and user authentication to provide a personalized experience; 4. Optimize performance and follow best practices to improve website efficiency and security.

PHP is suitable for web development and rapid prototyping, and Python is suitable for data science and machine learning. 1.PHP is used for dynamic web development, with simple syntax and suitable for rapid development. 2. Python has concise syntax, is suitable for multiple fields, and has a strong library ecosystem.
