1. Each line of command is separated by a semicolon (;) As the end
For MySQL, the first thing you have to keep in mind is that each line of the command is separated by a semicolon (;) As the end, but ... There is no absolutely absolute thing, also
Although this article uses the PHP language, keep in mind that any server-side language will work correctly. To understand this article, I assume you have a basic understanding of JavaScript and PHP or a similar server-side language.
This example
Register_global defaults to off in later versions of PHP4.2To get a variable submitted from another page:Method One: Find the Register_global in php.ini and set it to on.Method Two: Put this extract ($_post) in front of the receiving page, extract ($
Ocidefinebyname
Allow the SELECT command to use PHP variables.
Syntax: boolean ocidefinebyname (int stmt, string ColumnName, mixed &variable, int [type]);
Return Value: Boolean value
function type: Database functions
Content DescriptionThis
PhpMyAdmin is a MySQL database management tool, after the installation of the tool, you can directly manage the MySQL data through the web, without the need to execute system commands to manage, is very suitable for database Operations Command
In general, there is more than one site on a server, more than a MySQL (and PHP collocation of the best combination) database. In order to prevent security risks, we generally set up a separate database access account for each database, and the
PHP version is different, has stopped upgrading the development of the 4.0 series 4.4.x, but there are still some production environment running this version, need to continue to maintain code. The PHP 5.0 series is now the mainstream version of
Naming is the core of program planning. The ancients believed that knowing a person's real name would gain an incredible power over that person. As long as you think of the right name for something, it will give you and later people a stronger power
What's the use of pseudo-static?
The main thing is to cater to search engines to facilitate search engine spiders (spider) to crawl the relevant content on the page!
User-friendly access to the site a good web page if it is dynamic users in each
use PEAR to buffer PHP programs
Buffering in the PHP World is a hot topic, because PHP generates dynamic pages that need to be recalculated every time a user requests, regardless of whether the requested result is the same, and PHP compiles the
Several MySQL statements commonly used in PHP
To display a database or table:
Show databases;//can then use database_name;
Show tables;
Change table name:
ALTER TABLE table_name rename new_t;
To add a column:
ALTER TABLE table_name ADD column c_n
Today, I met a big monster--Summer insects
╮(╯▽╰)╭, the Apprentice is not fine, because he fell into the big hole. The pit is dug like this:
Previously, in order to indicate the current time of "Tomorrow", "the day after", will use the class as
Product classification, multi-level tree structure of the forum, mailing lists and many other places we all encounter this problem: how to store multi-level structure of data?
In the application of PHP, it is usually a relational database that
In doing a picture preview of the things in the diagram, encountered a problem, is to determine whether the remote file exists (not the same server). The code is as follows:
PHP does not cache data headers
function Nocache_headers () { //Why is these @-silenced when the other header calls aren ' t? @header (' expires:wed, Jan 1984 05:00:00 GMT '); @header (' last-modified: '. Gmdate (' d, D M Y h:i:s '). '
1. On the head of the original ecological code or class, note the author, the key algorithm calculation process
For example
/**
* @author Zengmoumou
* Function: According to list IP, get IP corresponding carrier, province, city, county
*/
2.
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