php 删除数据表与删除数据库

php 删除数据表与删除数据库

//---------------------------删除数据表
function Ebak_Drop($tablename,$dbname){
 global $empire;
 $dbname=RepPostVar($dbname);
 $empire->query("use `$dbname`");
 $count=count($tablename);
 if(empty($count))
 {printerror("EmptyChangeDelTb","history.go(-1)");}
 $a="";
 $first=1;
 for($i=0;$i<$count;$i++)
 {
  if(empty($first))
  {
   $a.=",";
     }
  else
  {
   $first=0;
  }
  $a.="`".$tablename[$i]."`";
    }
 $sql1=$empire->query("DROP TABLE IF EXISTS ".$a.";");
 printerror("DelTbSuccess","ChangeTable.php?mydbname=$dbname");
}

//--------------------------删除数据库
function Ebak_DropDb($dbname){
 global $empire;
 $dbname=RepPostVar($dbname);
 if(empty($dbname))
 {
  printerror("NotChangeDelDb","history.go(-1)");
 }
 $sql=$empire->query("DROP DATABASE `$dbname`");
 if($sql)
 {
  printerror("DelDbSuccess","ChangeDb.php");
 }
 else
 {printerror("DbError","history.go(-1)");}
}

php 文件在线压缩代码

class PHPZip
{
 function Zip($dir, $zipfilename)
 {
     if (@function_exists('gzcompress'))
  { 
   $curdir = getcwd();
   if (is_array($dir))
   {
     $filelist = $dir;
   }
   else
   {
    $filelist = $this -> GetFileList($dir);
   }
   
   if ((!empty($dir))&&(!is_array($dir))&&(file_exists

($dir))) chdir($dir);
   else chdir($curdir);

   if (count($filelist)>0)
   {
    foreach($filelist as $filename)
    {
     if (is_file($filename))
     {
      $fd = fopen ($filename,

"r");
      $content = @fread ($fd,

filesize ($filename));
      fclose ($fd);

      if (is_array($dir))

$filename = basename($filename);
      $this -> addFile($content,

$filename);
     }
    }
    $out = $this -> file();

    chdir($curdir);
    $fp = fopen($zipfilename, "w");
    fwrite($fp, $out, strlen($out));
    fclose($fp);
   }
   return 1;
  }
  else return 0;
 }

 function GetFileList($dir)
 {
  if (file_exists($dir))
  {
   $args = func_get_args();
   $pref = $args[1];
    
   $dh = opendir($dir);
   while($files = readdir($dh))
   {
    if (($files!=".")&&($files!=".."))
    {
     if (is_dir($dir.$files))
     {
      $curdir = getcwd();
      chdir($dir.$files);
      $file = array_merge($file,

$this -> GetFileList("", "$pref$files/"));
      chdir($curdir);
     }
     else $file[]=$pref.$files;
    }
   }
   closedir($dh);
  }
  return $file;
 }

    var $datasec      = array();
    var $ctrl_dir     = array();
    var $eof_ctrl_dir = "x50x4bx05x06x00x00x00x00";
    var $old_offset   = 0;

    /**
     * Converts an Unix timestamp to a four byte DOS date and time format

(date
     * in high two bytes, time in low two bytes allowing magnitude

comparison).
     *
     * @param  integer  the current Unix timestamp
     *
     * @return integer  the current date in a four byte DOS format
     *
     * @access private
     */
    function unix2DosTime($unixtime = 0) {
        $timearray = ($unixtime == 0) ? getdate() : getdate($unixtime);

        if ($timearray['year'] < 1980) {
         $timearray['year']    = 1980;
         $timearray['mon']     = 1;
         $timearray['mday']    = 1;
         $timearray['hours']   = 0;
         $timearray['minutes'] = 0;
         $timearray['seconds'] = 0;
        } // end if

        return (($timearray['year'] - 1980) << 25) | ($timearray['mon'] <<

21) | ($timearray['mday'] << 16) |
                ($timearray['hours'] << 11) | ($timearray['minutes'] << 5) |

($timearray['seconds'] >> 1);
    } // end of the 'unix2DosTime()' method

