30 lines
1.4 KiB
PHP
Executable File
30 lines
1.4 KiB
PHP
Executable File
<?php
|
|
$nomFicAppelant = basename(__FILE__);
|
|
include ($includePathConf. "/prod.dbConnect.php");
|
|
|
|
// -----------------------------------------------------
|
|
// Clients
|
|
// -----------------------------------------------------
|
|
$reqSelect="SELECT count(*) as `nb` FROM `clients` ;";
|
|
if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['reqSelect=' => $reqSelect], 'statsSurLaBase.php');}
|
|
$resConn=$idPdoProd->query($reqSelect);
|
|
$result= $resConn->fetch(PDO::FETCH_ASSOC);
|
|
$nbClients=$result['nb'];
|
|
|
|
// -----------------------------------------------------
|
|
// Commandes
|
|
// -----------------------------------------------------
|
|
$reqSelect="SELECT * FROM `commande` WHERE `idMail` like '%@%' ;";
|
|
if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['reqSelect=' => $reqSelect], 'statsSurLaBase.php');}
|
|
$resConn=$idPdoProd->query($reqSelect);
|
|
$nbCdes= $resConn->rowCount(). '</td></tr>';
|
|
|
|
// -----------------------------------------------------
|
|
// Produits
|
|
// -----------------------------------------------------
|
|
$reqSelect="SELECT count(*) FROM `produits` ;";
|
|
if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['reqSelect=' => $reqSelect], 'statsSurLaBase.php');}
|
|
$resConn=$idPdoProd->query($reqSelect);
|
|
$result=$resConn->fetch(PDO::FETCH_NUM);
|
|
$nbProduits=$result[0]. '</td></tr>';
|
|
?>
|