problem : 1 What is the difference between the storage engine in MySQL and which one is the default?
answer : 1 We can store the engine:
1. MyISAM (the default engine for MySQL. Each MyISAM table is divided into three files stored on the hard disk. The file name is the type that indicates the start and has an extension file name to indicate the files. The. frm file is used to store the table format. The data file is stored in the. MYD (MYData) file. The suffix of the index file is. MYI. )
2. InnoDB (InnoDB is a transaction-safe (acid-compatible) type of storage engine. He has transactional commit, rollback, and disaster recovery capabilities to protect the user's data. )
3. Merge
4. HEAP (Memory storage engine, which stores the data in memory.) Before we were familiar with the heap table. )
5. BDB (BerkeleyDB) (Sleepycat software company provides the Berkeley DB transaction storage engine for MySQL. The abbreviation for this engine is BDB. The BDB table has many great features, including disaster recovery and also supports commit and rollback of transactions. )
6. EXAMPLE
7. Federated (This storage engine is to access the remote database to obtain data rather than accessing the local data table)
8. ARCHIVE (ARCHIVE storage engine is often used in a very small script that requires large data and no index)
9. CSV (CSV storage engine stores data in a file using a comma-delimited format)
Blackhole (Blackhole storage engine is like a "black hole" that accepts data but is thrown directly and is not stored. The retrieved result set always returns NULL)
question : What is the function of the 2 Hearder () function in PHP?
answer : the 2 header () function sends the native HTTP header request to the client. We can redirect the page using the header () function. Using the header () function, it is important to note that you cannot have any form of output statement until you use it.
question : 3 How do I execute PHP scripts on the command line?
answer : 3 only need to run the PHP CLI (Command line interface) program and provide PHP script files as command line parameters.
question : 4 Suppose your Zend engine supports <??> syntax, how do I open it in your configuration?
answer : 4 in php.ini file:
Set up
Short_open_tag=on
question : 5 Shopping cart online verification, how to configure PayPal?
Answer : 5 We don't need to do anything extra, just jump to PayPal's address after submission and provide the data you need for patpal, such as the total price and address.
question : 6 nl2br () What is this function for?
answer : 6 Insert the HTML wrap tag before all new lines in the string.
question : What is 7 htaccess? Where and why are we using it?
answer : 7. The htaccess file is a configuration file for the Apache server, which provides a configuration parameter for each directory. This file contains one or more configuration directives, which are then placed under a specific directory file and then applied to the directory and all its subdirectories.
question : 8 How do I get the IP address of the client and the address of the previous page?
answer : 8 by using $_server[' remote_addr '],$_server[' http_referer '.
Issue : 9 Choose lamp (Linux, Apache, MySQL,
PHP) And what are the reasons for not choosing a different language and operating system?
answer : 9 Because the lamp is open source. Linux is much better security than window. Apache is stronger in functionality and security than IIS. MySQL is now the most popular open source database. PHP is much faster than ASP or other scripting languages.
question : 10 How do I encrypt and decrypt data from MySQL tables in MySQL?
answer : 10 using Aes_encrypt () and Aes_decrypt ()
The above is the small sum summarized PHP Interview and PHP developers should master the 10 questions, and later have new questions to share at any time Oh!
PHP Interview and PHP developers should have 10 questions "Brother Lian Experience Skills"