Advanced Search

Select 4 shengmu letters domain name from database

/ Published in: PHP
Save to your folder(s)
用正则表达式从数据库中选出所有字母皆为声母的四字母域名

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. <?php
  2. /*
  3.  * Author: polo.mp
  4.  * Data:   2009-03-26
  5.  * Url:    http://www.pjoke.com/tools/domain/4shengmu.php
  6.  */
  7. set_time_limit(0);
  8. date_default_timezone_set(RPC); //设置默认时区为中国
  9. $smfile = "4shengmu.html";
  10. $smTime = 0;
  11. if (file_exists($smfile)) {
  12.     $smTime = date("YmdH", filemtime($smfile));
  13. }
  14. $nowTime = date("YmdH", time());
  15.  
  16. if ($nowTime - $smTime > 1) {  //1小时1次
  17.     $fp = fopen($smfile, 'wb');
  18. }
  19. else {
  20.     $fp = fopen($smfile, 'rb');
  21. include("header.php");
  22.     fpassthru($fp);
  23. include("footer.php");
  24.     fclose($fp);
  25.     exit;
  26. }
  27.  
  28. require_once('../../db/jk-config.php');
  29.  
  30. $sqlstr = "select * from pooldrop where length(`name`)<5 and `name` not regexp '[^b-df-hj-np-tw-z]' and `type`='com'";
  31.  
  32. $result = $jkdb->get_results($sqlstr);
  33.  
  34. $htmltext = "<p>待删除的4声母域名（.com）</p></td>
  35.   </tr>
  36.   <tr><td></td></tr>
  37.   <tr>
  38. <td width=\"773\" colspan=\"2\">";
  39. if ($result) {
  40.     $htmltext.= "<table><tr><td>4声母</td><td>后缀</td><td>删除日期（美国东部时间）</td></tr>";
  41.     foreach ($result as $re) :
  42.     	$htmltext .= "<tr><td>".$re->name."</td><td>".$re->type."</td><td>".$re->date."</td></tr>";
  43. 	endforeach;
  44. 	$htmltext .= "</table>";
  45. }
  46.  
  47. fwrite($fp, $htmltext);
  48. fclose($fp);
  49. include("header.php");
  50. echo $htmltext;
  51. include("footer.php");
  52. ?>

URL: http://www.pjoke.com/tools/domain/4shengmu.php

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.