public function all($id)
 {
     if ($id == '') {
         $sql = "SELECT * FROM `user`;";
         $vai = new MySQLDB();
         $result = $vai->ExecuteQuery($sql);
     } else {
         $sql = "SELECT * FROM `user` WHERE `id` = {$id};";
         $vai = new MySQLDB();
         $result = $vai->ExecuteQuery($sql);
     }
     while ($dados = mysql_fetch_array($result)) {
         $cliente = new User();
         $cliente->setid(array('id' => $dados['id']));
         $cliente->setnome(array('nome' => $dados['nome']));
         $cliente->setpassword(array('password' => $dados['password']));
         $cliente->setemail(array('email' => $dados['email']));
         $cliente->setstatus(array('status' => $dados['status']));
         $arr[] = $cliente;
     }
     return $arr;
 }
Example #2
0
<?php

include 'models/user.php';
// try setting User
$adminuser = new User();
// this should be fetched from the DB.
$adminuser->SetID(5);
$adminuser->setusername("admin");
$adminuser->setpassword("admin");
$adminuser->setstatus(1);
$adminuser->settypeid(1);
echo 'User ID: ' . $adminuser->GetID() . "<br/>";
echo 'Username: '******'Password: '******'Status: ' . $adminuser->GetStatus() . "<br/>";
echo 'Type ID: ' . $adminuser->GetTypeID() . "<br/>";