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)

?>

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

友情链接：喷水织机