Backend Development
PHP Tutorial
Teach you how to deploy php projects under Linux - Apache, php, mysql association (share)Teach you how to deploy php projects under Linux - Apache, php, mysql association (share)
This article will share with you how to deploy php projects under Linux - Apache, php, mysql association (sharing), which has certain reference value. Friends in need can refer to it. I hope it will be helpful to you. Everyone helps.

MySql
1. Mysql and apache are best installed first, because When configuring php, you need to configure and test related to mysql and apacheFirst download the mysql-sever file, because the blogger's Linux environment is the CentOS version, and there seems to be no mysql-sever in the yum source when mysql is installed normally. File, you need to download it from the official website1.下载mysql-service文件
[root@tele-1 ~]# wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
2.安装mysql-service文件
[root@tele-1 ~]# rpm -ivh mysql-community-release-el7-5.noarch.rpm
2. Install mysql
[root@tele-1 ~]# yum install mysql-community-server
3. After the installation is complete, start the mysql service
[root@tele-1 ~]# service mysqld restart
4. The initial installation of mysql does not have a password, and the default user name is root. So we need to change the password and use the mysql command line to change it
1. Enter the mysql command line
[root@tele-1 ~]# mysql -uroot Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 474801 Server version: 5.6.36 MySQL Community Server (GPL) Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql>
<strong>2.使用命令进行密码修改</strong><br>
mysql> set password for 'root'@'localhost' = password('你要修改的密码'); Query OK, 0 rows affected (0.06 sec)
5. Because the blogger uses The local navicat software is used to connect to mysql under Linux, so if you want to access it locally, you need to change the user table in the mysql database
1.操作mysql数据库表
mysql> use mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql>
2.查看user表中的数据(在mysql命令行中可以直接进行sql语句编写)
mysql> select * from user; mysql>
3. In the blogger's table This is the modified table. If you want remote access, you need the data marked in red above. Host refers to the IP address that can access this database, and % means that all requests can be connected.
You can modify a piece of data or add a piece of data. But it is best not to modify the data marked in blue above. The modified statement is in the format belowmysql> update user set Host = '%' where ???
4. Finally, exit or \q are the methods to exit the mysql command line
mysql> \q Bye
Installing Apache
1. The apache installation method is relatively simple
[root@tele-2 ~]# yum install httpd
2. Access the virtual machine from the external network Address, we need to modify the apache configuration file /etc/httpd/conf/httpd.conf

Find #ServerName www.example.com :80 Change to ServerName localhost:80
As shown in the picture on the right:
As shown in the picture on the right:
3. After the modification is completed, we need to start the httpd service again and check the startup status[root@tele-2 ~]# service httpd start
Redirecting to /bin/systemctl start httpd.service
[root@tele-2 ~]# service httpd status
Redirecting to /bin/systemctl status httpd.service
● httpd.service - The Apache HTTP Server
Loaded: loaded (/usr/lib/systemd/system/httpd.service; enabled; vendor preset: disabled)
Active: active (running) since Mon 2017-06-05 15:57:34 CST; 5s ago
Docs: man:httpd(8)
man:apachectl(8)
Process: 54532 ExecStop=/bin/kill -WINCH ${MAINPID} (code=exited, status=0/SUCCESS)
Process: 39046 ExecReload=/usr/sbin/httpd $OPTIONS -k graceful (code=exited, status=0/SUCCESS)
Main PID: 54573 (httpd)
Status: "Processing requests..."
Memory: 15.8M
CGroup: /system.slice/httpd.service
├─54573 /usr/sbin/httpd -DFOREGROUND
├─54576 /usr/sbin/httpd -DFOREGROUND
├─54577 /usr/sbin/httpd -DFOREGROUND
├─54578 /usr/sbin/httpd -DFOREGROUND
├─54579 /usr/sbin/httpd -DFOREGROUND
└─54580 /usr/sbin/httpd -DFOREGROUND
Jun 05 15:57:34 tele-2 systemd[1]: Starting The Apache HTTP Server...
Jun 05 15:57:34 tele-2 systemd[1]: Started The Apache HTTP Server.
PHP
1.php installation command
[root@tele-2 ~]# yum install php
[root@tele-2 ~]# service httpd start
Redirecting to /bin/systemctl start httpd.service
In the apache default page path
/# Create a new test.php page under ##var/www/html and add the code
<?php phpinfo(); ?>
4. Visit this page and enter localhost/test.php, or ip: Port number/test.php You can see the configuration information of the php environment

