直接上代码了，每次直接使用test::getInstance() 获取对象，可以防止不必要的重复创建对象
class test {
protected static $handle;
public function __construct() {}
public static getInstance() {
if(empty(self::$hanlde)) {
self::$hanlde = new test();
}
return self::$hanlde;
}
}
1.htmlentities()函数：
说明：将html标签转换成特殊字符。例如将'";
//Lets make it safer before we use it
$userInputEntities = htmlentities($userInput);
//Now we can display it
echo $userInputEntities;
由于最近csdn的控件比较垃圾，请将上面的$apos改成单引号。---呼！
上面的语句执行后，将生成下面的结果
I am going to hax0r your site, hahaha!
'
2.html_entity_decode()函数
说明：将htmlentities()函数转义过的字符串转成html标签。
例子：
$orig = "I'll \"walk\" the dog now";
$a = htmlentities($orig);
$b = html_entity_decode($a);
echo $a; // I will "walk" the dog now
echo $b; // I will "walk" the dog now
$dir = './img/'; // 源图片目录
$i = 10; // 开始的导入用户uid
$size = 'big'; // 生成的图片大小 设置大小 (small,middle,big)
$files1 = scandir($dir);
foreach($files1 as $value) {
if($value!='.' && $value!='..' && $value!='Thumbs.db') {
$newdir = get_avatar($i,$size);
copyimage($dir.$value,$newdir,$size);
$i++;
}
}
//echo $i;
function get_avatar($uid, $size = 'middle', $type = '') {
$size = in_array($size, array('big', 'middle', 'small')) ? $size : 'middle';
$uid = abs(intval($uid));
$uid = sprintf("%09d", $uid);
$dir1 = substr($uid, 0, 3);
$dir2 = substr($uid, 3, 2);
$dir3 = substr($uid, 5, 2);
$typeadd = $type == 'real' ? '_real' : '';
if(!is_dir($dir1)) {
mkdir($dir1);
}
if(!is_dir($dir1.'/'.$dir2)) {
mkdir($dir1.'/'.$dir2);
}
if(!is_dir($dir1.'/'.$dir2.'/'.$dir3)) {
mkdir($dir1.'/'.$dir2.'/'.$dir3);
}
return $dir1.'/'.$dir2.'/'.$dir3.'/'.substr($uid, -2).$typeadd."_avatar_$size.jpg";
}
function copyimage($upfile,$newfile,$size = 'middle') {
if($size == 'middle'){$px = 160;}
if($size == 'small'){$px = 48;}
if($size == 'big'){$px = 200;}
$image_path=$upfile;
$image_info=getimagesize($image_path);
if($image_info[2]==2) {
$image2=imagecreatefromjpeg($image_path);
}
$image2_x=imagesx($image2);
$image2_y=imagesy($image2);
if($image2_x > $px) {
$x = $px;
$y = intval($px*$image2_y/$image2_x);
} else {
$y = $image2_y;
$x = $image2_x;
}
$image1=imagecreatetruecolor($x,$y);
imagecopyresized($image1,$image2,0,0,0,0,$x,$y,$image2_x,$image2_y);
$Img = imagejpeg($image1,$newfile);
}
?>
function compare($data1=0,$data2=0){
//regle:1<2<3<5<4<6<7<8<10<9
$tmp = array(1,2,3,5,4,6,7,8,10,9);
$cdata1=$cdata2=0;
foreach($tmp as $key=>$value){
if($data1==$value){
$cdata1=$key;
}
if($data2==$value){
$cdata2=$key;
}
}
return ($cdata1>$cdata2)?$data1:$data2;
}
简要情况如下
tableA(id,price)
tableB(pid,sid,shuliang)
其中tableA.id=tableB.pid,tableA.id=tableB.sid
大致意思是，
一个A可能由几个A元素组成，元素A有价格，组合A需要通过计算（每个元素A的价格x数量）得到价格
下面是目前想到的用法,使用了一个临时表，应该还有更好的解法
$list=array();
$bundle_id=ARRAY();
$sql="SELECT pb.bundle_id, sum(p.products_price*pb.subproduct_qty) as cout, sum(p.products_price_fournisseur*pb.subproduct_qty) as coutf FROM products p,products_bundles pb WHERE p.products_id=pb.subproduct_id GROUP BY pb.bundle_id";
$query=tep_db_query($sql);
while($value=tep_db_fetch_array($query)){
$list[]=$value;
}
if($list){
//clean the table
tep_db_query("DELETE FROM products_calculer_ensemble");
$insert="INSERT INTO products_calculer_ensemble VALUES";
$link='';
foreach($list as $value){
$insert.=$link."($value[bundle_id],$value[cout],$value[coutf])";
$link=',';
}
tep_db_query($insert);
tep_db_query("UPDATE products_calculer_ensemble SET coutf=0 WHERE coutf>0 AND pid IN (SELECT pb.bundle_id FROM products p,products_bundles pb WHERE p.products_id=pb.subproduct_id AND p.products_price_fournisseur=0)");
tep_db_query("UPDATE products p,products_calculer_ensemble pce SET p.products_price=pce.cout, p.products_price_fournisseur=pce.coutf WHERE p.products_id=pce.pid");
}
</div>
<div id="_mcePaste"><?php</div>
<div id="_mcePaste">$pot="/\d{1,4}(.*)\d{1,2}\\1\d{1,2}/";</div>
<div id="_mcePaste">$cont="2010-12-08";</div>
<div id="_mcePaste">if(preg_match($pot,$cont,$arr)){</div>
<div id="_mcePaste"><span style="white-space: pre;"> </span>echo "匹配成功".$arr[0];</div>
<div id="_mcePaste">}else{</div>
<div id="_mcePaste"><span style="white-space: pre;"> </span>echo "匹配不成功";</div>
<div id="_mcePaste">}</div>
<div id="_mcePaste">?></div>
<div id="_mcePaste">
</div>
<div id="_mcePaste"><?php</div>
<div id="_mcePaste">$str="aaa<bbb>ccc<dddd>eee";</div>
<div id="_mcePaste">$mode="/<.*>/U";</div>
<div id="_mcePaste">if(preg_match_all($mode,$str,$arr)){</div>
<div id="_mcePaste"><span style="white-space: pre;"> </span>echo "匹配成功".print_r($arr);</div>
<div id="_mcePaste">}else{</div>
<div id="_mcePaste"><span style="white-space: pre;"> </span>echo "匹配不成功";</div>
<div id="_mcePaste">}</div>
<div id="_mcePaste">?></div>
<div id="_mcePaste">
</div> <div id="_mcePaste"><?php</div> <div id="_mcePaste">$str="aaa<bbb>ccc<dddd>eee";</div> <div id="_mcePaste">$mode="/<.*>/U";</div> <div id="_mcePaste">echo preg_replace($mode,"替换内容",$str);</div> <div id="_mcePaste">?></div> <div id="_mcePaste">
</div>
<div id="_mcePaste"><?php</div>
<div id="_mcePaste">$str="aaa<bbb>ccc<dddd>eee";</div>
<div id="_mcePaste">$mode=array("/<bbb>/","/<dddd>/");</div>
<div id="_mcePaste">$m=array("/<yyy>/","/<mmmm>/");</div>
<div id="_mcePaste">echo preg_replace($mode,$m,$str);</div>
<div id="_mcePaste">?></div>
<div id="_mcePaste">
</div> <div id="_mcePaste"><?php</div> <div id="_mcePaste">$str="密码1:bbb\n密码2:BBB";</div> <div id="_mcePaste">$mode="/(bbb)/ie";</div> <div id="_mcePaste">//参数1为正则替换一次，如过2，这连后面的大写b也正则匹配了</div> <div id="_mcePaste">//preg_replace($mode,"md5(\\1)",$str,1);</div> <div id="_mcePaste">echo preg_replace($mode,"md5(\\1)",$str);</div> <div id="_mcePaste">?></div> <div id="_mcePaste">
</div>
<div id="_mcePaste"><?php</div>
<div id="_mcePaste">$str="asd,sdsa,efsd,we。dce,sec";</div>
<div id="_mcePaste">$mode="/[,.。]/";</div>
<div id="_mcePaste">$arr=preg_split($mode,$str);</div>
<div id="_mcePaste">for($i=0;$i<count($arr);$i++){</div>
<div id="_mcePaste"><span style="white-space: pre;"> </span>echo $arr[$i]."<br>";</div>
<div id="_mcePaste">}</div>
<div id="_mcePaste">?></div>
<div id="_mcePaste">
虽然国内建站在论坛方面首先考虑discuz(php),phpwind(php)和dvbbs(asp)。但是在国外使用phpbb还是比较多。
虽然以前前一直没用过也没听过phpbb，自然也没什么兴趣去看他的代码。但是前天的CMS课上，老师给我们4个小时的时间做一个给phpbb批量添加用户的脚本。
使用方法，修改相应的数据库连接代码，然后把这个文件方上服务器就可以了。上传文件用excel另存csv就可以了
添加单个用户
<div id="_mcePaste"><?php
$username = $_POST['username'];
$password = $_POST['password'];
$email = $_POST['email'];
if($username&&$password&&$email){
$bd = mysql_connect("localhost", "root", "root") or die('Connessione fallita' . mysql_error());
mysql_select_db('phpbb') or die('Selezione Database' . mysql_error());
$pass = md5($password);
$now = time();
$check=mysql_query("SELECT * FROM users WHERE username='$username' OR user_email='$email'") or die(mysql_error());
if(!mysql_fetch_array($check)){
$sql = "INSERT INTO `users` (`user_type`, `group_id`, `user_permissions`, `user_perm_from`, `user_ip`, `user_regdate`, `username`, `username_clean`, `user_password`, `user_passchg`, `user_pass_convert`, `user_email`, `user_email_hash`, `user_birthday`, `user_lastvisit`, `user_lastmark`, `user_lastpost_time`, `user_lastpage`, `user_last_confirm_key`, `user_last_search`, `user_warnings`, `user_last_warning`, `user_login_attempts`, `user_inactive_reason`, `user_inactive_time`, `user_posts`, `user_lang`, `user_timezone`, `user_dst`, `user_dateformat`, `user_style`, `user_rank`, `user_colour`, `user_new_privmsg`, `user_unread_privmsg`, `user_last_privmsg`, `user_message_rules`, `user_full_folder`, `user_emailtime`, `user_topic_show_days`, `user_topic_sortby_type`, `user_topic_sortby_dir`, `user_post_show_days`, `user_post_sortby_type`, `user_post_sortby_dir`, `user_notify`, `user_notify_pm`, `user_notify_type`, `user_allow_pm`, `user_allow_viewonline`, `user_allow_viewemail`, `user_allow_massemail`, `user_options`, `user_avatar`, `user_avatar_type`, `user_avatar_width`, `user_avatar_height`, `user_sig`, `user_sig_bbcode_uid`, `user_sig_bbcode_bitfield`, `user_from`, `user_icq`, `user_aim`, `user_yim`, `user_msnm`, `user_jabber`, `user_website`, `user_occ`, `user_interests`, `user_actkey`, `user_newpasswd`, `user_form_salt`, `user_new`, `user_reminded`, `user_reminded_time`) VALUES
(0, 2, 0x3030303030303030303036787271656977770a6931636a796f3030303030300a716c61713532303030303030, 0, '127.0.0.1', $now, '$username', '$username', '$pass', $now, 0, '$email', 282589336312, '', $now, $now, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 'en', 1.00, 0, 'D M d, Y g:i a', 1, 0, '', 0, 0, 0, 0, -3, 0, 0, 't', 'd', 0, 't', 'a', 0, 1, 0, 1, 1, 1, 1, 230271, '', 0, 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'b3926a7717a7ca0d', 1, 0, 0);";
mysql_query($sql);
echo "Success<br/>";
}else{
echo "Failed! username or email used<br/>";
}
}
?>
<html>
<head>
<title>Add user</title>
</head>
<body>
<form action="#" method="post">
<label>username:<input name="username"/></label>
<label>password:<input type="password" name="password"/></label>
<label>email:<input name="email"/></label>
<input type="submit" value="submit"/>
</form>
<a href="adduser.php">Ajouter un compte</a>
<a href="addusers.php">Ajouter multi comptes</a>
</body>
</html></div>
使用csv文件批量添加用户
<?php
$csv=$_FILES["csv"];
if($csv&&$csv["type"]=="text/csv"){
$list=file($csv["tmp_name"]);
if($list){
$bd = mysql_connect("localhost", "root", "root") or die('Connessione fallita' . mysql_error());
mysql_select_db('phpbb') or die('Selezione Database' . mysql_error());
foreach($list as $value){
list($username,$password,$email)=explode(";",$value);
if($username&&$password&&$email){
addusers($username,$password,$email);
}
unset($username,$password,$email);
}
echo "success";
}
}
function addusers($username,$password,$email){
$pass = md5($password);
$now = time();
$check=mysql_query("SELECT * FROM users WHERE username='$username' OR user_email='$email'") or die(mysql_error());
if(!mysql_fetch_array($check)){
mysql_query("INSERT INTO `users` (`user_type`, `group_id`, `user_permissions`, `user_perm_from`, `user_ip`, `user_regdate`, `username`, `username_clean`, `user_password`, `user_passchg`, `user_pass_convert`, `user_email`, `user_email_hash`, `user_birthday`, `user_lastvisit`, `user_lastmark`, `user_lastpost_time`, `user_lastpage`, `user_last_confirm_key`, `user_last_search`, `user_warnings`, `user_last_warning`, `user_login_attempts`, `user_inactive_reason`, `user_inactive_time`, `user_posts`, `user_lang`, `user_timezone`, `user_dst`, `user_dateformat`, `user_style`, `user_rank`, `user_colour`, `user_new_privmsg`, `user_unread_privmsg`, `user_last_privmsg`, `user_message_rules`, `user_full_folder`, `user_emailtime`, `user_topic_show_days`, `user_topic_sortby_type`, `user_topic_sortby_dir`, `user_post_show_days`, `user_post_sortby_type`, `user_post_sortby_dir`, `user_notify`, `user_notify_pm`, `user_notify_type`, `user_allow_pm`, `user_allow_viewonline`, `user_allow_viewemail`, `user_allow_massemail`, `user_options`, `user_avatar`, `user_avatar_type`, `user_avatar_width`, `user_avatar_height`, `user_sig`, `user_sig_bbcode_uid`, `user_sig_bbcode_bitfield`, `user_from`, `user_icq`, `user_aim`, `user_yim`, `user_msnm`, `user_jabber`, `user_website`, `user_occ`, `user_interests`, `user_actkey`, `user_newpasswd`, `user_form_salt`, `user_new`, `user_reminded`, `user_reminded_time`) VALUES
(0, 2, 0x3030303030303030303036787271656977770a6931636a796f3030303030300a716c61713532303030303030, 0, '127.0.0.1', $now, '$username', '$username', '$pass', $now, 0, '$email', 282589336312, '', $now, $now, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 'en', 1.00, 0, 'D M d, Y g:i a', 1, 0, '', 0, 0, 0, 0, -3, 0, 0, 't', 'd', 0, 't', 'a', 0, 1, 0, 1, 1, 1, 1, 230271, '', 0, 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'b3926a7717a7ca0d', 1, 0, 0);");
}
}
?>
<html>
<head>
<title>Ajouter multi comptes</title>
</head>
<body>
<form action="#" method="post" enctype="multipart/form-data">
<label>csv:<input type="file" name="csv"/></label>
<input type="submit" value="submit"/>
</form>
<a href="adduser.php">Ajouter un compte</a>
<a href="addusers.php">Ajouter multi comptes</a>
</body>
</html>
UNICODE编码在PHP中使用UCS-2编码
直接上代码了
//将内容进行UNICODE编码，编码后的内容格式：YOKA\u738b （原始：YOKA王）
function unicode_encode($name)
{
$name = iconv('UTF-8', 'UCS-2', $name);
$len = strlen($name);
$str = '';
for ($i = 0; $i < $len - 1; $i = $i + 2)
{
$c = $name[$i];
$c2 = $name[$i + 1];
if (ord($c) > 0)
{ // 两个字节的文字
$str .= '\u'.base_convert(ord($c), 10, 16).base_convert(ord($c2), 10, 16);
}
else
{
$str .= $c2;
}
}
return $str;
}
// 将UNICODE编码后的内容进行解码，编码后的内容格式：YOKA\u738b （原始：YOKA王）
function unicode_decode($name)
{
// 转换编码，将Unicode编码转换成可以浏览的utf-8编码
$pattern = '/([\w]+)|(\\\u([\w]{4}))/i';
preg_match_all($pattern, $name, $matches);
if (!empty($matches))
{
$name = '';
for ($j = 0; $j < count($matches[0]); $j++)
{
$str = $matches[0][$j];
if (strpos($str, '\\u') === 0)
{
$code = base_convert(substr($str, 2, 2), 16, 10);
$code2 = base_convert(substr($str, 4), 16, 10);
$c = chr($code).chr($code2);
$c = iconv('UCS-2', 'UTF-8', $c);
$name .= $c;
}
else
{
$name .= $str;
}
}
}
return $name;
}
