PHP | 东莞科技时代

‘PHP’ 存档

PHP 执行MySQL存储过程 can’t return a result set in the given context及参数解释

Cody 发表于 2011-05-05 浏览次数: 506

自己写了一个mysql存储过程，以为php有用于调用存储过程的内建函数，查了一下发现只能用mysql_query(call pro())这样的方式，我认为从本质上也就相当于在mysql命令行里执行语句了，由于我的存储过程含有输入输出参数，直接调用会报一个 mysql_error错误：XXXXcan’t return a result set in the given context

google了一下这个错误发现有人用以下的代码解决了这个问题：
原文地址：http://www.phpweblog.net/GaRY/archive/2008/01/29/2752.html#Post

关键就是两点

define(‘CLIENT_MULTI_RESULTS’, 131072);

$link= mysql_connect(“127.0.0.1″,”root”,”",1,CLIENT_MULTI_RESULTS) or die(“Could not connect: “.mysql_error());

下面就可以正常使用了，以下是例子程序。

1 <?php
2 define(‘CLIENT_MULTI_RESULTS’, 131072);
3
4 $link=mysql_connect(“127.0.0.1″,”root”,”",1,CLIENT_MULTI_RESULTS)ordie(“Could not connect: “.mysql_error());
5 mysql_select_db(“vs”)ordie(“Could not select database”);
6 ?>
7
8 <?php
9 $result=mysql_query(“call get_news_from_class_id(2)”)ordie(“Query failed:”.mysql_error());
10 while($row=mysql_fetch_array($result,MYSQL_ASSOC))
11 {
12 $line=’<tr><td><a target = _blank href=\”.$row["url"].’\'>’.$row["title"].’(‘.$row["page_time"].’)’.’</a></td></tr>’;
14 echo$line;
15 printf(” “);
16
17 }
18 mysql_free_result($result);
19 ?>
20
21 <?php
22 mysql_close($link);
23 ?>

其中的一个参数CLIENT_MULTI_RESULTS不明白是什么意思，google之，在mysql的官方主页上关于mysql提供的c接口的文档（http://dev.mysql.com/doc/refman/5.0/en/mysql-real-connect.html）里找到了这个参数和其他一些参数，我大概翻译了一下描述，如下：

Flag Name	Flag Description
CLIENT_COMPRESS	Use compression protocol.（使用压缩协议。）
CLIENT_FOUND_ROWS	Return the number of found (matched) rows, not the number of changed rows.（返回找到（匹配）的行数，而不是改变了的行数。）
CLIENT_IGNORE_SIGPIPE	Prevents the client library from installing a SIGPIPE signal handler. This can be used to avoid conflicts with a handler that the application has already installed.（阻止客户端库安装一个SIGPIPE信号处理器。这个可以用于当应用程序已经安装该处理器的时候避免与其发生冲突。）
CLIENT_IGNORE_SPACE	Allow spaces after function names. Makes all functions names reserved words.（允许在函数名后使用空格。所有函数名可以预留字。）
CLIENT_INTERACTIVE	Allow interactive_timeout seconds (instead of wait_timeout seconds) of inactivity before closing the connection. The client’s session wait_timeout variable is set to the value of the session interactive_timeout variable.（允许使用关闭连接之前的不活动交互超时的描述，而不是等待超时秒数。客户端的会话等待超时变量变为交互超时变量。）
CLIENT_LOCAL_FILES	Enable LOAD DATA LOCAL handling.
CLIENT_MULTI_RESULTS	Tell the server that the client can handle multiple result sets from multiple-statement executions or stored procedures. This flag is automatically enabled if CLIENT_MULTI_STATEMENTS is enabled. See the note following this table for more information about this flag.（通知服务器客户端可以处理由多语句或者存储过程执行生成的多结果集。当打开CLIENT_MULTI_STATEMENTS时，这个标志自动的被打开。可以在本表后查看更多关于该标志位的信息。）
CLIENT_MULTI_STATEMENTS	Tell the server that the client may send multiple statements in a single string (separated by “;”). If this flag is not set, multiple-statement execution is disabled. See the note following this table for more information about this flag.（通知服务器客户端可以发送多条语句（由分号分隔）。如果该标志为没有被设置，多条语句执行。）
CLIENT_NO_SCHEMA	Don’t allow the db_name.tbl_name.col_name syntax. This is for ODBC. It causes the parser to generate an error if you use that syntax, which is useful for trapping bugs in some ODBC programs.（不允许“数据库名.表名.列名”这样的语法。这是对于ODBC的设置。当使用这样的语法时解析器会产生一个错误，这对于一些ODBC的程序限制bug来说是有用的。）
CLIENT_ODBC	Unused.（不使用）
CLIENT_SSL	Use SSL (encrypted protocol). This option should not be set by application programs; it is set internally in the client library. Instead, use mysql_ssl_set() before calling mysql_real_connect().（使用SSL。这个设置不应该被应用程序设置，他应该是在客户端库内部是设置的。可以在调用mysql_real_connect()之前调用mysql_ssl_set()来代替设置。）
CLIENT_REMEMBER_OPTIONS	Remember options specified by calls to mysql_options(). Without this option, if mysql_real_connect() fails, you must repeat the mysql_options() calls before trying to connect again. With this option, the mysql_options() calls need not be repeated.（记住通过调用mysql_options()生成的设置。如果不使用这个设置，当mysql_real_connect失败时，再重新连接之前必须反复调用mysql_options()。当然，如果使用这个设置，就不必反复调用了。）

下面有对于CLIENT_MULTI_STATEMENTS的说明：
If you enable CLIENT_MULTI_STATEMENTS or CLIENT_MULTI_RESULTS, you should process the result for every call to mysql_query() or mysql_real_query() by using a loop that calls mysql_next_result() to determine whether there are more results. For an example, see Section 20.9.12, “C API Support for Multiple Statement Execution”.

如果打开了CLIENT_MULTI_STATEMENTS或CLIENT_MULTI_RESULTS，你必须对每一个mysql_query()或者mysql_real_query()的调用结果通过一个循环来处理，在这个循环中，调用mysql_next_result()来决定（发现）是否有更多的结果，如Section 20.9.12, “C API Support for Multiple Statement Execution”

来源：http://edu.codepub.com/2010/0921/26012.php

Posted in MySQL, PHP

Tags: MySQL, PHP, 存储过程

没有评论 »

PHP阳历到农历转换的一个类

Cody 发表于 2010-12-28 浏览次数: 639

<?php
//PHP阳历到农历转换的一个类
class Calendar
{
#农历每月的天数
    var $everyCMonth=array(
    0=>array(8,0,0,0,0,0,0,0,0,0,0,0,29,30,7,1),
    1=>array(0,29,30,29,29,30,29,30,29,30,30,30,29,0,8,2),
    2=>array(0,30,29,30,29,29,30,29,30,29,30,30,30,0,9,3),
    3=>array(5,29,30,29,30,29,29,30,29,29,30,30,29,30,10,4),
    4=>array(0,30,30,29,30,29,29,30,29,29,30,30,29,0,1,5),
    5=>array(0,30,30,29,30,30,29,29,30,29,30,29,30,0,2,6),
    6=>array(4,29,30,30,29,30,29,30,29,30,29,30,29,30,3,7),
    7=>array(0,29,30,29,30,29,30,30,29,30,29,30,29,0,4,8),
    8=>array(0,30,29,29,30,30,29,30,29,30,30,29,30,0,5,9),
    9=>array(2,29,30,29,29,30,29,30,29,30,30,30,29,30,6,10),
    10=>array(0,29,30,29,29,30,29,30,29,30,30,30,29,0,7,11),
    11=>array(6,30,29,30,29,29,30,29,29,30,30,29,30,30,8,12),
    12=>array(0,30,29,30,29,29,30,29,29,30,30,29,30,0,9,1),
    13=>array(0,30,30,29,30,29,29,30,29,29,30,29,30,0,10,2),
    14=>array(5,30,30,29,30,29,30,29,30,29,30,29,29,30,1,3),
    15=>array(0,30,29,30,30,29,30,29,30,29,30,29,30,0,2,4),
    16=>array(0,29,30,29,30,29,30,30,29,30,29,30,29,0,3,5),
    17=>array(2,30,29,29,30,29,30,30,29,30,30,29,30,29,4,6),
    18=>array(0,30,29,29,30,29,30,29,30,30,29,30,30,0,5,7),
    19=>array(7,29,30,29,29,30,29,29,30,30,29,30,30,30,6,8),
    20=>array(0,29,30,29,29,30,29,29,30,30,29,30,30,0,7,9),
    21=>array(0,30,29,30,29,29,30,29,29,30,29,30,30,0,8,10),
    22=>array(5,30,29,30,30,29,29,30,29,29,30,29,30,30,9,11),
    23=>array(0,29,30,30,29,30,29,30,29,29,30,29,30,0,10,12),
    24=>array(0,29,30,30,29,30,30,29,30,29,30,29,29,0,1,1),
    25=>array(4,30,29,30,29,30,30,29,30,30,29,30,29,30,2,2),
    26=>array(0,29,29,30,29,30,29,30,30,29,30,30,29,0,3,3),
    27=>array(0,30,29,29,30,29,30,29,30,29,30,30,30,0,4,4),
    28=>array(2,29,30,29,29,30,29,29,30,29,30,30,30,30,5,5),
    29=>array(0,29,30,29,29,30,29,29,30,29,30,30,30,0,6,6),
    30=>array(6,29,30,30,29,29,30,29,29,30,29,30,30,29,7,7),
    31=>array(0,30,30,29,30,29,30,29,29,30,29,30,29,0,8,8),
    32=>array(0,30,30,30,29,30,29,30,29,29,30,29,30,0,9,9),
    33=>array(5,29,30,30,29,30,30,29,30,29,30,29,29,30,10,10),
    34=>array(0,29,30,29,30,30,29,30,29,30,30,29,30,0,1,11),
    35=>array(0,29,29,30,29,30,29,30,30,29,30,30,29,0,2,12),
    36=>array(3,30,29,29,30,29,29,30,30,29,30,30,30,29,3,1),
    37=>array(0,30,29,29,30,29,29,30,29,30,30,30,29,0,4,2),
    38=>array(7,30,30,29,29,30,29,29,30,29,30,30,29,30,5,3),
    39=>array(0,30,30,29,29,30,29,29,30,29,30,29,30,0,6,4),
    40=>array(0,30,30,29,30,29,30,29,29,30,29,30,29,0,7,5),
    41=>array(6,30,30,29,30,30,29,30,29,29,30,29,30,29,8,6),
    42=>array(0,30,29,30,30,29,30,29,30,29,30,29,30,0,9,7),
    43=>array(0,29,30,29,30,29,30,30,29,30,29,30,29,0,10,8),
    44=>array(4,30,29,30,29,30,29,30,29,30,30,29,30,30,1,9),
    45=>array(0,29,29,30,29,29,30,29,30,30,30,29,30,0,2,10),
    46=>array(0,30,29,29,30,29,29,30,29,30,30,29,30,0,3,11),
    47=>array(2,30,30,29,29,30,29,29,30,29,30,29,30,30,4,12),
    48=>array(0,30,29,30,29,30,29,29,30,29,30,29,30,0,5,1),
    49=>array(7,30,29,30,30,29,30,29,29,30,29,30,29,30,6,2),
    50=>array(0,29,30,30,29,30,30,29,29,30,29,30,29,0,7,3),
    51=>array(0,30,29,30,30,29,30,29,30,29,30,29,30,0,8,4),
    52=>array(5,29,30,29,30,29,30,29,30,30,29,30,29,30,9,5),
    53=>array(0,29,30,29,29,30,30,29,30,30,29,30,29,0,10,6),
    54=>array(0,30,29,30,29,29,30,29,30,30,29,30,30,0,1,7),
    55=>array(3,29,30,29,30,29,29,30,29,30,29,30,30,30,2,8),
    56=>array(0,29,30,29,30,29,29,30,29,30,29,30,30,0,3,9),
    57=>array(8,30,29,30,29,30,29,29,30,29,30,29,30,29,4,10),
    58=>array(0,30,30,30,29,30,29,29,30,29,30,29,30,0,5,11),
    59=>array(0,29,30,30,29,30,29,30,29,30,29,30,29,0,6,12),
    60=>array(6,30,29,30,29,30,30,29,30,29,30,29,30,29,7,1),
    61=>array(0,30,29,30,29,30,29,30,30,29,30,29,30,0,8,2),
    62=>array(0,29,30,29,29,30,29,30,30,29,30,30,29,0,9,3),
    63=>array(4,30,29,30,29,29,30,29,30,29,30,30,30,29,10,4),
    64=>array(0,30,29,30,29,29,30,29,30,29,30,30,30,0,1,5),
    65=>array(0,29,30,29,30,29,29,30,29,29,30,30,29,0,2,6),
    66=>array(3,30,30,30,29,30,29,29,30,29,29,30,30,29,3,7),
    67=>array(0,30,30,29,30,30,29,29,30,29,30,29,30,0,4,8),
    68=>array(7,29,30,29,30,30,29,30,29,30,29,30,29,30,5,9),
    69=>array(0,29,30,29,30,29,30,30,29,30,29,30,29,0,6,10),
    70=>array(0,30,29,29,30,29,30,30,29,30,30,29,30,0,7,11),
    71=>array(5,29,30,29,29,30,29,30,29,30,30,30,29,30,8,12),
    72=>array(0,29,30,29,29,30,29,30,29,30,30,29,30,0,9,1),
    73=>array(0,30,29,30,29,29,30,29,29,30,30,29,30,0,10,2),
    74=>array(4,30,30,29,30,29,29,30,29,29,30,30,29,30,1,3),
    75=>array(0,30,30,29,30,29,29,30,29,29,30,29,30,0,2,4),
    76=>array(8,30,30,29,30,29,30,29,30,29,29,30,29,30,3,5),
    77=>array(0,30,29,30,30,29,30,29,30,29,30,29,29,0,4,6),
    78=>array(0,30,29,30,30,29,30,30,29,30,29,30,29,0,5,7),
    79=>array(6,30,29,29,30,29,30,30,29,30,30,29,30,29,6,8),
    80=>array(0,30,29,29,30,29,30,29,30,30,29,30,30,0,7,9),
    81=>array(0,29,30,29,29,30,29,29,30,30,29,30,30,0,8,10),
    82=>array(4,30,29,30,29,29,30,29,29,30,29,30,30,30,9,11),
    83=>array(0,30,29,30,29,29,30,29,29,30,29,30,30,0,10,12),
    84=>array(10,30,29,30,30,29,29,30,29,29,30,29,30,30,1,1),
    85=>array(0,29,30,30,29,30,29,30,29,29,30,29,30,0,2,2),
    86=>array(0,29,30,30,29,30,30,29,30,29,30,29,29,0,3,3),
    87=>array(6,30,29,30,29,30,30,29,30,30,29,30,29,29,4,4),
    88=>array(0,30,29,30,29,30,29,30,30,29,30,30,29,0,5,5),
    89=>array(0,30,29,29,30,29,29,30,30,29,30,30,30,0,6,6),
    90=>array(5,29,30,29,29,30,29,29,30,29,30,30,30,30,7,7),
    91=>array(0,29,30,29,29,30,29,29,30,29,30,30,30,0,8,8),
    92=>array(0,29,30,30,29,29,30,29,29,30,29,30,30,0,9,9),
    93=>array(3,29,30,30,29,30,29,30,29,29,30,29,30,29,10,10),
    94=>array(0,30,30,30,29,30,29,30,29,29,30,29,30,0,1,11),
    95=>array(8,29,30,30,29,30,29,30,30,29,29,30,29,30,2,12),
    96=>array(0,29,30,29,30,30,29,30,29,30,30,29,29,0,3,1),
    97=>array(0,30,29,30,29,30,29,30,30,29,30,30,29,0,4,2),
    98=>array(5,30,29,29,30,29,29,30,30,29,30,30,29,30,5,3),
    99=>array(0,30,29,29,30,29,29,30,29,30,30,30,29,0,6,4),
    100=>array(0,30,30,29,29,30,29,29,30,29,30,30,29,0,7,5),
    101=>array(4,30,30,29,30,29,30,29,29,30,29,30,29,30,8,6),
    102=>array(0,30,30,29,30,29,30,29,29,30,29,30,29,0,9,7),
    103=>array(0,30,30,29,30,30,29,30,29,29,30,29,30,0,10,8),
    104=>array(2,29,30,29,30,30,29,30,29,30,29,30,29,30,1,9),
    105=>array(0,29,30,29,30,29,30,30,29,30,29,30,29,0,2,10),
    106=>array(7,30,29,30,29,30,29,30,29,30,30,29,30,30,3,11),
    107=>array(0,29,29,30,29,29,30,29,30,30,30,29,30,0,4,12),
    108=>array(0,30,29,29,30,29,29,30,29,30,30,29,30,0,5,1),
    109=>array(5,30,30,29,29,30,29,29,30,29,30,29,30,30,6,2),
    110=>array(0,30,29,30,29,30,29,29,30,29,30,29,30,0,7,3),
    111=>array(0,30,29,30,30,29,30,29,29,30,29,30,29,0,8,4),
    112=>array(4,30,29,30,30,29,30,29,30,29,30,29,30,29,9,5),
    113=>array(0,30,29,30,29,30,30,29,30,29,30,29,30,0,10,6),
    114=>array(9,29,30,29,30,29,30,29,30,30,29,30,29,30,1,7),
    115=>array(0,29,30,29,29,30,29,30,30,30,29,30,29,0,2,8),
    116=>array(0,30,29,30,29,29,30,29,30,30,29,30,30,0,3,9),
    117=>array(6,29,30,29,30,29,29,30,29,30,29,30,30,30,4,10),
    118=>array(0,29,30,29,30,29,29,30,29,30,29,30,30,0,5,11),
    119=>array(0,30,29,30,29,30,29,29,30,29,29,30,30,0,6,12),
    120=>array(4,29,30,30,30,29,30,29,29,30,29,30,29,30,7,1)
    );
##############################
#农历天干

    var $mten=array("null","甲","乙","丙","丁","戊","己","庚","辛","壬","癸");    #农历地支
    var $mtwelve=array("null","子(鼠)","丑(牛)","寅(虎)","卯(兔)","辰(龙)",
                   "巳(蛇)","午(马)","未(羊)","申(猴)","酉(鸡)","戌(狗)","亥(猪)");    #农历月份
    var $mmonth=array("闰","正","二","三","四","五","六",
                  "七","八","九","十","十一","十二","月");
    var $mday=array("null","初一","初二","初三","初四","初五","初六","初七","初八","初九","初十",
                "十一","十二","十三","十四","十五","十六","十七","十八","十九","二十",
                "廿一","廿二","廿三","廿四","廿五","廿六","廿七","廿八","廿九","三十");#农历日
##############################
#赋给初值
#天干地支
    var $ten=0;
    var $twelve=0;
    function MyPub($cYear,$cMonth,$cDay)
    {
        $total=11;#阳历总天数 至1900年12月21日
        $mtotal=0;#阴历总天数
        for ($y=1901;$y<$cYear;$y++)
        {
            $total+=365;
            if ($y%4==0) $total ++;
        }
        #再加当年的几个月
        switch ($cMonth){
                 case 12:
                      $total+=30;
                 case 11:
                      $total+=31;
                 case 10:
                      $total+=30;
                 case 9:
                      $total+=31;
                 case 8:
                      $total+=31;
                 case 7:
                      $total+=30;
                 case 6:
                      $total+=31;
                 case 5:
                      $total+=30;
                 case 4:
                      $total+=31;
                 case 3:
                      $total+=28;
                 case 2:
                      $total+=31;
               }

            #如果当年是闰年还要加一天
            if ($cYear%4==0 and $cMonth>2)
            {
                $total++;
            }

            $total+=$cDay-1;

            ##############################
            #用农历的天数累加来判断是否超过阳历的天数
            for($j=0;$j<=120;$j++)
            {
                $i=1;
                for($i=1;$i<=13;$i++)
                {
                    $mtotal+=$this->everyCMonth[$j][$i];
                    if ($mtotal>=$total)
                    {
                        $flag=1;
                        break;
                    }
                }
                if ($flag==1)break;
            }
                    return array("m"=>$j,"d"=>$i,"t"=>$total,"n"=>$mtotal);
    }
    function Cal($Year,$Month,$Day)
    {
        $Par=$this->MyPub($Year,$Month,$Day);

        $md=$this->everyCMonth[$Par["m"]][$Par["d"]]-($Par["n"]-$Par["t"]);
        $week=($Par["t"]+5)%7;
        if ($this->everyCMonth[$Par["m"]][0]<>0 and $this->everyCMonth[$Par["m"]][0]<$Par["d"])
        {
                $mm=$Par["d"]-1;
        }else{
                $mm=$Par["d"];
        }
        if ($Par["d"]==$this->everyCMonth[$Par["d"]][0]+1 and $this->everyCMonth[$Par["d"]][0]<>0)
        {
            $cMonth=$this->mmonth[0].$this->mmonth[$mm];#闰月
        }else{
            $cMonth=$this->mmonth[$mm].$this->mmonth[13];
        }
        return array("year"=>$this->mten[$this->everyCMonth[$Par["m"]][14]].$this->mtwelve[$this->everyCMonth[$Par["m"]][15]],
                    "month"=>$cMonth,
                    "day"=>$this->mday[$md],
                    "week"=>$week);
    }
}
/////调用
$test=new Calendar;
$Year=$test->Cal(2004,2,20);
echo $Year["year"]."年".$Year["month"].$Year["day"]."周".$Year["week"];
?>

原文：http://www.oschina.net/code/snippet_59519_1763

Posted in PHP

Tags: PHP, 农历, 转换, 阳历

没有评论 »

PHP+MySQL数据分页

Cody 发表于 2010-12-28 浏览次数: 653

<?php
if($_GET["page"]){
	$page=$_GET["page"];#获取要显示的页码
}else{
	$page=1;#没有参数传入时，显示第一页
}
$col=13;#每页显示记录条数
$p=($page-1)*$col;
mysql_connect("127.0.0.1:3306","root","");
mysql_query("set names gbk");
mysql_select_db("php");#数据库中需要事先建product表并插入数据，含有name和price字段。
$result=mysql_query("select * from product limit ".$p.",".$col."");
echo "
<table BORDER=1>
<tr>
<th>name</th>
<th>price</th>
</tr>
";
while($rs=mysql_fetch_object($result))
{
echo "<tr>
<td>".$rs->name."</td>
<td>".$rs->price."</td>
</tr>
";
}
echo "</table>";
$count=mysql_query("select name from product");#取得记录总条数
$num = mysql_num_rows($count)/$col;#计算页数
$num=ceil($num);#无条件小数进位确定总页数
mysql_close();
if($page==1){
	echo '上一页';
}else{
	echo "<a href=?page=".($page-1).">上一页</a>";
}
echo " 第".$page."页 ";
if($page==$num){
	echo '下一页<br>';
}else{
	echo "<a href='?page=".($page+1)."'>下一页</a><br>";
}

if($page==1){
}else{
	echo "<a href='?page=1'>第一页</a><<<";
}

for($i=-2;$i<=2;$i++){
	if(($page+$i)>$num||($page+$i)<1){

	}else{
		echo " <a href=?page=".($page+$i).">".($page+$i)."</a> ";
	}
}
if($page==$num){
}else{
	echo ">>><a href='?page=".$num."'>最后一页</a><br>";
}
?>
<form action="" method='get'>
跳转到<input type='text' name='page'>页
<input type='submit' value="确定">
</form>

原文：http://www.oschina.net/code/snippet_104588_2169

Posted in MySQL, PHP

Tags: MySQL, PHP, 分页, 数据

没有评论 »

PHP无损裁剪图片

Cody 发表于 2010-12-28 浏览次数: 711

<?php
$image = "jiequ.jpg"; // 原图
$imgstream = file_get_contents($image);
$im = imagecreatefromstring($imgstream);
$x = imagesx($im);//获取图片的宽
$y = imagesy($im);//获取图片的高

// 缩略后的大小
$xx = 140;
$yy = 200;

if($x>$y){
//图片宽大于高
    $sx = abs(($y-$x)/2);
    $sy = 0;
    $thumbw = $y;
    $thumbh = $y;
} else {
//图片高大于等于宽
    $sy = abs(($x-$y)/2.5);
    $sx = 0;
    $thumbw = $x;
    $thumbh = $x;
  }
if(function_exists("imagecreatetruecolor")) {
  $dim = imagecreatetruecolor($yy, $xx); // 创建目标图gd2
} else {
  $dim = imagecreate($yy, $xx); // 创建目标图gd1
}
imageCopyreSampled ($dim,$im,0,0,$sx,$sy,$yy,$xx,$thumbw,$thumbh);
header ("Content-type: image/jpeg");
imagejpeg ($dim, false, 100);
?>

原文：http://www.oschina.net/code/snippet_99943_2522

Posted in PHP

Tags: PHP, 图片, 无损, 裁剪

没有评论 »

字符串截取, 支持常用编码

Cody 发表于 2010-12-28 浏览次数: 707

/**
 * 字符串截取，支持中文和其他编码
 *
 * @static
 * @access public
 * @param string $str 需要转换的字符串
 * @param string $start 开始位置
 * @param string $length 截取长度
 * @param string $charset 编码格式
 * @param string $suffix 截断显示字符
 * @return string
 */
function msubstr($str, $start=0, $length, $charset="utf-8", $suffix=true)
{
    if(function_exists("mb_substr"))
         mb_substr($str, $start, $length, $charset);
    elseif(function_exists('iconv_substr')) {
         iconv_substr($str,$start,$length,$charset);
    }
    $re['utf-8']   = "/[\x01-\x7f]|[\xc2-\xdf][\x80-\xbf]|[\xe0-\xef][\x80-\xbf]{2}|[\xf0-\xff][\x80-\xbf]{3}/";
    $re['gb2312'] = "/[\x01-\x7f]|[\xb0-\xf7][\xa0-\xfe]/";
    $re['gbk']    = "/[\x01-\x7f]|[\x81-\xfe][\x40-\xfe]/";
    $re['big5']   = "/[\x01-\x7f]|[\x81-\xfe]([\x40-\x7e]|\xa1-\xfe])/";
    preg_match_all($re[$charset], $str, $match);
    $slice = join("",array_slice($match[0], $start, $length));
    if($suffix) return $slice."…";
    return $slice;
}

http://www.oschina.net/code/snippet_99943_2546

Posted in PHP

Tags: 字符串, 常用, 截取, 编码

没有评论 »

PHP判断输入是否是纯数字，英文，汉字等

Cody 发表于 2010-12-28 浏览次数: 860

<?php

/********
	判断输入是否是纯数字，英文，汉字等

利用php的mb_strlen和strlen函数就可以轻松得知字符串的构成
	是全英文、英汉混合、还是纯汉字。简要说明如下（以上示例程序）
	1、如果strlen返回的字符长度和mb_strlen以当前编码计算的长度一
	致，可以判断是纯英文字符串。
	2、如果strlen返回的字符长度和mb_strlen以当前编码计算的长度不一致，
	且strlen返回值同mb_strlen的返回值求余后得0可以判断为是全汉字的字符串。
	3、如果strlen返回的字符长度和mb_strlen以当前编码计算的长度不一致，
	且strlen返回值同mb_strlen的返回值求余后不为0，可以判断为是英汉混合的字符串。
*
* ****************/
$str = "456abc";
$x = mb_strlen($str,'gb2312');
$y = strlen($str); echo "------456abc----<br>";
echo "$x".'<br />';
echo "$y".'<br />';
$str = "456我是中国人abc<br />";
$x = mb_strlen($str,'gb2312');
$y = strlen($str);
echo "------456我是中国人abc----<br />";
echo "$x".'<br />'; echo "$y".'<br />';
$str = "我是中国人我爱祖国";
$x = mb_strlen($str,'gb2312');
$y = strlen($str);
echo "------我是中国人我爱祖国----<br />"; echo "$x".'<br />';
echo "$y".'<br />'; $str = "我";
$x = mb_strlen($str,'gb2312');
$y = strlen($str);
echo "------我----<br />"; echo "$x".'<br />';
echo "$y".'<br />';
$str = "我ab";
$x = mb_strlen($str,'gb2312');
$y = strlen($str);
echo "------我ab----<br />"; echo "$x".'<br />'; echo "$y".'<br />';
?>

Posted in PHP

Tags: PHP, 判断, 数字, 汉字, 英文

没有评论 »

PHP格式化日期

Cody 发表于 2010-12-28 浏览次数: 687

function ShowDate($flag=0, $timestr=NULL)
{
    // 获取周几
    $warr = array(
    "0" => 星期日,
    "1" => 星期一,
    "2" => 星期二,
    "3" => 星期三,
    "4" => 星期四,
    "5" => 星期五,
    "6" => 星期六
    );
    $i = date("w", $timeStamp);  

    // 设置北京时间并获取时间戳
    date_default_timezone_set('PRC');
    $timeStamp = NULL;
    if ($timestr)
        $timeStamp = strtotime($timestr);
    else
        $timeStamp = time();  

    // 设置时间显示格式
    $ret1 = date("Y年m月d日 H:m:s", $timeStamp) . " " . $warr[$i];
    $ret2 = date("Y-m-d H:m:s", $timeStamp) . " " . $warr[$i];
    $ret3 = date("y/m/d", $timeStamp);
    $ret = $ret1; // 默认返回第一种  

    if ($flag == 2)
        $ret = $ret2;
    else if ($flag == 3)
        $ret = $ret3;  

    return $ret;
}

原文：http://www.oschina.net/code/snippet_59519_1387

Posted in PHP

Tags: PHP, 日期, 格式化

没有评论 »

备份数据库为SQL文件

Cody 发表于 2010-12-28 浏览次数: 595

<!?php  

/******   备份数据库结构 ******/  

      /*
      函数名称：table2sql()
      函数功能：把表的结构转换成为SQL
      函数参数：$table: 要进行提取的表名
      返 回 值：返回提取后的结果，SQL集合
      函数作者：heiyeluren
      */  

     function table2sql($table)
      {
          global $db;
         $tabledump = "DROP TABLE IF EXISTS $table;\n";
         $createtable = $db--->query("SHOW CREATE TABLE $table");
         $create = $db->fetch_row($createtable);
         $tabledump .= $create[1].";\n\n";
          return $tabledump;
      }  

     /****** 备份数据库结构和所有数据 ******/
      /*
      函数名称：data2sql()
      函数功能：把表的结构和数据转换成为SQL
      函数参数：$table: 要进行提取的表名
      返 回 值：返回提取后的结果，SQL集合
      函数作者：heiyeluren
      */
     function data2sql($table)
      {
          global $db;
         $tabledump = "DROP TABLE IF EXISTS $table;\n";
         $createtable = $db->query("SHOW CREATE TABLE $table");
         $create = $db->fetch_row($createtable);
         $tabledump .= $create[1].";\n\n";  

         $rows = $db->query("SELECT * FROM $table");
         $numfields = $db->num_fields($rows);
         $numrows = $db->num_rows($rows);
          while ($row = $db->fetch_row($rows))
          {
             $comma = "";
             $tabledump .= "INSERT INTO $table VALUES(";
              for($i = 0; $i < $numfields; $i++)
              {
                 $tabledump .= $comma."'".mysql_escape_string($row[$i])."'";
                 $comma = ",";
              }
             $tabledump .= ");\n";
          }
         $tabledump .= "\n";  

          return $tabledump;
      }
?>  

<!--?php
$host="localhost"; //主机名
$user="root"; //MYSQL用户名
$password="root"; //密码
$dbname="dedecmsv4"; //备份的数据库       

mysql_connect($host,$user,$password);
mysql_select_db($dbname);       

$q1=mysql_query("show tables");
while($t=mysql_fetch_array($q1)){
$table=$t[0];
$q2=mysql_query("show create table `$table`");
$sql=mysql_fetch_array($q2);
$mysql.=$sql['Create Table'].";\r\n\r\n";#DDL       

$q3=mysql_query("select * from `$table`");
while($data=mysql_fetch_assoc($q3))
{
$keys=array_keys($data);
$keys=array_map('addslashes',$keys);
$keys=join('`,`',$keys);
$keys="`".$keys."`";
$vals=array_values($data);
$vals=array_map('addslashes',$vals);
$vals=join("','",$vals);
$vals="'".$vals."'";       

$mysql.="insert into `$table`($keys) values($vals);\r\n";
}
$mysql.="\r\n";       

}
$filename=date('Ymd')."_".$dbname.".sql"; //文件名为当天的日期
$fp = fopen($filename,'w');
fputs($fp,$mysql);
fclose($fp);
echo "数据备份成功,生成备份文件".$filename;
?>

原文：http://www.oschina.net/code/snippet_102132_1427

Posted in MySQL, PHP

Tags: SQL文, 备份, 数据库

没有评论 »

彻底解决跨浏览器下PHP下载文件名中的中文乱码问题

Cody 发表于 2010-12-28 浏览次数: 625

<?php  

$ua = $_SERVER["HTTP_USER_AGENT"];  

$filename = "中文 文件名.txt";  

$encoded_filename = urlencode($filename);  

$encoded_filename = str_replace("+", "%20", $encoded_filename);  

header('Content-Type: application/octet-stream');  

if (preg_match("/MSIE/", $ua)) {  

     header('Content-Disposition: attachment; filename="' . $encoded_filename . '"');  

} else if (preg_match("/Firefox/", $ua)) {  

     header('Content-Disposition: attachment; filename*="utf8\'\'' . $filename . '"');  

} else {  

     header('Content-Disposition: attachment; filename="' . $filename . '"');  

 }  

 print 'ABC';  

 ?>

Posted in PHP

Tags: PHP, 下载, 中文乱码, 解决, 跨浏览器

没有评论 »

PHP正则过滤html标签、空格、换行符

Cody 发表于 2010-12-23 浏览次数: 935

$str=preg_replace(“/\s+/”, ” “, $str); //过滤多余回车

$str=preg_replace(“/<[ ]+/si”,”<”,$str); //过滤<__(“<”号后面带空格)

$str=preg_replace(“/<\!–.*?–>/si”,”",$str); //注释

$str=preg_replace(“/<(\!.*?)>/si”,”",$str); //过滤DOCTYPE

(更多…)

Posted in PHP

Tags: HTML, PHP, 换行符, 标签, 正则、, 空格, 过滤

没有评论 »

‘PHP’ 存档

PHP 执行MySQL存储过程 can’t return a result set in the given context及参数解释

PHP阳历到农历转换的一个类

PHP+MySQL数据分页

PHP无损裁剪图片

字符串截取, 支持常用编码

PHP判断输入是否是纯数字，英文，汉字等

PHP格式化日期

备份数据库为SQL文件

彻底解决跨浏览器下PHP下载文件名中的中文乱码问题

PHP正则过滤html标签、空格、换行符

最新文章

存档

日历

Categories

友情链接

赞助商链接

最新的评论

功能

Ads

2012 年二月
一	二	三	四	五	六	日
« 十
		1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29