shebbycs Posted April 9, 2013 Share Posted April 9, 2013 It is possible to insert data like this below picture and how to code that ? Quote Link to comment https://forums.phpfreaks.com/topic/276701-how-to-code-the-insertion-data-based-on-table/ Share on other sites More sharing options...
jazzman1 Posted April 9, 2013 Share Posted April 9, 2013 Yes, it's possible. Have you ever heard about databases? Quote Link to comment https://forums.phpfreaks.com/topic/276701-how-to-code-the-insertion-data-based-on-table/#findComment-1423620 Share on other sites More sharing options...
shebbycs Posted April 9, 2013 Author Share Posted April 9, 2013 (edited) Yes, it's possible. Have you ever heard about databases? yes even I had created all the field but how to call that for example I call like this only $sql2 = mysql_query("SELECT *,DATE_FORMAT(Task_Date, '%d/%m/%Y %l:%i %p') AS Task_Date FROM task_report WHERE ID='$b' ORDER BY Task_Date") or die(mysql_error()); echo "<body bgcolor='#F5D16A'>"; echo "<center><img src ='OK.gif'></center><br>"; echo "<center><h2>OPERATION REPORT</h2>"; echo "<table><tr><td><h3>LOCATION</h3></td><td><h3>:</h3></td><td><h3>".$a."</h3></td></tr></table></center>"; echo "<center><table border = '1'>"; echo "<tr><th>DATE & TIME</th><th>STAFF NAME</th><th>TASK</th><th>OPERATION</th><th>ACTION & RESULTS</th><th>CHECK BY</th></tr>"; while($report = mysql_fetch_array($sql2)) { echo "<tr align='center'><td>".$report['Task_Date']."</td>"; echo "<td>".$report['Task_Name']."</td>"; echo "<td>".$report['Task_Task']."</td>"; echo "<td>".$report['Task_Operation']."</td> "; echo "<td>".$report['Task_Action']."</td> "; echo "<td>".$report['Check_By']."</td></tr> "; } echo "</table>"; Edited April 9, 2013 by shebbycs Quote Link to comment https://forums.phpfreaks.com/topic/276701-how-to-code-the-insertion-data-based-on-table/#findComment-1423622 Share on other sites More sharing options...
jazzman1 Posted April 9, 2013 Share Posted April 9, 2013 So, what results did you get? Quote Link to comment https://forums.phpfreaks.com/topic/276701-how-to-code-the-insertion-data-based-on-table/#findComment-1423624 Share on other sites More sharing options...
shebbycs Posted April 9, 2013 Author Share Posted April 9, 2013 So, what results did you get? sorry again I thinks this post should be solved because the criteria every date and time must be inserted so the problem is solved Quote Link to comment https://forums.phpfreaks.com/topic/276701-how-to-code-the-insertion-data-based-on-table/#findComment-1423635 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.