Associate php and mysql
1. Search module
[root@tele-2 ~]# yum search php2. Install related modules
[root@tele-2 ~]# yum install php-mysql php-gd php-imap php-ldap php-odbc php-pear php-xml php-xmlrpc3. After the installation is completed, restart mysqld, Restart httpd and revisit the info.php just now. We find that there is more MySQL related information. As shown on the right:
至此,php在linux中的运行环境就已经成功配置完成了。
1.mysql yum安装默认文件夹及相关命令
数据库目录:/var/lib/mysql/ 配置文件:/usr/share/mysql(mysql.server命令及配置文件) 相关命令:/usr/bin(mysqladmin mysqldump等命令) my.cnf: /etc/my.cnf 启动脚本:/etc/rc.d/init.d/(启动脚本文件mysql的目录)
启动命令:service mysql start
停止命令:service mysql stop
运行状态:service mysql status
2.apache
配置文件路径:/etc/httpd/conf/httpd.conf
启动命令:service httpd start
停止命令:service httpd stop
运行状态:service httpd status
3.php
php默认页面路径:/var/www/html
推荐学习:《PHP视频教程》
The above is the detailed content of Teach you how to deploy php projects under Linux - Apache, php, mysql association (share). For more information, please follow other related articles on the PHP Chinese website!
PHP's Purpose: Building Dynamic WebsitesApr 15, 2025 am 12:18 AMPHP is used to build dynamic websites, and its core functions include: 1. Generate dynamic content and generate web pages in real time by connecting with the database; 2. Process user interaction and form submissions, verify inputs and respond to operations; 3. Manage sessions and user authentication to provide a personalized experience; 4. Optimize performance and follow best practices to improve website efficiency and security.
PHP: Handling Databases and Server-Side LogicApr 15, 2025 am 12:15 AMPHP uses MySQLi and PDO extensions to interact in database operations and server-side logic processing, and processes server-side logic through functions such as session management. 1) Use MySQLi or PDO to connect to the database and execute SQL queries. 2) Handle HTTP requests and user status through session management and other functions. 3) Use transactions to ensure the atomicity of database operations. 4) Prevent SQL injection, use exception handling and closing connections for debugging. 5) Optimize performance through indexing and cache, write highly readable code and perform error handling.
How do you prevent SQL Injection in PHP? (Prepared statements, PDO)Apr 15, 2025 am 12:15 AMUsing preprocessing statements and PDO in PHP can effectively prevent SQL injection attacks. 1) Use PDO to connect to the database and set the error mode. 2) Create preprocessing statements through the prepare method and pass data using placeholders and execute methods. 3) Process query results and ensure the security and performance of the code.
PHP and Python: Code Examples and ComparisonApr 15, 2025 am 12:07 AMPHP and Python have their own advantages and disadvantages, and the choice depends on project needs and personal preferences. 1.PHP is suitable for rapid development and maintenance of large-scale web applications. 2. Python dominates the field of data science and machine learning.
PHP in Action: Real-World Examples and ApplicationsApr 14, 2025 am 12:19 AMPHP is widely used in e-commerce, content management systems and API development. 1) E-commerce: used for shopping cart function and payment processing. 2) Content management system: used for dynamic content generation and user management. 3) API development: used for RESTful API development and API security. Through performance optimization and best practices, the efficiency and maintainability of PHP applications are improved.
PHP: Creating Interactive Web Content with EaseApr 14, 2025 am 12:15 AMPHP makes it easy to create interactive web content. 1) Dynamically generate content by embedding HTML and display it in real time based on user input or database data. 2) Process form submission and generate dynamic output to ensure that htmlspecialchars is used to prevent XSS. 3) Use MySQL to create a user registration system, and use password_hash and preprocessing statements to enhance security. Mastering these techniques will improve the efficiency of web development.
PHP and Python: Comparing Two Popular Programming LanguagesApr 14, 2025 am 12:13 AMPHP and Python each have their own advantages, and choose according to project requirements. 1.PHP is suitable for web development, especially for rapid development and maintenance of websites. 2. Python is suitable for data science, machine learning and artificial intelligence, with concise syntax and suitable for beginners.
The Enduring Relevance of PHP: Is It Still Alive?Apr 14, 2025 am 12:12 AMPHP is still dynamic and still occupies an important position in the field of modern programming. 1) PHP's simplicity and powerful community support make it widely used in web development; 2) Its flexibility and stability make it outstanding in handling web forms, database operations and file processing; 3) PHP is constantly evolving and optimizing, suitable for beginners and experienced developers.


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

SAP NetWeaver Server Adapter for Eclipse
Integrate Eclipse with SAP NetWeaver application server.

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Atom editor mac version download
The most popular open source editor

Dreamweaver CS6
Visual web development tools

EditPlus Chinese cracked version
Small size, syntax highlighting, does not support code prompt function






