php 显示mysql服务器所有数据库 SHOW DATABASES
$mydbname=$_GET['mydbname'];
$selectdbname=$phome_db_dbname;
if($mydbname)
{
$selectdbname=$mydbname;
}
$db='';
if($canlistdb)
{
$db.="<option value='".$selectdbname."'
selected>".$selectdbname."</option>";
}
else
{
$sql=$empire->query("SHOW DATABASES");
while($r=$empire->fetch($sql))
{
if($r[0]==$selectdbname)
{$select=" selected";}
else
{$select="";}
$db.="<option value='".$r[0]."'".$select.">".$r
[0]."</option>";
}
}
php mysql显示数据表字段 SHOW FIELDS
$mydbname=RepPostVar($_GET['mydbname']);
$mytbname=RepPostVar($_GET['mytbname']);
if(empty($mydbname)||empty($mytbname))
{
printerror("ErrorUrl","history.go(-1)");
}
$form=$_GET['form'];
if(empty($form))
{
$form='ebakchangetb';
}
$usql=$empire->query("use `$mydbname`");
$sql=$empire->query("SHOW FIELDS FROM `".$mytbname."`");
php 返回mysql字符编码与删除字符编码
function Ebak_GetSetChar($char){
global $empire;
if(empty($char))
{
return '';
}
$r=$empire->fetch1("SHOW COLLATION LIKE '".$char."';");
return $r['Charset'];
}
//---------------------返回设置编码
function Ebak_ReturnSetNames($char){
if(empty($char))
{
return '';
}
$dumpsql="DoSetDbChar('".$char."');rn";
return $dumpsql;
}
//--------------------去除字段中的编码
function Ebak_ReplaceFieldChar($sql){
global $phome_db_ver;
if($phome_db_ver=='4.0'&&strstr($sql,' character set '))
{
$preg_str="/ character set (.+?) collate (.+?) /is";
$sql=preg_replace($preg_str,' ',$sql);
}
return $sql;
}
php 创建目录函数教程
function DoMkdir($path){
global $public_r;
//不存在则建立
if(!file_exists($path))
{
//安全模式
if($public_r[phpmode])
{
$pr[0]=$path;
FtpMkdir($ftpid,$pr);
$mk=1;
}
else
{
$mk=@mkdir($path,0777);
}
@chmod($path,0777);
if(empty($mk))
{
printerror("NotMkdir","history.go(-1)");
}
}
return true;
}
php 读取,删除,写入文件实例教程
//-------------------------------删除文件
function DelFiletext($filename){
@unlink($filename);
}
//---------------------------------取得文件内容
function ReadFiletext($filepath){
$htmlfp=@fopen($filepath,"r");
while($data=@fread($htmlfp,1000))
{
$string.=$data;
}
@fclose($htmlfp);
return $string;
}
//--------------------------------写文件
function WriteFiletext($filepath,$string){
global $filechmod;
$string=stripSlashes($string);
$fp=@fopen($filepath,"w");
@fputs($fp,$string);
@fclose($fp);
if(empty($filechmod))
{
@chmod($filepath,0777);
}
}
//--------------------------------写文件
function WriteFiletext_n($filepath,$string){
global $filechmod;
$fp=@fopen($filepath,"w");
@fputs($fp,$string);
@fclose($fp);
if(empty($filechmod))
{
@chmod($filepath,0777);
}
}