Displaying contents of Sqlite Database in php

[alexmahone]

Hi ,

 

I have "testdb.s3db" sqlite database in the project folder.. I have created few records in a table also, 

 

 

I'm stuck in retrieving the records in GridView ..

 

 

I need your kind attention want a solution asap ..   ..

[trq]

Where exactly are you stuck?

[priyankagound]

Hi,

Below is the code which may help you to come out with the answer you looking for.

 

<?php
  try
  {
    //open the database
    $db = new PDO('sqlite:/var/databases/307Code/python/readings.db');

    //now output the data to a simple html table...
    print "<table border=1>";
    print "<tr><td>Date & Time Recieved</td><td>Node</td><td>Temp</td><td>Hum</td><td>Light</td><td>Dew</td></tr>";
    $result = $db->query('SELECT * FROM readingstable');
    foreach($result as $row)
    {


      print "<tr><td>".$row['Recieved']."</td>";
      print "<td>".$row['Node']."</td>";
      print "<td>".$row['Temp']."</td>";
      print "<td>".$row['Hum']."</td>";
      print "<td>".$row['Light']."</td>";
      print "<td>".$row['Dew']."</td></tr>";
    }
    print "</table>";

    // close the database connection
    $db = NULL;
  }

[alexmahone]

im stuck in putting the records into grid view ... i'm looking for a code snippet..

 

thank u

[Barand]

I haven't used sqlite but I think you need

$result = $db->query('SELECT * FROM readingstable');
   while($row = $result->fetch())
    {

[trq]

im stuck in putting the records into grid view ... i'm looking for a code snippet..

 

thank u

We are not here to write code for people, the manual is full of examples. What have you tried? Be specific.

[alexmahone]

Thank u 

priyankagound