-
php整理常用时间戳和日期
昨天0时时间戳 $yesterday_zero = strtotime(date('Y-m-d')) - 3600 * 24; 昨天此时时间戳 $yesterday_now = strtotime('-1 day'); 本周一时间戳 $week_this_monday = strtotime('last Monday'); 明天时间戳 $tomorrow = strtotime("+1 day"); 上周一时间戳 $week_ ...
-
ThinkPHP中处理分类常使用到的方法集合类
类里面的主要方法如下
(1)php组合一维数组
(2)php组合多维数组
(3)php传递一个子级返回父级id 例如:首页>>服装>>女装>>裙子
(4)php传递一个父级ID返回所有子级分类
(5)php获取指定父id的所有分类
(6)php生成树形结构数组>服装>>女装>>裙子 Static public function getParents($cate,$id){ $arr=array(); foreach($cate as $v){ if($v['id']==$id){ $arr[]=$v; $arr=array_merge(self::getParents($cate,$v['pid']),$arr); } } return $arr; } //传递一个父级ID返回所有子级分类 Static public function getChiIds($cate,$pid,$str=0){ $arr=array(); static $strarr = array(); foreach ($cate as $v){ if($v['pid']==$pid){ $arr[]= $v; $strarr[] = $v['id']; $arr=array_merge($arr,self::getChiIds($cate,$v['id'])); } } return $str == 1 ? $strarr : $arr; } //获取指定父id的所有分类 static public function getCateByPid($cate,$pid=0){ $arr = array(); foreach($cate as $v){ if($v['pid']==$pid){ $arr[] = array('id'=>$v['id'],'name'=>$v['name']); } } return $arr; } //生成树形结构数组 static public function getCateTreeArr($cate,$pid){ $arr = array(); foreach($cate as $v){ if($v['pid']==$pid){ $child = Category::getCateTreeArr($cate,$v['id']); if($child){ $v['child'] = $child; } $arr[] = $v; } } return $arr; } } /******************** 这是一个文章分类表的设置 CREATE TABLE IF NOT EXISTS `yk_article_cate` ( `id` smallint(4) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, `alias` varchar(50) NOT NULL, `pid` smallint(4) unsigned NOT NULL DEFAULT '0', `spid` varchar(50) NOT NULL, `ordid` smallint(4) unsigned NOT NULL DEFAULT '255', `status` tinyint(1) NOT NULL DEFAULT '1', `seo_title` varchar(255) NOT NULL, `seo_keys` varchar(255) NOT NULL, `seo_desc` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; **************/ ?>
]]>
-
PHP $_FILES中error返回值详解
用PHP上传文件时,我们会用程序去监听浏览器发送过来的文件信息,首先会通 过$_FILES[fieldName][‘error’]的不同数值来判断此欲上传的文件状态是否正常。$_FILES[fieldName] [‘error’]==0代表一切正常,其它数值的具体含义请参考下面一段程序的注释部分,如有翻译不到之处还望指正! switc ...
-
常用的PHP函数
function check_date($date) { //检查日期是否合法日期 $dateArr = explode("-", $date); if (is_numeric($dateArr[0]) && is_numeric($dateArr[1]) && is_numeric($dateArr[2])) { //OsPHP.COM.CN return checkdate($dateArr[1],$dateArr[2],$dateArr[0]); } return false; } function check_time($time) { //检查时间是否合法时间 $timeArr = explode(“:”, $time); if (is_numeric($timeArr[0]) && is_numeric($timeArr[1]) && is_numeric($timeArr[2])) { if (($timeArr[0] >= 0 && $timeArr[0] <= 23) && ($timeArr[1] >= 0 && $timeArr[1] <= 59) && ($timeArr[2] >= 0 && $timeArr[2] <= 59)) return true; else return false; } return false; } function DateDiff($date1, $date2, $unit = "") { //时间比较函数,返回两个日期相差几秒、几分钟、几小时或几天 switch ($unit) { case 's': $dividend = 1; break; case 'i': $dividend = 60; break; case 'h': $dividend = 3600; break; case 'd': $dividend = 86400; break; //oSPHP.COM.CN default: $dividend = 86400; } $time1 = strtotime($date1); $time2 = strtotime($date2); if ($time1 && $time2) return (float)($time1 – $time2) / $dividend; return false; } ?> PHP重定向 方法一:header("Location: index.php"); 方法二:echo "
nwindow.location =”$PHP_SELF”; “; 方法三:echo ““; ?> 获取访问者浏览器 function browse_infor() { $browser="";$browserver=""; $Browsers =array("Lynx","MOSAIC","AOL","Opera","JAVA","MacWeb","WebExplorer","OmniWeb"); $Agent = $GLOBALS["HTTP_USER_AGENT"]; for ($i=0; $i<=7; $i++) //开源OSPhP.COM.CN { if (strpos($Agent,$Browsers[$i])) { $browser = $Browsers[$i]; $browserver =””; } } if (ereg(“Mozilla”,$Agent) && !ereg(“MSIE”,$Agent)) //OSPHP.COm.CN { $temp =explode(“(“, $Agent); $Part=$temp[0]; $temp =explode(“/”, $Part); $browserver=$temp[1]; $temp =explode(” “,$browserver); $browserver=$temp[0]; $browserver =preg_replace(“/([d.]+)/”,”1″,$browserver); $browserver = ” $browserver”; //开源代码OSPhP.COm.CN $browser = “Netscape Navigator”; } if (ereg(“Mozilla”,$Agent) && ereg(“Opera”,$Agent)) { $temp =explode(“(“, $Agent); $Part=$temp[1]; $temp =explode(“)”, $Part); $browserver=$temp[1]; $temp =explode(” “,$browserver);$browserver=$temp[2]; $browserver =preg_replace(“/([d.]+)/”,”1″,$browserver); $browserver = ” $browserver”; $browser = “Opera”; } if (ereg(“Mozilla”,$Agent) && ereg(“MSIE”,$Agent)) { $temp = explode(“(“, $Agent); $Part=$temp[1]; $temp = explode(“;”,$Part); $Part=$temp[1]; $temp = explode(” “,$Part);$browserver=$temp[2]; $browserver =preg_replace(“/([d.]+)/”,”1″,$browserver); $browserver = ” $browserver”; $browser = “Internet Explorer”; } if ($browser!=””) { $browseinfo = “$browser$browserver”; } else { $browseinfo = “Unknown”; } return $browseinfo; } //调用方法$browser=browseinfo() ;直接返回结果 ?> //oS 获取访问者操作系统 function osinfo() { $os=""; $Agent = $GLOBALS["HTTP_USER_AGENT"]; if (eregi('win',$Agent) && strpos($Agent, '95')) { //OsPHP.COM.CN $os=”Windows 95″; } elseif (eregi(‘win 9x’,$Agent) && strpos($Agent, ‘4.90’)) { $os=”Windows ME”; } elseif (eregi(‘win’,$Agent) && ereg(’98’,$Agent)) { $os=”Windows 98″; } elseif (eregi(‘win’,$Agent) && eregi(‘nt 5.0’,$Agent)) { $os=”Windows 2000″; } elseif (eregi(‘win’,$Agent) && eregi(‘nt’,$Agent)) { //oSPHP.COM.CN $os=”Windows NT”; } elseif (eregi(‘win’,$Agent) && eregi(‘nt 5.1’,$Agent)) { $os=”Windows XP”; } elseif (eregi(‘win’,$Agent) && ereg(’32’,$Agent)) { $os=”Windows 32″; } elseif (eregi(‘linux’,$Agent)) { $os=”Linux”; } elseif (eregi(‘unix’,$Agent)) { $os=”Unix”; } elseif (eregi(‘sun’,$Agent) && eregi(‘os’,$Agent)) { $os=”SunOS”; } elseif (eregi(‘ibm’,$Agent) && eregi(‘os’,$Agent)) { //OSPHP.COm.CN $os=”IBM OS/2″; } elseif (eregi(‘Mac’,$Agent) && eregi(‘PC’,$Agent)) { $os=”Macintosh”; } elseif (eregi(‘PowerPC’,$Agent)) { //开源OSPhP.COM.CN $os=”PowerPC”; } elseif (eregi(‘AIX’,$Agent)) { $os=”AIX”; } elseif (eregi(‘HPUX’,$Agent)) { $os=”HPUX”; } elseif (eregi(‘NetBSD’,$Agent)) { $os=”NetBSD”; } elseif (eregi(‘BSD’,$Agent)) { $os=”BSD”; } elseif (ereg(‘OSF1’,$Agent)) { //PHP开源代码 $os=”OSF1″; } elseif (ereg(‘IRIX’,$Agent)) { $os=”IRIX”; } elseif (eregi(‘FreeBSD’,$Agent)) { $os=”FreeBSD”; } if ($os==”) $os = “Unknown”; return $os; } //调用方法$os=os_infor() ; ?> 文件格式类 $mime_types = array( 'gif' => ‘image/gif’, ‘jpg’ => ‘image/jpeg’, ‘jpeg’ => ‘image/jpeg’, ‘jpe’ => ‘image/jpeg’, ‘bmp’ => ‘image/bmp’, ‘png’ => ‘image/png’, ‘tif’ => ‘image/tiff’, ‘tiff’ => ‘image/tiff’, ‘pict’ => ‘image/x-pict’, ‘pic’ => ‘image/x-pict’, ‘pct’ => ‘image/x-pict’, ‘tif’ => ‘image/tiff’, ‘tiff’ => ‘image/tiff’, ‘psd’ => ‘image/x-photoshop’, ‘swf’ => ‘application/x-shockwave-flash’, ‘js’ => ‘application/x-javascrīpt’, ‘pdf’ => ‘application/pdf’, ‘ps’ => ‘application/postscrīpt’, ‘eps’ => ‘application/postscrīpt’, ‘ai’ => ‘application/postscrīpt’, ‘wmf’ => ‘application/x-msmetafile’, ‘css’ => ‘text/css’, ‘htm’ => ‘text/html’, ‘html’ => ‘text/html’, ‘txt’ => ‘text/plain’, ‘xml’ => ‘text/xml’, ‘wml’ => ‘text/wml’, ‘wbmp’ => ‘image/vnd.wap.wbmp’, ‘mid’ => ‘audio/midi’, ‘wav’ => ‘audio/wav’, ‘mp3’ => ‘audio/mpeg’, ‘mp2’ => ‘audio/mpeg’, ‘avi’ => ‘video/x-msvideo’, ‘mpeg’ => ‘video/mpeg’, ‘mpg’ => ‘video/mpeg’, ‘qt’ => ‘video/quicktime’, ‘mov’ => ‘video/quicktime’, ‘lha’ => ‘application/x-lha’, ‘lzh’ => ‘application/x-lha’, ‘z’ => ‘application/x-compress’, ‘gtar’ => ‘application/x-gtar’, ‘gz’ => ‘application/x-gzip’, ‘gzip’ => ‘application/x-gzip’, ‘tgz’ => ‘application/x-gzip’, ‘tar’ => ‘application/x-tar’, ‘bz2’ => ‘application/bzip2’, ‘zip’ => ‘application/zip’, ‘arj’ => ‘application/x-arj’, ‘rar’ => ‘application/x-rar-compressed’, ‘hqx’ => ‘application/mac-binhex40’, ‘sit’ => ‘application/x-stuffit’, ‘bin’ => ‘application/x-macbinary’, ‘uu’ => ‘text/x-uuencode’, ‘uue’ => ‘text/x-uuencode’, ‘latex’=> ‘application/x-latex’, //开源OSPhP.COM.CN ‘ltx’ => ‘application/x-latex’, ‘tcl’ => ‘application/x-tcl’, ‘pgp’ => ‘application/pgp’, ‘asc’ => ‘application/pgp’, ‘exe’ => ‘application/x-msdownload’, ‘doc’ => ‘application/msword’, ‘rtf’ => ‘application/rtf’, ‘xls’ => ‘application/vnd.ms-excel’, ‘ppt’ => ‘application/vnd.ms-powerpoint’, ‘mdb’ => ‘application/x-msaccess’, ‘wri’ => ‘application/x-mswrite’, ); ?> php生成excel文档 header("Content-type:application/vnd.ms-excel"); header("Content-Disposition:filename=test.xls"); echo "test1t"; echo "test2tn"; echo "test1t"; echo "test2tn"; echo "test1t"; //开源OSPhP.COM.CN echo “test2tn”; echo “test1t”; echo “test2tn”; echo “test1t”; echo “test2tn”; echo “test1t”; echo “test2tn”; //改动相应文件头就可以输出.doc .xls等文件格式了 ?> 时间比较问题 举一个简单例子说明:比如一个论坛对当天发表的贴子用new图片标记一下。 方法一: //$db->rows[$i][date]中为数据库中datetime字段值. $today=time(); $theDay=date(“Y-m-d H:i:s”,$today-24*3600); $newTag=$db->rows[$i][date]>=$theDay?”“:””; //方法二: $newTag=$db->rows[$i][date]>=date(“Y-m-d 00:00:00″)?”“:””; ?> /提取页面和浏览器提交的变量,作用相当于使PHP.INI开了全局变量 //OSPHP.com.CN @extract($_SERVER, EXTR_SKIP); @extract($_SESSION, EXTR_SKIP); @extract($_POST, EXTR_SKIP); @extract($_FILES, EXTR_SKIP); @extract($_GET, EXTR_SKIP); @extract($_ENV, EXTR_SKIP); ?> //读取文件函数 function readfromfile($file_name) { if (file_exists($file_name)) { $filenum=fopen($file_name,"r"); flock($filenum,LOCK_EX); $file_data=fread($filenum, filesize($file_name)); rewind($filenum); fclose($filenum); return $file_data; } } ?> //写入文件函数 function writetofile($file_name,$data,$method="w") { $filenum=fopen($file_name,$method); flock($filenum,LOCK_EX); $file_data=fwrite($filenum,$data); fclose($filenum); return $file_data; } ?> //页面快速转向 function turntopage($url="index.php",$info = "页面转向中...",$second=2){ print "n页面转向中…. n”; print “n”; print “ n”; print “nn”; print “n”; print ”
n”; print “n“; exit; ?> 产生随机字符串函数 function random($length) { $hash = @#@#; $chars = @#ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789abcdefghijklmnopqrstuvwxyz@#; $max = strlen($chars) - 1; mt_srand((double)microtime() * 1000000); for($i = 0; $i < $length; $i++) { $hash .= $chars[mt_rand(0, $max)]; } return $hash; } ?> 截取一定长度的字符串(该函数对GB2312使用有效) function Wordscut($string, $length ,$sss=0) { if(strlen($string) > $length) { if($sss){ $length=$length – 3; $addstr=@# …@#; //OsPHP.COM.CN } for($i = 0; $i < $length; $i++) { if(ord($string[$i]) > 127) { $wordscut .= $string[$i].$string[$i + 1]; //oSPHP.COM.CN $i++; } else { $wordscut .= $string[$i]; } } return $wordscut.$addstr; } return $string; } ?> 取得客户端IP地址 function GetIP(){ if (getenv("HTTP_CLIENT_IP") && strcasecmp(getenv("HTTP_CLIENT_IP"), "unknown")) $ip = getenv("HTTP_CLIENT_IP"); else if (getenv("HTTP_X_FORWARDED_FOR") && strcasecmp(getenv("HTTP_X_FORWARDED_FOR"), "unknown")) $ip = getenv("HTTP_X_FORWARDED_FOR"); else if (getenv("REMOTE_ADDR") && strcasecmp(getenv("REMOTE_ADDR"), "unknown")) $ip = getenv("REMOTE_ADDR"); else if (isset($_SERVER[@#REMOTE_ADDR@#]) && $_SERVER[@#REMOTE_ADDR@#] && strcasecmp($_SERVER[@#REMOTE_ADDR@#], "unknown")) $ip = $_SERVER[@#REMOTE_ADDR@#]; else $ip = "unknown"; return($ip); } ?> 判断邮箱地址 function checkEmail($inAddress) { return (ereg("^([a-zA-Z0-9_-])+@([a-zA-Z0-9_-])+(.[a-zA-Z0-9_-])+",$inAddress)); } ?> 分页(两个函数配合使用) function getpage($sql,$page_size=20) { global $page,$totalpage,$sums; //out param $page = $_GET["page"]; //$eachpage = $page_size; $pagesql = strstr($sql," from "); //OSPHP.COm.CN $pagesql = “select count(*) as ids “.$pagesql; $result = mysql_query($pagesql); if($rs = mysql_fetch_array($result)) $sums = $rs[0]; $totalpage = ceil($sums/$page_size); if((!$page)($page<1)) $page=1; $startpos = ($page-1)*$page_size; $sql .=" limit $startpos,$page_size "; return $sql; } function showbar($string="") { global $page,$totalpage; $out="共“.$totalpage.”页 “; //开源代码OSPHP.COM.Cn $linkNum =4; $start = ($page-round($linkNum/2))>0 ? ($page-round($linkNum/2)) : “1”; //oSPHP.COM.CN $end = ($page+round($linkNum/2))<$totalpage ? ($page+round($linkNum/2)) : $totalpage; $prestart=$start-1; $nextend=$end+1; if($page<>1) $out .= “第一页 “; if($start>1) //OSPHP.COm.CN $out.=”..<< “; for($t=$start;$t<=$end;$t++) { $out .= ($page==$t) ? "[“.$t.”] ” : “$t “; //OSPHP.COM.Cn开源 } if($end<$totalpage) $out.=">>..“; if($page<>$totalpage) $out .= ” 最后页“; //开源OSPhP.COM.CN return $out; } ?> //获得当前的脚本网址 function get_php_url(){ if(!empty($_server["REQUEST_URI"])){ $scriptName = $_SERVER["REQUEST_URI"]; $nowurl = $scriptName; }else{ $scriptName = $_SERVER["PHP_SELF"]; //OSPHP.COM.Cn开源 if(empty($_SERVER[“QUERY_STRING”])) $nowurl = $scriptName; else $nowurl = $scriptName.”?”.$_SERVER[“QUERY_STRING”]; } return $nowurl; } ?> /把全角数字转为半角数字 function GetAlabNum($fnum){ $nums = array("0","1","2","3","4","5","6","7","8","9"); $fnums = "0123456789"; for($i=0;$i<=9;$i++) $fnum = str_replace($nums[$i],$fnums[$i],$fnum); $fnum = ereg_replace("[^0-9.]|^0{1,}","",$fnum); if($fnum=="") $fnum=0; return $fnum; } ?> //去除HTML标记 function Text2Html($txt){ $txt = str_replace(" "," ",$txt); $txt = str_replace("<","<",$txt); $txt = str_replace(">“,”>”,$txt); $txt = preg_replace(“/[rn]{1,}/isU”,” rn”,$txt); return $txt; } ?> /相对路径转化成绝对路径 function relative_to_absolute($content, $feed_url) { preg_match('/(http|https|ftp):///', $feed_url, $protocol); $server_url = preg_replace("/(http|https|ftp|news):///", "", $feed_url); $server_url = preg_replace("//.*/", "", $server_url); if ($server_url == '') { return $content; } if (isset($protocol[0])) { $new_content = preg_replace('/href="//', 'href="'.$protocol[0].$server_url.'/', $content); $new_content = preg_replace('/src="//', 'src="'.$protocol[0].$server_url.'/', $new_content); } else { $new_content = $content; } return $new_content; } ?> //取得所有链接 function get_all_url($code){ preg_match_all('/n”; print ” n”; print ”n”; print ” n”; print ”n”; print ” n”; print ”n”; //OSPHP.COm.CN print ”
n”; print ” n”; print ”页面转向提示信息 n”; print ”n”; print ” n”; print ”$info n”; print ”n”; print ” n”; print ” n”; print ”n”; print ” 如果你的浏览器不支持自动跳转,请按这里 n”; print ”n”; print ” n”; print ““‘ ]+)[“|’]?s*[^>]*>([^>]+)/i’,$code,$arr); return array(‘name’=>$arr[2],’url’=>$arr[1]); } ?> //HTML表格的每行转为CSV格式数组 function get_tr_array($table) { $table = preg_replace("' ]*?>’si”,'”‘,$table); $table = str_replace(“ “,'”,’,$table); $table = str_replace(“ “,”{tr}”,$table); //去掉 HTML 标记 $table = preg_replace(“‘<[/!]*?[^<>]*?>’si”,””,$table); //去掉空白字符 $table = preg_replace(“‘([rn])[s]+'”,””,$table); $table = str_replace(” “,””,$table); $table = str_replace(” “,””,$table); $table = explode(“,{tr}”,$table); array_pop($table); return $table; } ?> //将HTML表格的每行每列转为数组,采集表格数据 function get_td_array($table) { $table = preg_replace("']*?>’si”,””,$table); $table = preg_replace(“‘
]*?>’si”,””,$table); $table = preg_replace(“‘ “,”{tr}”,$table); //PHP开源代码 $table = str_replace(“ “,”{td}”,$table); //去掉 HTML 标记 $table = preg_replace(“‘<[/!]*?[^<>]*?>’si”,””,$table); //去掉空白字符 $table = preg_replace(“‘([rn])[s]+'”,””,$table); $table = str_replace(” “,””,$table); $table = str_replace(” “,””,$table); $table = explode(‘{tr}’, $table); array_pop($table); //OSPHP.COM.Cn开源 foreach ($table as $key=>$tr) { $td = explode(‘{td}’, $tr); array_pop($td); $td_array[] = $td; } return $td_array; } ?> //返回字符串中的所有单词 $distinct=true 去除重复 function split_en_str($str,$distinct=true) { preg_match_all('/([a-zA-Z]+)/',$str,$match); if ($distinct == true) { $match[1] = array_unique($match[1]); } sort($match[1]); //oSPHP.COM.CN return $match[1]; } ?> ZT:http://www.osphp.com.cn/read.php?entryid=323&page=1&part=3]]>]*?>’si”,””,$table); $table = str_replace(“ -
PHP使用JMail发送邮件
silent = true; //屏蔽例外错误 $jmail->charset = ‘gb2312’; //否则中文会乱码 $jmail->From = ‘web535000@163.com’; //这里理论上是可以不与发件人地址相同的,但用163的试了几次都不行,改成一样的就可以了 $jmail->FromName = ‘BoboTest’; $jmail->AddRecipient(‘abc1@1 ...
-
php连接mssql的故障问题mssql_connect() [function.mssql-connect]: message: 登录失败。 (severity 14)
不能连接mssql 报错:mssql_connect() [function.mssql-connect]: message: 登录失败。 (severity 14)php.inimssql.secure_connection = Off改成这个即可,然后重启服务器。windows+php 每次修改php.ini都需要重启机器才能生效。。。。没linux好,太烂了。
-
PHP 连接SQL Server2005 失败,Fatal error: Call to undefined function mssql_connect() in
Loaded Configuration File D:\wamp\Apache2\bin\php.ini 注意:加载的是D:\wamp\Apache2\bin\php.ini ,所以修改;extension=php_mssql.dll 不要搞错。 三、打开 D:\wamp\Apache2\bin\php.ini ,设置两个地方:即去掉;extension=php_mssql.dll前的”;”,再设置mssql.secure_connec ...
-