Heim >Backend-Entwicklung >PHP-Tutorial > 帮忙写个表格样式,不难的,该怎么解决

帮忙写个表格样式,不难的,该怎么解决

WBOY
WBOYOriginal
2016-06-13 13:38:561294Durchsuche

帮忙写个表格样式,不难的
就是一个把我要
输出数据的表格美观一化,我要做为长期之类板,以后一生中便可直接套用。我的原样子如下。众好汉,请发挥你们的才智。原代码及样子如一:

CSS code
<!--

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;}


PHP code
<!--

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>
Stellungnahme:
Der Inhalt dieses Artikels wird freiwillig von Internetnutzern beigesteuert und das Urheberrecht liegt beim ursprünglichen Autor. Diese Website übernimmt keine entsprechende rechtliche Verantwortung. Wenn Sie Inhalte finden, bei denen der Verdacht eines Plagiats oder einer Rechtsverletzung besteht, wenden Sie sich bitte an admin@php.cn