PHP has a variety of ways to install and expand, mainly the package management of Yum installation, PECL installation, as well as the underlying source code compilation installation.
Package management of the safety loading and unloading is
A.ShowTables orShowTables from database_name; --Displays the names of all tables in the current databaseB.ShowDatabases --DisplayMySQLName of all databases inC.ShowColumns from table_name to database_name; OrShowColumns from Database_name.table_name;
MySQL is "the most popular open database in the world", at least for MySQL Web sites. But no matter how popular MySQL is, many companies are resisting the use of MySQL. The phenomenon comes from a number of reasons, some of whom mistakenly believe
PHP has a strong interest in the recent days, so decided to learn. The first is the installation.
First step, install Apache
Download Apache2.2 installation package from Apache, install, run, browser enter address 127.0.0.1:8080, appear "It works! ",
Introduced:
Php-mysql is the most primitive Extension of PHP operation MySQL Database
The php-mysqli I represents improvement, which raises the relative advanced function, and in Extension, it also increases security.
PDO is
Tag:databases status process Database tables A. show tables or show tables from database_name; -- displays the names of all tables in the current database b. show databases; -- displays the names of all databases in MySQL
In the Windows Server
Locate the php.ini file for the PHP installation directory and then we searchExtension=php_pdo.dll this line to see if there is a semicolon in front of the line, and if so, remove it. and find out if there are any
Transfer from http://www.blogjava.net/baoyaer/articles/209466.htmlSetup recommendations:For a single running Web server, it is recommended to add:Skip-lockingSkip-name-resolveSkip-networkingUse "LOCALHOST" when you link the database to PHP. This way
A good memory is better than a random writing .... The following collection of the MySQL show in the use of skills .... If you need a friend, you can have a look.A. Show tables or show tables from database_name;//displays the names of all tables in
Through one hour of research and setup. the latest PHP5.0 + MYSQL5.0 + WIN2003. I personally think it is necessary to write a tutorial. because many aspects are different from old versions. to be honest, I also read many official documents to solve
When phpMyAdmin is used today, phpMyAdmin prompts that MYSQL extension cannot be loaded. Check that the PHP configuration is incorrect. I will share the solution process with you for reference. When phpMyAdmin is used today, phpMyAdmin prompts that
In fact, if you only want to test the php operation rather than the server operation, you can use phpnow and so on, and download is available at home.
In fact, if you only want to test the php operation rather than the server operation, you can use
Basic mysql knowledge
I believe that when I first started learning php, MySQL is the preferred choice for databases and mysql extension is the preferred choice for database connection expansion. However, with the improvement of php version, mysql
The following content mainly introduces the basic content of MySQL5.0. at the same time, this article also lists the actual application code in MySQL5.0. I hope you will understand the actual content of MySQL5.0 after browsing. The following
The latest PHP 5.0 + MYSQL 5.0 + WIN2003.I personally think it is necessary to write a tutorial because many aspects are different from those of the old version.To be honest, I also read many official documents to solve many strange problems.
=======
This article mainly introduces PHP implementation based on object-oriented Mysqli expansion library, adding and deleting the Operation tool class, combined with the case analysis of the mysqli additions and deletions to the Operation class packaging
Php connection to mysql error: Fatalerror: Calltoundefinedfunctionmysql_connect (). the phpinfo configuration is as follows: & nbsp; blog. csdn. ne php connection to mysql error: Fatal error: Call to undefined function mysql_connect ()
Php
The native MySQLAPI of PHP database extension does not recommend this extension when writing new code. You should use mysqli or PDO_MySQL extension instead.
Install
During compilation, you only need to use the -- with-mysql [= DIR] configuration
Configure the latest PHP and MYSQL servers through one hour of research and setup. The latest PHP 5.0 + MYSQL 5.0 + WIN2003.
I personally think it is necessary to write a tutorial because many aspects are different from those of the old version.
To
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.