asmiera201190 2 Report post Posted September 18, 2014 salam saya nak tanya... cane nak papar data menggunakan mysql dengan gunakan 2 tarikh cam tarikh mula dan tarikh akhir tanpa pengishtiharan? lanuages php guna mysql Quote Share this post Link to post Share on other sites
asmiera201190 2 Report post Posted September 22, 2014 masalah coding saya adalah berkaitan tentang paparan tarikh untuk bahagian laporan. iaitu berkenaan paparan dari tarikh yg user boleh select from starting date to end date. Quote Share this post Link to post Share on other sites
umarzuki 78 Report post Posted September 23, 2014 mungkin for loop & array? Quote Share this post Link to post Share on other sites
ahaksz! 44 Report post Posted September 24, 2014 Boleh share sikit coding? Maybe dah betol tapi kena tweak sket2 je. Mana la tau kan. :P Quote Share this post Link to post Share on other sites
asmiera201190 2 Report post Posted September 30, 2014 <?php echo "<table border='1' style='border-collapse: collapse;border-color: silver;'>"; echo "<td width='100' align='center'>date in</td><td width='100' align='center'>date out</td> <td width='100' align='center'>model</td> "; echo "</tr>"; include("proses/dbcon.php"); $date_in = $_POST['date_in']; $date_out = $_POST['date_out']; if(isset($submit)) { $sql = "select * from inventory where createdate >= '$date_in' and createdate <= '$date_out' "; } $result= mysql_query($sql); while($row=mysql_fetch_array($result)) { echo "<tr>"; echo "<td align='center' width='200'>" . $row['date_in'] . "</td>"; echo "<td align='center' width='200'>" . $row['date_out'] . "</td>"; echo "<td align='center' width='200'>" . $row['model'] . "</td>"; echo "</tr>"; } echo "</table>"; ?> nie untuk input yang akan display <form method="post" action="view.php"> <label>From Time : </label><input type="date" name="date_in" /><br/><br/> <label>To Time : </label><input type="date" name="date_out" /><br/><br/> <input type="submit" name="submit" value="Submit" /> </form> Quote Share this post Link to post Share on other sites