bonjour,
voila un ami m'a donnée cette classe mais elle est en sqlLite un language que je connais peu, je voudrai le mettre en mysql, pour des raisons aussi de sécurité.
Pouvez-vous m'aider, j ai chercher les commandes sur le web mais certaines je ne sais pas comment les remplacer?
Je vous passe la class :
<?php
class user
{
public $id;
public $username;
public $password;
public $name;
public $city;
public $postcode;
public $adress;
public $phone;
public $mail;
public $dname;
public $deliverycity;
public $deliverypostcode;
public $deliveryadress;
public $discount;
public $nip;
private $error;
function _ _ constuct($id='')
{
if($id!='')
$this->load($id);
}
function load($id)
{
if($db = sqlite _ open($sqlitePath, 0666, $this->error ))
{
$value = sqlite _ array _ query($db, "SELECT *
FROM users WHERE users _ id = '".$id."'");
if(sqlite _ num _ rows($value) == 0)
{
$this->error = "L'utilisateur avec l'id
précisé n'existe pas !";
return false;
}
$this->id = $value['users _ id'];
$this->username = $value['users _ username'];
$this->password = $value['users _ password'];
$this->name = $value['users _ name'];
$this->city = $value['users _ city'];
$this->postcode = $value['users _ postcode'];
$this->adress = $value['users _ adress'];
$this->phone = $value['users _ phone'];
$this->mail = $value['users _ mail'];
$this->dname = $value['users _ dname'];
$this->deliverycity = $value['users _
deliverycity'];
$this->deliverypostcode = $value['users _
deliverypostcode'];
$this->deliveryadress = $value['users _
deliveryadress'];
$this->discount = $value['users _ discount'];
$this->nip = $value['users _ nip'];
$this->error='';
sqlite _ close($db);
return true;
}
else
{
return false;
}
}
function checklogin($username, $password)
{
if($db = sqlite _ open($sqlitePath, 0666, $this->
error ))
{
$value = sqlite _ array _ query($db,
"SELECT users _ id FROM users WHERE users _
username = '".$username."' AND users _ password =
MD5(".$password.")");
if(sqlite _ num _ rows($db) == 0)
{
$this->error = 'Le login ou le mot de passe
utilisateur est incorrect !';
sqlite _ close($db);
return -1;
}
return $value['users _ id'];
}
else
{
return 0;
}
}
function add($username, $password, $name,
$city, $postcode, $adress, $phone, $mail, $dname,
$deliverycity, $deliverypostcode, $deliveryadress,
$discount, $nip)
{
$this->username = sqlite _ escape _
string($username);
$this->password = sqlite _ escape _
string($password);
$this->name = sqlite _ escape _ string($name);
$this->city = sqlite _ escape _ string($city);
$this->postcode = sqlite _ escape _
string($postcode);
$this->adress = sqlite _ escape _ string($adress);
$this->phone = sqlite _ escape _ string($phone);
$this->mail = sqlite _ escape _ string($mail);
$this->dname = sqlite _ escape _ string($dname);
$this->deliverycity = sqlite _ escape _
string($deliverycity);
$this->deliverypostcode = sqlite _ escape _ string(
$deliverypostcode);
$this->deliveryadress = sqlite _ escape _
string($deliveryadress);
$this->discount = sqlite _ escape _
string($discount);
$this->nip = sqlite _ escape _ string($nip);
if($this->validate())
{
if($db = sqlite _ open($sqlitePath, 0666, $this->
error ))
{
sqlite _ array _ query($db, "INSERT INTO
users (users _ id, users _ username, users _ password,
users _ name, users _ city, users _ postcode, users _
adress, users _ phone, users _ mail, users _ dname,
users _ deliverycity, users _ deliverypostcode, users _
deliveryadress, users _ discount, users _ nip) VALUES
(NULL, ".$this->username.", ".$this->password.",
".$this->name.", ".$this->city.", ".$this->postcode.",
".$this->adress.", ".$this->phone.", ".$this->mail.",
".$this->dname.", ".$this->deliverycity.", ".$this->
deliverypostcode.", ".$this->deliveryadress.", ".$this->
discount.", ".$this->nip.");");
sqlite _ close($db);
return true;
}
else
{
return false;
}
}
}
function validate()
{
//nous vous laissons le soin de réaliser la fonction validate.
//la fonction doit retourner false lorsque tous les champs demandés n'ont pas été renseignés
return true;
}
function geterror()
{
return $this->error;
}
}
?>
remplacer par ceci:
<?php
class user
{
public $id;
public $username;
public $password;
public $name;
public $city;
public $postcode;
public $adress;
public $phone;
public $mail;
public $dname;
public $deliverycity;
public $deliverypostcode;
public $deliveryadress;
public $discount;
public $nip;
private $error;
function _ _ constuct($id='')
{
if($id!='')
$this->load($id);
}
function load($id)
{
if($db = mysql_select_db($sqlitePath, 0666, $this->error ))
{
$value = mysql_fetch_array($db, "SELECT *
FROM users WHERE users _ id = '".$id."'");
if(mysql_num_rows($value) == 0)
{
$this->error = "L'utilisateur avec l'id
précisé n'existe pas !";
return false;
}
$this->id = $value['users _ id'];
$this->username = $value['users _ username'];
$this->password = $value['users _ password'];
$this->name = $value['users _ name'];
$this->city = $value['users _ city'];
$this->postcode = $value['users _ postcode'];
$this->adress = $value['users _ adress'];
$this->phone = $value['users _ phone'];
$this->mail = $value['users _ mail'];
$this->dname = $value['users _ dname'];
$this->deliverycity = $value['users _
deliverycity'];
$this->deliverypostcode = $value['users _
deliverypostcode'];
$this->deliveryadress = $value['users _
deliveryadress'];
$this->discount = $value['users _ discount'];
$this->nip = $value['users _ nip'];
$this->error='';
mysql_close($db);
return true;
}
else
{
return false;
}
}
function checklogin($username, $password)
{
if($db = mysql_select_db($sqlitePath, 0666, $this->
error ))
{
$value = mysql_fetch_array($db,
"SELECT users _ id FROM users WHERE users _
username = '".$username."' AND users _ password =
MD5(".$password.")");
if(mysql_num_rows($db) == 0)
{
$this->error = 'Le login ou le mot de passe
utilisateur est incorrect !';
mysql_close($db);
return -1;
}
return $value['users _ id'];
}
else
{
return 0;
}
}
function add($username, $password, $name,
$city, $postcode, $adress, $phone, $mail, $dname,
$deliverycity, $deliverypostcode, $deliveryadress,
$discount, $nip)
{
$this->username = mysql_real_escape_string($username);
$this->password = mysql_real_escape_string($password);
$this->name = mysql_real_escape_string($name);
$this->city = mysql_real_escape_string($city);
$this->postcode = sqlite _ escape _
string($postcode);
$this->adress = mysql_real_escape_string($adress);
$this->phone = mysql_real_escape_string($phone);
$this->mail = mysql_real_escape_string($mail);
$this->dname = mysql_real_escape_string($dname);
$this->deliverycity = sqlite _ escape _
string($deliverycity);
$this->deliverypostcode = mysql_real_escape_string(
$deliverypostcode);
$this->deliveryadress = sqlite _ escape _
string($deliveryadress);
$this->discount = sqlite _ escape _
string($discount);
$this->nip = mysql_real_escape_string($nip);
if($this->validate())
{
if($db = mysql_select_db($sqlitePath, 0666, $this->
error ))
{mysql_fetch_array($db, "INSERT INTO
users (users _ id, users _ username, users _ password,
users _ name, users _ city, users _ postcode, users _
adress, users _ phone, users _ mail, users _ dname,
users _ deliverycity, users _ deliverypostcode, users _
deliveryadress, users _ discount, users _ nip) VALUES
(NULL, ".$this->username.", ".$this->password.",
".$this->name.", ".$this->city.", ".$this->postcode.",
".$this->adress.", ".$this->phone.", ".$this->mail.",
".$this->dname.", ".$this->deliverycity.", ".$this->
deliverypostcode.", ".$this->deliveryadress.", ".$this->
discount.", ".$this->nip.");");
sqlite _ close($db);
return true;
}
else
{
return false;
}
}
}
function validate()
{
//nous vous laissons le soin de réaliser la fonction validate.
//la fonction doit retourner false lorsque tous les champs demandés n'ont pas été renseignés
return true;
}
function geterror()
{
return $this->error;
}
}
?>
merci.
de sqlLite au mysql
× Après avoir cliqué sur "Répondre" vous serez invité à vous connecter pour que votre message soit publié.
× Attention, ce sujet est très ancien. Le déterrer n'est pas forcément approprié. Nous te conseillons de créer un nouveau sujet pour poser ta question.