Mysql - 多表查询
2017-07-20 •
1 条评论
member 表: uuid, username. people 表: uuid, name.
$userinfo = json_decode($userinfo, true);
$count = json_decode(json_encode($count), true);
foreach($simplelist as $obj){
echo "姓名:".$obj->name." uerid:".$obj->userid."<br/>";
}
var arr1 = new Array(3);
arr1[0] = "a";
arr1[1] = "b";
arr1[2] = "c";
arr1[3] = "d";
var arr2 = new Array(3);
arr2[0] = "x";
arr2[1] = "y";
arr2[2] = "z";
console.log(arr1);
console.log(arr2);
var length = arr1.length;
console.log(length);
var arr3 = new Array(3);
for(var j=0;j<length;j++){
var a = 2*j;
console.log(a);
var b = 2*j+1;
console.log(b);
arr3[a]=arr1[j];
arr3[b]=arr2[j];
}
console.log(arr3);
var str = arr3.join("");
console.log(str);
//axbyczd
//清空文件操作
function delDirAndFile($dirName){
if($handle = opendir("$dirName")){
while(false !== ($item = readdir($handle))){
if($item != "." && $item != ".."){
if(is_dir("$dirName/$item")){
delDirAndFile("$dirName/$item");
}else{
if(unlink("$dirName/$item")){
//echo "成功删除文件: $dirName/$item\n";
}
}
}
}
closedir($handle);
if(rmdir($dirName)){
//echo "成功删除目录: $dirName\n";
}
}
}
//遍历目录下的文件
function rmdi_r($dirname){
//判断是否为一个目录,非目录直接关闭
if(is_dir($dirname)){
//如果是目录,打开他
$name = opendir($dirname);
//使用while循环遍历
$i = 0;
while($file = readdir($name)){
//去掉本目录和上级目录的点
if($file == "." || $file == ".."){
continue;
}
//如果目录里面还有一个目录,再次回调
if(is_dir($dirname."/".$file)){
rmdi_r($dirname."/".$file);
}
//exit();
//如果目录里面是个文件,那么输出文件名
if(is_file($dirname."/".$file)){
echo "<li class=''>序号:".($i+1)."|路径:".$dirname."/".$file."</li>";
}
$i++;
}
//遍历完毕关闭文件
closedir($name);
//输出目录名
//echo("目录名称:".$dirname);
echo "<b>当下目录内还有".$i."个文件</b>";
if($i == 0){//目录为空提示语
echo "该目录为空";
}else{}
}
}
html {
filter: grayscale(100%);/*IE浏览器*/
-webkit-filter: grayscale(100%);/*谷歌浏览器*/
-moz-filter: grayscale(100%);/*火狐*/
-ms-filter: grayscale(100%);/*IE*/
-o-filter: grayscale(100%);/*opera*/
filter:progid:DXImageTransform.Microsoft.BasicImage(grayscale=1);/*兼容*/
-webkit-filter: grayscale(1);/*谷歌浏览器*/
}