sqlite - Sqlite Examples

Not logged in

• Honeypot
• Browse
• Home
• Login
• Reports
• Search
• Ticket
• Timeline
• Wiki

• Contents
• No-Diff
• Text

*** 1,21 ****
  *: CREATE A NEW TABLE IN A .db FILE:
  
! <pre>
  $dbfile = 'foo.db';
  if (!$db = sqlite_open($dbfile, 0666, $err) ) { die($err); }
  $create='CREATE TABLE CONTACTS(
  name VARCHAR(32),
  precall VARCHAR(5),
  number VARCHAR(30)
  )';
  $sql = sqlite_query($db,$create);
  
  sqlite_query($db, " INSERT INTO CONTACTS
  VALUES ('PETER','089','4711')");
  sqlite_query($db, " INSERT INTO CONTACTS
  VALUES ('ANNA','040','1122')");
  sqlite_query($db, " INSERT INTO CONTACTS
  VALUES ('Maxi','089','9876')");
  sqlite_close($db);
! </pre>
  ------------------------------------------
--- 1,35 ----
  *: CREATE A NEW TABLE IN A .db FILE:
  
! 
  $dbfile = 'foo.db';
+ "{linebreak}"
  if (!$db = sqlite_open($dbfile, 0666, $err) ) { die($err); }
+ "{linebreak}"
  $create='CREATE TABLE CONTACTS(
+ "{linebreak}"
  name VARCHAR(32),
+ "{linebreak}"
  precall VARCHAR(5),
+ "{linebreak}"
  number VARCHAR(30)
+ "{linebreak}"
  )';
+ "{linebreak}"
  $sql = sqlite_query($db,$create);
+ "{linebreak}"
  
  sqlite_query($db, " INSERT INTO CONTACTS
+ "{linebreak}"
  VALUES ('PETER','089','4711')");
+ "{linebreak}"
  sqlite_query($db, " INSERT INTO CONTACTS
+ "{linebreak}"
  VALUES ('ANNA','040','1122')");
+ "{linebreak}"
  sqlite_query($db, " INSERT INTO CONTACTS
+ "{linebreak}"
  VALUES ('Maxi','089','9876')");
+ "{linebreak}"
  sqlite_close($db);
! "{linebreak}"
  ------------------------------------------