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;
}
}
?>[ |
