7.13PHP快捷记函数功能

is_array()
检验变量是否为数组
例：is_array($getsqlarr)


mysql_real_escape_string()变转字符
00->5c 30  0x00->\0
0a->5c 6e  换行->\n
0d->5c 72  回车->\r
1a->5c 5a  代替->\Z
22->5c 22  "   ->\"
27->5c 27  '   ->\'
5c->5c 5c  \   ->\\
并不转义%和_


substr(string,start,length)
返回字符串一部分
string,start,length:字符串，开始部分，长度是多少


explode()把字符串打散为数组
<?php
$str = "Hello world. I love Shanghai!";
print_r (explode(" ",$str));
?>  
Array ( [0] => Hello [1] => world. [2] => I [3] => love [4] => Shanghai! )
其中“ ”可以换成其他，比如“&”


mysql_fetch_assoc()函数从结果集中取得一行作为关联数组
<?php
$con = mysql_connect("localhost", "hello", "321");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }


$db_selected = mysql_select_db("test_db",$con);
$sql = "SELECT * from Person WHERE Lastname='Adams'";
$result = mysql_query($sql,$con);
print_r(mysql_fetch_assoc($result));


mysql_close($con);
?>


输出：
Array
(
[LastName] => Adams
[FirstName] => John
[City] => London
) 


urldecode：解码字符串中的%##




$sql = "SELECT * FORM game_select_role_list where `role_id` > 1000 AND `level` > 100";
$result  = mysql_query($sql, $con->link);
*:选择数据库表里面列的名称例可以改为'' ''


今天小任务：
连接数据库读取库game_select_role_list这表格里面的玩家信息
条件：role_id > 1000 and level > 100


<?php
require_once("./header.php");


//连接数据库指定数据库
//$g_global['db']里面包含
$con = $g_global['db']


//读取数据库里面所有玩家信息
$sql = "SELECT * FROM game_select_role_list where 'role_id' > '1000' AND 'leve' >  '100' ";
$result = mysql_query($sql, $con);
$tmp = mysql_fetch_assoc($result);
while($tmp = mysql_fetch_assoc($result)){
dump($tmp);

//对中文名字进行解码
dump(urldecode：$tmp['role_name']);
}
?>