php – Demengqi的好时机

centos 安装 mssql 支持php访问mssql(仅64位)

1、安装所需库

yum install php.x86_64
yum install php-odbc.x86_64
yum install php-pear.noarch
yum install php-pecl-apc.x86_64
yum install php-xml.x86_64
yum install php-xmlrpc.x86_64
yum install php-tidy.x86_64
yum install php-intl.x86_64
yum install php-imap.x86_64
yum install php-pecl-memcache.x86_64

2、下载 mssql 的OSBC驱动
http://www.microsoft.com/en-us/download/confirmation.aspx?id=28160

3、安装
cd ~
tar xvf sqlncli-11.0.1790.0.tar.gz

cd ./sqlncli-11.0.1790.0

./build_dm.sh
如果有提示输入”YES” 必须大写。

如果成功

./install.sh install
如果有提示输入”YES” 必须大写。

校验是否安装
odbcinst -q -d -n “SQL Server Native Client 11.0”

4、其他

vi /etc/odbcinst.ini 查看内容

[PostgreSQL]
Description=ODBC for PostgreSQL
Driver=/usr/lib/psqlodbc.so
Setup=/usr/lib/libodbcpsqlS.so
Driver64=/usr/lib64/psqlodbc.so
Setup64=/usr/lib64/libodbcpsqlS.so
FileUsage=1

[MySQL]
Description=ODBC for MySQL
Driver=/usr/lib/libmyodbc5.so
Setup=/usr/lib/libodbcmyS.so
Driver64=/usr/lib64/libmyodbc5.so
Setup64=/usr/lib64/libodbcmyS.so
FileUsage=1

[SQL Server Native Client 11.0]
Description=Microsoft SQL Server ODBC Driver V1.0 for Linux
Driver=/opt/microsoft/sqlncli/lib64/libsqlncli-11.0.so.1790.0
Threading=1
UsageCount=1

vi /etc/odbc.ini 开始空文件

编辑内容如下：

[连接名]
Driver = SQL Server Native Client 11.0
Server = tcp:host网址,1433
Trace=Yes

保存即可。

5、配置 httpd.conf文件，不知道有没有用
Add these two lines to /etc/httpd/conf/httpd.conf
SetEnv ODBCSYSINI /etc
SetEnv ODBCINI /etc/odbc.ini

测试
# isql -v 连接名 ‘用户名’ ‘密码’

http://strangenut.com/blogs/dacrowlah/archive/2012/04/13/installing-and-using-the-microsoft-sql-server-odbc-driver-for-linux.aspx

6、编辑php程序：
prepare(“$query”);
$stmt->execute();
while ($row = $stmt->fetch()) {
print_r($row);
}
$dbh = null;
unset($dbh); unset($stmt);

http://php.net/manual/zh/ref.pdo-odbc.php

http://phplens.com/phpeverywhere/node/view/9

7、注意：
http://www.vixual.net/blog/archives/133

PHP Warning: PHP Startup: Unable to load dynamic library ‘/usr/lib64/php/modules/module.so’ – /usr/lib64/php/modules/module.so: cannot open shared object file: No such file or directory in Unknown on line 0
; Enable mcrypt extension module

編輯 /etc/php.d/mcrypt.ini，將第 2 行的
将 extension=module.so 改成 extension=mcrypt.so
# service httpd restart

关于生日计算的程序

因为一个朋友要我帮忙改个javascript计算他朋友孩子年龄的代码，发现其中有些难度，后来用php改写了程序，计算更准确些。

header ( "Content-type: text/html; charset=utf-8" );

$weeklist = array ("星期日", "星期一", "星期二", "星期三", "星期四", "星期五", "星期六" );
$date = date ( 'Y年m月d日' );
$dateDisp = $date . $weeklist [date ( w )];

echo '今天是' . $date . '<br>';

$birthday = strtotime ( '1977-02-14' ); //生日
$haveday = floor ( (time () - $birthday) / (60 * 60 * 24) ); //出生距离现在的天数
echo '生日是'.date('Y-m-d',$birthday).'<br>';
echo '距现在是'.$haveday.'天<br>';

//计算年
if (date ( 'n' ) >= date ( 'n', $birthday ) && date ( 'j' ) >= date ( 'j', $birthday ))
 $have_year = date ( 'Y' ) - date ( 'Y', $birthday );
else
 $have_year = date ( 'Y' ) - date ( 'Y', $birthday ) - 1;
 
//计算月 
if (date ( 'n' ) >= date ( 'n', $birthday )) {
 $have_month = date ( 'n' ) - date ( 'n', $birthday );

} else {
 if (date ( 'j' ) >= date ( 'j', $birthday )) {
  $have_month = 4 + date ( 'n' );
 } else {
  $have_month = 4 + date ( 'n' ) - 1;
 }
}

if (date ( 'j' ) >= date ( 'j', $birthday )) {
 $have_day = date ( 'j' ) - date ( 'j', $birthday );
} else {
 $time_tmp = time () - date ( 'd' ) * 86400;
 $date_tmp = date ( 't', $time_tmp );
 $have_day = $date_tmp - date ( 'j', $birthday ) + date ( 'j' );
}

echo '您'.$have_year . '岁' . $have_month . '月零' . $have_day . '天啦 ^_^';
//echo $haveday;

防止 SQL injection 攻击

if($user_name == ” || $user_passwd == ”){
ErrMsg(“账号不能为空白”);
}
if (!preg_match(‘/^\w+$/’, $user_name)){
ErrMsg(“只能是数字字母”);
}

对输入的过滤

