整理了以下四种在MySQL中修改root密码的方法,可能对大家有所帮助!

方法1: 用SET PASSWORD命令

  mysql -u root

  mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpass');

方法2:用mysqladmin

  mysqladmin -u root password "newpass"

  如果root已经设置过密码,采用如下方法

  mysqladmin -u root password oldpass "newpass"

方法3: 用UPDATE直接编辑user表

  mysql -u root

  mysql> use mysql;

  mysql> UPDATE user SET Password = PASSWORD('newpass') WHERE user = 'root';

  mysql> FLUSH PRIVILEGES;

在丢失root密码的时候,可以这样

  mysqld_safe --skip-grant-tables&

  mysql -u root mysql

  mysql> UPDATE user SET password=PASSWORD("new password") WHERE user='root';

  mysql> FLUSH PRIVILEGES;

首先查看mysql的版本信息:

#rpm -qa|grep -i mysql

显示:
MySQL-server-4.0.14-0
MySQL-client-4.0.14-0

删除mysql。


rpm -ev MySQL-server-4.0.14-0
rpm -ev MySQL-client-4.0.14-0

如果在卸载mysql-devel出现如下的错误:
[root@localhost f]# rpm -e mysql-4.1.12-3.RHEL4.1
error: Failed dependencies:
        libmysqlclient.so.14 is needed by (installed) cyrus-sasl-sql-2.1.19-5.EL4.i386
        libmysqlclient.so.14 is needed by (installed) dovecot-0.99.11-2.EL4.1.i386
那么,你需要按倒序来先删除dovecot-0.99.11-2.EL4.1.i386,然后是cyrus-sasl-sql-2.1.19-5.EL4.i386,最后,你可以完全删除mysql-devel,其他的类似。
[root@localhost f]# rpm -e dovecot-0.99.11-2.EL4.1.i386
[root@localhost f]# rpm -e cyrus-sasl-sql-2.1.19-5.EL4.i386
开始卸载

[root@localhost f]# rpm -e mysql-4.1.12-3.RHEL4.1


  卸载后/var/lib/mysql中的数据及/etc/my.cnf不会删除,如果确定没用后就手工删除

  rm -f /etc/my.cnf

  rm -rf /var/lib/mysql



linux下 mysql字符集的修改 不指定

