Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on May 26th, 2012  |  syntax: PHP  |  size: 0.52 KB  |  hits: 9  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
This paste has a previous version, view the difference. Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1.  <?php
  2.        
  3.         $con = mysql_connect("iiiiim","iiiii","iiiii");
  4.                         if (!$con)
  5.                           {
  6.                           die('Could not connect: ' . mysql_error());
  7.                           }
  8.                         mysql_select_db("a5528405_travel");
  9.                
  10.                 $sql=mysql_query("SELECT * FROM traveller");   
  11.  
  12.  
  13. while($row = mysql_fetch_array($sql))
  14. {
  15.         $arr[] = array( "id" => $row["id"], "naam" => $row["name"], "code" => $row["code"], "datum" => $row["date"], "coordinate" => $row["coordinate"], "bericht" => $row["message"], "overig" => $row["overig"] );
  16. }
  17.  
  18. json_encode($arr);
  19.  
  20. ?>
create a new version of this paste RAW Paste Data