PHP的小知识点。

又有一段时间没有弄PHP了，以前的PHP的小知识点。

<?php
 $conn=@mysql_connect("127.0.0.1","root","") or die ("连接事发生错误");
 if ($conn) {
  echo "连接成功! <br/><hr/>";
 }

 mysql_select_db("doie",$conn);
 $sql="select * from admin";
 $SelectResult=mysql_query($sql,$conn);

 while($row=mysql_fetch_array($SelectResult))
 {
  echo "admin_id:$row[admin_id]<br/>";
  echo "AdminUser:$row[admin_username]<br/>";
  echo "admin_password:$row[admin_password]<br/>";
  $leave=$row[admin_leave];
  if($leave==0){
   echo "admin_leave:$row[admin_leave]<br/>";
  }
  else{
   echo "此管理员权限过低！";

  }
  echo "<hr>";
 }

 echo "<hr color=pink size=5>";

 $array= array(45,45,78,84,54);
 print_r($array);

 echo "<hr color=pink size=5>";

 $arr = array("id"=>2,"title"=>56);
 echo $arr[id];
 print_r(2);

 echo "<hr color=pink size=5>";

 $prr= array ("淡定","牛X");
 if(is_array($prr))
 {
  echo "这个是数组";
 }

 echo "<hr color=pink size=5>";

 $a="2004-2-7-6";
 $arrs=explode("-",$a);
 print_r($arrs);
  echo "<br/>arr第0个元素是:";
  echo $arrs[0];
  echo "&nbsp;&nbsp;&nbsp;数组输出连接：";
  echo $arrs[0].$arrs[1].$arrs[2];
  echo "<br/>";
  foreach($prr as $key=>$value){
   echo "ForEach遍历数组：$value<br/>";
  }
 echo "<hr color=pink size=5>";
 $md5=md5("admin");
 echo "Md5加密admin：$md5<br/>";

 echo "<hr color=pink size=5>";
 $date=date("Y-m-d");
 echo "当前时间：$date<br/>";

 echo "<hr color=pink size=5>";

 function UserLogin()
 {
  echo "返回字符串函数：User Login successful!";
 }
 UserLogin();

 echo "<hr color=pink size=5>";

 function User()
 {
  return "无返回值函数：User Login successful!";
 }
 $Result =UserLogin();
 echo $Result;

 echo "<hr color=pink size=5>";
 function Users($a,$b)
 {
  $b=10000;
  $c=$a+$b;
  return $c;
 }
 $Results =Users(878,$b);
 echo "选择性参数函数：A+B=$Results <br/>";

 echo "<hr color=pink size=5>";
?>

 

 

 

SQLCMD：

CREATE TABLE `admin` (
 `admin_id` int NOT NULL AUTO_INCREMENT PRIMARY KEY ,
 `admin_username` varchar( 16 ) NOT NULL ,
 `admin_password` varchar( 16 ) NOT NULL ,
 `admin_leave` int default '0'
);

insert into admin (admin_username,admin_password) values('admin','123456');
insert into admin (admin_username,admin_password,admin_leave) values('admin888','123456',1);
select * from admin;
delete from admin where admin_id=2;