摘要: 在某些数据库中有交叉表,但在MySQL中却没有这个功能,但网上看到有不少朋友想找出一个解决方法,特发贴集思广义。http://topic.csdn.net/u/20090530/23/0b782674-4b0b-4cf5-bc1a-e8914aaee5ab.html?96198现整理解法如下:数据样本:create table tx( id int primary key, c1 char(2), c2 char(2), c3 int ); insert into tx values (1 ,'A1','B1',9), (2 ,'A2',' 阅读全文
posted @ 2012-01-11 16:30 bluepace 阅读(455) 评论(0) 推荐(0) 编辑
摘要: 1 <? 2 $host = "www.aaa.com"; 3 $path = "/Report.php?ReportID=1"; 4 $cookie = Session_id(); 5 6 $fp = fsockopen($host, 80, $errno, $errstr, 30); 7 if (!$fp) { 8 print "$errstr ($errno)<br />\n"; 9 exit;10 }11 $out = "GET ".$path." HTTP/1.1\r\n&qu 阅读全文
posted @ 2012-01-11 11:51 bluepace 阅读(682) 评论(0) 推荐(0) 编辑
摘要: 1 <?php 2 ignore_user_abort(true); 3 set_time_limit(0); 4 5 while(1) { 6 $fp = fopen('time_task.txt',"a+"); 7 $str = date("Y-m-d h:i:s")."\n\r"; 8 fwrite($fp,$str); 9 fclose($fp);10 sleep(5); //半小时执行一次11 }12 ?> 阅读全文
posted @ 2012-01-11 11:28 bluepace 阅读(297) 评论(0) 推荐(0) 编辑