mysql od函数_常用函数 - Just Code - ITeye博客

超、凢脫俗 2022-10-31 04:02 6阅读 0赞

代码：

/\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*

\* Filename : function file 2.0 \*

\* Address: New York \*

\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*/

// 防注入

function inject($str) \{

if(!empty($str))\{

$pour=eregi('select|insert|update|delete|\\'|\\/\\\*|\\\*|\\.\\.\\/|\\.\\/||\\"|union|into|load\_file|outfile', $str);

if($pour)\{

exit("");

\}else\{ return $str; \}

\}else\{

exit("");

// 返回正整数

function isint($str)\{

if(!empty($str))\{

$pour=preg\_match("/^\[0-9\]\*\[1-9\]\[0-9\]\*$/",$str);

if($pour)\{ return $str; \}else\{ exit(""); \}

\}else\{

exit("");

// 截取字段

function all\_substr($str, $start, $length)\{

$pa="/\[\\x01-\\x7f\]|\[\\xc2-\\xdf\]\[\\x80-\\xbf\]|\\xe0\[\\xa0-\\xbf\]\[\\x80-\\xbf\]|\[\\xe1-\\xef\]\[\\x80-\\xbf\]\[\\x80-\\xbf\]|";

$pa.="\\xf0\[\\x90-\\xbf\]\[\\x80-\\xbf\]\[\\x80-\\xbf\]|\[\\xf1-\\xf7\]\[\\x80-\\xbf\]\[\\x80-\\xbf\]\[\\x80-\\xbf\]/";

preg\_match\_all($pa, $str, $t\_string);

if(count($t\_string\[0\]) - $start > $length)\{

return join('', array\_slice($t\_string\[0\], $start, $length)) . "...";

\}else\{

return join('', array\_slice($t\_string\[0\], $start, $length));

// 检测用户名

function user($str,$tips)\{

if(empty($str))\{

exit("");

\}else\{

$pour=preg\_match("/^\[a-z0-9\]\[a-z0-9\_\]\{3,15\}$/i", $str);

if($pour)\{ return inject($str); \}else\{ exit(""); \}

// 检测是否为空

function is\_empty($str,$tips)\{

if(empty($str))\{

exit("");

\}else\{

return inject($str);

// 验证邮件地址

function isEmail($str)\{

$pour=preg\_match("/^\[\_\\.0-9a-z-\]+@(\[0-9a-z\]\[0-9a-z-\]+\\.)+\[a-z\]\{2,4\}$/i",$str);

if($pour)\{

return $str;

\}else\{

exit("");

// 验证是否为数组

function is\_arr($arr)\{

if(is\_array($arr))\{ return $arr; \}else\{ exit(""); \}

// 返回图片

function html\_img($path,$add = '',$alt = '',$title = '')\{

if(!empty($alt))\{ $alt = "alt=\\"".$alt."\\""; \} if(!empty($title))\{ $title = "title=\\"".$title."\\""; \}

return "![%5C%22%22.%24path.%22%5C%22][5C_22_22._24path._22_5C_22]";

// 返回链接

function html\_link($path,$title,$add = '',$target = '')\{

if(!empty($target))\{ $target = "target=\\"".$target."\\""; \}

return "".$title."";

// 返回地址

function gotoUrl($url='',$tips='')\{

if(empty($url) && empty($tips))\{

exit("");

\}elseif(!empty($url) && empty($tips))\{

exit("");

\}elseif(empty($url) && !empty($tips))\{

exit("");

\}else\{

exit("");

// 验证url地址

function url($str)\{

return (preg\_match("/^http:\\/\\/\[A-Za-z0-9\]+\\.\[A-Za-z0-9\]+\[\\/=\\?%\\-&\_~\`@\[\\\]\\':+!\]\*(\[^<>\\"\\"\])\*$/",$str))?true:"URL format error!";

// 获取html中图片的地址

function getImg($str)\{

$str = stripslashes($str);

$pattern = "/\]\*src\\=\\"((\[^>\]\*)(jpg|gif|png|bmp|jpeg))\\"/"; //获取所有图片标签的全部信息

preg\_match\_all($pattern, $str, $matches);

return $matches\[1\]; //$matches\[1\]中就是所想匹配的结果,结果为数组

// 非法字符

function isvalidname($username)\{

$badkey = array("\\\\", '|', ' ', ' ', "'", '"', '/', '\*', ',', '~', ';', '

'>', '$', "\\r", "\\t", "\\n",'\#','\*','?',':','@','!','(',')','~','\`','^','&');

foreach ($badkey as $value)\{

if (strpos($username, $value) !== false)\{

return false;

exit;

return true;

// 去除html标签

function isbare($str)\{

return strip\_tags($str);

// 在指定的预定义字符前添加反斜杠

function addline($str)\{

return addslashes($str);

// 去除预定义字符前添加反斜杠

function delline($str)\{

return stripslashes($str);

// 截取字段

function firstPath($str,$end)\{

return substr( $str,0,strpos( $str, $end)) ;

function lastPath($str,$end)\{

return substr( $str,strrpos($str, $end)) ;

// 返回路径中的文件名部分

function urlName($path,$suffix)\{

if(empty($suffix))\{

return basename($path); //显示带有文件扩展名的文件名

\}else\{

return basename($path,$suffix); //显示不带有文件扩展名的文件名

// GD库是否开启

function gd()\{

if(extension\_loaded('gd')) \{

if(function\_exists('gd\_info')) \{

echo '

'; print_r(gd_info()); echo '

'; exit;

\}else\{

exit('OOOOPS, this GD Version is so low !');

\}else

exit(' We can not find GD !');

// 返回图片信息

function myimg($img,$btn = 0)\{

$getinfor = @getimagesize($img);

if($btn == 1)\{

return $arr = array($getinfor\[0\],$getinfor\[1\]);

\}elseif($btn == 2)\{

switch($getinfor\[2\])\{

case 1: return 'gif'; break;

case 2: return 'jpg'; break;

case 3: return 'png'; break;

case 6: return 'bmp'; break;

\}else\{

echo '

'; print_r($getinfor); echo '

'; exit;

// 打印函数

function printer($arr,$add = 1)\{

echo '

'; if($add !=1 ){ var_dump($arr); }else{ print_r($arr); } echo '

'; exit;

//返回结果为1只有数字,2只有字符,3两者都有

function checkVS($str)\{

$a=0; $b=0;

for($i=0;$i

$v=ord(substr($str,$i,1));

if($v>=48 and $v<=57)\{

$a=1;

\}else\{

$b=2;

return $a+$b;

// 返回数组中最大值

function maxi($arr)\{

sort($arr);

return $arr\[count($arr)-1\];

/\*\*\*\*\*

\*@dir - Directory to destroy

\*@virtual\[optional\]- whether a virtual directory

\*/

function destroyDir($dir, $virtual = false)

$ds = DIRECTORY\_SEPARATOR;

$dir = $virtual ? realpath($dir) : $dir;

$dir = substr($dir, -1) == $ds ? substr($dir, 0, -1) : $dir;

if (is\_dir($dir) && $handle = opendir($dir))

while ($file = readdir($handle))

if ($file == '.' || $file == '..')

continue;

elseif (is\_dir($dir.$ds.$file))

destroyDir($dir.$ds.$file);

else

unlink($dir.$ds.$file);

closedir($handle);

rmdir($dir);

return true;

else

return false;

// 列出目录内容 $dir 不要加 '/'

function list\_files($dir)

if(is\_dir($dir))

if($handle = opendir($dir))

while(($file = readdir($handle)) !== false)

if($file != "." && $file != ".." && $file != "Thumbs.db")

echo '

closedir($handle);

// 删除指定文件

function delFile($path)\{

if(is\_file($path))\{

@unlink($path);

// 移动(目录要存在)或者修改名字

function moveFile($oldName,$newName)\{

@rename($oldName,$newName);

// 创建相应的文件夹

function createdir($dir='')\{

if (!is\_dir($dir))\{

$temp = explode('/',$dir);

$cur\_dir = '';

for($i=0;$i

$cur\_dir .= $temp\[$i\].'/';

if (!is\_dir($cur\_dir))\{

@mkdir($cur\_dir,0777);

// 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 flyTo($title='',$message='',$url='')\{

$html ="

if(!empty($url))\{

$html .="";

//$html .="

$html .="

$html .="\*\{font-family:Arial, Helvetica, sans-serif; font-size:13px;\} table\{border-collapse:collapse;\} .m\_title\{background:\#DADAFF;\} .line\_1\{background:\#FFFAF6;\}";

$html .="

".$title."";

$html .="

$html .="  
".$message."  
";

$html .="The system will return in 3 seconds.  
If your browser does not automatically return,  
please click \[

Here \] Enter .";

//$html .="  
\[ Back \]";

$html .="

$html .="";

echo $html;

exit;

/\*

include("function.php");

$total=mysql\_num\_rows($result);

pageft($total,10);

$result=mysql\_query("select \* from wp\_shoutlugmap order by id desc limit $firstcount,$displaypg");

while($row=mysql\_fetch\_array($result))\{

// display something

echo $pagenav;

\*/

function pageft($totle,$displaypg=20,$url='')\{

global $page,$firstcount,$pagenav,$\_SERVER;

$GLOBALS\["displaypg"\]=$displaypg;

if(!$page)\{$page=1;\}

if(!$url)\{$url=$\_SERVER\["REQUEST\_URI"\];\}

$parse\_url=parse\_url($url);

$url\_query=$parse\_url\["query"\];

if($url\_query)\{

$url\_query=ereg\_replace("(^|&)page=$page","",$url\_query);

$url=str\_replace($parse\_url\["query"\],$url\_query,$url);

if($url\_query)\{$url.="&page";\}else\{$url.="page";\}

\}else \{

$url.="?page";

$lastpg=ceil($totle/$displaypg);

$page=min($lastpg,$page);

$prepg=$page-1;

$nextpg=($page==$lastpg ? 0 : $page+1);

$firstcount=($page-1)\*$displaypg;

$pagenav="显示第 **".($totle?($firstcount+1):0)."**\-**".min($firstcount+$displaypg,$totle)."** 条记录，共 $totle 条记录  
";

if($lastpg<=1)\{return false;\}

$pagenav.=" 首页 ";

if($prepg)\{$pagenav.=" 前页 ";\}else\{$pagenav.=" 前页 ";\}

if($nextpg)\{$pagenav.=" 后页 ";\}else\{$pagenav.=" 后页 ";\}

$pagenav.=" 尾页 ";

$pagenav.="　到第 \\n";

for($i=1;$i<=$lastpg;$i++)\{

if($i==$page)\{

$pagenav.="$i\\n";

\}else\{

$pagenav.="$i\\n";

$pagenav.=" 页，共 $lastpg 页";

// 产生随机字符串函数

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;

// 获得文件后缀

function extend($file\_name)\{

$extend = pathinfo($file\_name);

$extend = strtolower($extend\["extension"\]);

return $extend;

// 该函数将 URL 和 E-mail 地址字符串转换为可点击的超级链接。

function makeLinks($text) \{

$text = eregi\_replace('(((f|ht)\{1\}tp://)\[-a-zA-Z0-9@:%\_+.~\#?&//=\]+)','\\1', $text);

$text = eregi\_replace('(\[\[:space:\]()\[\{\}\])(www.\[-a-zA-Z0-9@:%\_+.~\#?&//=\]+)','\\1\\2', $text);

$text = eregi\_replace('(\[\_.0-9a-z-\]+@(\[0-9a-z\]\[0-9a-z-\]+.)+\[a-z\]\{2,3\})','[\\1][1]', $text);

return $text;

// 随着 WordPress 越来越普及，Gravatar 也随之流行。由于 Gravatar 提供了易于使用的API，将其纳入应用程序也变得十分方便。

/\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*

\*@email - Email address to show gravatar for

\*@size - size of gravatar

\*@default - URL of default gravatar to use

\*@rating - rating of Gravatar(G, PG, R, X)

\*/

function show\_gravatar($email, $size, $default, $rating)

echo '![p><p>'&default='.%24default.'&size='.%24size.'&rating='.%24rating.'][p_p_default_._24default._size_._24size._rating_._24rating.]

height="'.$size.'px" />';

// 创建标签云

function getCloud( $data = array(), $minFontSize = 12, $maxFontSize = 30 )

$minimumCount = min( array\_values( $data ) );

$maximumCount = max( array\_values( $data ) );

$spread = $maximumCount - $minimumCount;

$cloudHTML = '';

$cloudTags = array();

$spread == 0 && $spread = 1;

foreach( $data as $tag => $count )

$size = $minFontSize + ( $count - $minimumCount )

\* ( $maxFontSize - $minFontSize ) / $spread;

$cloudTags\[\] = ''

. htmlspecialchars( stripslashes( $tag ) ) . '';

return join( "\\n", $cloudTags ) . "\\n";

/\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*

\*\*\*\* Sample usage \*\*\*/

/\*

$arr = Array('Actionscript' => 35, 'Adobe' => 22, 'Array' => 44, 'Background' => 43,

'Blur' => 18, 'Canvas' => 33, 'Class' => 15, 'Color Palette' => 11, 'Crop' => 42,

'Delimiter' => 13, 'Depth' => 34, 'Design' => 8, 'Encode' => 12, 'Encryption' => 30,

'Extract' => 28, 'Filters' => 42);

echo getCloud($arr, 12, 36);

\*/

// 为用户提供强制性的文件下载功能。

/\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*

\*@file - path to file

\* eg: force\_download('10.png');

\*/

function force\_download($file)

if ((isset($file))&&(file\_exists($file))) \{

header("Content-length: ".filesize($file));

header('Content-Type: application/octet-stream');

header('Content-Disposition: attachment; filename="' . $file . '"');

readfile("$file");

\} else \{

echo "No file selected";

// 建用户友好的日志缩略名。

function create\_slug($string)\{

$slug=preg\_replace('/\[^A-Za-z0-9-\]+/', '-', $string);

return $slug;

/\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*

\* $dir\_name = 'message/templates'; //返回哪个目录的总文件数 \*

\* $file\_count = get\_file\_count($dir\_name); \*

\* echo $dir\_name.'目录下文件总数:'.count($file\_count).'  
'; \*

\* print\_r($file\_count); \*

\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*/

function get\_file\_count($dir\_name)\{ //得到目录下的文件函数

global $files; //申明全局变量有于统计

$od = opendir($dir\_name); //打开目录,返回连接号

while ($name = readdir($od))\{ //读取目录

$file\_path = $dir\_name.'/'.$name; //目录 用于使用 is\_file()

if (is\_file($file\_path))\{ //是一个文件

$files\[\] = $file\_path; //添加,用于最后的统计

\}elseif (($name !='.') && ($name !='..'))\{ //输出$name看看就知道

get\_file\_count($file\_path); //递归的调用

return $files; //返回目录下的总文件数

// Function: 获取远程图片并把它保存到本地

// 确定您有把文件写入本地服务器的权限

// 变量说明:

// $url 是远程图片的完整URL地址，不能为空。

// $filename 是可选变量: 如果为空，本地文件名将基于时间和日期

// 自动生成.

function GrabImage($url,$filename='') \{

if($url == '')\{return false;\}

if($filename == '') \{

$ext = strrchr($url,'.');

if($ext != '.gif' && $ext != '.jpg')\{return false;\}

$filename = date('dMYHis').$ext;

ob\_start();

readfile($url);

$img = ob\_get\_contents();

ob\_end\_clean();

$size = strlen($img);

$fp2 = @fopen($filename, 'a');

fwrite($fp2,$img);

fclose($fp2);

return $filename;

/\*

$img = GrabImage('http://dl.iteye.com/upload/picture/pic/55053/2d4fa08f-4e39-3ca2-8087-fc2fd1c836ec.jpg','');

if($img)\{

echo '

\}else\{

echo 'false';

\*/

/\* 计算复活节 echo easter(); 默认为今年 \*/

function easter($year = '')\{

return empty($year) ? date("m-d-Y", easter\_date()) : date("m-d-Y", easter\_date($year));

/\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*

求相对路径

$path\_a = "/mytest/jquery.js";

$path\_b = "/willdo/church/index.php";

echo compara\_path($path\_a, $path\_b);

\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*/

function compara\_path($path\_a, $path\_b) \{

//切割路径.

$array\_a = explode('/', $path\_a);

$array\_b = explode('/', $path\_b);

//从数组中删除最后的文件,剩下的全为文件夹名称.

$file\_a = array\_pop($array\_a);

$file\_b = array\_pop($array\_b);

//子目录个数.

$a\_len = count($array\_a);

$b\_len = count($array\_b);

//循环求出第几个目录不同.

for ( $i = 0; $i < $a\_len; $i++ ) \{

if ($array\_a\[$i\] != $array\_b\[$i\] ) \{

break;

//求出相对路径.

$com\_path = '';

for ( $j = 0; $j < $a\_len - $i; $j++ ) \{

$com\_path .= '../';

for ( $i; $i< $b\_len; $i++ ) \{

$com\_path .= $array\_b\[$i\] . '/';

$com\_path .= $file\_b;

return $com\_path;

分享到：

![18e900b8666ce6f233d25ec02f95ee59.png][]

![72dd548719f0ace4d5f9bca64e1d7715.png][]

2010-01-29 02:04

[5C_22_22._24path._22_5C_22]: 
[1]: mailto:%5C1
[p_p_default_._24default._size_._24size._rating_._24rating.]: http://www.gravatar.com/avatar.php?gravatar_id='.md5%28%24email%29.
[18e900b8666ce6f233d25ec02f95ee59.png]: /images/20221024/4915777544714e0ea33610c57ddd97f0.png
[72dd548719f0ace4d5f9bca64e1d7715.png]: /images/20221024/3abb0d3500ab464ab642d18a01b244c3.png