<table width="1000" border="1">
<tbody>
<tr>
<td> </td>
<td> </td>
<td>12.15</td>
<td>12.14</td>
</tr>
<tr>
<td rowspan="4">广场店 </td>
<td>到店</td>
<td>10人</td>
<td>2人</td>
</tr>
<tr>
<td>取消</td>
<td>5人</td>
<td>1人</td>
</tr>
<tr>
<td>初次</td>
<td>5人</td>
<td>1人</td>
</tr>
<tr>
<td>第二次</td>
<td>5人</td>
<td>1人</td>
</tr>
<tr>
<td rowspan="4">火车站店 </td>
<td>到店</td>
<td>10人</td>
<td>2人</td>
</tr>
<tr>
<td>取消</td>
<td>5人</td>
<td>1人</td>
</tr>
<tr>
<td>初次</td>
<td>5人</td>
<td>1人</td>
</tr>
<tr>
<td>第二次</td>
<td>5人</td>
<td>1人</td>
</tr>
</tbody>
</table>我的数据文件如下:Array
(
[0] => Array
(
[0] => 324
[id] => 324
[1] => 5
[orderingcomein] => 5
[2] => 5
[iscomein] => 5
[3] => 2015-12-08
[day1] => 2015-12-08
[4] => 1
[daytype] => 1
[5] => 4
[reportcount] => 4
) [1] => Array
(
[0] => 325
[id] => 325
[1] => 5
[orderingcomein] => 5
[2] => 6
[iscomein] => 6
[3] => 2015-12-08
[day1] => 2015-12-08
[4] => 1
[daytype] => 1
[5] => 4
[reportcount] => 4
) [2] => Array
(
[0] => 330
[id] => 330
[1] => 6
[orderingcomein] => 6
[2] => 5
[iscomein] => 5
[3] => 2015-12-08
[day1] => 2015-12-08
[4] => 1
[daytype] => 1
[5] => 7
[reportcount] => 7
) [3] => Array
(
[0] => 331
[id] => 331
[1] => 6
[orderingcomein] => 6
[2] => 6
[iscomein] => 6
[3] => 2015-12-08
[day1] => 2015-12-08
[4] => 1
[daytype] => 1
[5] => 7
[reportcount] => 7
) [4] => Array
(
[0] => 335
[id] => 335
[1] => 9
[orderingcomein] => 9
[2] => 5
[iscomein] => 5
[3] => 2015-12-08
[day1] => 2015-12-08
[4] => 1
[daytype] => 1
[5] => 11
[reportcount] => 11
) [5] => Array
(
[0] => 336
[id] => 336
[1] => 9
[orderingcomein] => 9
[2] => 6
[iscomein] => 6
[3] => 2015-12-08
[day1] => 2015-12-08
[4] => 1
[daytype] => 1
[5] => 11
[reportcount] => 11
) [6] => Array
(
[0] => 340
[id] => 340
[1] => 14
[orderingcomein] => 14
[2] => 5
[iscomein] => 5
[3] => 2015-12-08
[day1] => 2015-12-08
[4] => 1
[daytype] => 1
[5] => 3
[reportcount] => 3
) [7] => Array
(
[0] => 341
[id] => 341
[1] => 14
[orderingcomein] => 14
[2] => 6
[iscomein] => 6
[3] => 2015-12-08
[day1] => 2015-12-08
[4] => 1
[daytype] => 1
[5] => 3
[reportcount] => 3
) [8] => Array
(
[0] => 346
[id] => 346
[1] => 5
[orderingcomein] => 5
[2] => 5
[iscomein] => 5
[3] => 2015-12-09
[day1] => 2015-12-09
[4] => 1
[daytype] => 1
[5] => 3
[reportcount] => 3
) [9] => Array
(
[0] => 347
[id] => 347
[1] => 5
[orderingcomein] => 5
[2] => 6
[iscomein] => 6
[3] => 2015-12-09
[day1] => 2015-12-09
[4] => 1
[daytype] => 1
[5] => 3
[reportcount] => 3
) [10] => Array
(
[0] => 354
[id] => 354
[1] => 9
[orderingcomein] => 9
[2] => 5
[iscomein] => 5
[3] => 2015-12-09
[day1] => 2015-12-09
[4] => 1
[daytype] => 1
[5] => 12
[reportcount] => 12
) [11] => Array
(
[0] => 355
[id] => 355
[1] => 9
[orderingcomein] => 9
[2] => 6
[iscomein] => 6
[3] => 2015-12-09
[day1] => 2015-12-09
[4] => 1
[daytype] => 1
[5] => 12
[reportcount] => 12
) [12] => Array
(
[0] => 360
[id] => 360
[1] => 14
[orderingcomein] => 14
[2] => 5
[iscomein] => 5
[3] => 2015-12-09
[day1] => 2015-12-09
[4] => 1
[daytype] => 1
[5] => 3
[reportcount] => 3
) [13] => Array
(
[0] => 361
[id] => 361
[1] => 14
[orderingcomein] => 14
[2] => 6
[iscomein] => 6
[3] => 2015-12-09
[day1] => 2015-12-09
[4] => 1
[daytype] => 1
[5] => 3
[reportcount] => 3
))其中orderingcomein定义,5=>广场店 , 6=>'火车站 店, iscomein定义,0-到店,1-取消,6-初次,5-第二次 ,reportcount是人次我想把数据填充到这个表格去,弄了好多方法都不行,麻烦哪位给看看
解决方案 »
- php mysql select 报
- mysql某字段设置为“唯一”后,就无法再插入相同记录了吗?
- Cannot modify header information
- 推荐一下自己的网站,散散分
- 有用过mb_convert_encoding函数的吗?我将utf-8转换为gbk的时候,空格变成了???
- 菜鸟问题:EOT是什么东东?EOT;和<<<EOT是什么意思啊?
- php中creole都支持那些数据库啊?
- 如何把选择的复选框从数据库中删掉。小弟我编写如下代码,但是错误的,请帮忙指正一下。
- system函数无法执行gcc指令
- 怎么用navcat修改wordpress所有域名
- thinkphp怎么提交表单保存表单中标签的值进数据库
- zabbix
0 =>
array (
0 => '324',
'id' => '324',
1 => '5',
'orderingcomein' => '5',
2 => '5',
'iscomein' => '5',
3 => '2015-12-08',
'day1' => '2015-12-08',
4 => '1',
'daytype' => '1',
5 => '4',
'reportcount' => '4',
),
1 =>
array (
0 => '325',
'id' => '325',
1 => '5',
'orderingcomein' => '5',
2 => '6',
'iscomein' => '6',
3 => '2015-12-08',
'day1' => '2015-12-08',
4 => '1',
'daytype' => '1',
5 => '4',
'reportcount' => '4',
),
2 =>
array (
0 => '330',
'id' => '330',
1 => '6',
'orderingcomein' => '6',
2 => '5',
'iscomein' => '5',
3 => '2015-12-08',
'day1' => '2015-12-08',
4 => '1',
'daytype' => '1',
5 => '7',
'reportcount' => '7',
),
3 =>
array (
0 => '331',
'id' => '331',
1 => '6',
'orderingcomein' => '6',
2 => '6',
'iscomein' => '6',
3 => '2015-12-08',
'day1' => '2015-12-08',
4 => '1',
'daytype' => '1',
5 => '7',
'reportcount' => '7',
),
4 =>
array (
0 => '335',
'id' => '335',
1 => '9',
'orderingcomein' => '9',
2 => '5',
'iscomein' => '5',
3 => '2015-12-08',
'day1' => '2015-12-08',
4 => '1',
'daytype' => '1',
5 => '11',
'reportcount' => '11',
),
5 =>
array (
0 => '336',
'id' => '336',
1 => '9',
'orderingcomein' => '9',
2 => '6',
'iscomein' => '6',
3 => '2015-12-08',
'day1' => '2015-12-08',
4 => '1',
'daytype' => '1',
5 => '11',
'reportcount' => '11',
),
6 =>
array (
0 => '340',
'id' => '340',
1 => '14',
'orderingcomein' => '14',
2 => '5',
'iscomein' => '5',
3 => '2015-12-08',
'day1' => '2015-12-08',
4 => '1',
'daytype' => '1',
5 => '3',
'reportcount' => '3',
),
7 =>
array (
0 => '341',
'id' => '341',
1 => '14',
'orderingcomein' => '14',
2 => '6',
'iscomein' => '6',
3 => '2015-12-08',
'day1' => '2015-12-08',
4 => '1',
'daytype' => '1',
5 => '3',
'reportcount' => '3',
),
8 =>
array (
0 => '346',
'id' => '346',
1 => '5',
'orderingcomein' => '5',
2 => '5',
'iscomein' => '5',
3 => '2015-12-09',
'day1' => '2015-12-09',
4 => '1',
'daytype' => '1',
5 => '3',
'reportcount' => '3',
),
9 =>
array (
0 => '347',
'id' => '347',
1 => '5',
'orderingcomein' => '5',
2 => '6',
'iscomein' => '6',
3 => '2015-12-09',
'day1' => '2015-12-09',
4 => '1',
'daytype' => '1',
5 => '3',
'reportcount' => '3',
),
10 =>
array (
0 => '354',
'id' => '354',
1 => '9',
'orderingcomein' => '9',
2 => '5',
'iscomein' => '5',
3 => '2015-12-09',
'day1' => '2015-12-09',
4 => '1',
'daytype' => '1',
5 => '12',
'reportcount' => '12',
),
11 =>
array (
0 => '355',
'id' => '355',
1 => '9',
'orderingcomein' => '9',
2 => '6',
'iscomein' => '6',
3 => '2015-12-09',
'day1' => '2015-12-09',
4 => '1',
'daytype' => '1',
5 => '12',
'reportcount' => '12',
),
12 =>
array (
0 => '360',
'id' => '360',
1 => '14',
'orderingcomein' => '14',
2 => '5',
'iscomein' => '5',
3 => '2015-12-09',
'day1' => '2015-12-09',
4 => '1',
'daytype' => '1',
5 => '3',
'reportcount' => '3',
),
13 =>
array (
0 => '361',
'id' => '361',
1 => '14',
'orderingcomein' => '14',
2 => '6',
'iscomein' => '6',
3 => '2015-12-09',
'day1' => '2015-12-09',
4 => '1',
'daytype' => '1',
5 => '3',
'reportcount' => '3',
),
);
$orderingcomein = array(5 => '广场店', 6 => '火车站 店');
$iscomein = array(0 => '到店', 1 => '取消', 6 => '初次', 5 => '第二次');
echo "<table>\n";
foreach($data as $row) {
echo "<tr>\n";
foreach($row as $k=>$v) {
if(is_numeric($k)) continue;
if(isset($$k) && isset(${$k}[$v])) $v = ${$k}[$v];
echo "<td>$v</td>";
}
echo "</tr>\n";
}
echo "</table>";<table>
<tr>
<td>324</td><td>广场店</td><td>第二次</td><td>2015-12-08</td><td>1</td><td>4</td></tr>
<tr>
<td>325</td><td>广场店</td><td>初次</td><td>2015-12-08</td><td>1</td><td>4</td></tr>
<tr>
<td>330</td><td>火车站 店</td><td>第二次</td><td>2015-12-08</td><td>1</td><td>7</td></tr>
<tr>
<td>331</td><td>火车站 店</td><td>初次</td><td>2015-12-08</td><td>1</td><td>7</td></tr>
<tr>
<td>335</td><td>9</td><td>第二次</td><td>2015-12-08</td><td>1</td><td>11</td></tr>
<tr>
<td>336</td><td>9</td><td>初次</td><td>2015-12-08</td><td>1</td><td>11</td></tr>
<tr>
<td>340</td><td>14</td><td>第二次</td><td>2015-12-08</td><td>1</td><td>3</td></tr>
<tr>
<td>341</td><td>14</td><td>初次</td><td>2015-12-08</td><td>1</td><td>3</td></tr>
<tr>
<td>346</td><td>广场店</td><td>第二次</td><td>2015-12-09</td><td>1</td><td>3</td></tr>
<tr>
<td>347</td><td>广场店</td><td>初次</td><td>2015-12-09</td><td>1</td><td>3</td></tr>
<tr>
<td>354</td><td>9</td><td>第二次</td><td>2015-12-09</td><td>1</td><td>12</td></tr>
<tr>
<td>355</td><td>9</td><td>初次</td><td>2015-12-09</td><td>1</td><td>12</td></tr>
<tr>
<td>360</td><td>14</td><td>第二次</td><td>2015-12-09</td><td>1</td><td>3</td></tr>
<tr>
<td>361</td><td>14</td><td>初次</td><td>2015-12-09</td><td>1</td><td>3</td></tr>
</table>