    /**
     * Adds "file" to archive
     *
     * @param  string   file contents
     * @param  string   name of the file in the archive (may contains the

path)
     * @param  integer  the current timestamp
     *
     * @access public
     */
    function addFile($data, $name, $time = 0)
    {
        $name     = str_replace('\', '/', $name);

        $dtime    = dechex($this->unix2DosTime($time));
        $hexdtime = 'x' . $dtime[6] . $dtime[7]
                  . 'x' . $dtime[4] . $dtime[5]
                  . 'x' . $dtime[2] . $dtime[3]
                  . 'x' . $dtime[0] . $dtime[1];
        eval('$hexdtime = "' . $hexdtime . '";');

        $fr   = "x50x4bx03x04";
        $fr   .= "x14x00";            // ver needed to extract
        $fr   .= "x00x00";            // gen purpose bit flag
        $fr   .= "x08x00";            // compression method
        $fr   .= $hexdtime;             // last mod time and date

        // "local file header" segment
        $unc_len = strlen($data);
        $crc     = crc32($data);
        $zdata   = gzcompress($data);
        $c_len   = strlen($zdata);
        $zdata   = substr(substr($zdata, 0, strlen($zdata) - 4), 2); // fix

crc bug
        $fr      .= pack('V', $crc);             // crc32
        $fr      .= pack('V', $c_len);           // compressed filesize
        $fr      .= pack('V', $unc_len);         // uncompressed filesize
        $fr      .= pack('v', strlen($name));    // length of filename
        $fr      .= pack('v', 0);                // extra field length
        $fr      .= $name;

        // "file data" segment
        $fr .= $zdata;

        // "data descriptor" segment (optional but necessary if archive is

not
        // served as file)
        $fr .= pack('V', $crc);                 // crc32
        $fr .= pack('V', $c_len);               // compressed filesize
        $fr .= pack('V', $unc_len);             // uncompressed filesize

        // add this entry to array
        $this -> datasec[] = $fr;
        $new_offset        = strlen(implode('', $this->datasec));

        // now add to central directory record
        $cdrec = "x50x4bx01x02";
        $cdrec .= "x00x00";                // version made by
        $cdrec .= "x14x00";                // version needed to extract
        $cdrec .= "x00x00";                // gen purpose bit flag
        $cdrec .= "x08x00";                // compression method
        $cdrec .= $hexdtime;                 // last mod time & date
        $cdrec .= pack('V', $crc);           // crc32
        $cdrec .= pack('V', $c_len);         // compressed filesize
        $cdrec .= pack('V', $unc_len);       // uncompressed filesize
        $cdrec .= pack('v', strlen($name) ); // length of filename
        $cdrec .= pack('v', 0 );             // extra field length
        $cdrec .= pack('v', 0 );             // file comment length
        $cdrec .= pack('v', 0 );             // disk number start
        $cdrec .= pack('v', 0 );             // internal file attributes
        $cdrec .= pack('V', 32 );            // external file attributes -

'archive' bit set

        $cdrec .= pack('V', $this -> old_offset ); // relative offset of

local header
        $this -> old_offset = $new_offset;

        $cdrec .= $name;

        // optional extra field, file comment goes here
        // save to central directory
        $this -> ctrl_dir[] = $cdrec;
    } // end of the 'addFile()' method

    /**
     * Dumps out file
     *
     * @return  string  the zipped file
     *
     * @access public
     */
    function file()
    {
        $data    = implode('', $this -> datasec);
        $ctrldir = implode('', $this -> ctrl_dir);

        return
            $data .
            $ctrldir .
            $this -> eof_ctrl_dir .
            pack('v', sizeof($this -> ctrl_dir)) .  // total # of entries

"on this disk"
            pack('v', sizeof($this -> ctrl_dir)) .  // total # of entries

overall
            pack('V', strlen($ctrldir)) .           // size of central dir
            pack('V', strlen($data)) .              // offset to start of

central dir
            "x00x00";                             // .zip file comment

length
    } // end of the 'file()' method

}

php 汉字转成拼音代码
<?php
function utf82gb($utfstr){ // UTF-8汉字转GBK汉字
 if(function_exists('iconv')){ return iconv('utf-8','gbk',$utfstr); }
 global $UC2GBTABLE;
 $okstr = "";
 if(trim($utfstr)=="") return $utfstr;
 if(empty($UC2GBTABLE)){
  $filename = dirname(__FILE__) . "/gb2312-utf8.table";
  $fp = fopen($filename,"r");
  while($l = fgets($fp,15))
  { $UC2GBTABLE[hexdec(substr($l, 7, 6))] = hexdec(substr($l, 0, 6));}
  fclose($fp);
 }
 $okstr = "";
 $ulen = strlen($utfstr);
 for($i=0;$i<$ulen;$i++)
 {
  $c = $utfstr[$i];
  $cb = decbin(ord($utfstr[$i]));
  if(strlen($cb)==8){
   $csize = strpos(decbin(ord($cb)),"0");
   for($j=0;$j < $csize;$j++){
    $i++; $c .= $utfstr[$i];
   }
   $c = utf82u($c);
   if(isset($UC2GBTABLE[$c])){
    $c = dechex($UC2GBTABLE[$c]+0x8080);
    $okstr .= chr(hexdec($c[0].$c[1])).chr(hexdec($c[2].$c[3]));
   }
   else
   { $okstr .= "&#".$c.";";}
  }
  else $okstr .= $c;
 }
 $okstr = trim($okstr);
 return $okstr;
}

function SpGetPinyin($str,$ishead=0,$isclose=1){ // GBK汉字转拼音
 global $pinyins;
 $restr = "";
 $str = trim($str);
 $slen = strlen($str);
 if($slen<2) return $str;
 if(count($pinyins)==0){
  $fp = fopen(dirname(__FILE__) . '/pinyin.db',"r");
  while(!feof($fp)){
   $line = trim(fgets($fp));
   $pinyins[$line[0].$line[1]] = substr($line,3,strlen($line)-3);
  }
  fclose($fp);
 }
 for($i=0;$i<$slen;$i++){
  if(ord($str[$i])>0x80)
  {
   $c = $str[$i].$str[$i+1];
   $i++;
   if(isset($pinyins[$c])){
    if($ishead==0) $restr .= $pinyins[$c];
    else $restr .= $pinyins[$c][0];
   }else $restr .= "_";
  }else if( eregi("[a-z0-9]",$str[$i]) ){ $restr .= $str[$i]; }
  else{ $restr .= "_";  }
 }
 if($isclose==0) unset($pinyins);
 return $restr;
}

function getPinyin($string){ // UTF-8汉字转拼音
 return SpGetPinyin(utf82gb($string));
}

echo getPinyin("中国WEB第一站");
?>

