PHP experience collection

Author：Eve Cole Update Time：2009-05-30 20:06:10

I just finished the project I was working on recently and am quite free. Come here and share some of the skills I have accumulated with you!
1. Regarding PHP redirection method one: header("Location: index.php");
Method 2: echo "<script>window.location ="$PHP_SELF";</script>";
Method three: echo "<META HTTP-EQUIV="Refresh" CONTENT="0; URL=index.php">";

2. Get the visitor's browser

function browse_infor() {
$browser="";$browserver="";
$Browsers =array("Lynx","MOSAIC","AOL","Opera","JAVA","MacWeb","WebExplorer","OmniWeb");
$Agent = $GLOBALS["HTTP_USER_AGENT"];
for ($i=0; $i<=7; $i++) {
if (strpos($Agent,$Browsers[$i])) {
$browser = $Browsers[$i];
$browserver="";
}
}
if (ereg("Mozilla",$Agent) && !ereg("MSIE",$Agent)) {
$temp =explode("(", $Agent); $Part=$temp[0];
$temp =explode("/", $Part); $browserver=$temp[1];
$temp =explode(" ",$browserver); $browserver=$temp[0];
$browserver =preg_replace("/([d.]+)/"," \1",$browserver );
$browserver = " $browserver";
$browser = "Netscape Navigator";
}
if (ereg("Mozilla",$Agent) && ereg("Opera",$Agent)) {
$temp =explode("(", $Agent); $Part=$temp[1];
$temp =explode(")", $Part); $browserver=$temp[1];
$temp =explode(" ",$browserver);$browserver=$temp[2];
$browserver =preg_replace("/([d.]+)/"," \1",$browserver );
$browserver = " $browserver";
$browser = "Opera";
}
if (ereg("Mozilla",$Agent) && ereg("MSIE",$Agent)) {
$temp = explode("(", $Agent); $Part=$temp[1];
$temp = explode(";",$Part); $Part=$temp[1];
$temp = explode(" ",$Part);$browserver=$temp[2];
$browserver =preg_replace("/([d.]+)/"," \1",$browserver );
$browserver = " $browserver";
$browser = "Internet Explorer";
}
if ($browser!="") {
$browseinfo = "$browser$browserver";
}else {
$browseinfo = "Unknown";
}
return $browseinfo;
}
//Call the method $browser=browseinfo(); directly return the result

3. Get the visitor's operating system

4. File format class

$mime_types = array(
'gif' => 'image/gif',
'jpg' => 'image/jpeg',
'jpeg' => 'image/jpeg',
'jpe' => 'image/jpeg',
'bmp' => 'image/bmp',
'png' => 'image/png',
'tif' => 'image/tiff',
'tiff' => 'image/tiff',
'pict' => 'image/x-pict',
'pic' => 'image/x-pict',
'pct' => 'image/x-pict',
'tif' => 'image/tiff',
'tiff' => 'image/tiff',
'psd' => 'image/x-photoshop',

'swf' => 'application/x-shockwave-flash',
'js' => 'application/x-javascript',
'pdf' => 'application/pdf',
'ps' => 'application/postscript',
'eps' => 'application/postscript',
'ai' => 'application/postscript',
'wmf' => 'application/x-msmetafile',

'css' => 'text/css',
'htm' => 'text/html',
'html' => 'text/html',
'txt' => 'text/plain',
'xml' => 'text/xml',
'wml' => 'text/wml',
'wbmp' => 'image/vnd.wap.wbmp',

'mid' => 'audio/midi',
'wav' => 'audio/wav',
'mp3' => 'audio/mpeg',
'mp2' => 'audio/mpeg',

'avi' => 'video/x-msvideo',
'mpeg' => 'video/mpeg',
'mpg' => 'video/mpeg',
'qt' => 'video/quicktime',
'mov' => 'video/quicktime',

'lha' => 'application/x-lha',
'lzh' => 'application/x-lha',
'z' => 'application/x-compress',
'gtar' => 'application/x-gtar',
'gz' => 'application/x-gzip',
'gzip' => 'application/x-gzip',
'tgz' => 'application/x-gzip',
'tar' => 'application/x-tar',
'bz2' => 'application/bzip2',
'zip' => 'application/zip',
'arj' => 'application/x-arj',
'rar' => 'application/x-rar-compressed',

'hqx' => 'application/mac-binhex40',
'sit' => 'application/x-stuffit',
'bin' => 'application/x-macbinary',

'uu' => 'text/x-uuencode',
'uue' => 'text/x-uuencode',

'latex' => 'application/x-latex',
'ltx' => 'application/x-latex',
'tcl' => 'application/x-tcl',

'pgp' => 'application/pgp',
'asc' => 'application/pgp',
'exe' => 'application/x-msdownload',
'doc' => 'application/msword',
'rtf' => 'application/rtf',
'xls' => 'application/vnd.ms-excel',
'ppt' => 'application/vnd.ms-powerpoint',
'mdb' => 'application/x-msaccess',
'wri' => 'application/x-mswrite',
);