jed , 2009-4-28 14:36 , 数据库技术 , 评论(0) , 阅读(4653) , Via 本站原创
安装完的MySQL的默认字符集为 latin1 ,为了要将其字符集改为用户所需要的(比如utf8),就必须改其相关的配置文件;由于linux下MySQL的默认安装目录分布在不同的文件下;不像windows一样放在同一目录下,只需修改其中的my.ini文件,重起后就生效了;所以先来看看linux下MySQL的数据库文件、配置文件和命令文件分别在不同的目录 :

     1、数据库目录,其所创建的数据库文件都在该目录下
  /var/lib/mysql/



   2、配置文件 (mysql.server命令及配置文件所在地)
  /usr/share/mysql



   3、相关命令(如mysql mysqladmin等)
  /usr/bin



   4、启动脚本(如mysql启动命令)
  /etc/rc.d/init.d/



      


           查看默认字符集

            #mysql -u root - p

            #(输入密码)

            mysql> show variables like 'character_set%' ;
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | latin1                     |
| character_set_connection | latin1                     |
| character_set_database   | latin1                     |
| character_set_filesystem | binary                     |
| character_set_results    | latin1                     |
| character_set_server     | latin1                     |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+

            修改字符集 :

         1.查找/etc目录下是否有my.cnf文件;

            #ls -l | grep my.cnf (在/etc下查找是否有my.cnf文件存在)

          2.如果没有就要从/usr/share/mysql,拷贝一个到/etc 下,在/usr/share/mysql目录下有五个后缀为.cnf的文件,分别是 my-huge.cnf    my-innodb-heavy-4G.cnf    my-large.cnf   my-medium.cnf     my-small.cnf ;从中随便拷贝一个到/etc目录下并将其改为my.cnf文件,我选择的是my-medium.cnf :

           #cp /usr/share/mysql/my-medium.cnf   /etc/my.cnf

          3.修改my.cnf文件,在该文件中的三个地方加上 default-character-set=utf8([client] [mysqld] [mysql])

             #vi  /etc/my.cnf

             修改如下:(红色为添加部分)

             [client]
            #password       = your_password
             port            = 3306
             socket          = /var/lib/mysql/mysql.sock
             default-character-set=utf8   (经过验证好像这一步不用设置也可以达到效果)

              [mysqld]
               port            = 3306
                socket          = /var/lib/mysql/mysql.sock
                skip-locking
                key_buffer = 16M
                max_allowed_packet = 1M
                table_cache = 64
                sort_buffer_size = 512K
                net_buffer_length = 8K
               read_buffer_size = 256K
               read_rnd_buffer_size = 512K
               myisam_sort_buffer_size = 8M
               default-character-set=utf8
               init_connect='SET NAMES utf8'



               [mysql]
               no-auto-rehash
               default-character-set=utf8
              保存退出;

           4.重起MySQL服务器,使其设置的内容生效

              #/etc/init.d/mysql  restart

            5. 重新登入mysql;

               # mysql -u root - p

                #(输入密码)

               mysql> show variables like 'character_set%' ;
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |(都生成了utf8,成功了 哈哈哈)
| character_set_database   | utf8                       |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | utf8                       |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+



        mysql启动和停止 操作 :

        可以通过 #/etc/init.d/mysql   [start | stop | restart](实现启动,停止,重启)

        也可以通过 #service mysql [start | stop | restart](实现启动,停止,重启)



         以上为实践总结,如果有更好的方法请告知谢谢

Tags: , , ,
按以下完装可以解决 MYSQL 中文乱码问题 安装字体为GBK编码

我在linux 9 和linux as 3,linux as 4 下成功安装多次。

#groupadd mysql
#useradd -g mysql mysql
#tar -zxvf mysql-5.0.27.tar.gz
#cd mysql-5.0.27
#./configure -prefix=/opt/mysql -with-charset=gbk -with-extra-charsets=all
#make
#make install
#cp support-files/my-medium.cnf /etc/my.cnf或者cp /opt/mysql/share/mysql/my-medium.cnf /etc/my.cnf
#./scripts/mysql_install_db --user=mysql //初试化表并且规定用mysql用户来访问。初始化表以后就开始给mysql和root用户设定访问权限

设置用户权限
#chown -R root .
#chown -R mysql var
#chown -R mysql var/.
#chgrp -R mysql .

# cp support-files/mysql.server /etc/rc.d/init.d/mysqld
# chmod 700 /etc/init.d/mysqld
# chkconfig --add mysqld
# chkconfig --level 345 mysqld on
# service mysqld start
# netstat -atln 查看mysql端口3306是否打开,如果打开说明安装成功

更改root用户密码
#./bin/mysqladmin -u root password 'new passwd'

use 库名; 切换库名
create table 表名 (字段设定列表); 创建表
create database 库名; 创建数据库

#grant select,insert,update,delete,index,alter,create,drop,grant,references,reload,shutdown,process,file,reload,shutdown,precess on *.* to user_1@"%" Identified by '123';

#grant select,insert,update,delete,index,alter,create,drop on 库名.表名 to user_1@"%" Identified by "123";
Tags: ,

mysql字符集编码转换 不指定

jed , 2009-4-27 15:32 , 数据库技术 , 评论(0) , 阅读(5393) , Via 本站原创
启动mysql,登陆mysql以后,通过如下命令显示当前mysql所用编码。
>show variables like 'character%'; #执行编码显示
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+

