Jump to content

idan

New Members
 View Profile  See their activity

  • Posts

    6

  • Joined

  • Last visited

idan's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. idan
    I'm trying to add function to my crud table, whenever I press on the button the table will update with no need to refresh the page with order by name in descending order. Its doesn't do anything and I'm kind of lost I don't think my SQL code is incorrect so it must be somting else that I'm doing This is my main page where the button and the table is presented <!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"> <link rel="stylesheet" href="https://www.w3schools.com/w3css/4/w3.css"> <link href="https://cdn.jsdelivr.net/npm/[email protected]/dist/css/bootstrap.min.css" rel="stylesheet"> <title>Logistics Page</title> </head> <body> <div class="w3-top"> <div class="w3-bar w3-white w3-wide w3-padding w3-card"> <div class="w3-right w3-hide-small"> <a href="homePage.html" class="w3-bar-item w3-button">homePage</a> <a href="playertable.php" class="w3-bar-item w3-button">Players</a> <a href="Calandar.php" class="w3-bar-item w3-button">Calendar</a> <a href="Logistics.html" class="w3-bar-item w3-button">Logistics</a> <a href="Finance.php" class="w3-bar-item w3-button">contracts</a> <a href="about.html" class="w3-bar-item w3-button">About</a> <a href="contact.html" class="w3-bar-item w3-button">Contact</a> <a href="logout.php" class="w3-bar-item w3-button">Logout</a> </div> </div> </div> <div class="container mt-5"> <?php session_start(); require 'config.php'; ?> <br> <br> <div class="container mt-4"> <?php include('message.php'); ?> <div class="row"> <div class="col-md-12"> <div class="card"> <div class="card-header"> <h4>order Details <a href="create-player.php" class="btn btn-primary float-end">Add order</a> </h4> </div> <div class="card-body"> <table class="table table-bordered table-striped"> <thead> <tr> <th>Photo</th> <th>ID</th> <form action="playercode.php" method="POST" class="d-inline"> <!-- <th><input type="submit" value="First Name" name = "orderbyname" id="orderbyname"></th> --> <th> <button type="submit" name="orderbyname" class="btn btn-dark btn-sm">First Name</button> </th> </form> <th>Last Name</th> <th><input type="submit" value="Date of birth" name = "ageorder" id="ageorder"></th> <th>E-mail</th> <th>Phone</th> <th>Action</th> </tr> </thead> <tbody> <?php $query = "SELECT * FROM players"; $query_run = mysqli_query($conn,$query); if(mysqli_num_rows($query_run) > 0) { foreach($query_run as $row) { ?> <tr> <td><img src="<?= $row['Photo']; ?>"width='64px'></td> <td><?= $row['ID']; ?></td> <td><?= $row['Fname']; ?></td> <td><?= $row['Lname']; ?></td> <td><?= $row['Age']; ?></td> <td><?= $row['Email']; ?></td> <td><?= $row['Phone']; ?></td> <td> <a href="player-view.php?id=<?= $row['ID']; ?>" class="btn btn-info btn-sm">View</a> <a href="player-edit.php?id=<?= $row['ID']; ?>" class="btn btn-success btn-sm">Edit</a> <form action="playercode.php" method="POST" class="d-inline"> <button type="submit" name="delete_player" value="<?=$row['ID'];?>" class="btn btn-danger btn-sm">Delete</button> </form> </td> </tr> <?php } } else { echo "<h5> No Record Found </h5>"; } ?> </tbody> </table> </div> </div> </div> </div> </div> <script src="https://cdn.jsdelivr.net/npm/[email protected]/dist/js/bootstrap.bundle.min.js"></script> </body> </html> And this is the PHP code in a different page if(isset($_POST['orderbyname'])){ $readQuery = "SELECT * FROM players ORDER BY Fname DESC"; $readRess = mysqli_query($conn,$readQuery); if($readRess){ header("Location: stam.php"); exit(0); } }
  2. idan
    i dont understand you man i showed you the code that insert the data into the DB if(isset($_POST['save_contract'])) { $ID = $_POST['id']; $fullname = $_POST['fname']; $pcontract=$_FILES['pcontract']['name']; $img_loc=$_FILES['pcontract']['tmp_name']; $img_ext = pathinfo($pcontract,PATHINFO_EXTENSION); $img_des = "contracts/".$img_ext; move_uploaded_file($img_loc,$img_des); $passport=$_FILES['passport']['name']; $img_loc1=$_FILES['passport']['tmp_name']; $img_ext1 = pathinfo($passport,PATHINFO_EXTENSION); $img_des1 = "contracts/".$img_ext1; move_uploaded_file($img_loc1,$img_des1); $playerapproval=$_FILES['playerapproval']['name']; $img_loc2=$_FILES['playerapproval']['tmp_name']; $img_ext2 = pathinfo($playerapproval,PATHINFO_EXTENSION); $img_des2 = "contracts/".$img_ext2; move_uploaded_file($img_loc2,$img_des2); $testapproval=$_FILES['testapproval']['name']; $img_loc3=$_FILES['testapproval']['tmp_name']; $img_ext3 = pathinfo($testapproval,PATHINFO_EXTENSION); $img_des3 = "contracts/".$img_ext3; move_uploaded_file($img_loc3,$img_des3); $rent=$_FILES['rent']['name']; $img_loc4=$_FILES['rent']['tmp_name']; $img_ext4 = pathinfo($rent,PATHINFO_EXTENSION); $img_des4 = "contracts/".$img_ext4; move_uploaded_file($img_loc4,$img_des4); $insert = "INSERT INTO contracts(id, fullname, pcontract, passport, playerapproval, testapproval, rent) VALUES ('$ID','$fullname','$img_des','$img_des1','$img_des2','$img_des3','$img_des4')"; $query_run = mysqli_query($conn, $insert); if($query_run) { $_SESSION['message'] = "contract Created Successfully"; header("Location: Logistics.php"); exit(0); } else { $_SESSION['message'] = "contract Not Created"; header("Location: Logistics.php"); exit(0); } } and this is the table where i display all the data from the DB <tbody> <?php $query = "SELECT * FROM contracts"; $query_run = mysqli_query($conn,$query); if(mysqli_num_rows($query_run) > 0) { foreach($query_run as $row) { ?> <tr> <td><?= $row['id']; ?></td> <td><?= $row['fullname']; ?></td> <td> <img src="<?= $row['pcontract'];?>"width='100px'> </td> <td><img src="<?= $row['passport']; ?>"width='64px'></td> <td><img src="<?= $row['playerapproval']; ?>"width='64px'></td> <td><img src="<?= $row['testapproval']; ?>"width='64px'></td> <td><img src="<?= $row['rent']; ?>"width='64px'></td> <td> <a href="contract-view.php?id=<?= $row['id']; ?>" class="btn btn-info btn-sm">View</a> <a href="contract-edit.php?id=<?= $row['id']; ?>" class="btn btn-success btn-sm">Edit</a> <form action="contractcode.php" method="POST" class="d-inline"> <button type="submit" name="delete_contract" value="<?=$row['id'];?>" class="btn btn-danger btn-sm">Delete</button> </form> </td> </tr> <?php } } else { echo "<h5> No Record Found </h5>"; } ?> </tbody>
  3. idan
    i need to display the data inside a table on the top i copied my insert code and on button the table that you offered me
  4. idan
    ok i got a bigger problem now its displaying the same image for all field. this is the insert code if(isset($_POST['save_contract'])) { $ID = $_POST['id']; $Fname = $_POST['fullname']; $pcontract=$_FILES['pcontract']['name']; $img_loc=$_FILES['pcontract']['tmp_name']; $img_ext = pathinfo($pcontract,PATHINFO_EXTENSION); $img_des = "contracts/".$img_ext; move_uploaded_file($img_loc,$img_des); $passport=$_FILES['passport']['name']; $img_loc1=$_FILES['passport']['tmp_name']; $img_ext1 = pathinfo($passport,PATHINFO_EXTENSION); $img_des1 = "contracts/".$img_ext1; move_uploaded_file($img_loc1,$img_des1); $playerapproval=$_FILES['playerapproval']['name']; $img_loc2=$_FILES['playerapproval']['tmp_name']; $img_ext2 = pathinfo($playerapproval,PATHINFO_EXTENSION); $img_des2 = "contracts/".$img_ext2; move_uploaded_file($img_loc2,$img_des2); $testapproval=$_FILES['testapproval']['name']; $img_loc3=$_FILES['testapproval']['tmp_name']; $img_ext3 = pathinfo($testapproval,PATHINFO_EXTENSION); $img_des3 = "contracts/".$img_ext3; move_uploaded_file($img_loc3,$img_des3); $rent=$_FILES['rent']['name']; $img_loc4=$_FILES['rent']['tmp_name']; $img_ext4 = pathinfo($rent,PATHINFO_EXTENSION); $img_des4 = "contracts/".$img_ext4; move_uploaded_file($img_loc4,$img_des4); $insert = "INSERT INTO contracts(id, fullname, pcontract, passport, playerapproval, testapproval, rent) VALUES ('$ID','$Fname','$img_des','$img_des1','$img_des2','$img_des3','$img_des4')"; $query_run = mysqli_query($conn, $insert); if($query_run) { $_SESSION['message'] = "contract Created Successfully"; header("Location: Logistics.php"); exit(0); } else { $_SESSION['message'] = "contract Not Created"; header("Location: Logistics.php"); exit(0); } } and this is the table <tbody> <?php echo "<tbody>"; $query = "SELECT * FROM contracts"; $query_run = mysqli_query($conn,$query); if(mysqli_num_rows($query_run) > 0) { foreach($query_run as $row) { echo " <tr> <td>{$row['id']}</td> <td>{$row['fullname']}</td> <td><img src='{$row['pcontract']}' width='64px'></td> <td><img src='{$row['passport']}' width='64px'></td> <td><img src='{$row['playerapproval']}' width='64px'></td> <td><img src='{$row['testapproval']}' width='64px'></td> <td><img src='{$row['rent']}' width='64px'></td> <td> <a href='contract-view.php?id={$row['id']}' class='btn btn-info btn-sm'>View</a> <a href='contract-edit.php?id={$row['id']}' class='btn btn-success btn-sm'>Edit</a> <form action='contractcode.php' method='POST class='d-inline'> <button type='submit' name='delete_contract' value='{$row['id']}' class='btn btn-danger btn-sm'>Delete</button> </form> </td> </tr>"; } } else echo "<h5> No Record Found </h5>"; echo "</tbody>";?> </table>
  5. idan
    its still not displaying the images, im saving the images into a folder name contracts, if im open the folder the images are there but its just not displaying them. im trying to refernce them from the folder but its still not displaying them. im adding the code <td><img src='contracts/.{$row['pcontract']}' width='64px'></td> what im doing wrong ?
  6. idan
    I'm trying to upload multi images to the database all in separated fields and displaying them in a table. Im able to upload them into the DB but the images are not displaying all I see is image icon? this is the insert query if(isset($_POST['save_contract'])) { $ID = $_POST['id']; $Fname = $_POST['fullname']; $pcontract=$_FILES['pcontract']['name']; $img_loc=$_FILES['pcontract']['tmp_name']; $img_ext = pathinfo($pcontract,PATHINFO_EXTENSION); $img_des = "contracts/".$img_ext; move_uploaded_file($img_loc,$img_des); $passport=$_FILES['passport']['name']; $img_loc1=$_FILES['passport']['tmp_name']; $img_ext1 = pathinfo($passport,PATHINFO_EXTENSION); $img_des1 = "contracts/".$img_ext1; move_uploaded_file($img_loc1,$img_des1); $playerapproval=$_FILES['playerapproval']['name']; $img_loc2=$_FILES['playerapproval']['tmp_name']; $img_ext2 = pathinfo($playerapproval,PATHINFO_EXTENSION); $img_des2 = "contracts/".$img_ext2; move_uploaded_file($img_loc2,$img_des2); $testapproval=$_FILES['testapproval']['name']; $img_loc3=$_FILES['testapproval']['tmp_name']; $img_ext3 = pathinfo($testapproval,PATHINFO_EXTENSION); $img_des3 = "contracts/".$img_ext3; move_uploaded_file($img_loc3,$img_des3); $rent=$_FILES['rent']['name']; $img_loc4=$_FILES['rent']['tmp_name']; $img_ext4 = pathinfo($rent,PATHINFO_EXTENSION); $img_des4 = "contracts/".$img_ext4; move_uploaded_file($img_loc4,$img_des4); $insert = "INSERT INTO contracts(id, fullname, pcontract, passport, playerapproval, testapproval, rent) VALUES ('$ID','$Fname','$img_des','$img_des1','$img_des2','$img_des3','$img_des4')"; $query_run = mysqli_query($conn, $insert); if($query_run) { $_SESSION['message'] = "contract Created Successfully"; header("Location: Logistics.php"); exit(0); } else { $_SESSION['message'] = "contract Not Created"; header("Location: Logistics.php"); exit(0); } } and this is the table body where i display the data from the DB again its just displaying image icon not the picture itself i store the image in a folder name contracts. <tbody> <?php $query = "SELECT * FROM contracts"; $query_run = mysqli_query($conn,$query); if(mysqli_num_rows($query_run) > 0) { foreach($query_run as $row) { ?> <tr> <td><?= $row['id']; ?></td> <td><?= $row['fullname']; ?></td> <td><img src="<?= $row['pcontract']; ?>"width='64px'></td> <td><img src="<?= $row['passport']; ?>"width='64px'></td> <td><img src="<?= $row['playerapproval']; ?>"width='64px'></td> <td><img src="<?= $row['testapproval']; ?>"width='64px'></td> <td><img src="<?= $row['rent']; ?>"width='64px'></td> <td> <a href="contract-view.php?id=<?= $row['id']; ?>" class="btn btn-info btn-sm">View</a> <a href="contract-edit.php?id=<?= $row['id']; ?>" class="btn btn-success btn-sm">Edit</a> <form action="contractcode.php" method="POST" class="d-inline"> <button type="submit" name="delete_contract" value="<?=$row['id'];?>" class="btn btn-danger btn-sm">Delete</button> </form> </td> </tr> <?php } } else { echo "<h5> No Record Found </h5>"; } ?> </tbody>
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.