if( !get_magic_quotes_gpc() )
{
if( is_array($_GET) )
{
while( list($k, $v) = each($_GET) )
{
if( is_array($_GET[$k]) )
{
while( list($k2, $v2) = each($_GET[$k]) )
{
$_GET[$k][$k2] = addslashes($v2);
}
@reset($_GET[$k]);
}
else
{
$_GET[$k] = addslashes($v);
}
}
@reset($_GET);
}

if( is_array($_POST) )
{
while( list($k, $v) = each($_POST) )
{
if( is_array($_POST[$k]) )
{
while( list($k2, $v2) = each($_POST[$k]) )
{
$_POST[$k][$k2] = addslashes($v2);
}
@reset($_POST[$k]);
}
else
{
$_POST[$k] = addslashes($v);
}
}
@reset($_POST);
}

if( is_array($_COOKIE) )
{
while( list($k, $v) = each($_COOKIE) )
{
if( is_array($_COOKIE[$k]) )
{
while( list($k2, $v2) = each($_COOKIE[$k]) )
{
$_COOKIE[$k][$k2] = addslashes($v2);
}
@reset($_COOKIE[$k]);
}
else
{
$_COOKIE[$k] = addslashes($v);
}
}
@reset($_COOKIE);
}
}

SMTP Reply Codes

Code　　Description
211 　　System status, or system help reply.
214 　　Help message.
220 　　Domain service ready.Ready to start TLS.
221 　　Domain service closing transmission channel.
250 　　OK, queuing for node node started.Requested mail action okay, completed.
251 　　OK, no messages waiting for node node.User not local, will forward to forwardpath.
252 　　OK, pending messages for node node started.
　　　　Cannot VRFY user (e.g., info is not local), but will take message for this user and attempt delivery.
253　　 OK, messages pending messages for node node started.
354 　　Start mail input; end with <CRLF>.<CRLF>.
355 　　Octet-offset is the transaction offset.
421 　　Domain service not available, closing transmission channel.
432 　　A password transition is needed.
450 　　Requested mail action not taken: mailbox unavailable.ATRN request refused.
451　　 Requested action aborted: local error in processing.Unable to process ATRN request now
452 　　Requested action not taken: insufficient system storage.
453 　　You have no mail.
454 　　TLS not available due to temporary reason.Encryption required for requested authentication mechanism.
458 　　Unable to queue messages for node node.
459　　 Node node not allowed: reason.
500　　 Command not recognized: command.Syntax error.
501 　　Syntax error, no parameters allowed.
502 　　Command not implemented.
503 　　Bad sequence of commands.
504 　　Command parameter not implemented.
521 　　Machine does not accept mail.
530 　　Must issue a STARTTLS command first.Encryption required for requested authentication mechanism.
534 　　Authentication mechanism is too weak.
538 　　Encryption required for requested authentication mechanism.
550 　　Requested action not taken: mailbox unavailable.
551 　　User not local; please try forwardpath.
552 　　Requested mail action aborted: exceeded storage allocation.
553 　　Requested action not taken: mailbox name not allowed.
554 　　Transaction failed.

自己整理的php带密钥的加密解密类

在有些时候我们需要存贮到数据库中的内容是加密信息，比如 password，money 等敏感信息，以提高安全等级，

这里是一个带公钥的加密解密程序，测试是不错性能的，

<?php
/*
字符串加密解密函数，用于mysql存贮加密解密信息
*/
class MyClass_Crypt{

    //公钥
    protected $key = “123456”;

    private function keyED($txt,$encrypt_key)
    {
        $encrypt_key = md5($encrypt_key);
        $ctr=0;
        $tmp = “”;
        for ($i=0;$i<strlen($txt);$i++)
        {
            if ($ctr==strlen($encrypt_key)) $ctr=0;
            $tmp.= substr($txt,$i,1) ^ substr($encrypt_key,$ctr,1);
            $ctr++;
        }
        return $tmp;
    }

//$txt 是需要加密的字符串
    public function encrypt($txt,$key=”)
    {
        if(empty($key))
            $key=$this->key;

        srand((double)microtime()*1000000);
        $encrypt_key = md5(rand(0,32000));
        $ctr=0;
        $tmp = “”;
        for ($i=0;$i<strlen($txt);$i++)
        {
            if ($ctr==strlen($encrypt_key)) $ctr=0;
            $tmp.= substr($encrypt_key,$ctr,1) .
            (substr($txt,$i,1) ^ substr($encrypt_key,$ctr,1));
            $ctr++;
        }
        return $this->keyED($tmp,$key);
    }

//$txt 是需要解密的字符串
    public function decrypt($txt,$key=”)
    {
        if(empty($key))
            $key=$this->key;

        $txt = $this->keyED($txt,$key);
        $tmp = “”;
        for ($i=0;$i<strlen($txt);$i++)
        {
            $md5 = substr($txt,$i,1);
            $i++;
            $tmp.= (substr($txt,$i,1) ^ $md5);
        }
        return $tmp;
    }

    public function setKey($key)
    {
        if(empty($key))
            return Null;

        $this->key=$key;
    }

    public function getKey()
    {
        return $this->key;
    }

}
/*
$string = “123456”;
$crypt= new Crypt;
echo $crypt->getKey().'<br>’;
$crypt->setKey(‘sdfsd’);
echo $crypt->getKey().'<br>’;

// encrypt $string, and store it in $enc_text
$enc_text = $crypt->encrypt($string);

// decrypt the encrypted text $enc_text, and store it in $dec_text
$dec_text = $crypt->decrypt($enc_text);
print “Original text : $string<br>\n”;
print “Encrypted text : $enc_text<br>\n”;
print “Decrypted text : $dec_text\n”;
*/
?>