 php实例多文件上传实例代码
  //a = $('<span class="MultiFile-title" title="'+MultiFile.STRING.selected.replace('$file', v)+'">'+MultiFile.STRING.file.replace('$file', v.match(/[^/\]+$/gi)[0])+'</span>'),

                 //这是新的代码结构.

                //取出图片格式.

                ext = String(v.match(/.w{1,4}$/gi));

                // v变量是路径地址, 所以可以直接用img来显示出来.

                var imgs = (ext=='.jpg' || ext=='.gif' || ext=='.png')?'<img onmouseover="alert(this.src)" width="30" src="'+v+'"/>':'';       

                // 从'+imgs+'开始,就是我增加的.

                a = $('<span class="MultiFile-title" title="'+MultiFile.STRING.selected.replace('$file', v)+'">'+MultiFile.STRING.file.replace('$file', v.match(/[^/\]+$/gi)[0])+'</span> '+imgs+'　　<a class="a_b" href="javascript:;" title="点击插入主题" rsok="'+slave_count+'" onclick="alert('+slave_count+'); return false">点击插入</a>'),

         b = $('<a class="MultiFile-remove" href="#'+MultiFile.wrapID+'">'+MultiFile.STRING.remove+'</a>');
复制代码<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<title>无标题文档</title>

</head>

<script type="text/javascript" src="jquery.js"></script>

<script type="text/javascript" src="jquery.MultiFile.js"></script>

<script type="text/javascript">

        <!--

                $(function (){

                                        //测试jquery是否加载

                                        //alert('jquery');

                                        //用示例7模式的内容

                                        $('#T7').MultiFile({

                                        list: '#T7-list'

                                        });

                })

        -->

</script>

<body style="font-size:14px; margin:10%; height:">

<!--建立一个ID #T7  相应的设置一个div为T7-list来显示内容-->

<input id="T7" name="upfile" type="file" />

<div id="T7-list"></div>

<div>部分测试: <a href="javascript:;" onclick="alert($('#T7-list').html())">列表内容</a></div>

</body>

</html>
复制代码       //对于编辑来说, 键名key就会从0开始计算.所以获取一下附件最后一个rsok值是非常重要的.

           //var int_s=$('.a_b:last').attr('rsok');

       // Bind functionality to the first element

       if(!MultiFile.MultiFile) MultiFile.addSlave(MultiFile.e, 0);
复制代码

第二步. 把$img_array 数组循环一下. 做图片保存和文章位置替换