$xiaoID=$_POST['xsId_xiao'];//POST最小ID$daID=$_POST['xsId_da'];//POST最大ID$chaId="select * from xs where Id>='$xiaoID' and sId<='$daID'";$rsID=$mysqli->query($chaId);while($rs=$rsID->fetch_assoc()){ $ming=$rs['leiming'];//循环出类名; $chaming="select * from shitu where toming='$ming'"; $cha=$mysqli->query($chaming); while($row=$cha->fetch_assoc()){ $neirong.=$row['neirong'];//如这个类下很多文章,使用 $neirong. 连接起来 } $ming=iconv("UTF-8","GBK",$ming);//在WIN平台下转编码。 $wei='../txt/'.$ming.'.txt';//设置生成路径。 $weizhi=fopen($wei,'w')or die("can't open file"); fwrite($weizhi,$neirong);//生成 fclose($weizhi); $mysqli->close();}
功力只能想到这些了。想不出来怎么处理,错误了。求修改。
1:按ID 从小到大 循环出类名,
2:在循环类名下所有文章,
3:把一个类下所有文章生成为一个TXT。
回复讨论(解决方案)
既然错误了,为什么不贴出错误。
既然错误了,为什么不贴出错误。
他没错误呢。提交过去是空白。IE提示500错误。
php.ini 中令 display_errors=On
然后重启服务器运行看看
php.ini 中令 display_errors=On
然后重启服务器运行看看
呵呵,一样是500错误。
什么环境?清一下缓存看看。firefox 测试如何?
套红的部分有问题!
$xiaoID=$_POST['xsId_xiao'];//POST最小ID
$daID=$_POST['xsId_da'];//POST最大ID
$chaId="select * from xs where Id>='$xiaoID' and sId $rsID=$mysqli->query($chaId);
while($rs=$rsID->fetch_assoc()){
$ming=$rs['leiming'];//循环出类名;
$chaming="select * from shitu where toming='$ming'";
$cha=$mysqli->query($chaming);
while($row=$cha->fetch_assoc()){
$neirong.=$row['neirong'];//如这个类下很多文章,使用 $neirong. 连接起来
}
$ming=iconv("UTF-8","GBK",$ming);//在WIN平台下转编码。
$wei='../txt/'.$ming.'.txt';//设置生成路径。
$weizhi=fopen($wei,'w')or die("can't open file");
fwrite($weizhi,$neirong);//生成
fclose($weizhi);
$mysqli->close();
}
套红的部分有问题!
$xiaoID=$_POST['xsId_xiao'];//POST最小ID
$daID=$_POST['xsId_da'];//POST最大ID
$chaId="select * from xs where Id>='$xiaoID' and sId $rsID=$mysqli->query($chaId);
while($rs=$rsID->fetch_assoc()){
$ming=$rs['leiming'];//循环出类名;
$chaming="select * from shitu where toming='$ming'";
$cha=$mysqli->query($chaming);
while($row=$cha->fetch_assoc()){
$neirong.=$row['neirong'];//如这个类下很多文章,使用 $neirong. 连接起来
}
$ming=iconv("UTF-8","GBK",$ming);//在WIN平台下转编码。
$wei='../txt/'.$ming.'.txt';//设置生成路径。
$weizhi=fopen($wei,'w')or die("can't open file");
fwrite($weizhi,$neirong);//生成
fclose($weizhi);
$mysqli->close();
}
假如不使用 $row['neirong'] 就是这个类别下的1个文章,循环出来赋值给1个变量,使用变量加点连接起来,集合成一个变量,然后赋值为一个TXT文本内容,我想不到更好的办法。不知道还有其他办法不?
不是说不能 $neirong.=$row['neirong']; 这样写
而是由于 $neirong 没有初值,导致所有的查询结果都会被附加在其中,最终可能因内存不足而失败
何况也不符合你文章按类别归类的初衷
主要的问题在 $mysqli->close();
你是在外层循环中关闭数据库连接的,当 $xiaoID ≠ $daID 时将造成第二轮的 $cha=$mysqli->query($chaming); 失败
如果没有开启php的错误显示功能,则会导致web服务器出现500错
这样写就可以了
$sql = "select * from xs, shitu where xs.leiming=shitu.toming and xs.Id>='$xiaoID' and xs.sId<='$daID'";$rsID=$mysqli->query($sql);while($rs=$rsID->fetch_assoc()){ $ming=$rs['leiming'];//循环出类名; $ming=iconv("UTF-8","GBK",$ming);//在WIN平台下转编码。 $wei='../txt/'.$ming.'.txt';//设置生成路径。 file_put_contents($wei, $rs['neirong'], FILE_APPEND);}$mysqli->close();

PHPisusedforsendingemailsduetoitsintegrationwithservermailservicesandexternalSMTPproviders,automatingnotificationsandmarketingcampaigns.1)SetupyourPHPenvironmentwithawebserverandPHP,ensuringthemailfunctionisenabled.2)UseabasicscriptwithPHP'smailfunct

The best way to send emails is to use the PHPMailer library. 1) Using the mail() function is simple but unreliable, which may cause emails to enter spam or cannot be delivered. 2) PHPMailer provides better control and reliability, and supports HTML mail, attachments and SMTP authentication. 3) Make sure SMTP settings are configured correctly and encryption (such as STARTTLS or SSL/TLS) is used to enhance security. 4) For large amounts of emails, consider using a mail queue system to optimize performance.

CustomheadersandadvancedfeaturesinPHPemailenhancefunctionalityandreliability.1)Customheadersaddmetadatafortrackingandcategorization.2)HTMLemailsallowformattingandinteractivity.3)AttachmentscanbesentusinglibrarieslikePHPMailer.4)SMTPauthenticationimpr

Sending mail using PHP and SMTP can be achieved through the PHPMailer library. 1) Install and configure PHPMailer, 2) Set SMTP server details, 3) Define the email content, 4) Send emails and handle errors. Use this method to ensure the reliability and security of emails.

ThebestapproachforsendingemailsinPHPisusingthePHPMailerlibraryduetoitsreliability,featurerichness,andeaseofuse.PHPMailersupportsSMTP,providesdetailederrorhandling,allowssendingHTMLandplaintextemails,supportsattachments,andenhancessecurity.Foroptimalu

The reason for using Dependency Injection (DI) is that it promotes loose coupling, testability, and maintainability of the code. 1) Use constructor to inject dependencies, 2) Avoid using service locators, 3) Use dependency injection containers to manage dependencies, 4) Improve testability through injecting dependencies, 5) Avoid over-injection dependencies, 6) Consider the impact of DI on performance.

PHPperformancetuningiscrucialbecauseitenhancesspeedandefficiency,whicharevitalforwebapplications.1)CachingwithAPCureducesdatabaseloadandimprovesresponsetimes.2)Optimizingdatabasequeriesbyselectingnecessarycolumnsandusingindexingspeedsupdataretrieval.

ThebestpracticesforsendingemailssecurelyinPHPinclude:1)UsingsecureconfigurationswithSMTPandSTARTTLSencryption,2)Validatingandsanitizinginputstopreventinjectionattacks,3)EncryptingsensitivedatawithinemailsusingOpenSSL,4)Properlyhandlingemailheaderstoa


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

Atom editor mac version download
The most popular open source editor

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

PhpStorm Mac version
The latest (2018.2.1) professional PHP integrated development tool

SublimeText3 Chinese version
Chinese version, very easy to use

SublimeText3 Linux new version
SublimeText3 Linux latest version
