This tutorial is primarily configured with the Windows 2008 SP2 32bit standard to configure PHP 7.0rc2+nginx 1.9.4+mysql 5.6.26, and to turn on HTTPS access.
First, preparatory work
1, Nginx+php+mysql and other downloads and decompression: Baidu
Mysqli encapsulates some advanced operations, such as transactions, while encapsulating many of the methods available during DB operations.
The most widely used place is the mysqli business.
Like the following example:
The code is as
/*** Description, this class is suitable for small web site database backup, built-in MySQL connection, simply configure the data connection* and the location of the storage backup can be.* Class is materialized and you can connect to the database
The MySQL two log is used to record changes to the database, which is structured to discuss the format of the log.
Each log contains 4 bytes of magic number and event description package
Log has the first four bytes is Magic number:oxfe ox62 0x69 0
Mysqlnd_ms is a MYSQLND plug-in, which realizes the function of saving and switching, load balancing, and read and write separation. To use the Mysqlnd_ms read-write detach feature, you must use –WITH-MYSQLND when you install PHP. MYSQLND
Prepare an article
First, the environment description:
Operating system: Windows Server R2
PHP Version: PHP 5.5.8
MySQL version: MySQL5.6.15
Second, related software downloads:
1, PHP download address:
Free Asp+php+mysql type 80M free asp+php+sql type 80MProduct number HT02Price 1.00 Yuan/yearIntroduction: Please join the group: 28276105 own space upload IP is:*.> support ASP.PHP.MySQL Web script > Telecom + netcom Dual-line access > 256MB
The MySQL master and slave function was set up on CentOS 6.5, and recorded.
Server 1 (primary)ip:192.168.1.201System version: CentOS 6.5MySQL version: MySQL 5.5
Server 2 (from)ip:192.168.1.202System version: CentOS 6.5MySQL version: MySQL 5.5
The
The PHP Data Objects (PDO) extension defines a lightweight, consistent interface for PHP access to the database. Each database driver that implements the PDO interface can expose specific database features as standard extension functions. Note that
jquery+php query MySQL to implement AutoComplete, write this tutorial, because most of the things you've seen about AutoComplete are just giving you a source code package, and then telling you how to use it, rather than telling you how it works and
The simplest method of fuzzy query
In MySQL we can compare using the like or not like operators. Schema defaults are case-insensitive in MySQL.
Query example, Student table
+--------+---------+-------+-----------------+---------+| Studid | name |
Delete a duplicate record method:
1. Create a new temporary table
The code is as follows
Copy Code
CREATE TABLE tmp as SELECT * from Youtable Group by name (name is not expected to have duplicate columns)
2.
Many programmers think that query optimization is the task of the DBMS (Database Tutorial management System), which is not related to the SQL statements written by programmers, which is wrong. A good query plan can often improve the performance of
MySQL server cluster configuration methodMysql-cluster Installation
System centos5.1 32-bit (how to 64-bit RPM package with 64-bit)
http://dev.mysql.com/get/downloads/mysql-cluster-7.0 and the following package name correspond
A total of 5
Below we want four kinds of MySQL tutorial data table several effective optimization methods , so as to improve the MySQL database tutorial in the application of data throughput capacity.
The data type of the optimization table
What type of table
The Linux environment in this article is Red Hat 9.0,mysql is 4.0.16.Second, the installation of MySQL1, download the MySQL installation filesThe following two files are required to install MySQL:mysql-server-4.0.16-0.i386.rpmmysql-client-4.0.16-0.i3
Installation environment: Windows 2008 R2 Operating system + IIS 7.5 + PHP + MYSQL + Zend + phpmyadmin
Prepare to download the necessary software (click on the link below to download directly):
1. php-5.2.17-win32-vc6-x86
2. MYSQL 5.1
3.
Original:Author: xiaoconEmail: xiaocon@21cn.comReprinted please indicate the sourceI. Integration and Application of php, XML, XSLT, and MysqlI often see some posts about the combination of php, XML, and database, and some beginners.The php code and
Advantages of master-slave synchronization architecture The read work is handed over to the slave server, reducing the pressure on the master server. Back up data from the server to avoid affecting the primary server service during the backup
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.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service