替换函数:
str_replace("world","Shanghai",$all);
str_replace( old, new, all );
=============================================
取整数:(全部转成数字)
intval("196")
===============================================
遍历数组:
$arr = array(1, 2, 3, 4);
foreach ($arr as &$value) {
$value = $value * 2;
}
========================================
表单提交 多name获取:
$pro_id=$_POST["proid"];
$str=implode(",",$pro_id); // 串合 各数组元素,组成字符串
使用:
$postArray = explode(",",$str);
foreach ($postArray as $value)
<form name="form" action="test.php" method="post">
<input type="text" value="1" name="proid[0]">
<input type="text" value="3" name="proid[1]">
</form>
==========================================
调用外部变量:
global $conn;
==========================================
跳转
header("Location: /index.php");
============================================================
修改数据:
//insert into liuyan(bt,nr) values('$bt','$nr')
$query="update Qianbo_Members set RealName = '".$RealName."', Sex='".$Sex."' where MemName like '".$_SESSION["MemName"]."'";
$conn->Execute($query);
====================================
session:
//启用
session_start();
//创建
$_SESSION["views"]=1;
//获取
$_SESSION["views"];
释放
unset($_SESSION['views']);
完全终结
session_destroy();
===========================================
是否包含字符串(字符位置):
strpos("You","y");
存在:>=0
不存在:== false
位置从 0 开始
======================================
数组:(从0开始,和 asp 一样)
$cars=array();
$cars=array("Volvo","BMW","SAAB");
$cars[0]="Volvo";
=========================================
cookies:
创建
setcookie("Name", "HGC", time()+3600);
获取
$_COOKIE["Name"]
删除
setcookie("Name", "", time()-3600);
=======================================
分割:
explode("|",$str)
=====================================
$rs = @new COM("ADODB.RecordSet");
$sql_access="select * from Qianbo_About where ViewFlag and id=3";
$rs->Open($sql_access,$conn,1,1);
if(!$rs->eof)
{
$contact = $rs->Fields["Content"]->Value;
}
$rs->close();
=======================================
解决 未定义 问题:(在页面的第一行放置)
error_reporting(0);
=========================================
过滤html,js,sql:addslashes(sprintf("%s",$str))
===================================================================================
防sql注入:
1、使用PDO:
$pdo = new PDO('mysql:dbname=dbtest;host=127.0.0.1;charset=utf8', 'user', 'pass');
$stmt = $pdo->prepare('SELECT * FROM employees WHERE name = :name');
$stmt->execute(array(':name' => $name));
foreach ($stmt as $row) {
// do something with $row
}
2、使用mysqli:(sql注入(?占位),后期传的值不会当成sql语句)
<?php
$mysqli=new mysqli("localhost","root","","xsphpdb");
//$stmt=$mysqli->stmt_init();
//$sql="insert into shops(name,price,num,desn) values('aa','12.3','199,'hello')";
$sql="insert into shops(name,price,num,desn) values(?,?,?,?)";
$stmt=$mysqli->prepare($sql);
$stmt->bind_param("sdis",$name,$price,$num,$desn);
/*
bind_param函数指定类型:
i - integer(整型)
d - double(双精度浮点型)
s - string(字符串)
b - BLOB(布尔值)
*/
$name="zhangsan";
$price="43";
$num="33";
$desn="hello good";
$stmt->execute();
$stmt->close();
?>
===================================================
创建数组:array();
==========================================================
5、头部空格问题:( 去掉unicode[BOM] )
修改->页面属性->编码->不勾选unicode
str_replace("world","Shanghai",$all);
str_replace( old, new, all );
=============================================
取整数:(全部转成数字)
intval("196")
===============================================
遍历数组:
$arr = array(1, 2, 3, 4);
foreach ($arr as &$value) {
$value = $value * 2;
}
========================================
表单提交 多name获取:
$pro_id=$_POST["proid"];
$str=implode(",",$pro_id); // 串合 各数组元素,组成字符串
使用:
$postArray = explode(",",$str);
foreach ($postArray as $value)
<form name="form" action="test.php" method="post">
<input type="text" value="1" name="proid[0]">
<input type="text" value="3" name="proid[1]">
</form>
==========================================
调用外部变量:
global $conn;
==========================================
跳转
header("Location: /index.php");
============================================================
修改数据:
//insert into liuyan(bt,nr) values('$bt','$nr')
$query="update Qianbo_Members set RealName = '".$RealName."', Sex='".$Sex."' where MemName like '".$_SESSION["MemName"]."'";
$conn->Execute($query);
====================================
session:
//启用
session_start();
//创建
$_SESSION["views"]=1;
//获取
$_SESSION["views"];
释放
unset($_SESSION['views']);
完全终结
session_destroy();
===========================================
是否包含字符串(字符位置):
strpos("You","y");
存在:>=0
不存在:== false
位置从 0 开始
======================================
数组:(从0开始,和 asp 一样)
$cars=array();
$cars=array("Volvo","BMW","SAAB");
$cars[0]="Volvo";
=========================================
cookies:
创建
setcookie("Name", "HGC", time()+3600);
获取
$_COOKIE["Name"]
删除
setcookie("Name", "", time()-3600);
=======================================
分割:
explode("|",$str)
=====================================
$rs = @new COM("ADODB.RecordSet");
$sql_access="select * from Qianbo_About where ViewFlag and id=3";
$rs->Open($sql_access,$conn,1,1);
if(!$rs->eof)
{
$contact = $rs->Fields["Content"]->Value;
}
$rs->close();
=======================================
解决 未定义 问题:(在页面的第一行放置)
error_reporting(0);
=========================================
过滤html,js,sql:addslashes(sprintf("%s",$str))
===================================================================================
防sql注入:
1、使用PDO:
$pdo = new PDO('mysql:dbname=dbtest;host=127.0.0.1;charset=utf8', 'user', 'pass');
$stmt = $pdo->prepare('SELECT * FROM employees WHERE name = :name');
$stmt->execute(array(':name' => $name));
foreach ($stmt as $row) {
// do something with $row
}
2、使用mysqli:(sql注入(?占位),后期传的值不会当成sql语句)
<?php
$mysqli=new mysqli("localhost","root","","xsphpdb");
//$stmt=$mysqli->stmt_init();
//$sql="insert into shops(name,price,num,desn) values('aa','12.3','199,'hello')";
$sql="insert into shops(name,price,num,desn) values(?,?,?,?)";
$stmt=$mysqli->prepare($sql);
$stmt->bind_param("sdis",$name,$price,$num,$desn);
/*
bind_param函数指定类型:
i - integer(整型)
d - double(双精度浮点型)
s - string(字符串)
b - BLOB(布尔值)
*/
$name="zhangsan";
$price="43";
$num="33";
$desn="hello good";
$stmt->execute();
$stmt->close();
?>
===================================================
创建数组:array();
==========================================================
5、头部空格问题:( 去掉unicode[BOM] )
修改->页面属性->编码->不勾选unicode