5. Generate excel document with php

<?
header("Content-type:application/vnd.ms-excel");
header("Content-Disposition:filename=test.xls");
echo "test1t";
echo "test2tn";
echo "test1t";
echo "test2tn";
echo "test1t";
echo "test2tn";
echo "test1t";
echo "test2tn";
echo "test1t";
echo "test2tn";
echo "test1t";
echo "test2tn";
?>
//Change the corresponding file header to output file formats

such as .doc.
Method one:
//$db->rows[$i][date] is the datetime field value in the database.
$today=time();
$theDay=date("Ymd H:i:s",$today-24*3600);
$newTag=$db->rows[$i][date]>=$theDay?"<img src='../image/newinfor.gif'>":"";
Method two:
$newTag=$db->rows[$i][date]>=date("Ymd 00:00:00")?"<img src='../image/newinfor.gif'>":"";

7. Database encapsulation example

<?php
//------------------------------------------------ ------------------------------------------
// ※Database() constructor, database initial parameters
// ※Select() query
// ※GetRows() returns the total number of records queried
// ※Insert() insert record
// ※Update() update
// ※Delete() delete
// ※Halt() interrupts and displays error message*/
//------------------------------------------------ ------------------------------------------
define("DATABASETYPE","1"); //Define database type: 1 is MySql; 2 is SQL Server; 3 is Oracle; 4 is Odbc
define("SERVER","localhost"); //Host name or IP address of the database server
define("DATABASE","dbName"); //The name of the database to be connected
define("USER","tableName"); //User name used to connect to the database
define("PASSWORD","paswd"); //Password used to connect to the database

class Database{
var $dbLink; //Connection handle
var $result; //query handle
var $insId; //Insert() successfully returns the value of the AUTO_INCREMENT column
var $rows; //Return data array
var $numRows; //Return the number of data
var $dbHost, $dbUser, $userPassword, $database;
var $dbType=DATABASETYPE;
var $msgFlag = "yes" ; //yes:show the Mysql message ; no: die by show "Halted."
function Database($dbHost=SERVER,$dbUser=USER,$userPassword=PASSWORD,$database=DATABASE){
switch($this->dbType){
case 1:
$this->dbLink=@mysql_pconnect($dbHost,$dbUser,$userPassword);// or die("Can't Connect to Remote Host!");
@mysql_select_db($database,$this->dbLink);// or die ("Can't Connect to Remote Host!");
break;
case 2:
break;
}
return true;
}

/*SQL:Select() returns false and has no result*/
function Select($table,$columns,$condition=1){
$sql="select $columns from $table where $condition ";
//echo $sql."<br>";
$this->result=@mysql_query($sql,$this->dbLink);
unset($this->rows);
if($this->result){
$i=0;
if(!($this->rows=array("$i"=>@mysql_fetch_array($this->result))))
return false;
if(($this->numRows=@mysql_num_rows($this->result))==0)
return false;
while( $tempRows=@mysql_fetch_array($this->result )){
array_push($this->rows,$tempRows);
}
}else{
$this->Halt($sql);
return false;
}
return true;
}

/*SQL:GetRows() returns the total number of queried records*/
function GetRows($table,$condition=1){
$sql="select count(1) as count from $table where $condition";
//echo $sql."<br>";
$this->result=@mysql_query($sql,$this->dbLink);
if($this->result){
$temp=@mysql_fetch_array($this->result );
$this->numRows=$temp[count];
}else{
$this->Halt($sql);
return false;
}
return $this->numRows;
}

/*SQL:Insert()*/

function Insert($table,$columns,$values){
$sql="insert into $table ($columns) values ($values)";
//echo $sql;
$this->result=@mysql_query($sql,$this->dbLink);
if ($this->result)
$this->insId=@mysql_insert_id($this->dbLink);
else{
$this->Halt($sql);
return false;
}
return true;
}

/*SQL:Update()*/

function Update($table,$settings,$condition){
$sql="update $table set $settings where $condition";
//echo $sql;
$this->result=@mysql_query($sql,$this->dbLink);
if ($this->result)
$this->numRows=@mysql_affected_rows($this->result);
else{
$this->Halt($sql);
return false;
}
return true;
}

/*SQL:Delete*/

function Delete($table,$condition){
$sql="delete from $table where $condition";
$this->result=@mysql_query($sql,$this->dbLink);
if ($this->result)
$this->numRows=@mysql_affected_rows($this->result);
else{
$this->Halt($sql);
return false;
}

return true;
}

/*Halt():error message */

function Halt($msg){
if($this->msgFlag=="yes"){
printf("<b>Database Query Error:</b> %s<br>n", $msg);
printf("<b>MySql Error:</b> %s<br>n",mysql_error());
}else
echo "<META HTTP-EQUIV=REFRESH CONTENT='0;URL=../include/error.htm'>";//Customize an error message file
return false;
}
}
switch($db->dbType){
case 1:
@mysql_close();
break;
case 2:

break;
}
$db = new Database();
?>