SHARE
TWEET

Untitled

a guest Jun 14th, 2017 60 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <?php
  2. $host = "********" ;  
  3. $db = "*******" ;  
  4. $dbuser = "***********" ;  
  5. $dbpass = "*********" ;  
  6. $con = mysql_connect($host, $dbuser, $dbpass);
  7. if(!$con){
  8. die(mysql_error());
  9. }
  10.  
  11. $select = mysql_select_db($db, $con);
  12. if(!$select){
  13. die(mysql_error());
  14. }
  15.  
  16. $item = $_REQUEST['find'];
  17.  
  18. $data = mysql_query("SELECT * FROM requests WHERE status = 'OPEN'");
  19.  
  20. while($row = mysql_fetch_array($data)){
  21.  
  22.         $date_filled = $row['requested_time'];
  23.         $date_filled = gmdate('d/m/Y', $date_filled);
  24.         $time_filled = $row['requested_time'];
  25.         $time_filled = gmdate('h:m:s', $time_filled);
  26.  
  27.         echo "<tr>";
  28.         echo "<td align=center>",$row['reqid']," ","</td>";
  29.         echo "<td align=center>",$row['section']," ","</td>";
  30.         echo "<td>",$row['type']," - " ,$row['rlsname']," ","</td>";
  31.         echo "<td align=center>",$row['requester']," ","</td>";
  32.         echo "<td align=center>",$row['status']," ","</td>";
  33.         echo "<td align=center><font size=2>",$date_filled,"<br>",$time_filled,"</font></td>";
  34.         echo "</tr>";
  35.         echo "</table>";
  36.         echo "<br>";
  37.         echo "<br>";
  38. }
  39. ?>
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top