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
|
<?php
class facture
{
public $num_facture;
public $prix_total;
function connexion()
{
mysql_connect("127.0.0.1","root","") or die("echec de connexion à base");
$con=mysql_select_db("pfementionnée");
}
function afficherprix()
{
$login=$_GET['login'];
$requete="select * from client where login='$login';";
$result=@mysql_query($requete);
$ligne=@mysql_fetch_row($result);
$req="select * from reservationcircuit where cin='$ligne[0]';";
$result1=@mysql_query($req);
$num=mysql_num_rows($result1);
while($ligne1=@mysql_fetch_row($result1))
{
$req1="select * from circuit where id_circuit='$ligne1[0]';";
$res1=@mysql_query($req1);
$lig1=@mysql_fetch_row($res1);
$prix=0;
echo $prix=$lig1[6]*$ligne1[3];
}
}
}
$obj=new facture;
$obj->connexion();
$obj->afficherprix();
?> |