djdellux Posted November 18, 2008 Author Share Posted November 18, 2008 !!!UPDATE!!! *#*#*#*#*#*#*#*#* <html> <head> <title>Loggin DB</title> </head> <body> <form method="get" action="loggin1.php"> Page: <select name="Page"> <option value="approve.php" >Approve</option> <option value="custquery" >CustQuery</option> <option value="slpnlogin">SlpnLogin</option> </select> User Code: <select name="User Code"> <option >T3</option> <option >J9</option> <option>BL</option> <option >SC</option> <option >MN</option> <option >CA</option> <option>MW</option> <option >TJ</option> <option >E2</option> </select> Date: <input type="text" name="Date"> <p><input type="submit" value="send"/></p></form> <?php echo $_GET['Page']; $db = $_SERVER['DOCUMENT_ROOT']."/../data/log.db"; //connect to sql $handle = sqlite_open($db); $query = "SELECT * FROM log where id > 85076"; if ($_GET["Page"] !="") { $query.=" and page ='".$_GET["Page"]."'"; } echo $query; $result = sqlite_query($handle, $query); $row = sqlite_fetch_array( $result ); echo "<table>"; while($row = sqlite_fetch_array($result)){ echo " <tr>\n"; echo " <td> $row[id]</td><td> $row </td> <td> $row[desc] </td><td> $row[userCode] </td><td> $row[codeType] </td><td>". date( "Y-m-d", $row['time'])."</td><td> $row[ipaddr]</td>\n"; echo " </tr>\n"; } echo "</table>"; ?> </html> *#*#*#*#*#*#*#*#*#*#*#* THIS IS WHAT i HAVE NOW... ANY SUGGESTIONS OR BUG FINDS GUYS...THANKS -dELLUX Link to comment https://forums.phpfreaks.com/topic/132135-newbee/page/2/#findComment-692657 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.