PHP开发环境搭建及常用的数据库操作
1.常见的web服务器:
httpd(Apache)、nginx+PHP
Tomcat:jsp+html
win:IIS
客户端:IE、firefox、chrome、手机浏览器(Browser)
PHP开发环境:LAMP=Linux Apache Mysql PHP
或者LNMP=Linux Nginx Mysql PHP
Linux+Apache+Mysql/MariaDB+Perl/PHP/Python
2.搭建动态网站之CentOS
-
yum -y install httpd mariadb mariadb-server php php-mysql
httpd:就是Apache的一个版本
mariadb:MySQL数据库的客户端
mariadb-server:服务器端
php-mysql:php操作MySQL
-
systemctl start httpd:启动Apache
systemctl enable httpd:设置开机自启
-
systemctl start mariadb:启动数据库
systemctl enable mariadb:开机自启
-
mysqladmin -u root password “123456”:设置数据库账户和密码(默认为空)
登录mysql数据库验证:mysql -uroot -p123456
网站根目录:/var/www/html
注:debain的系统把yum改成apt即可
3.php7.3对MySQL8数据库基本操作之增删改查:
<?php
$server = 'localhost:3306';
$username = 'root';
$password = '123456';
$dbname = 'mydb';
$link = mysqli_connect($server,$username,$password,$dbname); //数据库连接
if($link){
echo "正常!";
}else{
echo "异常!";
}
mysqli_set_charset($link,'UTF8'); // 设置数据库字符集
echo "</br>";
//数据库插入数据
/*$sql = "INSERT INTO users(id,NAME,age,sex) VALUES(5,'zhangsan',18,'male'),(6,'lisi',28,'male')";
$result = mysqli_query($link,$sql);
if($result){
echo "插入成功!";
}else{
echo "插入失败!";
}*/
//删除数据
/*$sql = "delete from users where id=1";
$result = mysqli_query($link,$sql);
if($result){
echo "删除成功!";
}else{
echo "删除失败!";
}*/
//修改数据
/*$sql = "update users set age=19 where id=4";
$result = mysqli_query($link,$sql);
if($result){
echo "修改成功!";
}else{
echo "修改失败!";
}*/
//查询数据
$sql = "select * from users";
$result = mysqli_query($link,$sql);
$data = mysqli_fetch_all($result); // 从结果集中获取所有数据
print_r($data);
?>