PHP连接MYSQL初学入门需要掌握的东西

<?php

$fuwuqi = "127.0.0.1";         //服务器IP
$yonghuming = "root";          //数据库用户
$mima = "UFJLSD0GEX24TZN6";    //数据库密码
$shujukuming = "4cn";          //数据库名称

$link = mysql_connect($fuwuqi,$yonghuming,$mima);
mysql_select_db($shujukuming,$link) or die ("不存在数据库：".$shujukuming);

//mysql_query("SET NAMES ".yonghuming);

//添加数据

$sql = "insert into admin (username) values ('admin3') ";

mysql_query($sql) or die ("错误".mysql_error());

echo "添加成功";

//关键是查询

$sql = "select * from admin ";
$result = mysql_query($sql) or die ("错误".mysql_error());

$rows=mysql_num_rows($result);

while($total = mysql_fetch_array($result))
{
echo "<a href=\"/".$total[username]."\">".$total[username]."</a> ";
}

echo $_GET["admin"]; //5

echo $_SERVER['HTTP_HOST']; //localhost:8032

echo $_SERVER['QUERY_STRING']; //admin=5&kk=1

$ur = $_SERVER['QUERY_STRING'];

if (strpos($ur,"'") <> "" && strpos($ur,"'") >= 0 )
{
echo "<br>不能存在单引号".strpos($ur,"'");
}
else
{
echo "<br>无双引号".strpos($ur,"'");
}

function CuteStr($str,$num)
{
  if(strlen($str) > $num)
  {
   return substr($str,0,$num);
  }
  else
  {
   return $str;
  }
}
echo CuteStr("阿斯达岁的萨dadsad",10)

======================================================

友情链接：喷水织机