Home Backend Development PHP Tutorial Solution to PHP failure to connect to MYSQL under windows_PHP tutorial

Solution to PHP failure to connect to MYSQL under windows_PHP tutorial

Jul 21, 2016 pm 02:56 PM
mysql php windows Down Not on college Build a website document method of solve connect

Bkjia.Com DocumentsPHP cannot connect to MYSQL. When testing the connection to mysql, the prompt 'Fatal error: Call to undefined function mysql_connect()' The environment j is: windows xp sp2 en, apache2.2, mysql5.1rc.php5.28.

After completing the configuration according to the configuration tutorial of NetEase Technology, use phpinfo() to check. Mysql was not found..., but mysql can be operated normally in the DOS window. Then, I went back and forth to see where the problem was.

All methods in this page
http://www.somacon.com/p109.php are also

Then read the logs, reinstall, and repeatedly set php.ini, my.ini, apache.conf, but still couldn’t catch up. It was really hard for me to turn around. Later, there was really no other way. .. Just use adminphp to see if I can connect, but it prompts "Cannot load mysql extension. Please check your PHP configuration". I feel like I am Mr. bean


Could this prompt be caused by PHP? What about the library files loaded to connect to mysql? After starting the apache server, I tried to delete 'php5ts.dll' and 'libmysql.dll'. It said that it cannot be deleted. It means that there are programs using these two library files. It means that there are Loaded. (Of course there are many ways to test. For example, you can use some software to view all the library files loaded by the program service. It is also possible. However, ap also said that there is a problem with the php.ini settings. Then I will not look at anything else. I Just focus on php.ini configuration.

Without superstition that php.ini is correct, I finally discovered that this line is missing from .php.ini.

PHPIniDir "your php directory"

# (for example: PHPIniDir "c:/php")

Restart the apache server, and then use the methods commonly used on the Internet

The following is the quoted content:

以下为引用的内容:
$link=mysql_connect('localhost','用户名','password');
if(!$link) echo "失败!";
else echo "成功!";
mysql_close();
?>
$link =mysql_connect('localhost','username','password');

if(!$link) echo "Failure!";else echo "Success!";mysql_close();
?>



Test it. That’s it.
My php.ini configuration


That’s it, it took a lot of time... This is the first time I encountered this problem. It can only mean that "fate" is all "fate" "Ah!

Note:
以下为引用的内容:
en version:
problem:

if  something wrong with  'Fatal error: Call to undefined function mysql_connect()...' or

'Cannot load mysql extension. Please check your PHP configuration' while your test resolve:
add new line like :
PHPIniDir "#your php root fold"
(e.g: PHPIniDir "c:/php")
in php.ini file
restart servers
see.ok
if unlock its again. link  bellow :
http://www.somacon.com/p109.php
On the same machine. If .apache has been installed multiple times before, or the installation is not in the same directory, and there is more than one version, it is best to clean it up before installing mysql5.1rc. Registry Some other configuration tutorials say that you need to copy 2 dll files to system32. In fact, according to the above tutorial, because the environment variables are set, it is not necessary if you have done so before. Yes. Just delete him.

The following is the quoted content:en version:problem:if something wrong with 'Fatal error: Call to undefined function mysql_connect()...' or'Cannot load mysql extension. Please check your PHP configuration' while your test resolve:add new line like :PHPIniDir "#your php root fold"(e.g: PHPIniDir "c:/php")in php.ini filerestart serverssee.ok if unlock its again. link bellow :
http://www.somacon.com/p109.php
http://www.bkjia.com/PHPjc/364238.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/364238.htmlTechArticleLieHuo.Net Documentation PHP cannot connect to MYSQL. Test connection to mysql prompts 'Fatal error: Call to undefined function mysql_connect() environment j is: windows xp sp2 en, apach...
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

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

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

PHP: An Introduction to the Server-Side Scripting Language PHP: An Introduction to the Server-Side Scripting Language Apr 16, 2025 am 12:18 AM

PHP is a server-side scripting language used for dynamic web development and server-side applications. 1.PHP is an interpreted language that does not require compilation and is suitable for rapid development. 2. PHP code is embedded in HTML, making it easy to develop web pages. 3. PHP processes server-side logic, generates HTML output, and supports user interaction and data processing. 4. PHP can interact with the database, process form submission, and execute server-side tasks.

Choosing Between PHP and Python: A Guide Choosing Between PHP and Python: A Guide Apr 18, 2025 am 12:24 AM

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.

PHP and Python: Different Paradigms Explained PHP and Python: Different Paradigms Explained Apr 18, 2025 am 12:26 AM

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.

PHP vs. Python: Use Cases and Applications PHP vs. Python: Use Cases and Applications Apr 17, 2025 am 12:23 AM

PHP is suitable for web development and content management systems, and Python is suitable for data science, machine learning and automation scripts. 1.PHP performs well in building fast and scalable websites and applications and is commonly used in CMS such as WordPress. 2. Python has performed outstandingly in the fields of data science and machine learning, with rich libraries such as NumPy and TensorFlow.

Why Use PHP? Advantages and Benefits Explained Why Use PHP? Advantages and Benefits Explained Apr 16, 2025 am 12:16 AM

The core benefits of PHP include ease of learning, strong web development support, rich libraries and frameworks, high performance and scalability, cross-platform compatibility, and cost-effectiveness. 1) Easy to learn and use, suitable for beginners; 2) Good integration with web servers and supports multiple databases; 3) Have powerful frameworks such as Laravel; 4) High performance can be achieved through optimization; 5) Support multiple operating systems; 6) Open source to reduce development costs.

PHP's Impact: Web Development and Beyond PHP's Impact: Web Development and Beyond Apr 18, 2025 am 12:10 AM

PHPhassignificantlyimpactedwebdevelopmentandextendsbeyondit.1)ItpowersmajorplatformslikeWordPressandexcelsindatabaseinteractions.2)PHP'sadaptabilityallowsittoscaleforlargeapplicationsusingframeworkslikeLaravel.3)Beyondweb,PHPisusedincommand-linescrip

Can vs code run in Windows 8 Can vs code run in Windows 8 Apr 15, 2025 pm 07:24 PM

VS Code can run on Windows 8, but the experience may not be great. First make sure the system has been updated to the latest patch, then download the VS Code installation package that matches the system architecture and install it as prompted. After installation, be aware that some extensions may be incompatible with Windows 8 and need to look for alternative extensions or use newer Windows systems in a virtual machine. Install the necessary extensions to check whether they work properly. Although VS Code is feasible on Windows 8, it is recommended to upgrade to a newer Windows system for a better development experience and security.

PHP and the Web: Exploring its Long-Term Impact PHP and the Web: Exploring its Long-Term Impact Apr 16, 2025 am 12:17 AM

PHP has shaped the network over the past few decades and will continue to play an important role in web development. 1) PHP originated in 1994 and has become the first choice for developers due to its ease of use and seamless integration with MySQL. 2) Its core functions include generating dynamic content and integrating with the database, allowing the website to be updated in real time and displayed in personalized manner. 3) The wide application and ecosystem of PHP have driven its long-term impact, but it also faces version updates and security challenges. 4) Performance improvements in recent years, such as the release of PHP7, enable it to compete with modern languages. 5) In the future, PHP needs to deal with new challenges such as containerization and microservices, but its flexibility and active community make it adaptable.

See all articles