《PHP應(yīng)用:Win7環(huán)境下Apache連接MySQL提示連接已重置的解決辦法》要點(diǎn):
本文介紹了PHP應(yīng)用:Win7環(huán)境下Apache連接MySQL提示連接已重置的解決辦法,希望對(duì)您有用。如果有疑問,可以聯(lián)系我們。
相關(guān)主題:apache配置
PHP編程win7下手動(dòng)搭建wamp環(huán)境,碰到的幾個(gè)坑總結(jié)下:
PHP編程1.能正常訪問php和html類型文件,但是訪問項(xiàng)目文件時(shí)老是連接被重置,后來總結(jié)是數(shù)據(jù)庫的問題,就寫測(cè)試用例測(cè)試php能否成功調(diào)用數(shù)據(jù)庫.
PHP編程
<?php
echo "mysql";
$mysql_conf = array(
'host' => '127.0.0.1',
'db' => 'drupal628',
'db_user' => 'root',
'db_pwd' => 'admin',
);
$mysql_conn = @mysql_connect($mysql_conf['host'], $mysql_conf['db_user'], $mysql_conf['db_pwd']);
if (!$mysql_conn) {
echo "失敗";
die("could not connect to the database:\n" . mysql_error());//診斷連接錯(cuò)誤
}else{
echo "連接成功";
}
?>
PHP編程
<?php
echo "mysqli";
$mysql_conf = array(
'host' => '127.0.0.1',
'db' => 'drupal628',
'db_user' => 'root',
'db_pwd' => 'admin',
);
$mysqli = @new mysqli($mysql_conf['host'], $mysql_conf['db_user'], $mysql_conf['db_pwd']);
if ($mysqli->connect_errno) {
echo "失敗";
die("could not connect to the database:\n" . $mysqli->connect_error);//診斷連接錯(cuò)誤
}else{
echo "成功";
}
?>
PHP編程mysqli測(cè)試?實(shí)際是mysqli能連接成功,mysql連接不成功,phpinfo.php也顯示模塊都已正常加載,百思不得其解,直到找到這位大神的解答.
PHP編程解決方法:
PHP編程在apache的配置文件 httpd.conf 中添加: LoadFile D:/PHP/php5.2.13/libmysql.dll(一試便好,我不存在2的錯(cuò)誤)
修改\windows\system32\drivers\etc\hosts文件,把localhost指向127.0.0.1(因Windows7可解析IPv6,默認(rèn)localhost指向是::1而非127.0.0.1)
PHP編程2.不能自動(dòng)定位首頁
PHP編程在httpd.conf中<Directory "F:/php_projects"></Directory>中? 添加? DirectoryIndex index.html index.php default.html default.php指定默認(rèn)首頁.
PHP編程3.開始安裝phpmyadmin時(shí)老是提示錯(cuò)誤,我們都知道phpmyadmin只需要下載安裝包后解壓放到根目錄下即可,不明白為什么一直提示錯(cuò)誤,換了幾個(gè)版本錯(cuò)誤依舊,上面的問題解決后這個(gè)問題也不存在了.
PHP編程4.Call to undefined function imagecreatefrompng()發(fā)現(xiàn)是因?yàn)榘惭b時(shí)php忘了開啟gd2擴(kuò)展.
PHP編程以上就是本文的全部?jī)?nèi)容,希望對(duì)大家的學(xué)習(xí)有所幫助,也希望大家多多支持維易PHP.
轉(zhuǎn)載請(qǐng)注明本頁網(wǎng)址:
http://www.snjht.com/jiaocheng/818.html