帮忙写个表格样式,不难的
就是一个把我要
输出数据的表格美观一化,我要做为长期之类板,以后一生中便可直接套用。我的原样子如下。众好汉,请发挥你们的才智。原代码及样子如一:
<!-- Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/ --> .menu{ background:#9CF; display:block; } .menu ul{ list-style-type:none;} .menu li{ float:left; margin:0 3px; } .menu li a:hover{ background-color:#91f491; color:white; border-bottom:solid 1px #91f491; } .menu li a#current{ background-color:#0ce; color:white; border-bottom:none; } .one{ margin-top:20px; overflow-x:scroll; } .one a{ color:#00F; text-decoration:underline;}
<!-- Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/ --><div class="menu"><a href="main.php?o=price">数据维护</a></div> <div class="one"> <?php $q=$m->query('select * from whole where date=(select max(date) from whole) group by pol');while($r=$q->fetch_array(MYSQLI_USE_RESULT)){$op.='<option value="'.$r[id].'">'.$r[pol].'</option>';} $q2=$m->query('select * from whole where date=(select max(date) from whole) group by province');while($r2=$q2->fetch_array(MYSQLI_USE_RESULT)){$op2.='<option value="t.php?i='.$r2[id].'">'.$r2[province].'</option>';} ?> <form name="123" method="post" action=""> <table border="1" class="tb"> <tr> <td>起运地</td> <td colspan="2"><select name="pol"><option value="">-请选择-</option> <?php echo $op;?></select></td> </tr> <tr> <td width="10%">终到地</td> <td width="15%"><select name="dest" onchange="chk(this,'pod')"><option value="">-请选择-</option> <?php echo $op2;?></select></td> <td id="pod" width="75%"></td> </tr> <tr> <td><input type="submit" name="ok" value="提交/ok"></td> <td></td> <td></td> </tr> </table> </form> <?php if($_POST[pod]){ $p=0; $q3=$m->query("select * from whole where pod=(select pod from whole where id='".$_POST[pod]."') and pol=(select pol from whole where id='".$_POST[pol]."') and date=(select max(date) from whole)");$i=1; while($r3=$q3->fetch_array(MYSQLI_USE_RESULT)){ $p=count($r3)?1:0; $tb.='<tr> <td>'.$i.'</td> <td>'.$r3[store].'</td> <td>'.$r3[pol].'</td> <td>'.$r3[province].'</td> <td>'.$r3[pod].'</td> <td>'.$r3[kgs].'</td> <td>'.$r3[cbm].'</td> <td>'.$r3[tons].'</td> <td>'.$r3[ctns].'</td> <td>'.$r3[ctnsmore].'</td> <td>'.$r3[ctns5].'</td> <td>'.$r3[ctns50].'</td> <td>'.$r3[pallet].'</td> <td>'.$r3[tons3].'</td> <td>'.$r3[tons5].'</td> <td>'.$r3[tons8].'</td> <td>'.$r3[ft20].'</td> <td>'.$r3[ft40].'</td> <td>'.$r3[min].'</td> <td>'.$r3[time].'</td> <td>'.$r3[agent].'</td> <td>'.$r3[door].'</td> <td>'.$r3[currency].'</td> <td>'.$r3[mincbm].'</td> <td>'.$r3[remark].'</td> <td>'.$r3[remark2].'</td> </tr>';$i++; } if($p){ echo '<table border="1">'; echo '<tr> <td>行</td> <td>门店地址</td> <td>起运地</td> <td>省</td> <td>目的地</td> <td>1kgs</td> <td>cbm</td> <td>tons</td> <td>1ctns<br>(</td> <td>1ctns >16K</td> <td>>5ctns</td> <td>>50ctns</td> <td>pallet</td> <td>3tons</td> <td>5tons</td> <td>8tons</td> <td>20ft</td> <td>40ft</td> <td>min.</td> <td>t/time</td> <td>agent</td> <td>DOOR MIN</td> <td>币别</td> <td>MIN.1CBM</td> <td>备注</td> <td>备注2</td> </tr>'; echo $tb; echo '</table>'; } else{ echo '没有纪录。';} } ?> </div> <div class="clear"> </div>