在mysql中的my.cnf中修改如下设置:
找到客户端配置[client] 在下面添加
default-character-set=utf8 默认字符集为utf8
在找到[mysqld] 添加
default-character-set=utf8 默认字符集为utf8

旧数据升级办法
以原来的字符集为latin1为例,升级成为utf8的字符集,
编码转换步骤:
1、导出旧数据:
mysqldump -uroot -p --default-character-set=latin1 --set-charset=utf8 --skip-opt 数据库>old.sql
2、转换sql编码:

iconv -t utf-8 -f gb2312 -c old.sql > new.sql
在这里,假定原来的数据默认是gb2312编码。

3、导入新数据库:
mysql -uroot -p --default-character-set=gbk -f 新数据库<new.sql
附:
查看mysql支持的编码:

SHOW VARIABLES LIKE 'character_set_%';

SHOW VARIABLES LIKE 'collation_%';

查看文件编码命令:

file 文件名
/etc/init.d/mysql start (stop) 为启动和停止服务器
/etc/mysql/ 主要配置文件所在位置 my.cnf
/var/lib/mysql/ 放置的是数据库表文件夹,这里的mysql相当于windows下mysql的date文件夹

启动mysql后,以root登录mysql
isher@isher-ubuntu:~$ mysql -u root
>show variables like 'character%'; #执行编码显示
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+

在某些时候,我们续要修改mysql默认数据库的编码,以保证某些迁移的程序可以正常显示,编辑my.cnf文件进行编码修改,windows可以直接用Mysql Server Instance Config Wizard 进行设置

在linux下修改3个my.cnf的1个/etc/mysql/my.cnf文件

找到客户端配置[client] 在下面添加
default-character-set=utf8 默认字符集为utf8
在找到[mysqld] 添加
default-character-set=utf8 默认字符集为utf8
init_connect='SET NAMES utf8' (设定连接mysql数据库时使用utf8编码,以让mysql数据库为utf8运行)

修改好后,重新启动mysql 即可,查询一下show variables like 'character%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+



此方法用于标准mysql版本同样有效,对于/etc/my.cnf文件,需要从mysql/support-files的文件夹cp my-large.cnf一份到/etc/my.cnf


一般安装系统默认是INNODB
default-storage-engine=INNODB

  你可以使用很多方法指定一个要使用的存储引擎。最简单的方法是,如果你喜欢一种能满足你的大多数数据库需求的存储引擎,你可以在MySQL设置文件中设置一个默认的引擎类型(使用storage_engine 选项)或者在启动数据库服务器时在命令行后面加上--default-storage-engine或--default-table-type选项 。

  更灵活的方式是在随MySQL服务器发布同时提供的MySQL客户端时指定使用的存储引擎。最直接的方式是在创建表时指定存储引擎的类型,向下面这样:

  CREATE TABLE mytable (id int, title char(20)) ENGINE = INNODB
Linux+Apache的稳定性、安全性和性能以及低廉的价格正在赢得越来越多的市场份额,使用Linux+Apache作网站服务器的朋友也越来越多,而Apache作为一种http服务,相比FTP总是不容易控制,特别是当网站以http方式提供软件/音乐下载时,若是每个用户都开启多个线程并没有带宽的限制,将很快达到http的最大连接数或者造成网络壅塞,使得网站的许多正常服务都无法运行。不过,Apache的使用者们早已开发出了mod_limitipconn和mod_bandwidth两个模块,来控制http的并发连接数和用户所能够使用的带宽,下面将以RedHat Linux 7.3+Apache 1.3.7来说明它们的使用方法。

一、使用mod_limitipconn限制Apache的并发连接数

mod_limitipconn可以控制每个IP地址同时连接服务器某一个目录的并发连接数,是一个非常有用的模块,其官方网页是http://dominia.org/djao/limitipconn.html,最新版本为for Apache 1.3.7的0.04,并且还有支持Apache 2.x的模块下载,由于本人使用Apache 1.3.7版本,所以请使用2.x版本Apache的朋友到其官方网站察看具体的使用方法。

