To help you write a table style, it is not difficult to create a table that combines the appearance of the data I want to output. I want to use it as a long-term board and can be applied directly in my life. I used to look like this. Please give full play to your talents. The original code and its appearance are as follows: CSScode. menu {background: # 9CF; it is not difficult to write a table style.
Is
The output data table is beautiful. I want to use it as a long-term board and can be applied directly in my life. I used to look like this. Please give full play to your talents. The original code looks like:
CSS code
.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
Data Maintenance
Query ('select * from whole where date = (select max (date) from whole) group by Pol'); while ($ r = $ q-> fetch_array (MYSQLI_USE_RESULT )) {$ op. =''. $ R [pol].'';} $ 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. =''. $ R2 [province].'';}?>
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. =''. $ I .''. $ R3 [store].''. $ R3 [pol].''. $ R3 [province].''. $ R3 [pod].''. $ R3 [kgs].''. $ R3 [cbm].''. $ R3 [tons].''. $ R3 [ctns].''. $ R3 [ctnsmore].''. $ R3 [ctns5].''. $ R3 [ctns50].''. $ R3 [pallet].''. $ R3 [tons3].''. $ R3 [tons5].''. $ R3 [tons8].''. $ R3 [ft20].''. $ R3 [ft40].''. $ R3 [min].''. $ R3 [time].''. $ R3 [agent].''. $ R3 [door].''. $ R3 [currency].''. $ R3 [mincbm].''. $ R3 [remark].''. $ R3 [remark2].''; $ I ++;} if ($ p) {echo'
'; Echo'
| Line |
Store Address |
Departure location |
Save |
Destination |
1kgs |
Cbm |
Tons |
1 ctns (<0.08 M <16 K) |
1 ctns> 16 K |
> 5 ctns |
> 50 ctns |
Pallet |
3 tons |
5 tons |
8 tons |
20ft |
40ft |
Min. |
T/time |
Agent |
DOOR MIN |
Currency |
MIN.1CBM |
Remarks |
Note 2 |
'; Echo $ tb; echo'
';} Else {echo' has no record. ';}}?>