cs_isecso
Messages postés33Date d'inscriptionjeudi 17 août 2006StatutMembreDernière intervention 1 juin 2007
-
25 mai 2007 à 10:29
J_G
Messages postés1406Date d'inscriptionmercredi 17 août 2005StatutMembreDernière intervention28 août 2007
-
25 mai 2007 à 11:20
je peut pas accéder au base pour verifier login et password des utilisateur et voici les fichiers .
Merci d'avance.
---------------------page Admin--------------------------------------
<?php
session_start();
include ("../classes/Page.class.php");
include ("../classes/User.class.php");
//session_start(); //Variable session.auto_start = on in php.ini file
if (!($_SESSION["Login"]) || ($_SESSION["Login"] == "")) {
Header("Location: ../index.php?logonerror");
exit();
}
$usr = new User($_SESSION["Login"]);
$webPage = new Page(NULL,serialize($usr));
/*************** Ajouter le contenu de la page *******************/
$webPage->AddContent($usr->Display("black"));
/*********************** Afficher la page ************************/
echo $webPage->getPage();
?>
</td>
</tr>
</tbody>
</table>
</HTML>
---------------------page user.class-----------------------------------------------
<?php
if(!defined("PHP_USER_CLASS"))
{
define("PHP_USER_CLASS",1,True);
include("OraBase.class.php");
include("Frame.class.php");
class User
{
var $Login;
var $UsrGrpName;
var $UsrFName;
var $UsrLName;
var $UsrFunction;
var $UsrEmail;
var $UsrPasswd;
var $UsrPrivilege;
function User($Login=""){
$this->Login = $Login;
if(($Login != "") && $this->Check()){
$this->Load();
}
else {
$this->UsrGrpName = "";
$this->UsrFName = "";
$this->UsrLName = "";
$this->UsrFunction = "";
$this->UsrEmail = "";
$this->UsrPasswd = "";
$this->UsrPrivilege = "00000000000";
}
//echo $this->Display();
}
function SetPassword($UsrPasswd){
$this->UsrPasswd = sha1($UsrPasswd);
}
function Add()
{
$OraDb = new OraBase();
$OraDb->connect(); $OraDb->Query "select Login from users where Login '$this->Login'";
$results = $OraDb->Execute();
//echo count($results)."
";
list($key,$value) = each($results);
if(!isset($value[0])){//s'il n'y a 1 autre user ayant le même login
//echo "User Add : UsrEmail : $this->UsrEmail
";
$OraDb->Query = "insert into users values('$this->Login','$this->UsrGrpName','$this->UsrFName','$this->UsrLName','$this->UsrFunction','$this->UsrEmail','$this->UsrPasswd')";
if($OraDb->Execute()) return True;
return False;
}
else{
echo "Opération User->Add a échoué: '$this->Login' : Utilisateur existant
";
return False;
}
}
function Delete()
{
$OraDb = new OraBase();
$OraDb->connect(); $OraDb->Query "select Login from users where Login '$this->Login'";
$results = $OraDb->Execute();
//echo count($results)."
";
list($key,$value) = each($results);
if(isset($value[0])){//s'il n'y a 1 autre user ayant le même login
//echo "User Add : UsrEmail : $this->UsrEmail
";
$OraDb->Query = "DELETE FROM USERS WHERE LOGIN='$this->Login'";
if($OraDb->Execute()) return True;
return False;
}
else{
throw new Exception("Opération User->Delete a échouée: '$this->Login' : Utilisateur absent
");
return False;
}
}
function Load(){
$OraDb = new OraBase();
$OraDb->connect(); $OraDb->Query "select * from users where Login '$this->Login'";
$results = $OraDb->Execute();
//print_r($results);
if($results){
reset($results);
$oparray = array();
$this->UsrPasswd = $results['USRPASSWD'][0];
$this->UsrEmail = $results['USREMAIL'][0];
$this->UsrFunction = $results['USRFUNCTION'][0];
$this->UsrLName = $results['USRLNAME'][0];
$this->UsrFName = $results['USRFNAME'][0];
$this->UsrGrpName = $results['USRGRPNAME'][0];
$this->Login = $results['LOGIN'][0];
$this->UsrPrivilege = $this->GetPrivilege();
return True;
}
echo "Opération User->Load a échoué: '$this->Login' : Utilisateur absent
";
return False;
}
function Update()
{
if($this->Check()){
$OraDb = new OraBase();
$OraDb->connect();
$OraDb->Query = "update users set USRGRPName='$this->UsrGrpName',USRFNAME='$this->UsrFName',USRLNAME='$this->UsrLName',USRFUNCTION='$this->UsrFunction',USREMAIL='$this->UsrEmail',USRPASSWD='$this->UsrPasswd' where Login='$this->Login'";
return($OraDb->Execute());
}
else return FALSE;//User absent
}
//return True if a user exists, else return false
function Check()
{
$OraDb = new OraBase();
$OraDb->connect(); $OraDb->Query "select Login from users where Login '$this->Login'";
$results = $OraDb->Execute();
list($key,$value) = each($results);
if(isset($value[0])) return True;
else return False;
}
//return True if $this->Login and $this->UsrPasswd match, else return false
function CheckPassword()
{
$OraDb = new OraBase();
$OraDb->connect(); $OraDb->Query "select login from users where Login '$this->Login' and UsrPasswd = '".$this->UsrPasswd."'";
$results = $OraDb->Execute();
list($key,$value) = each($results);
if(isset($value[0])) return True;
else return False;
}
function Display($color="Green",$passwd=False,$priv=True)
{
$strUser = "
\n\";
$bool = True;
foreach($this as $key => $value) {
if($value==\"\") $value=\" \";
$bool = true;
if($key=='UsrPrivilege') $bool = $priv;
if($key=='UsrPasswd') $bool = $passwd;
if($bool)$strUser .= \"
----