8 tips for PHP and MySQL development. For websites with LAMP architecture, I used to focus mostly on installation and configuration, but there are few development stories, because I am rarely engaged in development. The original article of this article also comes from the website of the Publishedo LAMP architecture. I used to focus mostly on installation and configuration, but I have little on development b
This article describes how to install apache + mysql + php + phpMyAdmin in the source code. If other software packages are missing during installation, we will use yum for installation. If your RHEL is not charged and cannot use yum, configure the yum source of CentOS or download the rpm package.
This article describes how to install apache +
Reprinted from: http://blog.csdn.net/buutterfly/article/details/5630203
DEDECMS deployment-How to deploy apache+mysql+php (LAMP)?1. Linux OS:
Linux os:red Hat Enterprise Linux as Release 4 (Nahant Update 6)
2.Deploy Apache 2.1 Download Apache
Download Apache2 source from http://httpd.apache.org/, download it directly under/root, unzip the tar package php-5.2.1
For the three APIs used by php to connect to the mysql database, refer to the self-php Manual. This article does not make much sense. it is just for your convenience to access the Internet.
1. MySQL extension of PHP2. mysqli extension of PHP3.
./Configure
This is dispensable, but I have to make this step
CD ../PHP./Configure -- With-mysql =/usr/local -- With-Apache =/usr/local/Apache -- enable-track-varsMakeMake installCD ../Apache./Configure -- activate-module = src/modules/PhP4/libphp4.aMakeMake install
This step is to install the Apache web service. You can refer to./configure-help to add the required modules or install the service
Extmysql extension of PHP source code. I have written an external module extension. now I am looking at the mysql extension in the PHP source code. it can be integrated into PHP, so it should be a built-in extension. I have written an external module extension for this extension. now I start to look at the
feel like Mr. beanWill it be because php has not loaded the database file connected to mysql? After apache server is started. I tried to delete 'php5ts. dll 'and 'libmysql. dll '. the message "cannot be deleted" is displayed. it indicates that a program is using these two library files. it indicates that there is a load. (Of course there are many ways to test. for example, you can use some software to view
It's already midnight, and May Day is boring. You can't sleep. Therefore, install a virtual machine on the computer, and then build a p
It's already midnight, and May Day is boring.
You can't sleep. You can install a virtual machine on your computer. then, you can build a php environment on the virtual machine.
First, install MYSQL. I found many problems .. I will try again later.The installation steps on a
Setup and configuration of php + SQL Server Apache + php + mysql in windows
Setup and configuration of php + SQL Server Apache + php + mysql in windows
Php is fast and secure because o
PHP, Mysql-based on a given latitude and longitude point, nearby location query-reasonable use of the algorithm, improved efficiency by 2125, mysql-2125 times. PHP, Mysql-based on a given latitude and longitude point, nearby location query-reasonable use of algorithms, effic
Optimize the PHP website to run like MySQL. 1. what can and should we optimize?
Hardware
Operating System/software library
SQL Server (set and query)
Application programming interface (API)
Applications
II. optimize hardware
If you need a huge database table (> 2 GB), you should consider using a 64-bit hardware structure, such as Alpha, or the upcoming IA64. Because
As for the database in the Web programming, the function of the database is more and more cannot be neglected. Referring to the database, it should be said that PHP has very strong database support capabilities, from FileMaker to Oracle, almost all of the database system can be seamless connectivity. In order to facilitate the explanation of this article, we will mainly take MySQL as an example to explain.
Installation and configuration of Apache + php + mysql in windows (latest version ). First ready software: Apache official: apache_2.0.55-win32-x86-no_ssl.msi, more versions here; php official: php-5.0.5-Win32.zip, more images Download First ready software:
Apache official website:Apache_2.0.55-win32-x86-no_ssl.msi,Mo
located. If you do not use this directory, find it. -With-gd # open support for the gd library. If this error is returned, install the gd library-with-pear # support for opening the pear command-with-libxml-dir # enable the support for libxml2 just installed.
The entire compilation statement is:
The Code is as follows:
. /Configure-prefix =/usr/local/php5-with-apxs2 =/usr/local/apache2/bin/apxs-with-mysql =/usr/-with-mysqli =/usr/ bin/mysql_config-
missing functions.
8. if you need a faster speed, you should:
Identify bottlenecks (CPU, disk, memory, SQL Server, operating system, API, or application) and focus on solving them.
It provides you with faster speed/flexibility scaling.
Gradually understand the SQL server so that you can use the fastest possible SQL structure for your problems and avoid bottlenecks.
Optimize table layout and query.
Use replication for faster select speeds.
If yo
documentation, the term connector is interpreted as "a piece of software code that allows your app to connect to the MySQL database server." MySQL provides a number of language connectors, including PHP.When your PHP application needs to interact with a database server, you need to write PHP code to complete a series
Cd ../php
./Configure -- with-mysql =/usr/local -- with-apache =/usr/local/apache -- enable-track-vars
Make
Make install
Cd ../apache
./Configure -- activate-module = src/modules/php4/libphp4.a
Make
Make install
This step is to install the apache WEB service. you can refer to./configure-help to add the required modules or install the service by referring to the installation
client program)", and "documentation (document)" to ensure that all files are installed. Click "change..." and manually specify the installation directory. Modify the MySQL server path and data path
3) Check "configure the MySQL server now" and click "finish" to finish the software installation and start the MySQL Configuration Wizard.
4) Select the configurat
that the PHP Manual has two functions similar to the following:
The code is as follows:
Mysql_query ()
Mysql_unbuffered_query ()
The literal meanings and descriptions of the two functions confirm my idea. when the previous function is executed, all the result sets will be read from the Server to the Client buffer, and the other functions will not, this is what "unbuffered (unbuffered)" means.
That is t
Abstract: This article describes how to initiate a mysql Query request from the PHP layer to the result set returned by mysqlserver, and briefly describes the actions and components that may be involved in each layer. Grasp the entire interaction process from the global perspective. Shows the PHP-SQL component layers from the
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.