// mysql_func.php
/* Fonctions offrant une interface de base de donn�s simple */
/* ---------------------------------------------------- */
function dicton($path, $nombre){
srand(time());
$nombre=mt_rand( 1, $nombre);
if ($file = fopen($path, 'r')) {
for($index=0; $index < $nombre; $index++){
$chaine=fgets($file, 120);
}
if (fclose($file))
;
}
print ("\n");
}
function panel($result,$id, $depart,$fin){
//print "phase1 $depart $fin";
//$sql ="SELECT code_ag, text_ag, image_ag FROM art_group WHERE code_ag > '$depart' AND code_ag <'$fin'";
//print "
";
$qte=mysql_num_rows($result) ;
print"
";
for ($i=0; $i<$qte; $i++){
$fichier = mysql_fetch_array($result);
//print"$fichier[1] | ";
print"![$fichier[1]]($Base_R/computer/images/$fichier[2]) | ";
}
print"
";
}
function affiche_user($result){
$qte=mysql_num_rows($result) ;
$tabl=array (
"Date",
"Libelle sur ".$qte,
"Prix &euro",
"Contact",
"Image",);
titre($tabl);
while ($row = mysql_fetch_array($result)) {
//$RowColor = chgcolor();
if ($row[2] & 1){
print "";
print "$row[7] | \n";
print "$row[3] | \n";
print "$row[4] | \n";
print "$row[5] | \n";
print "
";
$i++; }
else if ($row[2] & 2){
print "
";
print "$row[7] | \n";
print "$row[3] | \n";
print "$row[4] | \n";
print "$row[5] | \n";
print "
";
$i++; }
else {
print "
";
print "$row[7] | \n";
print "$row[3]>/div> | \n";
print "$row[4] | \n";
print "$row[5] | \n";
print " | \n";
print "
";
$i++; }
}
print "";
}
function affiche($result){
$qte=mysql_num_rows($result) ;
$tabl=array (
"Index",
"Libelle sur ".$qte,
"Prix",
"Contact",
"Image",);
titre($tabl);
while ($row = mysql_fetch_array($result)) {
//$RowColor = chgcolor();
if ($row[2] & 1){
print "
";
print "$row[0] | \n";
print " | \n";
print "$row[4] | \n";
print "$row[5] | \n";
print "
";
$i++; }
else if ($row[2] & 2){
print "
";
print "$row[0] | \n";
print " | \n";
print "$row[4] | \n";
print "$row[5] | \n";
print "
";
$i++; }
else {
print "
";
print "$row[0] | \n";
print " | \n";
print "$row[4] | \n";
print "$row[5] | \n";
print " | \n";
print "
";
$i++; }
}
print "";
}
function affiche_admin($result, $depart, $arive){
$qte=mysql_num_rows($result) ;
$tabl=array (
"Code",
$depart." sur ".$qte ." Articles (click pour Information)",
"P. Achat",
"P.Vente",
"Four",
"Date",);
titre($tabl);
while ($row = mysql_fetch_array($result)) {
$RowColor = chgcolor();
print "
";
$i++;
print "$row[0] | ";
print " | ";
//print " $i | ";
print "
";
}
print "";
}
function titre($tableau){
print "";
print "";
$i=0;
while($i$tableau[$i]";
$i++;
}
print "
";
}
function chgcolor(){
static $couleur;
if($couleur == "#ffbb00")
{
$couleur = "#ffdd99";
}
else
{
$couleur = "#ffbb00";
}
return($couleur);
}
function connect() {
global $MySQL_Host, $MySQL_User, $MySQL_Passw;
if (! $linkid=mysql_connect("$MySQL_Host","$MySQL_User","$MySQL_Passw")) {
echo "Access denied Not autorized ",$MySQL_Host,"
";
exit;
}
return $linkid;
}
function createdb($db, $lkid) {
if (! $res=mysql_create_db($db, $lkid)) {
print mysql_error($lkid);
exit;
}
return $res;
}
function send_sql($db, $sql) {
if (! $res=mysql_db_query($db, $sql)) {
print "Erreur: ";
print mysql_error();
exit;
}
return $res;
}
function tab_out($result) {
$qte=mysql_num_fields($result);
print "";
print "";
for ($i=0;$i<$qte;$i++){
print "";
print mysql_field_name($result,$i);
print " | ";
}
print "
";
print "";
while ($row = mysql_fetch_array($result)) {
foreach ($row as $elem) {
print "$elem | ";
}
print "
";
}
print "
";
} // tab_out
// liste du panier
//function tab_out6 ($result,$Identifiant) {
function tab_out6 ($result) {
global $Base_R;
$qte= mysql_num_rows($result);
print "";
print "";
print "Qte | ";
print "Code | ";
print "$qte Articles (click -> information) | ";
print "Value | ";
print "Total | ";
print "
";
print "";
while ($row = mysql_fetch_array($result)) {
$tot=$row[2]*$row[3];
$RowColor = chgcolor();
print "
";
print "$row[3] | ";//quantite
print " | ";//code
print "$row[1] | ";//article
print "$row[2] | ";//prix Unite
print "$tot | ";//prix Total
print "
";
print "";
$total=$total+$tot;
}
$total=$total+20;
print "
";
print "";
print "Tax Transport Fr 20.00 |
";
print "TTC SWISS TOTAL VALUE CH Fr. $total | ";
print "
---|
";
print "
";
} // tab_out6