PHP veritabanındaki kullanıcıları listeleme

 <? 
  include("header.php"); 
  include("connect.php"); 
   
  echo "<h1>YAZARLARIMIZ</h1>"; 
   
  $query = mysql_query("SELECT * FROM users"); 
  $number = mysql_num_rows($query); 
  $counter = 0; 
   
  echo "<ul>"; 
  while($counter < $number) 
  { 
      echo "<li class='user'>mysql_result($query,$counter,'userNS')</li>"; 
      $counter++; 
  } 
   
  echo "</ul>"; 
  include("footer.php"); 
  ?> 

<?php 
   
  $dbhost ="127.0.0.1"; 
  $dbid = "root"; 
  $dbpass = ""; 
  $dbname = "nobble"; 
   
  $connection = mysql_connect($dbhost,$dbid,$dbpass) or die("Veritabani baglantisi gerçeklesmedi: " . mysql_error());; 
   
  ?>

 
  $select = @mysql_select_db($dbname, $connection); 
  

<? 
  include("header.php"); 
  include("connect.php"); 
   
  echo "<h1>YAZARLARIMIZ</h1>";?> 
   
  <?php   
   
  $query = mysql_query("SELECT * FROM users");  
  echo "<ul>"; 
   
  while ($writers = mysql_fetch_array($query))  
  {  
  echo "<li class=\"user\">"; 
  ?> 
  <?=$writers['userNS']?> 
  <? 
  echo "</li>"; 
  } 
   
  echo "</ul>"; 
  include("footer.php"); 
  ?>