mod_limitipconn for Apache 1.3x提供三种安装方式,分别是tar包、rpm安装文件和rpm源文件,由于rpm包只能用在 RedHat 7.x 版本,并且不支持检测代理服务器,所以我们一般都使用tar包的安装方式。

以管理员方式登陆服务器,然后在服务器上运行wget http://dominia.org/djao/limit/mod_limitipconn-0.04.tar.gz将mod_limitipconn的tar包下载到服务器,然后按照再运行tar zxvf mod_limitipconn-0.04.tar.gz将tar包解压缩,会在当前目录下生成mod_limitipconn-0.04目录,然后cd mod_limitipconn-0.04进入此目录,下一步就是使用apxs将目录中的mod_limitipconn.c编译。这时,我们需要确定自己的Apache安装在那个目录,并且找到apxs命令放在哪里。

通过命令whereis apxs,我们可以确定apxs命令的路径,如我的apxs命令所在为/usr/sbin/apxs,则输入/usr/sbin/apxs -c -i -a mod_limitipconn.c对mod_limitipconn.c进行编译,此命令会自动在你Apache的配置文件httpd.conf中加入需要的信息,并且将生成的mod_limitipconn.so模块拷贝到Apache的模块目录。不过为了确认此命令是否正常运作,请首先检查自己的Apache模块目录(我的是/usr/lib/apache),看内部是否含有mod_limitipconn.so文件,没有的话请将mod_limitipconn-0.04目录中生成的文件拷贝到此处。
Tags: , ,

经典收藏PHP常用函数 不指定

jed , 2009-4-22 09:09 , 代码编程 , 评论(0) , 阅读(5703) , Via 本站原创


<?
function GetIP() { //获取IP zuolo:由于防火墙的原因 REMOTE_ADDR 就是服务器外网IP
    if ($_SERVER["HTTP_X_FORWARDED_FOR"])
        $ip = $_SERVER["HTTP_X_FORWARDED_FOR"];
    else if ($_SERVER["HTTP_CLIENT_IP"])
        $ip = $_SERVER["HTTP_CLIENT_IP"];
    else if ($_SERVER["REMOTE_ADDR"])
        $ip = $_SERVER["REMOTE_ADDR"];
    else if (getenv("HTTP_X_FORWARDED_FOR"))
        $ip = getenv("HTTP_X_FORWARDED_FOR");
    else if (getenv("HTTP_CLIENT_IP"))
        $ip = getenv("HTTP_CLIENT_IP");
    else if (getenv("REMOTE_ADDR"))
        $ip = getenv("REMOTE_ADDR");
    else
        $ip = "Unknown";
    return $ip;
}
?>






<?php
function DateAdd($date, $int, $unit = "d") { //时间的增加(还可以改进成时分秒都可以增加,有时间再补上)
    $dateArr = explode("-", $date);
    $value[$unit] = $int;
    return date("Y-m-d", mktime(0,0,0, $dateArr[1] + $value['m'], $dateArr[2] + $value['d'], $dateArr[0] + $value['y']));
}

function GetWeekDay($date) { //计算出给出的日期是星期几
    $dateArr = explode("-", $date);
    return date("w", mktime(0,0,0,$dateArr[1],$dateArr[2],$dateArr[0]));
}
?>






<?
function check_date($date) { //检查日期是否合法日期
    $dateArr = explode("-", $date);
    if (is_numeric($dateArr[0]) && is_numeric($dateArr[1]) && is_numeric($dateArr[2])) {
        return checkdate($dateArr[1],$dateArr[2],$dateArr[0]);
    }
    return false;
}
function check_time($time) { //检查时间是否合法时间
    $timeArr = explode(":", $time);
    if (is_numeric($timeArr[0]) && is_numeric($timeArr[1]) && is_numeric($timeArr[2])) {
        if (($timeArr[0] >= 0 && $timeArr[0] <= 23) && ($timeArr[1] >= 0 && $timeArr[1] <= 59) && ($timeArr[2] >= 0 && $timeArr[2] <= 59))
            return true;
        else
            return false;
    }
    return false;
}

