php mysql 连接字符串_php 字符串及连接数据库基本知识点

$a1="hello";$a2="hell";

echo strlen($a1);

echo strcmp($a1,$a2)."
";

//拆分字符串

$str="hello|nihao|worde|name";

$arr1=explode("|",$str);

echo $arr1[2]."
";

//数组转化为字符串

$arr2=array("11","22","33","44","55");

echo implode($arr2)."&nbsp";

//替换字符串，从某个位置开始替换

$th=substr_replace($a1,"bb",0,2);

echo $th."
";

//替换字符串,原有字符替换成新的

$s = "hello";

$a = str_replace("l","a",$s);

echo $a."
";

//截取字符串

$jq=substr($s,0,3);

echo $jq;

//字符在字符串中的位置

$s1="nihao";

echo strpos($s1,h);

$host="localhost";

$uid="root";

$pwd="root";

$database="info";

$conn=mysql_connect($host,$uid,$pwd);

if($conn==false){echo "连接失败";}else{echo "连接成功";}

mysql_select_db($database,$conn);

mysql_query("create database xuexi,$conn");

$result= mysql_query("select * from DL");

$ss="";

while( $row=mysql_fetch_row($result))

{

$ss=$ss.$row[2]."&nbsp";

}

echo $ss;

//1生成连接对象

$db = new mysqli($host,$uid,$pwd,$database);

//2.判断是否连接成功

if(mysqli_connect_error())

{

echo "连接失败！";

exit; //退出

}

//执行MYSQL语句

$result=$db->query("select * from DL");

$zz="";

//遍历数组中数据，做下拉菜单

while($row = $result->fetch_row()/*获取返回值，返回是数组*/)

{

$zz = $zz."".$row[2]."";

}

$zz."";

echo $zz;