PHP操作技巧

mysql_query("select count(*) from table") //得到字段的结果数

******

rand(0,10) //随机数获取

*******

PHP、MySql防止重复插入： mysql_query("insert ignore into table(str) values(insertstr)",$connw);

******

时间的加减运算，返回时间戳： mktime(0,0,0,date("m"),date("d")+5,date("Y")); //前面三个零是小时、分钟、秒

*******

正则： ereg/eregi(正则,字符串) //匹配返回true,否则false eregi不区分大小写

以上是匹配字符串

查找字符串范例：

    if(preg_match("/\d{11}/",$number,$mobile)){   //mobile是把找到的字符串存储到这个数组中 
        echo "OK";
        //验证通过    
            
    }else{    
        //手机号码格式不对    
            echo "NO";
    } 

 

************

转换编码： mb_convert_encoding(str,"UTF-8","GBK"); iconv("gb2312","utf-8",$hang);

*********

用PHP邮件函数发送邮件

function mailsend($to,$subject,$neirong,$reply,$from)
{
$subject = iconv("utf-8","gb2312",$subject); //防止乱码
$message = $neirong;
$headers = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=utf-8' . "\r\n"; //Additional headers
$headers .= 'Reply-To: '.$reply . "\r\n";
$headers .= 'From: '.$from . "\r\n";
mail($to,$subject,$message,$headers);
}
mailsend("邮件地址","测试邮件","测试内容","webmaster@www.com","webmaster@www.com");
mail("邮件地址",iconv("utf-8","gb2312","测试邮件a"),"测试内容",'From:webmaster@www.com'."\r\n".'Reply-To:webmaster@www.com');

 ***********************************

升序和降序查找Mysql

$result=mysql_query("select * from cheliangdangan order by xuhao",$this->connw);//升序

$result=mysql_query("select * from cheliangdangan order by xuhao desc",$this->connw);//降序

 ***********************************

多字段模糊查询

$result=mysql_query("select * from dingdan where(
diyilianxirendianhua like '%".$tiaojian."%'
or yongchedanwei like '%".$tiaojian."%'
or xingchengmiaoshu like '%".$tiaojian."%'
or cheliang like '%".$tiaojian."%'
or xuhao like '%".$tiaojian."%'
or dierlianxirendianhua like '%".$tiaojian."%'
or userid like '%".$tiaojian."%'
)",$this->connw)or die("查找历史定单出错，请联系管理员，出错信息为：".mysql_error());

 int、text和字符都要统一格式，不然会出错

************************************

小数取整

intval($height*$bili)

************************************

得到图片尺寸

list($width, $height, $type, $attr) = getimagesize("./users/".$jieguo['ID']."/jpg/touxiang.jpg");