| 订阅 | 在线投稿
分享
 
 
当前位置: 王朝网络 >> php >> PHP jing yan ji jin

PHP jing yan ji jin

2008-12-22 08:09:05 编辑來源:互联网 评论
 
 
 
本文为【PHP经验集锦】的拼音翻译版
  zui jin gang gang wan cheng shou zhong de xiang mu , bi jiao xian 。 lai zhe er zhuan zhuan , ba ji lei de yi xie ji qiao fen xiang gei da jia !
  1、 guan yu PHP chong ding xiang
  fang fa yi :header("Location: index.php");
  fang fa er :echo "<script>window.location =\"$PHP_SELF\";</script>";
  fang fa san :echo "<META HTTP-EQUIV=\"Refresh\" CONTENT=\"0; URL=index.php\">";
  2、 huo qu fang wen zhe liu lan qi
  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;
  }
  // tiao yong fang fa $browser=browseinfo() ; zhi jie fan hui jie guo
  3、 huo qu fang wen zhe cao zuo xi tong
  function osinfo() {
  $os="";
  $Agent = $GLOBALS["HTTP_USER_AGENT"];
  if (eregi('win',$Agent) && strpos($Agent, '95')) {
  $os="Windows 95";
  }
  elseif (eregi('win 9x',$Agent) && strpos($Agent, '4.90')) {
  $os="Windows ME";
  }
  elseif (eregi('win',$Agent) && ereg('98',$Agent)) {
  $os="Windows 98";
  }
  elseif (eregi('win',$Agent) && eregi('nt 5\.0',$Agent)) {
  $os="Windows 2000";
  }
  elseif (eregi('win',$Agent) && eregi('nt',$Agent)) {
  $os="Windows NT";
  }
  elseif (eregi('win',$Agent) && eregi('nt 5\.1',$Agent)) {
  $os="Windows XP";
  }
  elseif (eregi('win',$Agent) && ereg('32',$Agent)) {
  $os="Windows 32";
  }
  elseif (eregi('linux',$Agent)) {
  $os="Linux";
  }
  elseif (eregi('unix',$Agent)) {
  $os="Unix";
  }
  elseif (eregi('sun',$Agent) && eregi('os',$Agent)) {
  $os="SunOS";
  }
  elseif (eregi('ibm',$Agent) && eregi('os',$Agent)) {
  $os="IBM OS/2";
  }
  elseif (eregi('Mac',$Agent) && eregi('PC',$Agent)) {
  $os="Macintosh";
  }
  elseif (eregi('PowerPC',$Agent)) {
  $os="PowerPC";
  }
  elseif (eregi('AIX',$Agent)) {
  $os="AIX";
  }
  elseif (eregi('HPUX',$Agent)) {
  $os="HPUX";
  }
  elseif (eregi('NetBSD',$Agent)) {
  $os="NetBSD";
  }
  elseif (eregi('BSD',$Agent)) {
  $os="BSD";
  }
  elseif (ereg('OSF1',$Agent)) {
  $os="OSF1";
  }
  elseif (ereg('IRIX',$Agent)) {
  $os="IRIX";
  }
  elseif (eregi('FreeBSD',$Agent)) {
  $os="FreeBSD";
  }
  if ($os=='') $os = "Unknown";
  return $os;
  }
  // tiao yong fang fa $os=os_infor() ;
  4、 wen jian ge shi lei
  $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、php sheng cheng excel wen dang
  <?
  header("Content-type:application/vnd.ms-excel");
  header("Content-Disposition:filename=test.xls");
  echo "test1\t";
  echo "test2\t\n";
  echo "test1\t";
  echo "test2\t\n";
  echo "test1\t";
  echo "test2\t\n";
  echo "test1\t";
  echo "test2\t\n";
  echo "test1\t";
  echo "test2\t\n";
  echo "test1\t";
  echo "test2\t\n";
  ?>
  // gai dong xiang ying wen jian tou jiu ke yi shu chu .doc .xls deng wen jian ge shi le
  6、 shi jian bi jiao wen ti
  ju yi ge jian dan li zi shuo ming : bi ru yi ge lun tan dui dang tian fa biao de tie zi yong new tu pian biao ji yi xia 。
  fang fa yi :
  //$db->rows[$i][date] zhong wei shu ju ku zhong datetime zi duan zhi .
  $today=time();
  $theDay=date("Y-m-d H:i:s",$today-24*3600);
  $newTag=$db->rows[$i][date]>=$theDay?"<img src='../image/newinfor.gif'>":"";
  fang fa er :
  $newTag=$db->rows[$i][date]>=date("Y-m-d 00:00:00")?"<img src='../image/newinfor.gif'>":"";
  7. shu ju ku feng zhuang li zi
  <?php
  //------------------------------------------------------------------------------------------
  // ※Database() gou zao han shu , shu ju ku chu shi shen shu
  // ※Select() cha xun
  // ※GetRows() fan hui cha xun de ji lu zong shu
  // ※Insert() cha ru ji lu
  // ※Update() geng xin
  // ※Delete() shan chu
  // ※Halt() zhong duan bing xian shi cuo wu xin xi */
  //------------------------------------------------------------------------------------------
  define("DATABASETYPE","1"); // ding yi shu ju ku lei xing :1 wei MySql;2 wei SQL Server;3 wei Oracle;4 wei Odbc
  define("SERVER","localhost"); //Host name or IP address of the database server
  define("DATABASE","dbName"); // yao lian jie de shu ju ku ming
  define("USER","tableName"); // yong yu lian jie shu ju ku de yong hu ming
  define("PASSWORD","paswd"); // yong yu lian jie shu ju ku de mi ma
  class Database{
  var $dbLink; // lian jie ju bing
  var $result; // cha xun ju bing
  var $insId; //Insert() cheng gong fan hui AUTO_INCREMENT lie de zhi
  var $rows; // fan hui shu ju shu zu
  var $numRows; // fan hui shu ju shu mu
  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() fan hui wei false wu jie guo */
  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"$tempRows=@mysql_fetch_array($this->result)){
   array_push($this->rows,$tempRows);
   }
  }else{
   $this->Halt($sql);
   return false;
  }
  return true;
  }
  /*SQL:GetRows() fan hui cha xun de ji lu zong shu */
  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"$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,$setings,$condition){
  $sql="update $table set $setings 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'>";// zi ding yi ge chu cuo ti shi wen jian
   return false;
  }
  }
  switch($db->dbType){
   case 1:
   @mysql_close();
   break;
  case 2:
  
   break;
  }
  $db = new Database();
  ?>【原文】【汉音对照
 
 
 
 
 
 
 
 
 
