Mac上配置php

Mac上配置php

mac自带apache, 打开终端

// 开启Apache服务  
sudo apachectl start  
// 查看Apache版本号  
sudo apachectl -v  

浏览器输入http://localhost, 会出现it works;

运行我们的php之前，我们需要更改我们的php配置文件，打开Finder，“前往->前往文件夹…”，输入：

/etc/apache2/  

找到#LoadModule php5_module libexec/apache2/libphp5.so 把注释去掉

重启apache

sudo apachectl restart 

建一个index.php文件, 用编辑器打开写入<?php phpinfo(); ?>

浏览器输入http://localhost/

创建数据库

	<meta charset="utf-8">
	<?php
	$servername = "127.0.0.1";
	$username = "root";
	$password = "123456";

	// 创建连接
	$conn = new mysqli($servername, $username, $password);
	// 检测连接
	if ($conn->connect_error) {
    	die("连接失败: " . $conn->connect_error);
	} 

	// 创建数据库
	$sql = "CREATE DATABASE test";
	if ($conn->query($sql) === TRUE) {
    	echo "数据库创建成功";
	} else {
    	echo "Error creating database: " . $conn->error;
	}

	$conn->close();
	?>
	

建表

	<meta charset="utf-8">
	<?php
	$servername = "127.0.0.1";
	$username = "root";
	$password = "123456";
	$dbname = "test";

	// 创建连接
	$conn = new mysqli($servername, $username, $password, 	$dbname);
	// 检测连接
	if ($conn->connect_error) {
    	die("连接失败: " . $conn->connect_error);
	} 

	// 使用 sql 创建数据表
	$sql = "CREATE TABLE t_person (
	id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY, 
	firstname VARCHAR(30) NOT NULL,
	lastname VARCHAR(30) NOT NULL,
	email VARCHAR(50),
	reg_date TIMESTAMP
	)";

	if ($conn->query($sql) === TRUE) {
    	echo "Table t_person created successfully";
	} else {
    	echo "创建数据表错误: " . $conn->error;
	}

	$conn->close();
	?>
	

如图

创建成功, 打开navicat查看

插入一条记录

	<meta charset="utf-8">
	<?php
	$servername = "127.0.0.1";
	$username = "root";
	$password = "123456";
	$dbname = "test";

	// 创建连接
	$conn = new mysqli($servername, $username, $password, 	$dbname);
	// 检测连接
	if ($conn->connect_error) {
    	die("连接失败: " . $conn->connect_error);
	} 

	$sql = "INSERT INTO t_person (firstname, lastname, email)
	VALUES ('jay', 'chou', 'chou@example.com')";

	if ($conn->query($sql) === TRUE) {
    	echo "新记录插入成功";
	} else {
    	echo "Error: " . $sql . "<br>" . $conn->error;
	}

	$conn->close();
	?>
	

插入成功, 如下图所示

读取数据

	<?php
	$servername = "127.0.0.1";
	$username = "root";
	$password = "123456";
	$dbname = "test";
 
	// 创建连接
	$conn = new mysqli($servername, $username, $password, 	$dbname);
	// Check connection
	if ($conn->connect_error) {
    	die("连接失败: " . $conn->connect_error);
	} 
 
	$sql = "SELECT id, firstname, lastname FROM MyGuests";
	$result = $conn->query($sql);
 
	if ($result->num_rows > 0) {
    	// 输出数据
    	while($row = $result->fetch_assoc()) {
        	echo "id: " . $row["id"]. " - Name: " . 	$row["firstname"]. " " . $row["lastname"]. "<br>";
    	}
	} else {
    	echo "0 结果";
	}
	$conn->close();
	?>
	

成功后如图

更新的操作

修改sql语句就行了

	UPDATE t_person SET email='kangbingbj@gmail.com' WHERE firstName='jay' AND lastname='chou'
	

删除记录

	DELETE FROM t_person WHERE firstname = 'julie'
	

这样环境基本已经OK，具体应用后期记笔记。