08/KukSQLite_02.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_02</title>
  7  </head>
  8  <body>
  9  <h3>Vytvorenie tabužky</h3>
 10  <?php
 11    $db = new SQLiteDatabase ("kuk.sqlite");
 12  //  $db = new SQLiteDatabase (":memory:");
 13  
 14    $db->query("BEGIN;
 15      CREATE TABLE cisla
 16      (id INTEGER PRIMARY KEY, meno CHAR(20), telefon CHAR(20));
 17      INSERT INTO cisla (meno, telefon )
 18      VALUES('Kuko Krátky', '+421905123456');
 19      INSERT INTO cisla (meno, telefon ) VALUES('Hamo Veselý', '+421903654321');
 20      INSERT INTO cisla (meno, telefon ) VALUES('Buro Smutný', '+421907890123');
 21      COMMIT;");
 22  
 23  ?>
 24  </body>
 25  </html>
 26  <!-- Vysledok
 27  
 28  
 29  -->
« Spä