日版宠物情人插曲《Winding Road》歌词

日版宠物情人2017的插曲,很带节奏感,日语的,女生唱的。 最后听见是在第8集的时候女主手割伤了,然后男主用嘴帮她吸了一下,插曲就出来了。 歌手:Def...

兄弟共妻,我成了他们夜里的美食

老钟家的两个儿子很特别,就是跟其他的人不太一样,魔一般的执着。兄弟俩都到了要结婚的年龄了,不管自家老爹怎么磨破嘴皮子,兄弟俩说不娶就不娶,老父母为兄弟两操碎了心...

如何磨出破洞牛仔裤?牛仔裤怎么剪破洞?

把牛仔裤磨出有线的破洞 1、具体工具就是磨脚石,下面垫一个硬物,然后用磨脚石一直磨一直磨,到把那块磨薄了,用手撕开就好了。出来的洞啊很自然的。需要猫须的话调几...

我就是扫描下图得到了敬业福和爱国福

先来看下敬业福和爱国福 今年春节,支付宝再次推出了“五福红包”活动,表示要“把欠大家的敬业福都还给大家”。 今天该活动正式启动,和去年一样,需要收集“五福”...

冰箱异味产生的原因和臭味去除的方法

有时候我们打开冰箱就会闻到一股异味,冰箱里的这种异味是因为一些物质发出的气味的混合体,闻起来让人恶心。 产生这些异味的主要原因有以下几点。 1、很多人有这种习...

 
 
