Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $host = "********" ;
- $db = "*******" ;
- $dbuser = "***********" ;
- $dbpass = "*********" ;
- $con = mysql_connect($host, $dbuser, $dbpass);
- if(!$con){
- die(mysql_error());
- }
- $select = mysql_select_db($db, $con);
- if(!$select){
- die(mysql_error());
- }
- $item = $_REQUEST['find'];
- $data = mysql_query("SELECT * FROM requests WHERE status = 'OPEN'");
- while($row = mysql_fetch_array($data)){
- $date_filled = $row['requested_time'];
- $date_filled = gmdate('d/m/Y', $date_filled);
- $time_filled = $row['requested_time'];
- $time_filled = gmdate('h:m:s', $time_filled);
- echo "<tr>";
- echo "<td align=center>",$row['reqid']," ","</td>";
- echo "<td align=center>",$row['section']," ","</td>";
- echo "<td>",$row['type']," - " ,$row['rlsname']," ","</td>";
- echo "<td align=center>",$row['requester']," ","</td>";
- echo "<td align=center>",$row['status']," ","</td>";
- echo "<td align=center><font size=2>",$date_filled,"<br>",$time_filled,"</font></td>";
- echo "</tr>";
- echo "</table>";
- echo "<br>";
- echo "<br>";
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement