小弟刚学习php,请问要怎么把如下数据库的数据转换成二维数组的形式,非常感谢!
$books = array(
"1" => array("1101" => 3, "1102" => 5,"1103" => 2,),
"2" => array("1101" => 2, "1102" => 5),
"3" => array("1102" => 5)
);
小弟刚学习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);