均采用win7 安装版:
Apache:
安装:
域名 localhost
修改
httpd.config:
1\ LoadModule php5_module D:/php/php5apache2_2.dll
2\ DirectoryIndex index.php index.html
3\ AddType application/x-httpd-php .php
4\ LoadFile D:/php/php5ts.dll
5\ PHPIniDir "D:/php"
PHP:
安装:
将php.ini复制到 C:\windows下
配置环境变量,我的电脑-属性-高级-环境变量,选择配置Path,加入d:\php;d:\php\ext;
修改:
php.ini:
修改存放php_*.ddl的路径
查找”extension_dir”,修改为extension_dir = “D:/php5/ext”
指定站点路径
查找”doc_root”,修改为doc_root = “D:\Apache2.2\htdocs”
测试:
在站点文件”D:\Apache2.2\htdocs”内新建文件”index.php”,内容为:
<?php
phpinfo();
?>
重启Apache,在浏览器输入”http://localhost/index.php“,将看到php相关信息的页面。
安装SQL
选择其中的server安装
在client 窗口创建用户:
mysql> CREATE USER 'zyy'@'localhost' IDENTIFIED BY '123456';
Query OK, 0 rows affected (0.00 sec)
创建sqltest.php文件,打开http://localhost/sqltest.php,显示响应错误;
sqltest.php文件:
<?php
// phpinfo();注解原来的phpinfo
//hostname主机(通常是localhost),username是用户名,password是密码
$hostname_conn = "localhost";
$username ="zyy";
$password = "123456";
//echo "连接成功";
if(mysql_connect($hostname_conn, $username, $password) ){
echo "连接!!!!";//如果链接成功了,输出成功,否则报错
}else{ exit(mysql_error());}
?>
发现时php.ini错误,修改如下:
1\ display_errors = On
2\ short_open_tag = On
3\ 行尾加入
extension=php_bz2.dll
extension=php_curl.dll
extension=php_dba.dll
;extension=php_dbase.dll
;extension=php_exif.dll
extension=php_fdf.dll
extension=php_gd2.dll
extension=php_gettext.dll
extension=php_gmp.dll
extension=php_imap.dll
;extension=php_interbase.dll
extension=php_ldap.dll
extension=php_mbstring.dll
;extension=php_mcrypt.dll
extension=php_mhash.dll
extension=php_mime_magic.dll
extension=php_ming.dll
extension=php_msql.dll
;extension=php_mssql.dll
extension=php_mysql.dll
extension=php_mysqli.dll
extension=php_oci8.dll
extension=php_openssl.dll
extension=php_pdo.dll
extension=php_pdo_firebird.dll
extension=php_pdo_mssql.dll
extension=php_pdo_mysql.dll
extension=php_pdo_oci.dll
;extension=php_pdo_oci8.dll
extension=php_pdo_odbc.dll
;extension=php_pdo_pgsql.dll
extension=php_pdo_sqlite.dll
extension=php_pdo_sqlite_external.dll
extension=php_pgsql.dll
extension=php_pspell.dll
extension=php_shmop.dll
extension=php_snmp.dll
extension=php_soap.dll
extension=php_sockets.dll
extension=php_sqlite.dll
;extension=php_sybase_ct.dll
extension=php_tidy.dll
extension=php_xmlrpc.dll
extension=php_xsl.dll
extension=php_zip.dll
重启apache,测试成功;
备注:启动sql server: 控制面板,管理工具,服务,找到mysql
初次体验:
准备工作(创建数据库):
1、建立用户 mysql> CREATE USER 'zyy'@'localhost' IDENTIFIED BY '123456';
2、创建数据库 mysql> CREATE DATABASE zyyInfo;
3、进入数据库编辑 mysql> USE zyyInfo;
4、创建表 mysql> CREATE TABLE mytable (name VARCHAR(20), sex CHAR(1), birth DATE, birthaddr VARCHAR(20));
5、显示表结构 mysql> DESCRIBE mytable;
| Field | Type | Null| Key | Default | Extra |
| name | varchar(20)| YES | | NULL | |
| sex | char(1) | YES | | NULL | |
| birth | date | YES | | NULL | |
| birthaddr | varchar(20)| YES | | NULL | |
6、编辑表
mysql> insert into mytable values (‘zyy’,‘m’,‘1988-07-07’,‘china’);
mysql> insert into mytable values (‘zbb’,‘m’,‘1988-07-07’,‘china’);
mysql> insert into mytable values (‘zuu’,‘m’,‘1988-07-07’,‘usa’);
7、赋予'zyy'@'localhost' 对数据库 zyyInfo的所有操作权限 mysql> grant all privileges on zyyInfo.* to zyy@localhost identified by '123456';
PHP 程序:
<?php
$hostname_conn = "localhost";
$username ="zyy";
$password = "123456";
$mysql_database="zyyInfo";
if($conn = mysql_connect($hostname_conn, $username, $password) ){
echo "connect ok“
}else{ exit(mysql_error());}
$strsql="SELECT * FROM `mytable`";
$result=mysql_db_query($mysql_database, $strsql, $conn);
$row=mysql_fetch_row($result);
echo '<font face="verdana">';
echo '<table border="1" cellpadding="1" cellspacing="2">';
echo "</b><tr></b>";
for ($i=0; $i<mysql_num_fields($result); $i++) {
echo '<td bgcolor="#000F00"><b>'.
mysql_field_name($result, $i);
echo "</b></td></b>";
}
echo "</tr></b>";
mysql_data_seek($result, 0);
while ($row=mysql_fetch_row($result)) {
echo "<tr></b>";
for ($i=0; $i<mysql_num_fields($result); $i++ ){
echo '<td bgcolor="#00FF00">';
echo $row[$i];
echo '</td>';
}
echo "</tr></b>";
}
echo "</table></b>";
echo "</font>";
mysql_free_result($result);
mysql_close($conn);
?>
运行结果:
name | sex | birth | birthaddr |
zyy | m | 1988-07-07 | china |
zbb | m | 1968-07-07 | china |
zuu | m | 1968-09-07 | usa |