Backend Development
PHP Tutorial
Example of how to implement infinite loop in PHP to obtain data in MySQL
Example of how to implement infinite loop in PHP to obtain data in MySQL
Recently, the company has a need to obtain data from MySQL, and then display it in a wireless loop on the page. In fact, this function can be realized through jq, or through php+mysql. The following editor will share with you the unlimited data based on PHP Friends who are interested can take a look at the implementation method of cyclically obtaining data in MySQL
Recently, the company has a need to obtain data from MySQL, and then display it in a wireless loop on the page. The main thing is to keep clicking a button, and then the data will cycle from the beginning to the end. If the data at the end is not enough, then take a few pieces from the beginning of the data to supplement it.
Actually, this function can be implemented through JQ or PHP + MYSQL, but JQ is more convenient and more efficient.
Display 10 pieces of data each time.
public function get_data($limit){
$sql="select * from ((select id,name from `mytable` limit {$limit},10) union all (select id,name from `mytable` limit 0,10)) as test limit 0,10";
return $this->query($sql);
}The above sql statement uses the union all method of mysql to splice the two collections together and take the first ten pieces of data.
public function getCount(){//获取数据的条数
$sql="select count(id) as t from `mytable`";
return $this->query($sql);
}The next step is to obtain the data in the controller and provide a data interface for ajax.
//测试数据库无限循环取数据
public function getInfiniteData(){
//用户点击数
$page = $_GET['click'];
//每次展示条数
$pagesize = 10;
//获取总条数
$total = $this->Mydemo->get_count();
$t = $total[0][0]['t'];
//算出每次点击的其起始位置
$limit = (($page - 1)*$pagesize)%$t;
$data = $this->Mydemo->get_data($limit);
if (!empty($data)) {
//转换为二维数组
$list = [];
foreach ($data as $key => $v) {
$list[$key] = $data[$key][0];
}
$info['msg'] = $list;
$info['code'] = '001';
}else{
$info['code'] = '002';
$info['msg'] = '暂无数据';
}
echo json_encode($info,JSON_UNESCAPED_UNICODE);die;
}Summary
The above is the detailed content of Example of how to implement infinite loop in PHP to obtain data in MySQL. For more information, please follow other related articles on the PHP Chinese website!
Hot AI Tools
Undress AI Tool
Undress images for free
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
Commenting Out Code in PHP
Jul 18, 2025 am 04:57 AM
There are three common methods for PHP comment code: 1. Use // or # to block one line of code, and it is recommended to use //; 2. Use /.../ to wrap code blocks with multiple lines, which cannot be nested but can be crossed; 3. Combination skills comments such as using /if(){}/ to control logic blocks, or to improve efficiency with editor shortcut keys, you should pay attention to closing symbols and avoid nesting when using them.
Tips for Writing PHP Comments
Jul 18, 2025 am 04:51 AM
The key to writing PHP comments is to clarify the purpose and specifications. Comments should explain "why" rather than "what was done", avoiding redundancy or too simplicity. 1. Use a unified format, such as docblock (/*/) for class and method descriptions to improve readability and tool compatibility; 2. Emphasize the reasons behind the logic, such as why JS jumps need to be output manually; 3. Add an overview description before complex code, describe the process in steps, and help understand the overall idea; 4. Use TODO and FIXME rationally to mark to-do items and problems to facilitate subsequent tracking and collaboration. Good annotations can reduce communication costs and improve code maintenance efficiency.
Improving Readability with Comments
Jul 18, 2025 am 04:46 AM
The key to writing good comments is to explain "why" rather than just "what was done" to improve the readability of the code. 1. Comments should explain logical reasons, such as considerations behind value selection or processing; 2. Use paragraph annotations for complex logic to summarize the overall idea of functions or algorithms; 3. Regularly maintain comments to ensure consistency with the code, avoid misleading, and delete outdated content if necessary; 4. Synchronously check comments when reviewing the code, and record public logic through documents to reduce the burden of code comments.
Writing Effective PHP Comments
Jul 18, 2025 am 04:44 AM
Comments cannot be careless because they want to explain the reasons for the existence of the code rather than the functions, such as compatibility with old interfaces or third-party restrictions, otherwise people who read the code can only rely on guessing. The areas that must be commented include complex conditional judgments, special error handling logic, and temporary bypass restrictions. A more practical way to write comments is to select single-line comments or block comments based on the scene. Use document block comments to explain parameters and return values at the beginning of functions, classes, and files, and keep comments updated. For complex logic, you can add a line to the previous one to summarize the overall intention. At the same time, do not use comments to seal code, but use version control tools.
Learning PHP: A Beginner's Guide
Jul 18, 2025 am 04:54 AM
TolearnPHPeffectively,startbysettingupalocalserverenvironmentusingtoolslikeXAMPPandacodeeditorlikeVSCode.1)InstallXAMPPforApache,MySQL,andPHP.2)Useacodeeditorforsyntaxsupport.3)TestyoursetupwithasimplePHPfile.Next,learnPHPbasicsincludingvariables,ech
Quick PHP Installation Tutorial
Jul 18, 2025 am 04:52 AM
ToinstallPHPquickly,useXAMPPonWindowsorHomebrewonmacOS.1.OnWindows,downloadandinstallXAMPP,selectcomponents,startApache,andplacefilesinhtdocs.2.Alternatively,manuallyinstallPHPfromphp.netandsetupaserverlikeApache.3.OnmacOS,installHomebrew,thenrun'bre
Mastering PHP Block Comments
Jul 18, 2025 am 04:35 AM
PHPblockcommentsareusefulforwritingmulti-lineexplanations,temporarilydisablingcode,andgeneratingdocumentation.Theyshouldnotbenestedorleftunclosed.BlockcommentshelpindocumentingfunctionswithPHPDoc,whichtoolslikePhpStormuseforauto-completionanderrorche
Effective PHP Commenting
Jul 18, 2025 am 04:33 AM
The key to writing PHP comments is clear, useful and concise. 1. Comments should explain the intention behind the code rather than just describing the code itself, such as explaining the logical purpose of complex conditional judgments; 2. Add comments to key scenarios such as magic values, old code compatibility, API interfaces, etc. to improve readability; 3. Avoid duplicate code content, keep it concise and specific, and use standard formats such as PHPDoc; 4. Comments should be updated synchronously with the code to ensure accuracy. Good comments should be thought from the perspective of others, reduce the cost of understanding, and become a code understanding navigation device.


