php 连接mysql连接被重置的解决方法

Home

Backend Development

PHP Tutorial

php 连接mysql连接被重置的解决方法_php技巧

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

May 17, 2016 am 09:21 AM

reset

新装了windows7 64位系统后，配备布置许多东西，总是有这样的那样子的拂意，昨天在开始配备布置php+apache的时候，echo phpinfo()完全没问题，但是一朝连接mysql就会呈现页面被重置的问题。原来问题不大，但是我却走到了误区:
　　1、我怀疑64位系统的问题；
　　2、我感觉代码靠不住，因为另外都能执行，轻率写个 substr()也是能显示出来的
　　......
　　这个问题纠结了我一天多，但是还是没解决到，无奈之下我用" php 连接 mysql 连接被重置 "为关键字举行搜索，呈现了不少的零星的信息，1个1个的找，终于有人提到是由于 libmysql.dll 的引用问题。抱着无比激动地心情看完，并参照执行，甚或者我情愿重启电脑，我怕那里的缓存给担搁了。后面终于解决。-----------这事让我深知误区的重要性，这里把解决的办法贴出来，希望有遇到的人能用患上着。
　　测验考试libmysql拷入 windows/system32下和libmysql.dll拷贝到apache/bin下。
　　当然，最省事的方法是：
　　在apache中：
　　LoadFile D:/PHP/php5.2.13/libmysql.dll
　　只上边这一行，mysql便可成功挪用。
　　我的服务器版本：win7
　　apache 2.2.13
　　php 5.2.13
　　mysql5.1.37
　　phpmyadmin3.3.2
　　下面是我的apache的部门配备布置。
　　PHPIniDir D:/PHP/php5.2.13 #不是必须
　　LoadFile D:/PHP/php5.2.13/php5ts.dll
　　LoadFile D:/PHP/php5.2.13/libmysql.dll
　　LoadModule php5_module D:/PHP/php5.2.13/php5apache2_2.dll
　　AddType application/x-httpd-php .php

Statement

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

PHP Dependency Injection Container: A Quick StartMay 13, 2025 am 12:11 AM

APHPDependencyInjectionContainerisatoolthatmanagesclassdependencies,enhancingcodemodularity,testability,andmaintainability.Itactsasacentralhubforcreatingandinjectingdependencies,thusreducingtightcouplingandeasingunittesting.

Dependency Injection vs. Service Locator in PHPMay 13, 2025 am 12:10 AM

Select DependencyInjection (DI) for large applications, ServiceLocator is suitable for small projects or prototypes. 1) DI improves the testability and modularity of the code through constructor injection. 2) ServiceLocator obtains services through center registration, which is convenient but may lead to an increase in code coupling.

PHP performance optimization strategies.May 13, 2025 am 12:06 AM

PHPapplicationscanbeoptimizedforspeedandefficiencyby:1)enablingopcacheinphp.ini,2)usingpreparedstatementswithPDOfordatabasequeries,3)replacingloopswitharray_filterandarray_mapfordataprocessing,4)configuringNginxasareverseproxy,5)implementingcachingwi

PHP Email Validation: Ensuring Emails Are Sent CorrectlyMay 13, 2025 am 12:06 AM

PHPemailvalidationinvolvesthreesteps:1)Formatvalidationusingregularexpressionstochecktheemailformat;2)DNSvalidationtoensurethedomainhasavalidMXrecord;3)SMTPvalidation,themostthoroughmethod,whichchecksifthemailboxexistsbyconnectingtotheSMTPserver.Impl

How to make PHP applications fasterMay 12, 2025 am 12:12 AM

TomakePHPapplicationsfaster,followthesesteps:1)UseOpcodeCachinglikeOPcachetostoreprecompiledscriptbytecode.2)MinimizeDatabaseQueriesbyusingquerycachingandefficientindexing.3)LeveragePHP7 Featuresforbettercodeefficiency.4)ImplementCachingStrategiessuc

PHP Performance Optimization Checklist: Improve Speed NowMay 12, 2025 am 12:07 AM

ToimprovePHPapplicationspeed,followthesesteps:1)EnableopcodecachingwithAPCutoreducescriptexecutiontime.2)ImplementdatabasequerycachingusingPDOtominimizedatabasehits.3)UseHTTP/2tomultiplexrequestsandreduceconnectionoverhead.4)Limitsessionusagebyclosin

PHP Dependency Injection: Improve Code TestabilityMay 12, 2025 am 12:03 AM

Dependency injection (DI) significantly improves the testability of PHP code by explicitly transitive dependencies. 1) DI decoupling classes and specific implementations make testing and maintenance more flexible. 2) Among the three types, the constructor injects explicit expression dependencies to keep the state consistent. 3) Use DI containers to manage complex dependencies to improve code quality and development efficiency.

PHP Performance Optimization: Database Query OptimizationMay 12, 2025 am 12:02 AM

DatabasequeryoptimizationinPHPinvolvesseveralstrategiestoenhanceperformance.1)Selectonlynecessarycolumnstoreducedatatransfer.2)Useindexingtospeedupdataretrieval.3)Implementquerycachingtostoreresultsoffrequentqueries.4)Utilizepreparedstatementsforeffi

See all articles