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 ? 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? 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 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>"; 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? 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 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
Archived
This topic is now archived and is closed to further replies.