Advertisement
Guest User

php

a guest
Oct 12th, 2016
187
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.76 KB | None | 0 0
  1. <?php
  2.    
  3.   $dbconn = pg_connect("host=192.168.0.118 dbname=maslovo user=admin password=uy564bfhg") or die('Could not connect: ' . pg_last_error());
  4.  
  5.  
  6.             $query = "SELECT name FROM layers_shp_class";
  7.             $result = pg_query($query) or die('Fail!' /*. pg_last_error()*/);
  8.  
  9.  
  10.        
  11.         $len = pg_field_prtlen($result, 0);
  12.         $rows = pg_num_rows($result);
  13.             echo '<div class="tree"><ul>';
  14.             while ($line = pg_fetch_array($result, null, PGSQL_ASSOC)) {              
  15.                 foreach ($line as $col_value) {
  16.                     echo "\t\t<li>$col_value</li>\n";
  17.                 }
  18.             };
  19.             echo "\t</ul></div>\n";
  20.        
  21.        
  22.     pg_free_result($result);
  23.     pg_close($dbconn);
  24. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement