TO:xuzuning(唠叨)
例如数组为:
$data = array(
1 => array(名称=>"甲",单价=>100.00),
2 => array(名称=>"乙",单价=>110.00),
3 => array(名称=>"丙",单价=>90.00),
4 => array(名称=>"丁",单价=>10.00),
5 => array(名称=>"戊",单价=>30.00),
6 => array(名称=>"己",单价=>50.00),
);
表结构为:
name and price
例如数组为:
$data = array(
1 => array(名称=>"甲",单价=>100.00),
2 => array(名称=>"乙",单价=>110.00),
3 => array(名称=>"丙",单价=>90.00),
4 => array(名称=>"丁",单价=>10.00),
5 => array(名称=>"戊",单价=>30.00),
6 => array(名称=>"己",单价=>50.00),
);
表结构为:
name and price
array_multisort -- 对多个数组或多维数组进行排序排序后再写入数据库可以了吧?
$data = array(
1 => array(名称=>"甲",单价=>100.00),
2 => array(名称=>"乙",单价=>110.00),
3 => array(名称=>"丙",单价=>90.00),
4 => array(名称=>"丁",单价=>10.00),
5 => array(名称=>"戊",单价=>30.00),
6 => array(名称=>"己",单价=>50.00),
);$sql = "insert into 表 (name,price) values ";
$ch = "";
foreach($data as $v) {
$sql .= $ch."('".join("','",$v)."')";
$ch = ",";
}
mysql_query($sql);或
foreach($data as $v) {
mysql_query("insert into 表 (name,price) values ('$v[名称]',$v[单价])");
}
$arr = array("one", "two", "three");
foreach ($arr as $value) {
echo "Value: $value<br>\n";
我已经用FOR循环来解决了。
以前为什么老是出错, 是因为我的一个逗号标错。结贴了