pano ko kaya palalabasin lahat ng data ko.. kasi kapag nilog in ko na sya as user may lumalabas naman na output/data kaso isang data lang gusto ko sana lahat ng data ni ganito ay lalabas.. at yun huli kong input o update ko ay sya ang nasa unahan..
ito po code ko
sample.php
<?php
session_start();
include "../config/config.php";
if(isset($_SESSION['id'])){
$user_id = $_SESSION['id'];
$_GET_RECORD = mysqli_query($con,"SELECT * FROM
while($row_edit = mysqli_fetch_assoc($_GET_RECORD)) {
$payee_name = $row_edit['payee_name'];
$email_address = $row_edit['email_address'];
$phone = $row_edit['phone'];
$birthday = $row_edit['birthday'];
$username = $row_edit['username'];
$password = $row_edit['password'];
}
}else {
echo "You must login first! <a href = '../login.php'>Login now! </a>";
}
$slq = "SELECT login.payee_name, payment.particular, payment.amount, payment.lddap_ada, payment.date FROM login INNER JOIN payment ON login.payee_name = payment.payee_name WHERE login.username = '$username' AND login.password = '$password' ";
$result = $con->query($slq);
if($result -> num_rows > 0) {
while ($row = $result->fetch_assoc()) {
$payee_name = $row["payee_name"];
$particular = $row["particular"] ;
$amount = $row["amount"];
$lddap_ada = $row["lddap_ada"] ;
$date = $row["date"];
}
} else {
echo "No results found.";
}
// I-close ang connection
$con->close();
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Document</title>
<link rel = "stylesheet" href ="../css/bootstrap.css">
<script src="../js/bootstrap.bundle.js"></script>
</head>
<body>
<div class="container mt-3">
<h2>Striped Rows</h2>
<p>The .table-striped class adds zebra-stripes to a table:</p>
<table class="table table-striped">
<thead>
<tr>
<th>Payee Name</th>
<th>Particular</th>
<th>Amount</th>
<th>LDDAP ADA</th>
<th>Date</th>
<th>Status</th>
</tr>
</thead>
<tbody>
<td><?php echo $payee_name; ?></td>
<td><?php echo $particular; ?></td>
<td><?php echo $amount; ?></td>
<td><?php echo $lddap_ada; ?></td>
<td><?php echo $date; ?></td>
<td><?php ?></td>
</tr>
</tbody>
</table>
</div>
</body>
</html>
ito po code ko
sample.php
<?php
session_start();
include "../config/config.php";
if(isset($_SESSION['id'])){
$user_id = $_SESSION['id'];
$_GET_RECORD = mysqli_query($con,"SELECT * FROM
login
WHERE id = '$user_id' ");while($row_edit = mysqli_fetch_assoc($_GET_RECORD)) {
$payee_name = $row_edit['payee_name'];
$email_address = $row_edit['email_address'];
$phone = $row_edit['phone'];
$birthday = $row_edit['birthday'];
$username = $row_edit['username'];
$password = $row_edit['password'];
}
}else {
echo "You must login first! <a href = '../login.php'>Login now! </a>";
}
$slq = "SELECT login.payee_name, payment.particular, payment.amount, payment.lddap_ada, payment.date FROM login INNER JOIN payment ON login.payee_name = payment.payee_name WHERE login.username = '$username' AND login.password = '$password' ";
$result = $con->query($slq);
if($result -> num_rows > 0) {
while ($row = $result->fetch_assoc()) {
$payee_name = $row["payee_name"];
$particular = $row["particular"] ;
$amount = $row["amount"];
$lddap_ada = $row["lddap_ada"] ;
$date = $row["date"];
}
} else {
echo "No results found.";
}
// I-close ang connection
$con->close();
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Document</title>
<link rel = "stylesheet" href ="../css/bootstrap.css">
<script src="../js/bootstrap.bundle.js"></script>
</head>
<body>
<div class="container mt-3">
<h2>Striped Rows</h2>
<p>The .table-striped class adds zebra-stripes to a table:</p>
<table class="table table-striped">
<thead>
<tr>
<th>Payee Name</th>
<th>Particular</th>
<th>Amount</th>
<th>LDDAP ADA</th>
<th>Date</th>
<th>Status</th>
</tr>
</thead>
<tbody>
<td><?php echo $payee_name; ?></td>
<td><?php echo $particular; ?></td>
<td><?php echo $amount; ?></td>
<td><?php echo $lddap_ada; ?></td>
<td><?php echo $date; ?></td>
<td><?php ?></td>
</tr>
</tbody>
</table>
</div>
</body>
</html>