小弟刚学习php,请问要怎么把如下数据库的数据转换成二维数组的形式,非常感谢!
$books = array(
"1" => array("1101" => 3, "1102" => 5,"1103" => 2,),
"2" => array("1101" => 2, "1102" => 5),
"3" => array("1102" => 5)
);
//连接数据库,分别输入地址,用户名,密码
$con = mysqli_connect('localhost','mysqlUserName','mysqlPassword');
//选择数据库,输入数据库名
mysqli_select_db('dbName',$con);
//执行SQL语句,搜索表
$result = mysqli_query("SELECT * FROM TABLE_NAME ");
//根据搜索结果取得数组
$books = mysqli_fetch_array($result);
//输出数组
var_dump($book);
不好意思刚才没看清题目,这个用foreach就可以解决
foreach($data as $value){
switch($value['uid']){
case 1:
$book[1] = array($value['bookid']=>$value['score']);
break;
case 2:
$book[2] = array($value['bookid']=>$value['score']);
break;
case 3:
$book[3] = array($value['bookid']=>$value['score']);
break;
}
}