function DateDiff($date1, $date2, $unit = "") { //时间比较函数,返回两个日期相差几秒、几分钟、几小时或几天
    switch ($unit) {
        case 's':
            $dividend = 1;
            break;
        case 'i':
            $dividend = 60;
            break;
        case 'h':
            $dividend = 3600;
            break;
        case 'd':
            $dividend = 86400;
            break;
        default:
            $dividend = 86400;
    }
    $time1 = strtotime($date1);
    $time2 = strtotime($date2);
    if ($time1 && $time2)
        return (float)($time1 - $time2) / $dividend;
    return false;
}

?>





PHP重定向


<?
方法一:header("Location: index.php");
方法二:echo "<scrīpt>window.location ="$PHP_SELF";</scrīpt>";
方法三:echo "<META HTTP-EQUIV="Refresh" CONTENT="0; URL=index.php">";

?>





<?
//获取访问者浏览器
function browse_infor()
{
    $browser="";$browserver="";
    $Browsers =array("Lynx","MOSAIC","AOL","Opera","JAVA","MacWeb","WebExplorer","OmniWeb");
    $Agent = $_SERVER["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))    { bug:会把谷歌浏览器Chrome误认为Netscape Navigator
//        $temp =explode("(", $Agent); $Part=$temp[0];
//        $temp =explode("/", $Part); $browserver=$temp[1];
//        $temp =explode(" ",$browserver); $browserver=$temp[0];
//        $browserver =preg_replace("/([d.]+)/","1",$browserver);
//        $browser = "Netscape Navigator";
//    }
    if (ereg("Mozilla",$Agent) && ereg("Chrome",$Agent))    {
        $browserver=substr($Agent,strripos($Agent, "Chrome"));
        $browserver=substr($browserver,7,(strripos($browserver," ")-7));
        $browser = "Google Chrome";
    }
    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);
        $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); bug:在IE7中会把版本号7.0转为710
        $browser = "Internet Explorer";
    }
    if ($browser!="")    {
        $browseinfo = "$browser $browserver";
    }
    else    {
        $browseinfo = "Unknown";
    }
    return $browseinfo;
}


//获取访问者操作系统
function osinfo() {
    $os="";
    $Agent = $_SERVER["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 5.1',$Agent)) {
        $os="Windows XP";
    }
    elseif (eregi('win',$Agent) && eregi('nt 6.0',$Agent)) {
        $os="Windows Vista";
    }
    elseif (eregi('win',$Agent) && eregi('nt',$Agent)) {
        $os="Windows NT";
    }
    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;
}






文件格式类


<?
$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-javascrīpt',
'pdf' => 'application/pdf',
'ps' => 'application/postscrīpt',
'eps' => 'application/postscrīpt',
'ai' => 'application/postscrīpt',
'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',
);

?>

[code]



php生成excel文档

[code]
<?
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";
//改动相应文件头就可以输出.doc .xls等文件格式了

?>





时间比较问题
举一个简单例子说明:比如一个论坛对当天发表的贴子用new图片标记一下。
方法一:

<?
//$db->rows[$i][date]中为数据库中datetime字段值.
$today=time();
$theDay=date("Y-m-d H:i:s",$today-24*3600);
$newTag=$db->rows[$i][date]>=$theDay?"<img src='../image/newinfor.gif'>":"";
//方法二:
$newTag=$db->rows[$i][date]>=date("Y-m-d 00:00:00")?"<img src='../image/newinfor.gif'>":"";

?>





//提取页面和浏览器提交的变量,作用相当于使PHP.INI开了全局变量

<?
@extract($_SERVER, EXTR_SKIP);
@extract($_SESSION, EXTR_SKIP);
@extract($_POST, EXTR_SKIP);
@extract($_FILES, EXTR_SKIP);
@extract($_GET, EXTR_SKIP);
@extract($_ENV, EXTR_SKIP);

