<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>