require_once 'conn.php';
$sql="select * from help_relation";
$result=mysql_query($sql);
$num=mysql_num_rows($result);
$pagesize=2;//设定每页的记录数
$pages=ceil($num/$pagesize);//取得总页数
if($pages $page=$_GET[page];//取得传递过来的页数
if($page>$pages){$page=$pages;}//如果传递过来的页数比总页数还大,就让它等于总页数
if($page $kaishi=($page-1)*$pagesize;//为下一步做准备,limit的初始记录
if(isset($_GET['help_keyword_id'])!=''){
$help_keyword_id=$_GET['help_keyword_id'];
$sql="select * from help_relation where help_keyword_id='$help_keyword_id' order by help_keyword_id desc limit $kaishi,$pagesize";//取得记录从计算出的初始值开始,一共$pagesize条
$result=mysql_query($sql);//取得结果
while($row=mysql_fetch_array($result))
{
echo "
//echo "
echo "
echo"
}
}
这是代码
回复讨论(解决方案)
没有传递 page 和 help_keyword_id 的代码
$help_keyword_id 只在有传入的 help_keyword_id 时存在,那没传入时不报错吗?
那应该怎么改呢 要重新写一条sql语句吗 还是在原有的基础上改
跪求大神啊 急用 实在是改不来 网上也找不到有用的
你这在网上档的么?你只做了分页,没做显示页码~当然没法做?
你要做一个显示页码的方法吧
点第一页的时候,就是你当前网址?page=1
你现在$page不存在肯定有问题啊?你起码要判断page为空的时候也要显示第一页
另一个$help_keyword_id 也是一样啊,你通过$_GET来获取,你的链接里必须存在啊
例如:www.baidu.com?page=1&help_keyword_id=15
这样才能获取啊

ThesecrettokeepingaPHP-poweredwebsiterunningsmoothlyunderheavyloadinvolvesseveralkeystrategies:1)ImplementopcodecachingwithOPcachetoreducescriptexecutiontime,2)UsedatabasequerycachingwithRedistolessendatabaseload,3)LeverageCDNslikeCloudflareforservin

You should care about DependencyInjection(DI) because it makes your code clearer and easier to maintain. 1) DI makes it more modular by decoupling classes, 2) improves the convenience of testing and code flexibility, 3) Use DI containers to manage complex dependencies, but pay attention to performance impact and circular dependencies, 4) The best practice is to rely on abstract interfaces to achieve loose coupling.

Yes,optimizingaPHPapplicationispossibleandessential.1)ImplementcachingusingAPCutoreducedatabaseload.2)Optimizedatabaseswithindexing,efficientqueries,andconnectionpooling.3)Enhancecodewithbuilt-infunctions,avoidingglobalvariables,andusingopcodecaching

ThekeystrategiestosignificantlyboostPHPapplicationperformanceare:1)UseopcodecachinglikeOPcachetoreduceexecutiontime,2)Optimizedatabaseinteractionswithpreparedstatementsandproperindexing,3)ConfigurewebserverslikeNginxwithPHP-FPMforbetterperformance,4)

APHPDependencyInjectionContainerisatoolthatmanagesclassdependencies,enhancingcodemodularity,testability,andmaintainability.Itactsasacentralhubforcreatingandinjectingdependencies,thusreducingtightcouplingandeasingunittesting.

Select DependencyInjection (DI) for large applications, ServiceLocator is suitable for small projects or prototypes. 1) DI improves the testability and modularity of the code through constructor injection. 2) ServiceLocator obtains services through center registration, which is convenient but may lead to an increase in code coupling.

PHPapplicationscanbeoptimizedforspeedandefficiencyby:1)enablingopcacheinphp.ini,2)usingpreparedstatementswithPDOfordatabasequeries,3)replacingloopswitharray_filterandarray_mapfordataprocessing,4)configuringNginxasareverseproxy,5)implementingcachingwi

PHPemailvalidationinvolvesthreesteps:1)Formatvalidationusingregularexpressionstochecktheemailformat;2)DNSvalidationtoensurethedomainhasavalidMXrecord;3)SMTPvalidation,themostthoroughmethod,whichchecksifthemailboxexistsbyconnectingtotheSMTPserver.Impl


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

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

SublimeText3 Chinese version
Chinese version, very easy to use

VSCode Windows 64-bit Download
A free and powerful IDE editor launched by Microsoft

SecLists
SecLists is the ultimate security tester's companion. It is a collection of various types of lists that are frequently used during security assessments, all in one place. SecLists helps make security testing more efficient and productive by conveniently providing all the lists a security tester might need. List types include usernames, passwords, URLs, fuzzing payloads, sensitive data patterns, web shells, and more. The tester can simply pull this repository onto a new test machine and he will have access to every type of list he needs.

Notepad++7.3.1
Easy-to-use and free code editor

SAP NetWeaver Server Adapter for Eclipse
Integrate Eclipse with SAP NetWeaver application server.
