';
$result=mysqli_query($conn,"SELECT * FROM client, ordering WHERE client.ID = ordering.ID_CLIENT");
while ($row=mysqli_fetch_array($result))
{
echo $row[0].' '.$row[1].' '.$row[2].' '.$row[3].' '.$row[4].' '.$row[5].' '.$row[6].' '.$row[7].' '.$row[8].' '.$row[9].'
'.$row[10].' '.$row[11].' '.$row[12].'
';
}
echo '
';
echo"Ερώτημα 2";
echo '
';
$result=mysqli_query($conn,"SELECT * FROM client WHERE client.ID NOT IN (SELECT ordering.ID_CLIENT FROM ordering)");
while ($row=mysqli_fetch_array($result))
{
echo $row[0].' '.$row[1].' '.$row[2].' '.$row[3].' '.$row[4].' '.$row[5].' '.$row[6].' '.$row[7].' '.$row[8].'
';
}
echo '
';
echo"Ερώτημα 3";
echo '
';
$result=mysqli_query($conn,"SELECT client.NAME, product.MANUFACTURER
FROM product, client, ordering, orderlist
WHERE client.ID = ordering.ID_CLIENT
AND ordering.ID = orderlist.ID_ORDERING
AND product.ID = orderlist.ID_PRODUCT
AND product.MANUFACTURER='SONY'
GROUP BY client.NAME");
while ($row=mysqli_fetch_array($result))
{
echo $row['NAME'].' '.$row['MANUFACTURER'].'
';
}
echo '
';
echo"Ερώτημα 4";
echo '
';
$result=mysqli_query($conn,"SELECT * from ordering
WHERE ordering.ADVANCEPAY=0
ORDER BY ordering.ORDERDATE DESC");
while ($row=mysqli_fetch_array($result))
{
echo $row[0].' '.$row[1].' '.$row[2].' '.$row[3].' '.$row[4].' '.$row[5].'
';
}
echo '
';
echo"Ερώτημα 5";
echo '
';
$result=mysqli_query($conn,"SELECT ordering.ID, SUM(orderlist.PRICE*orderlist.QUANTITY)
FROM ordering, orderlist
WHERE ordering.ID = orderlist.ID_ORDERING
AND ordering.ADVANCEPAY!=0
GROUP BY orderlist.ID_ORDERING");
while ($row=mysqli_fetch_array($result))
{
echo $row[0].' '.$row[1].'
';
}
echo '
';
echo"Ερώτημα 6";
echo '
';
$result=mysqli_query($conn,"SELECT client.NAME, ordering.ORDERDATE, ordering.ADVANCEPAY,
(SUM(orderlist.PRICE*orderlist.QUANTITY) - ordering.ADVANCEPAY) AS Υπόλοιπο
FROM client, ordering, orderlist
WHERE ordering.ID = orderlist.ID_ORDERING
AND client.ID = ordering.ID_CLIENT
AND client.NAME='PerfectSoft'
GROUP BY ordering.ID");
while ($row=mysqli_fetch_array($result))
{
echo $row[0].' '.$row[1].' '.$row[2].' '.$row[3].'
';
}
echo '
';
echo"Ερώτημα 7";
echo '
';
mysqli_query($conn,"UPDATE client SET client.ADDRESS='Ερυθρού Σταυρού 5' where client.NAME='SISMA SA'");
$result=mysqli_query($conn,"SELECT * from client");
while ($row=mysqli_fetch_array($result))
{
echo $row[0].' '.$row[1].' '.$row[2].' '.$row[3].' '.$row[4].' '.$row[5].' '.$row[6].' '.$row[7].' '.$row[8].'
';
}
echo '
';
echo"Ερώτημα 8";
echo '
';
$result=mysqli_query($conn,"SELECT * from ordering
WHERE ordering.ORDERDATE>'2020-11-30' AND ordering.ORDERDATE<='2020-12-31'
ORDER BY ordering.ORDERDATE ASC
");
while ($row=mysqli_fetch_array($result))
{
echo $row[0].' '.$row[1].' '.$row[2].' '.$row[3].' '.$row[3].'
';
}
mysqli_close();
?>