08/KukSQLite_05.php

  1  <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "DTD/xhtml1-strict.dtd">
  2  <html>
  3  <head>
  4    <meta http-equiv="Author" content="Imrich BURANSKY" />
  5    <meta http-equiv="Content-Type" content="text/html; charset=Windows-1250" />
  6    <title>KukSQLite_05</title>
  7  </head>
  8  <body>
  9  <h3>Získanie názvov stĺpcov tabužky</h3>
 10  <pre>
 11  <?php
 12    $db = new SQLiteDatabase ("kuk.sqlite");
 13    $dopyt = $db->query( 'SELECT * FROM cisla' );
 14    echo "\n";
 15    $nf = $dopyt->numFields();
 16    echo "Počet stĺpcov: $nf\n";
 17    echo "----------------------\n";
 18    for ($i=0; $i<$nf; $i++) echo "$i - ".$dopyt->fieldName($i)."\n";
 19    echo "----------------------\n";
 20  ?>
 21  </pre>
 22  </body>
 23  </html>
 24  
 25  <!-- Vysledok
 26  
 27  Práca s výsledkom dopytu
 28  
 29  Počet stĺpcov: 3
 30  ----------------------
 31  0 - id
 32  1 - meno
 33  2 - telefon
 34  ----------------------
 35  
 36  -->
« Spä