Part of Slepp's Projects — Pastebin — TURL — Imagebin — Filebin
Feedback -- English French German Japanese
Create Upload Newest Tools Donate
Sign In | Create Account

Paste Actions

Download Raw
Embed
pBox URL
Post to Twitter
Remove Paste

Paste Details

PHP Source format, 4 years 1 month old, and 184 hits.

Paste Description for Yancho

The read from DB and echo row script described in PUGMT

Yancho
Tuesday, December 18th, 2007 at 7:16:42pm MST 

  1. <?php
  2. //session_start();
  3.  
  4. // The file which gets the data from the table to echo
  5.  
  6. include 'db.php';
  7. $con = pg_connect("dbname=".$db." host=".$dbhost." user=".$dbuser." password=".$dbpass)
  8.       or die ("PostgreSQL Error --> " . pg_last_error($con));
  9.  
  10.  
  11.  $ip = $_SERVER['REMOTE_ADDR'];
  12.  
  13. //if (isset($_COOKIE['tid'])) { $tid = $_COOKIE['tid']; }
  14. //else { $tid = $_SESSION['tid']; }
  15.  
  16. //echo "tid is : $tid";
  17. //print_r ($_SESSION);
  18. //print_r ($_COOKIES);
  19.  
  20.  
  21. $query = "SELECT coalesce ((SELECT tid from xml where ip = '".$ip."' order by id ASC limit 1), 'null');"  ;
  22.  
  23. //echo $query ;
  24.  
  25. $sql = pg_query ($query) ;
  26.  
  27. $res =  pg_fetch_assoc($sql) ;
  28.  
  29. $exists = $res['coalesce'];
  30.  
  31.  ob_implicit_flush(true) ;
  32.  
  33. if ( $exists != "null" ) {
  34.  
  35.         $query2 = "SELECT tid, id, line from xml where ip = '".$ip."' order by id ASC limit 1;"  ;
  36.        
  37.         //echo $query2;
  38.  
  39.         $sql2 = pg_query ($query2);
  40.  
  41.         $result = pg_fetch_assoc($sql2);
  42.  
  43.         //print_r ($result);
  44.        
  45.         $tid = $result['tid'];
  46.  
  47.         $line2 = $result['line'];
  48.        
  49.         if ( $line2 != "<br><b>Welcome to destination - Hope you enjoyed your trip</b>" ) {
  50.        
  51.             $now = date("H:i:s");
  52.            
  53.             $line = $now." ".$line2;
  54.         }
  55.         else {
  56.           $line = $line2 ;
  57.         }
  58.  
  59.         $id = $result['id'];
  60.  
  61.         $_SESSION['last_inst'] = $line;
  62.         //setcookie("last_int",$line, time()+1200);
  63.  
  64.         ob_start();
  65.         echo $line;
  66.        
  67.         ob_end_flush();
  68.  
  69.  
  70.  
  71.  
  72.         // now deleting the line
  73.  
  74.         $dquery = "delete from xml where (tid = '".$tid."' and id = '".$id."');" ;
  75.         //echo $dquery;
  76.         $dquery = pg_query ($dquery);
  77. }
  78. else {
  79.  
  80.  echo $_COOKIE['last_inst'];
  81.    }
  82.  
  83. ?>

advertising

Update the Post

Either update this post and resubmit it with changes, or make a new post.

You may also comment on this post.

update paste below
details of the post (optional)

Note: Only the paste content is required, though the following information can be useful to others.

Save name / title?

(space separated, optional)



Please note that information posted here will expire by default in one month. If you do not want it to expire, please set the expiry time above. If it is set to expire, web search engines will not be allowed to index it prior to it expiring. Items that are not marked to expire will be indexable by search engines. Be careful with your passwords. All illegal activities will be reported and any information will be handed over to the authorities, so be good.

fantasy-obligation