search
HomeBackend DevelopmentPHP TutorialPHP automatically updates the site map every 15 minutes (reduces server consumption)

I am currently working on a short URL, and I wrote the code myself. Exercise yourself. When making an HTML website map, I want to display all the generated short links for easy inclusion. I wrote a sitemap.php, and later found that if there is a large flow of people or too much data in the future, the server burden will be particularly heavy. If there are 100,000 pieces of data, everyone will index these 100,000 pieces of data from the database when they visit. With 100 people visiting every second, the server simply cannot bear it. Then the idea of ​​generating html maps came up.

Due to my poor academic skills, there may be something wrong with my thinking. I hope to have better ideas to criticize and correct!

Principle:

Requires three files:

  • sitemap.html (This file is automatically generated by the system, sitemap. Clone version of php)

  • sitemap.php (main page, determines the style of the page, etc., completely =sitemap.html)

  • timeSitemap. php (for the update program, generate html pages. You can set up monitoring in the monitoring treasure.)

sitemap.php is the page file, sitemap.html is the clone version of sitemap.php, monitoring treasure Set up the timeSitemap.php file for scheduled monitoring to generate a site map every 15 minutes. Of course, the frequency is determined by the monitoring frequency of the monitoring treasure. If the map generation fails, 404 will be returned and the monitoring treasure will alarm. The same applies to sitemap.xml

The code is shared below (use the mysql query and other classes to simply encapsulate the database class for yourself, which will not be shown here):

sitemap.php

<?php
/*
@   sitemap html版地图
*/
// 引入数据库操作类
require_once &#39;c/class.class.php&#39;;
// 引入系统参数
$config = require &#39;c/config.php&#39;;
?>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no">
<title>网站地图 - <?php echo $config[&#39;web_title&#39;]; ?></title>
<meta name="keywords" content="<?php echo $config[&#39;web_keywords&#39;];?>">
<meta name="description" content="<?php echo $config[&#39;web_description&#39;]; ?>">
<link href="<?php //echo $config[&#39;web_url&#39;];?>/css/bootstrap.min.css" rel=&#39;stylesheet&#39; type=&#39;text/css&#39;>
<!--
<link href="<?php //echo $config[&#39;web_url&#39;];?>/css/style.css" rel=&#39;stylesheet&#39; type=&#39;text/css&#39;>
<link href="<?php //echo $config[&#39;web_url&#39;];?>/css/media.css" rel=&#39;stylesheet&#39; type=&#39;text/css&#39;>
<script src="<?php //echo $config[&#39;web_url&#39;];?>/css/jquery-3.1.1.min.js"></script>
-->
<link type="favicon" rel="shortcut icon" href="<?php //echo $config[&#39;web_url&#39;];?>/favicon.ico" />
<link type="favicon" rel="icon" href="<?php //echo $config[&#39;web_url&#39;];?>/favicon.ico" />
<style>
.table tr {
text-align: center;
}
a {
display: inline-block;
padding: 10px;
}
</style>
</head>
<body>
<!--先提示-->
<?php
// <!-- 取出所有短网址 -->
$cons = new con();
$consSql = "select * from urls order by id desc";
$consQuery = $cons->query($consSql);
// >> 总数量
$consNum = mysql_num_rows($consQuery);
?>
<div class="container">
<!--<table class="table table-striped table-bordered table-hover table-condensed">-->
<hr>
<div style=&#39;text-align:center;height:35px;line-height:35px;font-weight:bold;&#39;>
共<?php echo $consNum; ?>条数据</div><div style=&#39;text-align:center;&#39;>本页面每15分钟更新一次
</div>
</hr>
本站链接:<a href="http://bba.fun">bba.fun短网址</a><a href="http://bba.fun/page/api">api接口</a><a href="http://bba.fun/sitemap.html">网站地图</a>
<br>
生成链接:
<br>
<?php
// >> 显示总数量
echo "";
// >> 开始循环取出
while($rows = mysql_fetch_array($consQuery)){
echo "<a href=&#39;{$rows[&#39;short_url&#39;]}&#39; target=&#39;_blank&#39; rel=&#39;external nofollow&#39;>".$rows[&#39;short_url&#39;]."</a>";
}
?>
<!--</table>-->
<div style=&#39;text-align:center;height:35px;line-height:35px;font-weight:bold;&#39;>2017© <a href="<?php echo $config[&#39;web_url&#39;];?>"><?php echo $config[&#39;web_title&#39;]; ?></a></div><hr>
</div>
</body>
</html>

timeSitemap.php

<?php
/*
@   定时更新网站地图
*/
// 定义获取的url
$url = "http://bba.fun/sitemap.php";
// 定网站地图名字
$name = "sitemap.html";
// 获取源码
$html = file_get_contents($url);
// 写入html
$write = file_put_contents($name,$html);
if($write){
header("HTTP/1.1 200");
}else {
header("HTTP/1.1 404");
}
?>

The above is the detailed content of PHP automatically updates the site map every 15 minutes (reduces server consumption). For more information, please follow other related articles on the PHP Chinese website!

Statement
This article is reproduced at:csdn. If there is any infringement, please contact admin@php.cn delete
Laravel routing parameter delivery and controller method definition: Avoiding common errors and best practicesLaravel routing parameter delivery and controller method definition: Avoiding common errors and best practicesJul 23, 2025 pm 07:27 PM

This tutorial details the correct method of parameter passing in Laravel routing, and corrects common errors in writing parameter placeholders into controller method names. The article provides examples of standardized routing definitions and controller methods, and emphasizes that deletion operations should prioritize the use of HTTPDELETE methods to enhance routing semantics and maintainability.

Guide to matching Laravel routing parameter passing and controller methodGuide to matching Laravel routing parameter passing and controller methodJul 23, 2025 pm 07:24 PM

This article aims to resolve common errors in the Laravel framework where routing parameter passing matches controller methods. We will explain in detail why writing parameters directly to the controller method name in the routing definition will result in an error of "the method does not exist", and provide the correct routing definition syntax to ensure that the controller can correctly receive and process routing parameters. In addition, the article will explore best practices for using HTTPDELETE methods in deletion operations.

How to use PHP to develop a Q&A community platform Detailed explanation of PHP interactive community monetization modelHow to use PHP to develop a Q&A community platform Detailed explanation of PHP interactive community monetization modelJul 23, 2025 pm 07:21 PM

1. The first choice for the Laravel MySQL Vue/React combination in the PHP development question and answer community is the first choice for Laravel MySQL Vue/React combination, due to its maturity in the ecosystem and high development efficiency; 2. High performance requires dependence on cache (Redis), database optimization, CDN and asynchronous queues; 3. Security must be done with input filtering, CSRF protection, HTTPS, password encryption and permission control; 4. Money optional advertising, member subscription, rewards, commissions, knowledge payment and other models, the core is to match community tone and user needs.

Efficiently use JSON data to implement cascading drop-down menus in Laravel Blade templatesEfficiently use JSON data to implement cascading drop-down menus in Laravel Blade templatesJul 23, 2025 pm 07:18 PM

This article details how to load a local JSON file in a Laravel application and pass its data to a Blade template. By processing JSON parsing by the controller, the view layer uses Blade's @foreach instruction to traverse the data, thereby realizing dynamically generating drop-down menus. In particular, the article also explores in-depth how to combine JavaScript to implement multi-level linkage drop-down menu functions to provide users with dynamic content display based on selection, and provides practical code examples and precautions for implementing such interactions.

Deep analysis of matching Laravel routing parameter transfer and controller methodDeep analysis of matching Laravel routing parameter transfer and controller methodJul 23, 2025 pm 07:15 PM

This article deeply explores the correct transmission of routing parameters and the matching mechanism of controller methods in the Laravel framework. In response to the common "method does not exist" error caused by writing routing parameters directly to the controller method name, the article elaborates on the correct way to define routing, that is, declare parameters in the URI and receive them as independent parameters in the controller method. At the same time, the article also provides code examples and suggestions on best practices for HTTP methods, aiming to help developers build more robust and RESTful Laravel applications.

PHP integrated AI intelligent image processing PHP image beautification and automatic editingPHP integrated AI intelligent image processing PHP image beautification and automatic editingJul 23, 2025 pm 07:12 PM

PHP integrated AI image processing requires the help of a third-party API or local model, which cannot be directly implemented; 2. Use ready-made services such as Google CloudVision API to quickly realize facial recognition, object detection and other functions. The advantages are fast development and strong functions. The disadvantages are that they need to pay, rely on the network and have data security risks; 3. Deploy local AI models through PHP image library such as Imagick or GD combined with TensorFlowLite or ONNXRuntime. It can be customized, the data is safer, and the cost is low, but the development is difficult and requires AI knowledge; 4. Mixed solutions can combine the advantages of API and local model, such as using API for detection and beautification of local models; 5. Selecting AI image processing API should be comprehensive

Twilio Voice Call Maintenance and Recovery: Meeting Functions and Independent Call Leg Management PracticeTwilio Voice Call Maintenance and Recovery: Meeting Functions and Independent Call Leg Management PracticeJul 23, 2025 pm 07:09 PM

This article discusses in-depth two main strategies for realizing voice call holding (Hold) and recovery (Unhold) on the Twilio platform. First, we introduce the detailed introduction to leveraging the Twilio Conference feature to easily manage call retention by updating the Participant resources, and provide corresponding code examples. Second, for scenarios where more detailed control of independent call legs (CallLeg) is required, how to combine TwiML instructions (such as and/) to handle call reconnection, while highlighting the complexity of this approach. The article aims to provide professional and practical guidance to help developers choose the most suitable implementation solution according to specific needs.

Laravel routing parameter passing: correctly define the controller method and routing bindingLaravel routing parameter passing: correctly define the controller method and routing bindingJul 23, 2025 pm 07:06 PM

This article discusses the correct posture of parameter transfer of controller method in Laravel routing in depth. In response to common errors caused by writing routing parameters directly to the controller method name, the correct routing definition syntax is explained in detail, and the mechanism of Laravel automatic parameter binding is emphasized. At the same time, the article recommends using HTTPDELETE method that is more in line with RESTful specifications to handle deletion operations to improve the maintainability and semantics of the application.

See all articles

Hot AI Tools

Undress AI Tool

Undress AI Tool

Undress images for free

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

SAP NetWeaver Server Adapter for Eclipse

SAP NetWeaver Server Adapter for Eclipse

Integrate Eclipse with SAP NetWeaver application server.

DVWA

DVWA

Damn Vulnerable Web App (DVWA) is a PHP/MySQL web application that is very vulnerable. Its main goals are to be an aid for security professionals to test their skills and tools in a legal environment, to help web developers better understand the process of securing web applications, and to help teachers/students teach/learn in a classroom environment Web application security. The goal of DVWA is to practice some of the most common web vulnerabilities through a simple and straightforward interface, with varying degrees of difficulty. Please note that this software

EditPlus Chinese cracked version

EditPlus Chinese cracked version

Small size, syntax highlighting, does not support code prompt function

Atom editor mac version download

Atom editor mac version download

The most popular open source editor

mPDF

mPDF

mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),