$chaine\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 ("\n"); for ($i=0; $i<$qte; $i++){ $fichier = mysql_fetch_row($result, MYSQL_NUM); //print"\n"; print ("\n"); } print ("

\n"); } function afficheinfo($result){ $qte=mysql_num_rows($result); $tabl=array ( "Lieu", "Debut", "Fin", "Information", "Level", "Link",); titre($tabl); while ($row = mysql_fetch_row($result,MYSQL_NUM)) { if($row[0] == ""){ print "

$row[5]

";//titre } else { $RowColor = chgcolor(); //setlocal("LC_TIME","fr"); //$jour= date("d m Y",$row[0]); print ""; print "

$row[5]

\n";//lieu print "

$row[0]

\n";//debut print "

$row[1]

\n";//fin //print "

$row[2]

\n";//type //print "

$row[3]

\n";//groupe print "

$row[6]

\n";//libelle print "

$row[4]

\n";//level print "

$row[7]

";//lien print ""; print "

"; } } print ""; } function affichelink($result){ $qte=mysql_num_rows($result); $tabl=array ( "Go To Link", $qte ." Comment Informations Remarques", "Level",); titre($tabl); while ($row = mysql_fetch_row($result,MYSQL_NUM)) { if($row[3] == ""){ print "

$row[0]

";//titre } else { $RowColor = chgcolor(); print ""; print "

$row[0]

";//lien print "

$row[1]

\n";//libelle for ($index=0; $index<$row[3]; $index++) print "

";//score print ""; print "

"; } } print ""; } function affiche($result, $depart, $arive){ $qte=mysql_num_rows($result) ; $tabl=array ( "No", $depart." sur ".$qte ." Articles (click pour Information)", "Fr CH", "Tax %",); titre($tabl); for($index=$depart; $index<$arive; $index++){ mysql_data_seek($result, $index); $fichier = mysql_fetch_row($result,MYSQL_NUM); $RowColor = chgcolor(); print ""; print "

$fichier[0]

\n";//article print "

$fichier[1]

\n";//code print "

$fichier[2]

\n";//article print "

$fichier[3]

\n";//tax //print "

"; //print ""; //print ""; //print ""; //print ""; //print ""; //print "\n"; } print"\n"; } 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); for($index=$depart; $index<$arive; $index++){ mysql_data_seek($result, $index); $fichier = mysql_fetch_row($result,MYSQL_NUM); $RowColor = chgcolor(); print ""; print "

$fichier[0]

"; print "

$fichier[2]

"; print "

$fichier[13]

"; // pa print "

$fichier[14]

"; //pv print "

$fichier[1]

"; //four print "

$fichier[17]

";//date } 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 "Impossible de se connecter à ",$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 ""; print ""; while ($row = mysql_fetch_row($result,MYSQL_ASSOC)) { foreach ($row as $elem) { print ""; } print ""; } print "

"; print mysql_field_name($result,$i); print "
$elem

"; } // tab_out function tab_out1($result,$Identif ) { global $w;$Art=$w[Art];$NumArt=$w[NumArt];$Qte=$w[Number]; $qte=mysql_num_fields($result); print ""; print ""; for ($i=0;$i<$qte;$i++){ print ""; } print ""; print ""; print ""; print ""; while ($row = mysql_fetch_row($result,MYSQL_ASSOC)) { foreach ($row as $elem) { print ""; } print ""; print ""; print ""; } print "

"; print mysql_field_name($result,$i); print "	";print "+";print "	";print "-";print "
$elem	"; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print "	"; print " "; print ""; print ""; print ""; print " "; print "

"; } // tab_out1 //function tab_out2 ($result,$Identifiant) { function tab_out2 ($result) { //global $Base_R; $qte=mysql_num_rows($result); $ln=10; print ""; print ""; print ""; print ""; print ""; print ""; $i=0 ; while ($row = mysql_fetch_row($result,MYSQL_NUM)) { $RowColor = chgcolor(); print ""; $i++; print ""; print ""; //print ""; print "

"; } print "

No. Client:	$qte Nom (clik for Info)
$row[0]	$row[3]	$i

"; } // tab_out2 //function tab_out3 ($result,$Identifiant) { function tab_out3 ($result) { global $Base_R; $qte= mysql_num_rows($result); print ""; print ""; print ""; print ""; print ""; print ""; while ($row = mysql_fetch_row($result,MYSQL_NUM)) { // print ""; print ""; print ""; print ""; print "

"; } print "

Code:	$qte Fournisseurs
$row[0]	$row[2]

"; } // tab_out3 // liste du panier //function tab_out6 (result, client) { function tab_out6 ($result, $client) { global $Base_R; $qte= mysql_num_rows($result); print ""; print ""; print "\n"; print "\n"; print "\n"; print ("\n"); print ""; print ""; while ($row = mysql_fetch_row($result,MYSQL_NUM)) { $tot=$row[2]*$row[3]; $RowColor = chgcolor(); print "\n"; print "\n";//quantite //print "\n";//code //print "";//article print "\n";//article //print "\n";//prix Unite $tot=number_format($tot,'2') ; print "\n"; print "\n"; print "\n"; print ""; print "

"; $total=$total+($row[2]*$row[3]) ; } $total=number_format($total+20,'2'); print "

Qte	$qte Articles	Total	\n"); print (" \n"); print (" \n"); print ("
$row[3]	$row[4]	$row[1]	$row[1]	$row[2]	$tot	\n"; print " \n"; print "\n"; print "

\n"; print "\n"; print "\n"; print "\n"; print ("\n"); print ("\n"); print ("

Tax Transport Fr 20.00	Go order
TTC SWISS CH Fr.$total	\n"); print (" \n"); print (" \n"); print (" \n"); print ("

\n"); } // tab_out6