Advertisement
Guest User

Untitled

a guest
Mar 24th, 2017
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.07 KB | None | 0 0
  1. $conn = pg_connect("user = postgres password = nkr@123 host = localhost dbname = ARKREJ");
  2.  
  3. $res = pg_query($conn, "SELECT photo FROM public.zdata_4326, public.zdata WHERE zdata_4326.gid = zdata.gid AND zdata.gid = 1;");
  4.  
  5. if (!$res) {
  6. echo "An error occured at result.n";
  7. exit;
  8. }
  9.  
  10. if($res) {
  11. $Row = pg_fetch_row($res, '0');
  12.  
  13. $Object = pg_locreate($conn);
  14. header("Content-Type: image/jpg");
  15. $File = pg_loopen($conn, $Object, "r");
  16. pg_loreadall($File);
  17. }
  18. else {echo "The query failed!?! There is no row with id=1!";}
  19.  
  20. $conn = pg_connect("user = postgres password = nkr@123 host = localhost dbname = ARKREJ");
  21.  
  22. if (!$conn) {
  23. echo "An error occured.n";
  24. exit;
  25. }
  26.  
  27. $temp = "C:/Program Files/OSGeo/MapGuide/Web/Apache2/htdocs/tmp.jpg";
  28.  
  29.  
  30. if (!$temp) {
  31. echo "An error occured at temp.n";
  32. exit;
  33. }
  34.  
  35.  
  36. $result = pg_query($conn, "SELECT (photo, '$temp') FROM public.zdata_4326, public.zdata WHERE zdata_4326.gid = zdata.gid AND zdata.gid = 1;");
  37.  
  38. if (!$result) {
  39. echo "An error occured at result.n";
  40. exit;
  41. }
  42.  
  43. if ($result)
  44. {
  45. While ($line = pg_fetch_array($result))
  46. {
  47. $ctobj = $line["photo"];
  48. echo "<IMG SRC = show.php> </br>";
  49. }
  50. }
  51. else {echo "File does not exists"; }
  52.  
  53. <?
  54. header("Content-type: image/jpeg");
  55. $jpeg = fopen("C:/Program Files/OSGeo/MapGuide/Web/Apache2/htdocs/tmp.jpg", "r");
  56.  
  57. $photo = fread($jpeg, filesize("C:/Program Files/OSGeo/MapGuide/Web/Apache2/htdocs/tmp.jpg"));
  58.  
  59. echo pg_unescape_bytea($photo);
  60. ?>
  61.  
  62. $conn = pg_connect("user = postgres password = nkr@123 host = localhost dbname = ARKREJ");
  63. $res = pg_query($conn, "SELECT photo FROM public.zdata_4326, public.zdata WHERE zdata_4326.gid = zdata.gid AND zdata.gid = 1;");
  64. $raw = pg_fetch_result($res, 'photo');
  65. header('Content-type: image/jpeg');
  66. echo pg_unescape_bytea($raw);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement