PHP 开发环境配备

PHP 开发环境配置
WAMP + ZendFramework

1. 下载WAMP
http://downloads.sourceforge.net/project/wampserver/WampServer%202/WampServer%202.0/WampServer2.0i.exe?r=http%3A%2F%2Fsourceforge.net%2Fprojects%2Fwampserver%2Ffiles%2FWampServer%25202%2FWampServer%25202.0%2FWampServer2.0i.exe%2Fdownload&ts=1292142301&use_mirror=nchc

2. 下载ZendFramework
http://framework.zend.com/releases/ZendFramework-1.11.1/ZendFramework-1.11.1.zip

3. 配置环境变量PATH
E:\wamp\bin\php\php5.3.0;E:\wamp\bin\mysql\mysql5.1.36\bin

4.配置Apache httpd.conf
E:\wamp\bin\apache\Apache2.2.11\conf\httpd.conf

#LoadModule rewrite_module modules/mod_rewrite.so
修改为：
LoadModule rewrite_module modules/mod_rewrite.so


5.配置ZendFramework

新建目录E:\wamp\bin\php\php5.3.0\Zend
复制ZendFramework安装目录下的bin,library\Zend到E:\wamp\bin\php\php5.3.0的Zend目录下.

6.配置PHP php.ini
E:\wamp\bin\php\php5.3.0\php.ini

;include_path = ".;c:\php\includes;e:\wamp\bin\php\php5.3.0\PEAR;e:\wamp\bin\php\php5.3.0\Zend"
修改为:
include_path = ".;c:\php\includes;e:\wamp\bin\php\php5.3.0\PEAR;e:\wamp\bin\php\php5.3.0\Zend"

short_open_tag = Off
修改为:
short_open_tag = On

7.修改MYSQL管理员默认密码
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'IDENTIFIED BY 'root' WITH GRANT OPTION;
FLUSH PRIVILEGES;

8.修改PHPADMIN密码
E:\wamp\apps\phpmyadmin3.2.0.1\config.inc.php

$cfg['Servers'][$i]['password'] = '';
修改为:
$cfg['Servers'][$i]['password'] = 'root';

9.测试连接MYSQL

9.1 mysql -h localhost -u root
password:root

9.2 创建数据库
CREATE DATABASE TL;
USE TL;

9.3 插入测试数据
CREATE TABLE personal_info (
pi_id bigint(20) NOT NULL auto_increment,
pi_name varchar(50) NOT NULL,
pi_tel varchar(15) default NULL,
pi_qq varchar(15) default NULL,
pi_email varchar(50) default NULL,
PRIMARY KEY (pi_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4;


insert into personal_info values (1, 'Zhangsan', '13911111111', '642864125', 'zhangsan@126.com');
insert into personal_info values (2, 'Lisi', '13122222222', '63958741', 'lisi@163.com');
insert into personal_info values (3, 'Wangwu', '13833333333', '912345678', 'wangwu@sohu.com');
commit;

9.4 创建PHP应用目录
9.4.1 创建目录E:\wamp\apps\tl
9.4.2 配置应用目录权限
E:\wamp\alias\tl.conf

Alias /tl "E:/wamp/apps/tl/"

# to give access to tl from outside
# replace the lines
#
#        Order Deny,Allow
# Deny from all
# Allow from 127.0.0.1
#
# by
#
#        Order Allow,Deny
#   Allow from all
#


    Options Indexes FollowSymLinks MultiViews
    AllowOverride all
        Order Deny,Allow
Allow from all


9.5 测试页面
E:\wamp\apps\tl\index.php

<?php
	echo "hello world!";
?>

<?php
    $mysql_server_name="localhost:3306"; //数据库服务器名称
    $mysql_username="root"; // 连接数据库用户名
    $mysql_password="root"; // 连接数据库密码
    $mysql_database="tl"; // 数据库的名字
    $strsql="select * from personal_info"; // 从表中提取信息的sql语句
    
    // 连接到数据库
    $conn=mysql_connect($mysql_server_name, $mysql_username,
                        $mysql_password);
    // 设置数据库
    mysql_select_db($mysql_database, $conn);

    // 执行sql查询
    $result=mysql_query($strsql, $conn);
    
    // 获取查询结果
    $row=mysql_fetch_row($result);
    
    echo '<font face="verdana">';
    echo '<table cellpadding="1" cellspacing="2">';

    // 显示字段名称
    echo "\n<tr>\n";
    for ($i=0; $i<mysql_num_fields($result); $i++)
    {
      echo '<td bgcolor="#00FF00"><b>'.
      mysql_field_name($result, $i);
      echo "</b></td>\n";
    }
    echo "</tr>\n";
    // 定位到第一条记录
    mysql_data_seek($result, 0);
    // 循环取出记录
    while ($row=mysql_fetch_row($result))
    {
      echo "<tr>\n";
      for ($i=0; $i<mysql_num_fields($result); $i++ )
      {
        echo '<td bgcolor="#00FF00">';
        echo "$row[$i]";
        echo '</td>';
      }
      echo "</tr>\n";
    }
    
    echo "</table>\n";
    echo "</font>";
    // 释放资源
    mysql_free_result($result);
    // 关闭连接
    mysql_close($conn);  
?>