Nie wyświetla błędów ani w kodzie i po otwarciu strony. Mam dwa pola input w każdym rekordzie i według głównego ID w każdym rekordzie chce zrobić update bazy. Albo czegoś mi brakuję albo źle ułożyłem zmienne w update
tabela którą che edytować w bazie wygląda tak:
matches (matchID, homeID, guestID, homeGoals, guestGoals)
connect.php
<?php $db_server = "localhost"; $db_username = "root"; $db_password = ""; $db_database = "football_db"; $conn = new PDO("mysql:host=$db_server;dbname=$db_database", $db_username, $db_password); $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $conn->exec("set names utf8"); ?>
index.php
<form action="" method="put"> <table width="100%"> <thead> <tr> <td class="colsp" colspan="5">Terminarz</td> </tr> <tr class="subcolor title-row"> <td style="width: 10%">id</td> <td style="width: 40%" class="left">Gospodarz</td> <td style="width: 40%">Gość</td> <td style="width: 5%">Home<br/>Goals</td> <td style="width: 5%">Guest<br/>Goals</td> </tr> </thead> <tbody> <?php $hGoals = $_POST['inphomegoals']; $gGoals = $_POST['inpguestGoals']; $update="UPDATE matches SET homeGoals=$hGoals, guestGoals=$gGoals where matchID = ".$matchID; $stmt = $conn->prepare($update); $stmt->execute(); } $display = $conn->prepare( "SELECT m.matchID, hc.clubName as homeClub, gc.clubName as guestClub, m.homeGoals, m.guestGoals FROM matches AS m JOIN clubs AS hc ON hc.clubID = m.homeID JOIN clubs AS gc ON gc.clubID = m.guestID ORDER BY matchID ASC "); $display->execute(); $results = $display->fetchAll(); foreach ($results as $index => $row){ ?> <tr> <td><label><input type="number" name="inphomegoals" value="<?php echo $row['homeGoals']; ?>"/> : </label></td> <td><label><input type="number" name="inpguestGoals" value="<?php echo $row['guestGoals']; ?>"</label></td> </tr> <?php } ?> </tbody> <tfoot> <tr> <td colspan="5"><input type="submit" value="Add To Base" name="Submit" style="width: 150px; height: 45px"</td> </tr> </tfoot> </table> </form>