php基础汇总

1.php连接mysql数据库

$db_link = mysql_connect("localhost","root","root","password") or die("connect error:".mysql_error());mysql_select_db("databasename",$db_link);$sql = "select * from table";$result = mysql_query($sql,$db_link);$rows = mysql_fetch_array($result);  // 获取记录$row = mysql_num_rows[$result];        // 得到总行数$id = $rows["id"];

2.php中session的使用

// 在每个开始之前用session_start();$_SESSION["ID"] = "userid";

3.php中cookie的使用

setcookie(name,value,expire,path,domain,secure)

name:cookie名称
value:cookie值
expire:cookie有效期
path:cookie的服务器路径
domain:cookie的域名
secure:规定是否通过安全的HTTPS连接来传输cookie

// 设置了一个TestCookie，值为$value的一个小时后过期的cookie变量setcookie("TestCookie",$value,time()+3600,"/",".example.com");// 清空cookiesetcookie("TestCookie","",time()-2 * 3600,"/",".example.com");

4.php获取页面地址

// 可以得到上一页的地址$_SERVER['HTTP_REFERER'];// 得到当前页面的地址$_SERVER['PHP_SELF'];// 这个可以得到带参数的地址$_SERVER["HTTP_HOST"].$_SERVER["PHP_SELF"]."?".$_SERVER["QUERY_STRING"];

5.php时间

// date函数和mktime可以生成相应的日期：    $today = date("Y-m-d");        // 2007-03-15(格式可以自由定义)    $date = date("Ym");    $year = substr($date,0,4);    $month = substr($date,4,2);    $next_month = date("Y-m-d",mktime(0,0,0,$month+1,1,$year));    $last_month = date("Y-m-d",mktime(0,0,0,$month-1,1,$year));

6.php不显示错误信息

error_reporting(0);

7.php删除确认

<a href="del.php?fm_id=1" onClick="return confirm("确实要删除吗？");">删除</a>

8.javascript中写php

<script language="javascript">function check(){<?phpif($_SESSION["id"]){?>alert('您已登录！');<?php }  else {?>alert('请登陆');<?php } ?>}</script>

9.php上传文件

<form method="post" name="form" action="" enctype="multipart/form-data">    <input name="userfile[]" type="file" />    <input type="submit" value="提交" /></form><?php    $uploaddir = '/upload';    //返回路径中的文件名    $uploadfile = $uploaddir . basename($_FILES['basename']['name']);    // 移动临时文件到服务器文件夹    if(move_uploaded_file($_FILES['userfile']['tmp_name'],$uploadfile)){        echo "File is valid, and was successfully uploaded./n";    }else{        echo "ossible file upload attack!/n";    }?>

10.PHP显示客户IP，操作系统和浏览器

<?php    // 浏览者操作系统及浏览器    $os = $_SERVER["HTTP_USER_AGENT"];    // echo $os;    // 分析浏览器    if(strpos($os,"NetCaptor")) $explorer="NetCaptor";    elseif(strpos($os,"Opera")) $explorer="Opera";    elseif(strpos($os,"Firefox")) $explorer="Firefox";    elseif(strpos($os,"MSIE 6")) $explorer="MSIE 6.x";    elseif(strpos($os,"MSIE 5")) $explorer="MSIE 5.x";    elseif(strpos($os,"MSIE 4")) $explorer="MSIE 4.x";    elseif(strpos($os,"Netscape")) $explorer="Netscape";    else $explorer="Other";    // 分析操作系统    if(strpos($os,"Windows NT 5.0")) $os="Windows 2000";    elseif(strpos($os,"Windows NT 5.1")) $os="Windows XP";    elseif(strpos($os,"Windows NT 5.2")) $os="Windows 2003";    elseif(strpos($os,"Windows NT")) $os="Windows NT";    elseif(strpos($os,"Windows 9")) $os="Windows 98";    elseif(strpos($os,"unix")) $os="Unix";    elseif(strpos($os,"linux")) $os="Linux";    elseif(strpos($os,"SunOS")) $os="SunOS";    elseif(strpos($os,"BSD")) $os="FreeBSD";    elseif(strpos($os,"Mac")) $os="Mac";    else $os="Other";    // ip    unset($ip);        // 摧毁变量    if($_SERVER['HTTP_CLIENT_IP']){        $ip = $_SERVER['HTTP_CLIENT_IP'];    }else if($_SERVER['HTTP_X_FORWARDED_FOR']){        $ip=$_SERVER['HTTP_X_FORWARDED_FOR'];    } else{        $ip=$_SERVER['REMOTE_ADDR'];    }    //显示浏览者信息    echo "IP地址：".$ip."<br>";    echo "操作系统：".$os."<br>";    echo "浏览器：".$explorer."<br>";?>

11.PHP导出excel

header("Content-Type:application/vnd.ms-excel");header("Content-Disposition:attachment;filename=downdata.xls");header("Pragma:no-cache");header("Expires:0");echo "aa/t/n";echo "bb/t/n";

12.PHP指定服务器内存：ini_set();

ini_set("upload_max_filesize","20M");ini_set("post_max_size","32M");ini_set("memory_limit","32M");

13.PHP页面跳转

header("Location:www.baidu.com");