php 无法加载mysql的module的时候的配置的解决方案引发的思考_PHP
之后看phpinfo() 里 确实也没找到mysql 模块， 之后所谓的解决方案如“将php.ini” 放入C:\Windows 环境变量等不靠谱说法。。。。。
甚至拷贝ext的文件夹的dll 到System32 中等
统统不靠谱 直到看到这篇帖子，我才发现问题
http://www.haosblog.com/index.php?mod=article_read&id=322
“mysql无法找到的原因是mysql的运行库无法找到，打开mysql的安装文件夹，在bin文件夹中找到libmySQL.dll，将它复制到system32文件夹中，让mysql的运行库能在系统中注册，然后重启Apache”
我是在\MySQL\MySQL Server 5.5\lib目录里找到的
实际上在自己配置的时候应该发现不是环境变量或者是没有加载到php.ini 或者没加载到extension的
为什么这么说呢
首先，在Apache 的配置中 已经添加了php的配置路径
同时phpinfo()也显示的加载到了，有兴趣的同学可以试试php.ini 存在和不存在的时候的区别
其次，自己在php.ini里确实配置了extension_dir 的，如果这个东西没意义，那何必在配置文件里有这个选项？之后这里注意一下，他的分隔符和apache 刚好相反 是“\”
之后php 也顺利加载了
所以，其实完全可以避免自己跟着瞎折腾的，结果大意了。
PHP配置成功后phpinfo中找不到mysql不少新人使用Apache+PHP+MySql配置好PHP环境都会遇到一个问题：mysql无法使用，使用phpinfo()函数获取的信息中也找不到mysql。
网上不少资料都说要把php.ini转移到windows或者system32文件夹中，这是胡扯！如果你把php和php/ext的目录添加到了环境变量中是不需要这么设置的。这么做的原因是Apache会到默认路径中查找配置文件，而没有设置环境变量的话Apache就找不到php.ini了。你可以看看phpinfo()页面中搜索php.ini，php.ini的路径是windows那么就把PHP的路径写入环境变量中，环境变量的设置可上网查找一下，尽量不要将php.ini放入系统文件夹中，对系统盘的操作要越少越好。
mysql无法找到的原因是mysql的运行库无法找到，打开mysql的安装文件夹，在bin文件夹中找到libmySQL.dll，将它复制到system32文件夹中，让mysql的运行库能在系统中注册，然后重启Apache，打开phpinfo()页面，搜索mysql，结果如下图
那么恭喜你，mysql已经能够正常在你的PHP中运行了。
不少新人都会被这个问题困扰，当初我也被它困扰了很久，网上的资料都是说把php.ini复制到系统盘，可是依然无用。这里严重BS一下那些没有实际行动只会复制别人文章的人，不少错误的信息就是被他们扩散，误导了不少新人，严重鄙视！
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
1655
14
1413
52
1306
25
1252
29
1226
24
Explain JSON Web Tokens (JWT) and their use case in PHP APIs.
Apr 05, 2025 am 12:04 AM
JWT is an open standard based on JSON, used to securely transmit information between parties, mainly for identity authentication and information exchange. 1. JWT consists of three parts: Header, Payload and Signature. 2. The working principle of JWT includes three steps: generating JWT, verifying JWT and parsing Payload. 3. When using JWT for authentication in PHP, JWT can be generated and verified, and user role and permission information can be included in advanced usage. 4. Common errors include signature verification failure, token expiration, and payload oversized. Debugging skills include using debugging tools and logging. 5. Performance optimization and best practices include using appropriate signature algorithms, setting validity periods reasonably,
How does session hijacking work and how can you mitigate it in PHP?
Apr 06, 2025 am 12:02 AM
Session hijacking can be achieved through the following steps: 1. Obtain the session ID, 2. Use the session ID, 3. Keep the session active. The methods to prevent session hijacking in PHP include: 1. Use the session_regenerate_id() function to regenerate the session ID, 2. Store session data through the database, 3. Ensure that all session data is transmitted through HTTPS.
What is REST API design principles?
Apr 04, 2025 am 12:01 AM
RESTAPI design principles include resource definition, URI design, HTTP method usage, status code usage, version control, and HATEOAS. 1. Resources should be represented by nouns and maintained at a hierarchy. 2. HTTP methods should conform to their semantics, such as GET is used to obtain resources. 3. The status code should be used correctly, such as 404 means that the resource does not exist. 4. Version control can be implemented through URI or header. 5. HATEOAS boots client operations through links in response.
How do you handle exceptions effectively in PHP (try, catch, finally, throw)?
Apr 05, 2025 am 12:03 AM
In PHP, exception handling is achieved through the try, catch, finally, and throw keywords. 1) The try block surrounds the code that may throw exceptions; 2) The catch block handles exceptions; 3) Finally block ensures that the code is always executed; 4) throw is used to manually throw exceptions. These mechanisms help improve the robustness and maintainability of your code.
What are anonymous classes in PHP and when might you use them?
Apr 04, 2025 am 12:02 AM
The main function of anonymous classes in PHP is to create one-time objects. 1. Anonymous classes allow classes without names to be directly defined in the code, which is suitable for temporary requirements. 2. They can inherit classes or implement interfaces to increase flexibility. 3. Pay attention to performance and code readability when using it, and avoid repeatedly defining the same anonymous classes.
What is the difference between include, require, include_once, require_once?
Apr 05, 2025 am 12:07 AM
In PHP, the difference between include, require, include_once, require_once is: 1) include generates a warning and continues to execute, 2) require generates a fatal error and stops execution, 3) include_once and require_once prevent repeated inclusions. The choice of these functions depends on the importance of the file and whether it is necessary to prevent duplicate inclusion. Rational use can improve the readability and maintainability of the code.
Explain different error types in PHP (Notice, Warning, Fatal Error, Parse Error).
Apr 08, 2025 am 12:03 AM
There are four main error types in PHP: 1.Notice: the slightest, will not interrupt the program, such as accessing undefined variables; 2. Warning: serious than Notice, will not terminate the program, such as containing no files; 3. FatalError: the most serious, will terminate the program, such as calling no function; 4. ParseError: syntax error, will prevent the program from being executed, such as forgetting to add the end tag.
PHP and Python: Comparing Two Popular Programming Languages
Apr 14, 2025 am 12:13 AM
PHP and Python each have their own advantages, and choose according to project requirements. 1.PHP is suitable for web development, especially for rapid development and maintenance of websites. 2. Python is suitable for data science, machine learning and artificial intelligence, with concise syntax and suitable for beginners.