zui jin gang gang wan cheng shou zhong de xiang mu , bi jiao xian 。 lai zhe er zhuan zhuan , ba ji lei de yi xie ji qiao fen xiang gei da jia ! 1、 guan yu PHP chong ding xiang fang fa yi :header("Location: index.php"); fang fa er :echo "<script>window.location =\"$PHP_SELF\";</script>"; fang fa san :echo "<META HTTP-EQUIV=\"Refresh\" CONTENT=\"0; URL=index.php\">"; 2、 huo qu fang wen zhe liu lan qi 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\.]+)/","[url=file://\\1]\\1",$browserver[/url]); $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\.]+)/","[url=file://\\1]\\1",$browserver[/url]); $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\.]+)/","[url=file://\\1]\\1",$browserver[/url]); $browserver = " $browserver"; $browser = "Internet Explorer"; } if ($browser!="") { $browseinfo = "$browser$browserver"; }else { $browseinfo = "Unknown"; } return $browseinfo; } // tiao yong fang fa $browser=browseinfo() ; zhi jie fan hui jie guo 3、 huo qu fang wen zhe cao zuo xi tong function osinfo() { $os=""; $Agent = $GLOBALS["HTTP_USER_AGENT"]; if (eregi('win',$Agent) && strpos($Agent, '95')) { $os="Windows 95"; } elseif (eregi('win 9x',$Agent) && strpos($Agent, '4.90')) { $os="Windows ME"; } elseif (eregi('win',$Agent) && ereg('98',$Agent)) { $os="Windows 98"; } elseif (eregi('win',$Agent) && eregi('nt 5\.0',$Agent)) { $os="Windows 2000"; } elseif (eregi('win',$Agent) && eregi('nt',$Agent)) { $os="Windows NT"; } elseif (eregi('win',$Agent) && eregi('nt 5\.1',$Agent)) { $os="Windows XP"; } elseif (eregi('win',$Agent) && ereg('32',$Agent)) { $os="Windows 32"; } elseif (eregi('linux',$Agent)) { $os="Linux"; } elseif (eregi('unix',$Agent)) { $os="Unix"; } elseif (eregi('sun',$Agent) && eregi('os',$Agent)) { $os="SunOS"; } elseif (eregi('ibm',$Agent) && eregi('os',$Agent)) { $os="IBM OS/2"; } elseif (eregi('Mac',$Agent) && eregi('PC',$Agent)) { $os="Macintosh"; } elseif (eregi('PowerPC',$Agent)) { $os="PowerPC"; } elseif (eregi('AIX',$Agent)) { $os="AIX"; } elseif (eregi('HPUX',$Agent)) { $os="HPUX"; } elseif (eregi('NetBSD',$Agent)) { $os="NetBSD"; } elseif (eregi('BSD',$Agent)) { $os="BSD"; } elseif (ereg('OSF1',$Agent)) { $os="OSF1"; } elseif (ereg('IRIX',$Agent)) { $os="IRIX"; } elseif (eregi('FreeBSD',$Agent)) { $os="FreeBSD"; } if ($os=='') $os = "Unknown"; return $os; } // tiao yong fang fa $os=os_infor() ; 4、 wen jian ge shi lei $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、php sheng cheng excel wen dang <? header("Content-type:application/vnd.ms-excel"); header("Content-Disposition:filename=test.xls"); echo "test1\t"; echo "test2\t\n"; echo "test1\t"; echo "test2\t\n"; echo "test1\t"; echo "test2\t\n"; echo "test1\t"; echo "test2\t\n"; echo "test1\t"; echo "test2\t\n"; echo "test1\t"; echo "test2\t\n"; ?> // gai dong xiang ying wen jian tou jiu ke yi shu chu .doc .xls deng wen jian ge shi le 6、 shi jian bi jiao wen ti ju yi ge jian dan li zi shuo ming : bi ru yi ge lun tan dui dang tian fa biao de tie zi yong new tu pian biao ji yi xia 。 fang fa yi : //$db->rows[$i][date] zhong wei shu ju ku zhong datetime zi duan zhi . $today=time(); $theDay=date("Y-m-d H:i:s",$today-24*3600); $newTag=$db->rows[$i][date]>=$theDay?"<img src='../image/newinfor.gif'>":""; fang fa er : $newTag=$db->rows[$i][date]>=date("Y-m-d 00:00:00")?"<img src='../image/newinfor.gif'>":""; 7. shu ju ku feng zhuang li zi <?php //------------------------------------------------------------------------------------------ // ※Database() gou zao han shu , shu ju ku chu shi shen shu // ※Select() cha xun // ※GetRows() fan hui cha xun de ji lu zong shu // ※Insert() cha ru ji lu // ※Update() geng xin // ※Delete() shan chu // ※Halt() zhong duan bing xian shi cuo wu xin xi */ //------------------------------------------------------------------------------------------ define("DATABASETYPE","1"); // ding yi shu ju ku lei xing :1 wei MySql;2 wei SQL Server;3 wei Oracle;4 wei Odbc define("SERVER","localhost"); //Host name or IP address of the database server define("DATABASE","dbName"); // yao lian jie de shu ju ku ming define("USER","tableName"); // yong yu lian jie shu ju ku de yong hu ming define("PASSWORD","paswd"); // yong yu lian jie shu ju ku de mi ma class Database{ var $dbLink; // lian jie ju bing var $result; // cha xun ju bing var $insId; //Insert() cheng gong fan hui AUTO_INCREMENT lie de zhi var $rows; // fan hui shu ju shu zu var $numRows; // fan hui shu ju shu mu 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() fan hui wei false wu jie guo */ 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([url=mailto:$tempRows=@mysql_fetch_array($this-]result"$tempRows=@mysql_fetch_array($this->result[/url])){ array_push($this->rows,$tempRows); } }else{ $this->Halt($sql); return false; } return true; } /*SQL:GetRows() fan hui cha xun de ji lu zong shu */ 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){ [url=mailto:$temp=@mysql_fetch_array($this-]result"$temp=@mysql_fetch_array($this->result[/url]); $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,$setings,$condition){ $sql="update $table set $setings 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'>";// zi ding yi ge chu cuo ti shi wen jian return false; } } switch($db->dbType){ case 1: @mysql_close(); break; case 2: break; } $db = new Database(); ?>
󰈣󰈤
  免责声明:本文仅代表作者个人观点,与王朝网络无关。王朝网络登载此文出于传递更多信息之目的,并不意味着赞同其观点或证实其描述,其原创性以及文中陈述文字和内容未经本站证实,对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
玉美人_珠联璧合
清纯美女米卡
清新靓丽的早晨
玲子的自信与性感
痞子的甘南日记
疑是银河落九天
雪域坝上四——纯美色
冬日恋歌——西城杨柳弄轻柔
 
>>返回首页<<
 
 
 为你推荐
 
 
 
 转载本文
 UBB代码 HTML代码
复制到剪贴板...
 
 热帖排行
 
 
 
 
 
©2005- 王朝网络 版权所有