1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79
| <?php
class orders
{
public $product_id;
public $order_id;
public $op_amount;
public $order;
private $error;
/*constructeur*/
function __construct($id='')
{
if($id!='')
$this->load($id);
}
/*chargement*/
function load($id)
{
$bdd = new BDD();
if($bdd ->connect()!=false)
{
$value = mysql_fetch_array($db, "SELECT *
FROM order_products WHERE product_id = '".$id."'");
if(mysql_num_rows($value) == 0)
{
$this->error = "La commande avec l'id
pr?cis? n'existe pas !";
return false;
}
$this->product_id = $value['product_id'];
$this->order_id = $value['order_id'];
$this->op_amount = $value['op_amount'];
$this->order = $value['order'];
$this->error='';
mysql_close($db);
return true;
}
else
{
return false;
}
}
function add($product_id,$order_id,$op_amount,$order)
{
$this->product_id = mysql_real_escape_string($product_id);
$this->order_id = mysql_real_escape_string($order_id);
$this->op_amount = mysql_real_escape_string($op_amount);
$this->order = mysql_real_escape_string($order);
if($this->validate())
{
if($bdd ->connect()!=false)
{
mysql_fetch_array($db, "INSERT INTO order_products (product_id,order_id,op_amount)
VALUES (NULL, ".$this->product_id.",".$this->order_id.",".$this->op_amount.",".$this->order.");");
mysql_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;
}
}
?>[ |
Partager