?>





//读取文件函数

<?
function readfromfile($file_name) {
if (file_exists($file_name)) {
$filenum=fopen($file_name,"r");
flock($filenum,LOCK_EX);
$file_data=fread($filenum, filesize($file_name));
rewind($filenum);
fclose($filenum);
return $file_data;
}
}

?>





//写入文件函数


<?
function writetofile($file_name,$data,$method="w") {
$filenum=fopen($file_name,$method);
flock($filenum,LOCK_EX);
$file_data=fwrite($filenum,$data);
fclose($filenum);
return $file_data;
}

?>





//页面快速转向


<?
function turntopage($url="index.php",$info = "页面转向中...",$second=2){
print "<html>n<head>n<title>页面转向中....</title>n";
print "<meta http-equiv="refresh" content="$second;url=$url">n";
print "<style type="text/css">n<!--n";
print "td { font-family: "Verdana", "Arial";font-size: 12px}n";
print "A {COLOR: #000000; TEXT-DECORATION: none}n";
print "-->n</style>n";
print "</head>n<body>n";
print "<table width="100%" border="0" align="center">n";
print " <tr>n";
print " <td height="200"> </td>n";
print " </tr>n";
print " <tr>n";
print " <td align="center">n";
print " <table width="60%" border="0" cellpadding="8" bgcolor="#AA9FFF">n";
print " <tr>n";
print " <td height="30" align="center">页面转向提示信息</td>n";
print " </tr>n";
print " <tr>n";
print " <td align="center">$info</td>n";
print " </tr>n";
print " <tr>n";
print " <td align="center">n";
print " <a href="$url">如果你的浏览器不支持自动跳转,请按这里</a></td>n";
print " </tr>n";
print " </tr>n";
print " </table></td>n";
print " </tr>n";
print " <tr>n";
print " <td height="200"> </td>n";
print " </tr>n";
print "</table>n";
print "</body>n</html>";
exit;
?>






产生随机字符串函数


<?
function random($length) {
    $hash = "";
    $chars = "ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789abcdefghijklmnopqrstuvwxyz";
    $max = strlen($chars) - 1;
    mt_srand((double)microtime() * 1000000);
    for($i = 0; $i < $length; $i++) {
    $hash .= $chars[mt_rand(0, $max)];
    }
    return $hash;
}

?>





截取一定长度的字符串(该函数对GB2312使用有效)

<?
function Wordscut($string, $length ,$sss=0) {
if(strlen($string) > $length) {
               if($sss){
                      $length=$length - 3;
                      $addstr=@# ...@#;
                }
for($i = 0; $i < $length; $i++) {
   if(ord($string[$i]) > 127) {
    $wordscut .= $string[$i].$string[$i + 1];
    $i++;
   } else {
    $wordscut .= $string[$i];
   }
}
return $wordscut.$addstr;
}
return $string;
}

?>





取得客户端IP地址 //zuolo 由于防火墙的原因 REMOTE_ADDR 就是服务器外网IP


<?
function GetIP(){
             if (getenv("HTTP_CLIENT_IP") && strcasecmp(getenv("HTTP_CLIENT_IP"), "unknown"))
                   $ip = getenv("HTTP_CLIENT_IP");
             else if (getenv("HTTP_X_FORWARDED_FOR") && strcasecmp(getenv

("HTTP_X_FORWARDED_FOR"), "unknown"))
                   $ip = getenv("HTTP_X_FORWARDED_FOR");
             else if (getenv("REMOTE_ADDR") && strcasecmp(getenv("REMOTE_ADDR"), "unknown"))
                   $ip = getenv("REMOTE_ADDR");
             else if (isset($_SERVER["REMOTE_ADDR"]) && $_SERVER["REMOTE_ADDR"] &&

strcasecmp($_SERVER["REMOTE_ADDR"], "unknown"))
                   $ip = $_SERVER["REMOTE_ADDR"];
             else
                  $ip = "unknown";

             return($ip);
}

?>





判断邮箱地址


<?
function checkEmail($inAddress)
{
return (ereg("^([a-zA-Z0-9_-])+@([a-zA-Z0-9_-])+(.[a-zA-Z0-9_-])+",$inAddress));
}

?>





分页(两个函数配合使用)


<?
function getpage($sql,$page_size=20)
{
      global $page,$totalpage,$sums; //out param
      $page = $_GET["page"];
      //$eachpage = $page_size;
      $pagesql = strstr($sql," from ");
      $pagesql = "select count(*) as ids ".$pagesql;
      $result = mysql_query($pagesql);
      if($rs = mysql_fetch_array($result)) $sums = $rs[0];
      $totalpage = ceil($sums/$page_size);
      if((!$page)($page<1)) $page=1;
   $startpos = ($page-1)*$page_size;
   $sql .=" limit $startpos,$page_size ";
    return $sql;
}
function showbar($string="")
{    
    global $page,$totalpage;
$out="共<font ".$totalpage."color=@#red@#><b>".$totalpage."</b></font>页 ";
    $linkNum =4;
    $start = ($page-round($linkNum/2))>0 ? ($page-round($linkNum/2)) : "1";
    $end   = ($page+round($linkNum/2))<$totalpage ? ($page+round($linkNum/2)) : $totalpage;
    $prestart=$start-1;
    $nextend=$end+1;
    if($page<>1)
$out .= "<a href=@#?page=1&&".$string."@#title=第一页>第一页</a> ";
    if($start>1)
$out.="<a href=@#?page=".$prestart."@# title=上一页>..<<</a> ";

for($t=$start;$t<=$end;$t++)
    {
     $out .= ($page==$t) ? "<font [".$t."]color=@#red@#><b>[".$t."]</b></font> " : "<a $thref=@#?page=$t&&".$string."@#>$t</a> ";
    }
if($end<$totalpage)
$out.="<a href=@#?page=".$nextend."&&".$string."@# title=下一页>>>..</a>";
    if($page<>$totalpage)
   $out .= " <a href=@#?page=".$totalpage."&&".$string."@# title=最后页>最后页</a>";
   return $out;
}

?>





获取新插入数据的ID


<?
mysql_insert_id();
?>





//获得当前的脚本网址


<?
function get_php_url(){
        if(!empty($_server["REQUEST_URI"])){
                $scriptName = $_SERVER["REQUEST_URI"];
                $nowurl = $scriptName;
        }else{
                $scriptName = $_SERVER["PHP_SELF"];
                if(empty($_SERVER["QUERY_STRING"])) $nowurl = $scriptName;
                else $nowurl = $scriptName."?".$_SERVER["QUERY_STRING"];
        }
        return $nowurl;
}

?>





//把全角数字转为半角数字


<?
function GetAlabNum($fnum){
        $nums = array("0","1","2","3","4","5","6","7","8","9");
        $fnums = "0123456789";
        for($i=0;$i<=9;$i++) $fnum = str_replace($nums[$i],$fnums[$i],$fnum);
        $fnum = ereg_replace("[^0-9.]|^0{1,}","",$fnum);
        if($fnum=="") $fnum=0;
        return $fnum;
}

?>





//去除HTML标记


<?
function Text2Html($txt){
        $txt = str_replace(" "," ",$txt);
        $txt = str_replace("<","&lt;",$txt);
        $txt = str_replace(">","&gt;",$txt);
        $txt = preg_replace("/[rn]{1,}/isU","
rn",$txt);
        return $txt;
}

?>





//相对路径转化成绝对路径



<?
function relative_to_absolute($content, $feed_url) {
    preg_match('/(http|https|ftp):///', $feed_url, $protocol);
    $server_url = preg_replace("/(http|https|ftp|news):///", "", $feed_url);
    $server_url = preg_replace("//.*/", "", $server_url);

    if ($server_url == '') {
        return $content;
    }

    if (isset($protocol[0])) {
        $new_content = preg_replace('/href="//', 'href="'.$protocol[0].$server_url.'/', $content);
        $new_content = preg_replace('/src="//', 'src="'.$protocol[0].$server_url.'/', $new_content);
    } else {
        $new_content = $content;
    }
    return $new_content;
}

?>





//取得所有链接



<?
function get_all_url($code){
        preg_match_all('/<as+href=["|']?([^>"' ]+)["|']?s*[^>]*>([^>]+)</a>/i',$code,$arr);
        return array('name'=>$arr[2],'url'=>$arr[1]);
}

?>





//HTML表格的每行转为CSV格式数组

<?
function get_tr_array($table) {
        $table = preg_replace("'<td[^>]*?>'si",'"',$table);
        $table = str_replace("</td>",'",',$table);
        $table = str_replace("</tr>","{tr}",$table);
        //去掉 HTML 标记
        $table = preg_replace("'<[/!]*?[^<>]*?>'si","",$table);
        //去掉空白字符
        $table = preg_replace("'([rn])[s]+'","",$table);
        $table = str_replace(" ","",$table);
        $table = str_replace(" ","",$table);

        $table = explode(",{tr}",$table);
        array_pop($table);
        return $table;
}

?>






//将HTML表格的每行每列转为数组,采集表格数据


<?
function get_td_array($table) {
        $table = preg_replace("'<table[^>]*?>'si","",$table);
        $table = preg_replace("'<tr[^>]*?>'si","",$table);
        $table = preg_replace("'<td[^>]*?>'si","",$table);
        $table = str_replace("</tr>","{tr}",$table);
        $table = str_replace("</td>","{td}",$table);
        //去掉 HTML 标记
        $table = preg_replace("'<[/!]*?[^<>]*?>'si","",$table);
        //去掉空白字符
        $table = preg_replace("'([rn])[s]+'","",$table);
        $table = str_replace(" ","",$table);
        $table = str_replace(" ","",$table);
        
        $table = explode('{tr}', $table);
        array_pop($table);
        foreach ($table as $key=>$tr) {
                $td = explode('{td}', $tr);
                array_pop($td);
            $td_array[] = $td;
        }
        return $td_array;
}

?>





//返回字符串中的所有单词 $distinct=true 去除重复


<?
function split_en_str($str,$distinct=true) {
        preg_match_all('/([a-zA-Z]+)/',$str,$match);
        if ($distinct == true) {
                $match[1] = array_unique($match[1]);
        }
        sort($match[1]);
        return $match[1];
}
?>




//打印出为本PHP项目做出贡献的人员的清单


<?
string phpcredits(void)

?>
Tags:


update xxx set a=b where xxxxx;

update xxx set b=a where not b

Tags:

MySql复制表,数据,列,字段! 不指定

jed , 2009-4-17 13:20 , 数据库技术 , 评论(0) , 阅读(5463) , Via 本站原创
MySql数据库复制表数据

将 production 数据库中的 mytbl 表快速复制为 mytbl_new,2个命令如下:

CREATE TABLE mytbl_new LIKE production.mytbl;

INSERT mytbl_new SELECT * FROM production.mytbl;

第一个命令是创建新的数据表 mytbl_new ,并复制 mytbl 的数据表结构。

第二个命令是讲数据表 mytbl 中的数据复制到新表 mytbl_new 。

注:production.mytbl是指定要复制表的数据库名称为 production 。它是可选的。

假如没有production. ,MySQL数据库将会假设mytbl在当前操作的数据库。



另外:在mysql数据库中复制数据为:
Tags: , ,
分页: 2/5 第一页 上页 1 2 3 4 5 下页 最后页 [ 显示模式: 摘要 | 列表 ]