How to display database in plain html or php from python - Raspberry Pi Forums

hi guys,

seek urgent on display what's in database on plain html or php without gui interface or layout, plain database display. possible cause i'm new , keep struggling weeks already.

python code:

code: select all

import sqlite3 import rpi.gpio gpio import time import datetime  gpio.setmode(gpio.board) gpio.setup(7, gpio.out)  dbname='/var/www/leddb.db' = datetime.datetime.now() timestamp = now.strftime("%y/%m/%d %h:%m")  pin7 = "insert led values('" + "1" + "','" + "red led" + "','" + timestamp + "')"  def blink(numtimes, speed):     conn=sqlite3.connect(dbname)     curs=conn.cursor()      in range(numtimes):         curs.execute(pin7)         print "iteration " + str(i + 1)         gpio.output(7, true)         time.sleep(speed)         gpio.output(7, false)         time.sleep(speed)     print "done"      conn.commit()     conn.close()     gpio.cleanup()  print "blinking led"  iterations = raw_input("enter total number of times blink: ") speed = raw_input("enter length of each blink(seconds): ")  blink(int(iterations), float(speed)) 

hope guys me out possible, in advance, guys.

code: select all

<?php  $dbconn = mysql_connect('localhost', 'mysqluserid', 'mysqlpassword' );  if (!$dbconn) {         die('err001t db connection error: ' . mysql_error());  }  $dbsel = mysql_select_db('logdb', $dbconn);  if (!$dbsel) {         die('err002t can\'t use database: ' . mysql_error());  } echo "<pre>"; $result=1; $sql = ""; $sql .= $union."select elapsed, date_time, distance log_table workout_name = "foo"; $rs = mysql_query($sql) or die('err003t'.mysql_error()); while ($row = mysql_fetch_array($rs)) {         extract($row);         $disp_date = substr($date_time,0,-3);         $elapsed=$elapsed+0;         echo $result++.":\t".$elapsed."\tpb: ".$distance."m\ton ".$disp_date."\r\n"; } echo "</pre>"; ?>

raspberrypi