<tr>
<th>Sno</th>
<th>Customer ID</th>
<th>Merchant ID</th>
<th>Age</th>
<th>Sex</th>
<th>Amount</th>
<th>Time</th>
<th>Date</th>
</tr>
</thead>
<tbody>
<?php
require '../DataBaseConnect.php';
$database = new DataBaseConnect();
$result = $database->execute_query_return("select * from `transactions`");
while ($row = mysql_fetch_array($result)) {
echo "<tr>";
echo "<td>" . $row['sno'] . "</td>";
echo "<td>" . $row['cid'] . "</td>";
echo "<td>" . $row['mid'] . "</td>";
echo "<td>" . $row['age'] . "</td>";
echo "<td>" . $row['sex'] . "</td>";
echo "<td>" . $row['amount'] . "</td>";
echo "<td>" . $row['time'] . "</td>";
echo "<td>" . $row['date'] . "</td>";
echo "</tr>";
}
?>
</tbody>
Mobile: 9591279206<br>
Sex: Male<br><br>
<table border="1">
<tr>
<td>Sno</td>
<td>Customer ID</td>
<td>Merchant ID</td>
<td>Age</td>
<td>Sex</td>
<td>Amount</td>
<td>Time</td>
<td>Date</td>
</tr>
<?php
$result = $database->execute_query_return("select * from `transactions` where `cid`=119555");
while ($row = mysql_fetch_array($result)) {
echo "<tr>";
echo "<td>" . $row['sno'] . "</td>";
echo "<td>" . $row['cid'] . "</td>";
echo "<td>" . $row['mid'] . "</td>";
echo "<td>" . $row['age'] . "</td>";
echo "<td>" . $row['sex'] . "</td>";
echo "<td>" . $row['amount'] . "</td>";
echo "<td>" . $row['time'] . "</td>";
echo "<td>" . $row['date'] . "</td>";
echo "</tr>";
}
?>
</table>
</body>
return $args;
}
?>
<?php
require 'DataBaseConnect.php';
$database = new DataBaseConnect();
// $mid = rand(10,100);
// $cid = rand(100000,1000000);
// $amount = rand(1,10000);
// $age = rand(15,90);
// $sex = rand(1,2);
date_default_timezone_set('Asia/Kolkata');
$time = (string) date("H:i");
$date = date("d/m/Y");
// $database->execute_query_update("INSERT INTO `transactions`(`cid`, `mid`, `age`, `sex`, `amount`, `time`, `date`) VALUES (".$cid.",".$mid.",".$age.",".$sex.",".$amount.",'".$time."','".$date."')");
try {
$mid = $_GET['mid'];
$cid = $_GET['cid'];
$amount = $_GET['amount'];
$age = $_GET['age'];
$sex = $_GET['sex'];
$database->execute_query_update("INSERT INTO `transactions`(`cid`, `mid`, `age`, `sex`, `amount`, `time`, `date`) VALUES (" . $cid . "," . $mid . "," . $age . "," . $sex . "," . $amount . ",'" . $time . "','" . $date . "')");
$result = $database->execute_query_return("select * from `merchant1` where cid=" . $cid);
$row = mysql_fetch_array($result);
$newBalance = $row['balance'] + $amount;
echo $row['balance'] . " " . $amount;
$database->execute_query_update("UPDATE `merchant1` SET `balance` = " . $newBalance . " where `cid`=" . $cid);
} catch (Exception $e) {
echo 'Caught exception: ', $e->getMessage(), "\n";
}
<head>
<title>Merchant Details</title>
</head>
<body leftmargin="450">
<img src="img/User.png" /><br>
Merchant name: McDonalds<br>
ID: 58<br><br>
<table border="1">
<tr>
<td>Sno</td>
<td>Customer ID</td>
<td>Customer Name</td>
<td>Balance</td>
<td>Mobile</td>
</tr>
<?php
$result = $database->execute_query_return("select * from `merchant1`");
while ($row = mysql_fetch_array($result)) {
echo "<tr>";
echo "<td>" . $row['sno'] . "</td>";
echo "<td>" . $row['cid'] . "</td>";
echo "<td>" . $row['cname'] . "</td>";
echo "<td>" . $row['balance'] . "</td>";
echo "<td>" . $row['mobile'] . "</td>";
echo "</tr>";
}
?>
</table>
</body>
</html>
<title>View Customer Transactions</title>
</head>
<body>
<table border="1">
<tr>
<td>Sno</td>
<td>Customer ID</td>
<td>Merchant ID</td>
<td>Age</td>
<td>Sex</td>
<td>Amount</td>
<td>Time</td>
<td>Date</td>
</tr>
<?php
$result = $database->execute_query_return("select * from `transactions` where cid=805707");
while ($row = mysql_fetch_array($result)) {
echo "<tr>";
echo "<td>" . $row['sno'] . "</td>";
echo "<td>" . $row['cid'] . "</td>";
echo "<td>" . $row['mid'] . "</td>";
echo "<td>" . $row['age'] . "</td>";
echo "<td>" . $row['sex'] . "</td>";
echo "<td>" . $row['amount'] . "</td>";
echo "<td>" . $row['time'] . "</td>";
echo "<td>" . $row['date'] . "</td>";
echo "</tr>";
}
?>
</table>
</body>
