Warning: Undefined array key "HTTP_ACCEPT_LANGUAGE" in /www/wwwroot/01xj.net/wp-content/plugins/wp-ue/main.php on line 13
{"id":166,"date":"2011-10-08T11:27:47","date_gmt":"2011-10-08T11:27:47","guid":{"rendered":"http:\/\/www.01xj.net\/0\/?p=166"},"modified":"2011-10-08T11:27:47","modified_gmt":"2011-10-08T11:27:47","slug":"adodbsmarty%e7%9a%84%e4%b8%80%e4%b8%aaphp%e5%88%86%e9%a1%b5%e7%b1%bb%e5%b8%a6%e6%90%9c%e7%b4%a2%e5%88%86%e9%a1%b5","status":"publish","type":"post","link":"https:\/\/www.01xj.net\/?p=166","title":{"rendered":"ADODB+SMARTY\u7684\u4e00\u4e2aPHP\u5206\u9875\u7c7b(\u5e26\u641c\u7d22\u5206\u9875)"},"content":{"rendered":"[code]\ntable=$table;
\n $all=$conn->GetAll($sql);
\n $this->num=count($all);
\n return $this->num;
\n}
\nfunction Getallpage($n){\/\/\u5f97\u5230\u4e00\u5171\u51e0\u9875
\n $this->n=$n;
\n $this->j=ceil($this->num\/$this->n);
\n return $this->j;
\n}
\nfunction Getpage($d,$url){\/\/\u5206\u9875
\n $d=$_GET[‘page’];
\n $this->d=$d;
\n $this->url=$url;
\n if (empty($this->d) || $this->d <0 || $this->d==0 || $this->d==1){
\n $this->d=1;
\n if(($this->j)>1){
\n $str=”\u9996\u9875”;
\n $str.=$this->mathurl(2,5);
\n $str.=”url.”page=”.($this->d-1).”‘>\u4e0a\u4e00\u9875<\/a>“;
\n $str.=$this->mathurl(2,5);
\n $str.=”\u5c3e\u9875”;
\n }else{
\n $str=”url.”page=”.($this->d+1).”‘>\u4e0b\u4e00\u9875<\/a>“;
\n }
\n return $str;
\n return $this->d;
\n return $this->url;
\n}
\nfunction Getstart(){\/\/\u8d77\u59cb\u4f4d\u7f6e
\n if(empty($this->d)){
\n $this->start=0;
\n }else{
\n $this->start=$this->n*($this->d-1);
\n }
\n return $this->start;
\n}
\nfunction Getend($e){\/\/\u6bcf\u9875\u663e\u793a\u6761\u6570
\n return $this->d=$e;
\n}
\nfunction options(){\/\/\u8df3\u8f6c\u83dc\u5355
\n $opt=” url.”page=”.$o.”‘>”.$o.”<\/a> “;
\n }
\n }elseif($co>($do-$this->py)){\/\/\u9875\u7801\u8d85\u8fc7\u603b\u9875\u6570\u65f6
\n $co=$do;
\n for ($v=($co-($this->yc-1));$v<=$do;$v++){\/\/\u5f80\u5de6\u504f\u79fb$yc\u4e2a\u5355\u4f4d\n $murl.=\" url.”page=”.$v.”‘>”.$v.”<\/a> “;
\n }
\n }else{
\n for($k=($co-$this->py);$k<$co;$k++){\/\/\u5f80\u5de6\u504f\u79fb$py\u4e2a\u5355\u4f4d\n $murl.=\" url.”page=”.$v.”‘>”.$v.”<\/a> “;
\n }
\n }
\n return $murl;
\n}
\n}\/*
\nrequire_once(“..\/class\/Smarty.class.php”);
\ninclude “..\/adodb\/adodb.inc.php”;
\ninclude “..\/connect.php”;
\n$page=new Page();
\n$sql=”select * from class”;
\n$p[‘num’]=$page->Getallnum($sql);
\n$p[‘page’]=$page->Getallpage(10);
\n$p[‘link’]=$page->Getpage(1,”class.inc.php?”);
\n$p[‘start’]=$page->Getstart(0);
\n$p[‘end’]=$page->Getend(10);
\n$p[‘opt’]=$page->options();
\n$a=$conn->GetAll(“select * from class limit “.$p[‘start’].”,”.$p[‘end’].””);
\n————————–\u4e0a\u9762\u7684\u662f\u6570\u636e\u5e93\u5206\u9875\u7684\u4f8b\u5b50——————————-
\n————————–\u4e0b\u9762\u7684\u662f\u641c\u7d22\u5206\u9875\u7684\u4f8b\u5b50————————————–
\n$s=$_GET[‘s’];
\n$si=$_POST[‘s’];
\nif(empty($_GET[‘key’])){
\n$key=$si;
\n}else{
\n$key=$_GET[‘key’];
\n}
\nif($s==”s”){
\n$page=new Page();
\n$sqa=”select cname from class where cname like binary ‘%”.$key.”%'”;
\n$p[‘num’]=$page->Getallnum($sqa);
\n$p[‘page’]=$page->Getallpage(6);
\n$p[‘link’]=$page->Getpage(1,”class.inc.php?s=s&key=”.$key.”&”);
\n$p[‘start’]=$page->Getstart(0);
\n$p[‘end’]=$page->Getend(6);
\n$sql=”select cname from class where cname like binary ‘%”.$key.”%’ limit “.$p[‘start’].”,”.$p[‘end’].””;
\n$rs=$conn->GetAll($sql);
\n}
\n————————-\u4e0b\u9762\u7684\u662fsmarty\u5e94\u7528————————————————-
\n$smarty = new Smarty;
\n$smarty->assign(“page”,$p);
\n$smarty->assign(“show”,$a);
\n\/\/$smarty->assign(“se”,$rs);
\n$smarty->display(‘class.inc.htm’);
\n*\/
\n?><\/p>\n[\/code]\n","protected":false},"excerpt":{"rendered":"

[code]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-166","post","type-post","status-publish","format-standard","hentry","category-phpjsshell"],"_links":{"self":[{"href":"https:\/\/www.01xj.net\/index.php?rest_route=\/wp\/v2\/posts\/166","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.01xj.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.01xj.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.01xj.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.01xj.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=166"}],"version-history":[{"count":1,"href":"https:\/\/www.01xj.net\/index.php?rest_route=\/wp\/v2\/posts\/166\/revisions"}],"predecessor-version":[{"id":167,"href":"https:\/\/www.01xj.net\/index.php?rest_route=\/wp\/v2\/posts\/166\/revisions\/167"}],"wp:attachment":[{"href":"https:\/\/www.01xj.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=166"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.01xj.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=166"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.01xj.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=166"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}