Cześć. Jak poprawnie z aktualizować bazę danych. Pobranie z bazy danych jest poprawne. Nie działa tylko update.
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");
echo 'Connected to Database <br/>'; ?>
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
if(isset($_POST['Submit'])){ $hGoals = $_POST['inphomegoals'];
$gGoals = $_POST['inpguestGoals'];
$update="UPDATE matches SET homeGoals=$hGoals, guestGoals=$gGoals where matchID = ".$matchID;
$stmt = $conn->prepare($update);
$stmt->execute();
echo $stmt->rowCount() . " records UPDATED successfully"; }
$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 class="matchID">
<?php echo $row['matchID']; ?></label></td>
<td><label>
<?php echo $row['homeClub']; ?></label></td>
<td><label>
<?php echo $row['guestClub']; ?></label></td>
<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>