1. For a website with high traffic, what method do you use to solve the traffic problem?
First, confirm whether the server hardware is sufficient to support the current traffic
Secondly, optimize database access.
Third, external hotlinking is prohibited.
Fourth, control the download of large files.
Fifth, use different hosts to divert the main traffic.
Sixth, use traffic analysis and statistics software.
2. Use PHP to write the code to display the client IP and server IP:
//Display client IP
function get_client_ip() {#
if(getenv('HTTP_CLIENT_IP')) {
$client_ip = getenv('HTTP_CLIENT_IP');
} elseif(getenv('HTTP_X_FORWARDED_FOR')) {
$client_ip = getenv('HTTP_X_FORWARDED_FOR');
} elseif(getenv('REMOTE_ADDR')) {
$client_ip = getenv('REMOTE_ADDR');
} else {
$client_ip = $HTTP_SERVER_VAR['REMOTE_ADDR'];
}
return $client_ip;
}
//Server IP
function get_server_ip(){
if (isset($_SERVER))
{
if($_SERVER['SERVER_ADDR']) $huoqu_ip=$_SERVER['SERVER_ADDR'];
else $huoqu_ip=$_SERVER['LOCAL_ADDR'];
}
else
{
$huoqu_ip=getenv('SERVER_ADDR');
}
return $huoqu_ip;
}
3.MYsql programming interview questions.
(1) In a certain content management system, the message table has the following fields:
id article id
title article title
content article content
category_id article category id
hits clicks
Create the above table and write the MySQL statement:
CREATE TABLE 'message'(
id int(11) NOT NULL auto_increment,
title varchar(200) default NULL,
content blob,
category_id int(11) default NULL,
hits int(11) default NULL,
PRIMARY KEY('id')
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
(2) The same news release system as above: the comment table records the content of user replies, and the fields are as follows:
comment_id reply id
id article id, associated with the id in the message table
comment_content reply content
Now you need to query the database to get a list of article titles in the following format, and sort them by the number of replies, with the highest reply at the top
Article id Article title Number of clicks Number of replies
Use a SQL statement to complete the above query. If the article has no replies, the number of replies will be displayed as 0
SELECT message.id id,message.title title,IF(message.`hits` IS NULL,0,message.`hits`)
hits,IF(comment.`id` is NULL,0,count(*)) number
FROM message LEFT JOIN comment ON message.id=comment.id
GROUP BY message.`id`
(3) In the above content management system, the category table stores classification information, and the fields are as follows (3 points)
category_id int(4) not null auto_increment;
categroy_name varchar(40) not null;
When the user enters an article, select the article category by selecting the drop-down menu
Write how to implement this drop-down menu
function categoryList()
{
$result=mysql_query("select category_id,categroy_name from category")
or die("Invalid query: " . mysql_error());
print("");
}