Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $sql = "SELECT * FROM res WHERE email = '$email'";
- $result = mysqli_query($conn, $sql);
- if (mysqli_num_rows($result) > 0) {
- // Fetching data
- while ($row = mysqli_fetch_array($result)) {
- // Get User ID
- $_SESSION['user_id'] = $row['id'];
- $user_id = $_SESSION['user_id'];
- $url = $row['files'];
- // Get Files
- $_SESSION['files'] = $row['files'];
- $file = $_SESSION['files'];
- $edit = [
- 'id' => $row['id'],
- 'files' => $row['files']
- ];
- ?>
- <ul class="list-style">
- <li>
- <!-- Get Data of Specific id -->
- <?php echo "
- <div class='col-md-6'>
- $row[name]
- </div>
- <div class='col-md-6'>
- <a class='btn btn-primary' href='edit.php?'.http_build_query($edit, null, '&', PHP_QUERY_RFC3986).'>Edit</a>
- <a class='btn btn-danger' href='delete.php?id=$row[id]'>X</a>
- </div><br/>";
- ?>
- </li>
- </ul>
- <?php
- }
- }
- ?>
- include("config.php");
- if (isset($_GET['edit'])) {
- // $id = $_GET['edit'];
- $id = $_GET['id'];
- $files = $_GET['files'];
- $sql = "SELECT * FROM res WHERE id = '$id'";
- $result = mysqli_query($conn, $sql);
- $row = mysqli_fetch_array($result);
- }
- if (isset($_POST['name'])) {
- $name = $_POST['name'];
- $email = $_POST['email'];
- $phone = $_POST['phone'];
- $id = $_POST['id'];
- $sql2 = "UPDATE res SET name='$name', email='$email', phone_number='$phone' WHERE id = '$id'";
- $result2 = mysqli_query($conn, $sql2);
- echo "<meta http-equiv='refresh' content='0;url=list.php'>";
- }
- $edit = [
- 'id' => $row['id'],
- 'files' => $row['files']
- ];
- echo '<a href="edit.php?'.http_build_query($edit, null, '&', PHP_QUERY_RFC3986).'">Link</a>';
- $id = $_GET['id'];
- $files = $_GET['files'];
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement