本页文章导读:

    ▪php实例之创建SQLite数据库      例子：   代码示例: <?php /** * 创建sqlite数据库 * by www. */ $db = new PDO('sqlite:/usr/local/zodiac'); $db->beginTransaction(); $q = $db->query("SELECT name FROM sqlite_master WHERE type = 'table' AND name = 'zodiac'");.........

    ▪php实现十进制、三十六进制转换的函数      本文内容： 十进制、三十六进制转换 例子：   代码示例: <?php  /** * 进制转换：十进制、三十六进制转换 * by www. */  $dic = array(      0 => '0', 1 => '1', 2 => '2', 3 => '3', 4 =>.........

    ▪PHP过滤post、get敏感数据的例子      本节内容： 过滤post、get中敏感数据的代码。 例子：   代码示例: <? /** * 批量过滤post,get敏感数据 * by www. */   if (get_magic_quotes_gpc()) {      $_GET = stripslashes()_array($_GET);      $_POS.........

代码示例:

<?php
/**
* 创建sqlite数据库
* by www.
*/
$db = new PDO('sqlite:/usr/local/zodiac');

$db->beginTransaction();
$q = $db->query("SELECT name FROM sqlite_master WHERE type = 'table' AND name = 'zodiac'");

if ($q->fetch() === false) {

    $db->exec(<<<_SQL_
CREATE TABLE zodiac (
  id INT UNSIGNED NOT NULL,
  sign CHAR(11),
  symbol CHAR(13),
  planet CHAR(7),
  element CHAR(5),
  start_month TINYINT,
  start_day TINYINT,
  end_month TINYINT,
  end_day TINYINT,
  PRIMARY KEY(id)
)
_SQL_
);

    $sql=<<<_SQL_
INSERT INTO zodiac VALUES (1,'Aries','Ram','Mars','fire',3,21,4,19);
INSERT INTO zodiac VALUES (2,'Taurus','Bull','Venus','earth',4,20,5,20);
INSERT INTO zodiac VALUES (3,'Gemini','Twins','Mercury','air',5,21,6,21);
_SQL_;

    foreach (explode()("\n",trim($sql)) as $q) {
        $db->exec(trim($q));
    }
    $db->commit();
} else {
    $db->rollback();
}
?>

代码示例:

<?php 
/**
* 进制转换：十进制、三十六进制转换
* by www.
*/ 
$dic = array( 
    0 => '0', 1 => '1', 2 => '2', 3 => '3', 4 => '4', 5 => '5', 6 => '6', 7 => '7', 8 => '8', 9 => '9', 
    10 => 'A', 11 => 'B', 12 => 'C', 13 => 'D', 14 => 'E', 15 => 'F', 16 => 'G', 17 => 'H', 18 => 'I', 
    19 => 'J', 20 => 'K', 21 => 'L', 22 => 'M', 23 => 'N', 24 => 'O', 25 => 'P', 26 => 'Q', 27 => 'R', 
    28 => 'S', 29 => 'T', 30 => 'U', 31 => 'V', 32 => 'W', 33 => 'X', 34 => 'Y', 35 => 'Z' 
    ); 
 
 //十进制转换三十六进制 
function enid($int, $format = 8) { 
    global $dic; 
    $arr = array(); 
    $loop = true; 
    while ($loop)  
    { 
        $arr[] = $dic[bcmod($int, 36)]; 
        $int = floor(bcdiv($int, 36)); 
        if ($int == 0) { 
            $loop = false; 
        } 
    } 
    array_pad($arr, $format, $dic[0]); 
    return implode('', array_reverse($arr)); 
} 
 
//三十六进制转换十进制 
function deid($id) { 
    global $dic; 
    // 键值交换 
    $dedic = array_flip($dic); 
    // 去零 
    $id = ltrim($id, $dic[0]); 
    // 反转 
    $id = strrev($id); 
    $v = 0; 
    for($i = 0, $j = strlen($id); $i < $j; $i++)  
    { 
        $v = bcadd(bcmul($dedic[$id{$i}] , bcpow(36, $i)) , $v); 
    } 
    return $v; 
} 
 
// 遍历三位所有的三十六进制数 
$i = deid('ZZZ'); 
$b = array(); 
while ($i > 0) { 
    $id_dym = str_pad(enid($i), 3, 0, STR_PAD_LEFT); 
    echo strtolower()($id_dym), '<br>'; 
    $i--; 
} 

代码示例:

<?
/**
* 批量过滤post,get敏感数据
* by www.
*/
 
if (get_magic_quotes_gpc()) { 
    $_GET = stripslashes()_array($_GET); 
    $_POST = stripslashes_array($_POST); 
} 
 
function stripslashes_array(&$array) { 
while(list($key,$var) = each($array)) { 
    if ($key != 'argc' && $key != 'argv' && (strtoupper()($key) != $key || ''.intval($key) == "$key")) { 
      if (is_string($var)) { 
         $array[$key] = stripslashes($var); 
} 
if (is_array($var))  { 
     $array[$key] = stripslashes_array($var); 
} 
} 
} 
return $array; 
} 
//--------------------------
// 替换HTML尾标签,为过滤服务 
//-------------------------- 
function lib_replace_end_tag($str) 
{ 
if (empty($str)) return false; 
$str = htmlspecialchars()($str); 
$str = str_replace()( '/', "", $str); 
$str = str_replace("\\", "", $str); 
$str = str_replace(">", "", $str); 
$str = str_replace("<", "", $str); 
$str = str_replace("<SCRIPT>", "", $str); 
$str = str_replace("</SCRIPT>", "", $str); 
$str = str_replace("<script>", "", $str); 
$str = str_replace("</script>", "", $str); 
$str=str_replace("select","select",$str); 
$str=str_replace("join","join",$str); 
$str=str_replace("union","union",$str); 
$str=str_replace("where","where",$str); 
$str=str_replace("insert","insert",$str); 
$str=str_replace("delete","delete",$str); 
$str=str_replace("update","update",$str); 
$str=str_replace("like","like",$str); 
$str=str_replace("drop","drop",$str); 
$str=str_replace("create","create",$str); 
$str=str_replace("modify","modify",$str); 
$str=str_replace("rename","rename",$str); 
$str=str_replace("alter","alter",$str); 
$str=str_replace("cas","cast",$str); 
$str=str_replace("&","&",$str); 
$str=str_replace(">",">",$str); 
$str=str_replace("<","<",$str); 
$str=str_replace(" ",chr(32),$str); 
$str=str_replace(" ",chr(9),$str); 
$str=str_replace("    ",chr(9),$str); 
$str=str_replace("&",chr(34),$str); 
$str=str_replace("'",chr(39),$str); 
$str=str_replace("<br />",chr(13),$str); 
$str=str_replace("''","'",$str); 
$str=str_replace("css","'",$str); 
$str=str_replace("CSS","'",$str); 
 
return $str;
}