title: how do I connect to sqlite database?
body: <p>How do i connect to a sqlite database? I am planning to distribute a db with my application with all the tables already made in it, so i don't need to create a new db or tables, just distribute it.</p>
  
  <p>I so far have experience with mysql where i have used connection strings like</p>
  
  <pre><code>&lt;?php session_start();
  // DATABASE CONNECTION
  
  $hostname = 'localhost';       
  $dbname   = 'xxxxxxxxxxxx'; 
  $username = 'xxxxxxxxxxxx'; 
  $password = 'xxxxxxxxxxxx'; 
  
  // Let's connect to host
  mysql_connect($hostname, $username, $password) or DIE('Connection to host is failed, perhaps the service is down!');
  // Select the database
  mysql_select_db($dbname) or DIE('Database name is not available!');
  ?&gt;
  </code></pre>
  
  <p>After the connection is established i go about my business of inserting > selecting > deleting and updating table values using mysql_query and mysql_fetch_array etc.</p>
  
  <p>but how is this process different in SQLITE. all help is appreciated. i am new to sqlite.</p>