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
| <?php
define('dns', '...');
define('user', '...');
define('password', '....');
/**
* connexion()
*/
function connexion():PDO {
$conn = new PDO( dns, user, password );
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
return $conn;
}
/**
* calcultateCaProduction()
*/
function calcultateCaProduction( $id, $compte = 701 ):int {
$p = array($id, $compte);
$q = 'SELECT SUM(solde) as total FROM ma_tablee WHERE compte = ? AND id_commerces = ?';
try {
$conn = connexion();
$prod = $conn->prepare( $q );
$prod->execute( $p );
if ( $w = $prod->fetch(PDO::FETCH_OBJ) ){
return $w->total;
}
} catch (PDOException $e){
echo $e->getMessage();
}
}
echo calcultateCaProduction( $id = 1, $compte = 701 );
?> |
