php 获取系统当前路径与检查php配置参数
function getPath($mainpath, $relativepath) {
global $dir;
$mainpath_info = explode('/', $mainpath);
$relativepath_info = explode('/', $relativepath);
$relativepath_info_count = count($relativepath_info);
for ($i=0; $i<$relativepath_info_count; $i++) {
if ($relativepath_info[$i] == '.' || $relativepath_info[$i] == '') continue;
if ($relativepath_info[$i] == '..') {
$mainpath_info_count = count($mainpath_info);
unset($mainpath_info[$mainpath_info_count-1]);
continue;
}
$mainpath_info[count($mainpath_info)] = $relativepath_info[$i];
} //end for
return implode('/', $mainpath_info);
}
// 检查PHP配置参数
function getphpcfg($varname) {
switch($result = get_cfg_var($varname)) {
case 0:
return "No";
break;
case 1:
return "Yes";
break;
default:
return $result;
break;
}
}
共有的成员还有办法解决,例如:
class A {
static public $child;
}
A::$child = new B();
对于私有的成员似乎就没有什么干净的方法了,只能这样做:
class A {
static private $child;
static public initialize() {
self::$child = new B();
}
}
A::initialize();
php 数据库在线备份代码
function sqldumptable($table, $fp=0) {
$tabledump = "DROP TABLE IF EXISTS $table;n";
$tabledump .= "CREATE TABLE $table (n";
$firstfield=1;
$fields = mysql_query("SHOW FIELDS FROM $table");
while ($field = mysql_fetch_array($fields)) {
if (!$firstfield) {
$tabledump .= ",n";
} else {
$firstfield=0;
}
$tabledump .= " $field[Field] $field[Type]";
if (!empty($field["Default"])) {
$tabledump .= " DEFAULT '$field[Default]'";
}
if ($field['Null'] != "YES") {
$tabledump .= " NOT NULL";
}
if ($field['Extra'] != "") {
$tabledump .= " $field[Extra]";
}
}
mysql_free_result($fields);
$keys = mysql_query("SHOW KEYS FROM $table");
while ($key = mysql_fetch_array($keys)) {
$kname=$key['Key_name'];
if ($kname != "PRIMARY" and $key['Non_unique'] == 0) {
$kname="UNIQUE|$kname";
}
if(!is_array($index[$kname])) {
$index[$kname] = array();
}
$index[$kname][] = $key['Column_name'];
}
mysql_free_result($keys);
while(list($kname, $columns) = @each($index)) {
$tabledump .= ",n";
$colnames=implode($columns,",");
if ($kname == "PRIMARY") {
$tabledump .= " PRIMARY KEY ($colnames)";
} else {
if (substr($kname,0,6) == "UNIQUE") {
$kname=substr($kname,7);
}
$tabledump .= " KEY $kname ($colnames)";
}
}
$tabledump .= "n);nn";
if ($fp) {
fwrite($fp,$tabledump);
} else {
echo $tabledump;
}
$rows = mysql_query("SELECT * FROM $table");
$numfields = mysql_num_fields($rows);
while ($row = mysql_fetch_array($rows)) {
$tabledump = "INSERT INTO $table VALUES(";
$fieldcounter=-1;
$firstfield=1;
while (++$fieldcounter<$numfields) {
if (!$firstfield) {
$tabledump.=", ";
} else {
$firstfield=0;
}
if (!isset($row[$fieldcounter])) {
$tabledump .= "NULL";
} else {
$tabledump .= "'".mysql_escape_string($row[$fieldcounter])."'";
}
}
$tabledump .= ");n";
if ($fp) {
fwrite($fp,$tabledump);
} else {
echo $tabledump;
}
}
mysql_free_result($rows);
}
@mysql_connect($servername,$dbusername,$dbpassword) or die("数据库连接失败");
@mysql_select_db($dbname) or die("选择数据库失败");
$table = array_flip($_POST['table']);
$result = mysql_query("SHOW tables");
echo ($result) ? NULL : "出错: ".mysql_error();
$filename = basename($_SERVER['HTTP_HOST']."_MySQL.sql");
header('Content-type: application/unknown');
header('Content-Disposition: attachment; filename='.$filename);
$mysqldata = '';
while ($currow = mysql_fetch_array($result)) {
if (isset($table[$currow[0]])) {
$mysqldata.= sqldumptable($currow[0]);
$mysqldata.= $mysqldata."rn";
}
}
mysql_close();
exit;
function copy($from, $to) {
if ($this->abspath($to)=="/") $to=$this->basedir;
if ($this->dirname($from) == $this->dirname($to)) $to = $this->dirname($to).'/复件'.basename($from);
if (!is_dir($from)) {
return @copy($from, $to);
} else {
if (!is_dir($to)) @mkdir($to);
$path = opendir($from);
while( $file = readdir( $path ) ) {
if (($file=='.')||($file=='..')) continue;
if (is_dir($from.'/'.$file)) $this->copy($from.'/'.$file, $to.'/'.$file);
else echo basename($file), copy($from.'/'.$file, $to.'/'.$file) ? ' Success!' : ' False.', '<br />';
}
return true;
}
}
PHP连接MYSQL数据库类
mysql.php
<?php
Class Dirver{
//连接数据库
//link database
function DBLink($dbhost='localhost', $dbuser='root', $password='', $dbname='', $pconnect=0){
$this->LinkID[$this->Line] = ($pconnect == 1)? @mysql_pconnect($dbhost, $dbuser, $password) : @mysql_connect($dbhost, $dbuser, $password) or die("Connect to MySQL ($dbhost,$dbuser) failed");
//选择连接数据库
//choose to link database
@mysql_select_db($dbname, $this->LinkID[$this->Line]) or die('Cannot use database '.$dbname);
return $this->LinkID[$this->Line];
}
//查询语句
//view qurry
function query($query,$limit='') {
$this -> nums ++;
//检测如果有限制数据集则处理
//test if there is finite data,then function
if($limit>0){
$query = $query.' LIMIT '.$limit;
}
$this-> Lists[$this->Line][] = $query;
$querys = mysql_query($query,$this->LinkID[$this->Line]);
if(!$querys){
$this->DB_Error($query);
}
return $querys;
}
//返回数组资料
//back to array info
function fetch_array($query) {
return @mysql_fetch_array($query, MYSQL_ASSOC);
}
//返回数组资料
//back to array info
function result($query) {
return @mysql_result($query,$this->LinkID[$this->Line]);
}
//返回数组资料行
//back to row info
function rows($query) {
return $this->fetch_array($this->query($query));
}
//返回数组行
//back to numrows
function nums($query) {
return $this->num_rows($this->query($query));
}
//取得返回列的数目
//fetch the numbers backing out
function num_rows($query){
return @mysql_num_rows($query);
}
//返回单列的各字段
//return to every field of single row
function fetch_row($query) {
return @mysql_fetch_row($query);
}
//返回最后一次使用 INSERT 指令的 ID
//return to inserted ID used last time
function insert_id(){
return @mysql_insert_id($this->LinkID[$this->Line]);
}
//关闭当前数据库连接
//close current database link
function close(){
return @mysql_close($this->LinkID[$this->Line]);
}
//检测mysql版本
//test mysql version
function version(){
$query = @mysql_query("SELECT VERSION()",$this->LinkID[$this->Line]);
return @mysql_result($query, 0);
}
//返回友情提示信息
//return to kindly note
function DB_Error_t($query=''){
}
function DB_Error($query=''){
global $PHP_SELF;
//出错语句提示
//error sentence
$errors = preg_replace("/'(.+?)'/is"," '<font color='#8899DF'><b>\1</b></font>' ",mysql_error());
$charset ='';
//提示语言
//language noted
$lang = Array('This SQL Error Info!', 'Error Script:', 'Present time:',
'Http Host:', 'Server Name:', 'Server Software:',
'Host IP Address:', 'Remote User Agent:', 'Current File:',
'Current Line:', 'Line.', 'The Error number:',
'The specific Error was:', 'SQL Query :', 'Not discover whateverly SQL Sentence !');
//时间处理
//time
$nowdate = date('Y-m-d H:i A');
$errors = preg_replace("/'(.+?)'/is","'<font color='#8899DF'><b>\1</b></font>'",mysql_error());
//检测是否有语句
//test if there is any sentence.
if($query==''){
$query = $lang[14];
}
echo "<html>
<head>
<meta http-equiv='Content-Type' content='text/html; charset=$charset'>
<title>$lang[0]</title>
</head>
<body>
</body>
</html>
<table style='BORDER-COLLAPSE: collapse;font-size:9pt;' borderColor='#a8b7c6' cellSpacing='1' width='100%' border='1' cellpadding='3' align='center'>
<tr>
<td bgColor='#F9F9F9' height='38' colspan='2'>
<font size='4' face='Arial' color='#800000'>$lang[0]</font></td>
</tr>
<tr>
<td bgColor='#F9F9F9' width='165'>
<p align='right'>$lang[2]</td>
<td bgColor='#F9F9F9'>$nowdate</td>
</tr>
<tr>
<td bgColor='#F9F9F9' width='165'>
<p align='right'>$lang[3]</td>
<td bgColor='#F9F9F9'><b>".$_SERVER['HTTP_HOST']."</b></td>
</tr>
<tr>
<td bgColor='#F9F9F9' width='165'>
<p align='right'>$lang[4]</td>
<td bgColor='#F9F9F9'>".$_SERVER['SERVER_NAME']."</td>
</tr>
<tr>
<td bgColor='#F9F9F9' width='165'>
<p align='right'>$lang[5]</td>
<td bgColor='#F9F9F9'>".$_SERVER['SERVER_SOFTWARE']."</td>
</tr>
<tr>
<td bgColor='#F9F9F9' width='165'>
<p align='right'>$lang[6]</td>
<td bgColor='#F9F9F9'><font color="#800000">".$_SERVER['REMOTE_ADDR']."</font></td>
</tr>
<tr>
<td bgColor='#F9F9F9' width='165'>
<p align='right'>$lang[7]</td>
<td bgColor='#F9F9F9'><font color="#000080">".$_SERVER['HTTP_USER_AGENT'].";</font></td>
</tr>
<tr>
<td bgColor='#F9F9F9' width='165'>
<p align='right'>$lang[11]</td>
<td bgColor='#F9F9F9'><b>".mysql_errno()."</b></td>
</tr>
<tr>
<td bgColor='#F9F9F9' width='165'>
<p align='right'>$lang[12]</td>
<td bgColor='#F9F9F9'>$errors</td>
</tr>
<tr>
<td bgColor='#F9F9F9' width='165'>
<p align='right'>$lang[13]</td>
<td bgColor='#F9F9F9'>$query</td>
</tr>
</table>
</td>
</tr>
</table>";
exit;
}
}
?>