實現MySQL書架的后臺操作流程

$text = serialize($arr);//序列化該數組 
insert into bookshelf (uid shelf) values( "$text" ,'$uid');//插入初始化數據 
//添加書架，書架'shelf1' 名字要唯一 
$shelfs=select shelf from bookshelf where uid = '$uid';//查詢出uid 的書架 
$a = unserialize($shelfs);//反序列化MySQL書架得到數組， 
for(int i=0;i
if($(a)[0]==shelf1){ 
return "此書架以存在"; 
} 
return true; 
} 
$p = array('shelf1'=>'0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0'); 
$p = serialize($p);//插入新書架 
insert into bookshelf shelf values ('$p') where uid = '$uid'; 
//添加書籍 book1 'bid1'到書架shelf1 
$shelfs1 = select shelf from bookshelf where uid = '$uid';// 
$b = unserialize($shelfs1);// 
for(int i=0;i
if($b[i][0]=='$shelf1'){//得到要插入的MySQL書架 
$pk = explode('-','$b[i][1]); 
for(int num=1;num
if($pk[1][i]==0){ 
for(int k=1;k
if($pk[i][1]=='$bid1'){ 
return '此書架已有此時'; 
}else{//書架中沒有此書可以插入 默認插入到后面 
if($pk[i][1]==0){ 
$pk[i][1]==$bid1;//插入數組 
return implode("-",$pk[i]);//返回字符串 
} 
}else 
return "此書架以放滿"; 
} 
//讀取書架 用于在加入書架時顯示的列表 書籍數量 存入一個數組中 
$arr = new array(); 
$shlefs = select shelf from bookshelf where uid ='$uid';// 
$ss = unsersize($shelfs);//反序列化MySQL書架信息 
for(int nn=1;nn
$key =$ss[i][0]; 
$value=0; 
$n = explode("-",$ss[i][1]); 
for(int mm=1;mm
if($n[1] !=0){ 
$value++; 
} 
$arr[0]=$key; 
$arr[1]=$value; 
} 
//移動書籍 把bid2 從5位置移動到8位置 
$startpos = 2; 
$endpos = 8; 
if($startpos<0 || $startpos>20 || $endpos<0 || $endpos>20 || $startpos==$endpos)exit; 
$shelf = $_db->fetch_first("select * from `sns_shelf` where `uid`={$uid}"); 
$shelf select shelf from bookshelf wher uid ='$uid'; 
$shelfs=unserisize($shelf);// 
feach($shelfs as $key ,$value){ 
$array = explode("-",$value); 
if($array[1] == 'bid2'){找到bid2所在的MySQL書架 
if($sarry[1][$startpos]==0)exit;//如果開始位置沒有書不交換 
$temp = $sarry[1][$endpos];//交換位置 
$sarry[1][$endpos]=$sarry[1][$startpos]; 
$sarry[1][$startpos]=$temp; 
$val = implode("-",$value[1]); 
$shelfs[1] = $val; 
serialize($shelfsl);//序列化shelf 
update bookshelf set shelf = shelfs where uid = '$uid'; 
更新 
} 
}