<?php
require "sqlite_class.php";
//////////////////// LAST CHANGES ///////////////////////
#Two new methods added (28-12-2005 Wednesday 04:22)
#The method Select defines some sql clausules to do a select to database using SQLITE
#Method GetData allows to get an array of data values according the requested query and affected rows
# Author : Guto Ferreira (real name José Franco)
#$user = $_GET['user']; //// use this to get values from another page
$user = "Guto Ferreira";
$db = new db;
$conn = $db->Database("forum.txt");
$values = array("RESOURCE" => $conn,
"QUERY" => 1,
"ROWS" => "nome, login, password",
"TABLE" => "membros_auth",
"AFFECT" => "nome",
"CURRENT" => $user,
"ORDER" => "login");
$select = $db->Select($values);
$query = $db->Exec_Query($select);
/*
while($rows = sqlite_fetch_array($query,SQLITE_ASSOC)){
$nome = $rows["nome"]."<br>";
$login = $rows["login"]."<br>";
$password = $rows["password"]."<br>";
}
echo $nome.$login.$password;
*/
$rows = $db->GetData($query,array("nome","login","password"));
foreach($rows as $data){
echo $data;
}
/// or u can use
echo $rows[0]."<br>".$rows[1]."<br>".$rows[2];
$db->Close();
?>
|
Download
