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.