Källkod
Följande filer och mappar finns under mappen webbserverprogrammering.
Mappar visas till vänster och filer till höger. Klicka på en fil eller mapp för att öppna nedan eller visa dess innehåll.
webbserverprogrammering/exercises/mysql/exercise_1/
10 filer
back_button.php
create_table.php
dbconnection.php
delete_row.php
delete_table.php
index.php
insert_default_values.php
insert_values.php
print_table.php
update_values.php
create_table.php
dbconnection.php
delete_row.php
delete_table.php
index.php
insert_default_values.php
insert_values.php
print_table.php
update_values.php
delete_row.php
94 lines ASCII Windows (CRLF)
12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394
<!DOCTYPE html>
<html lang="sv">
<head>
<title>Radera rad</title>
<meta charset="utf-8">
<style type="text/css">
table#data {
border-collapse: collapse;
}
#data td {
padding: 8px;
border: 1px solid #686868;
}
</style>
</head>
<body>
<?php
include('back_button.php');
include ('dbconnection.php');
$message = "";
if (isset($_POST['id']) && !empty($_POST['id'])) {
$id = $_POST['id'];
try {
# prepare
$sql = "DELETE FROM kompisar WHERE id=?";
$stmt = $dbconn->prepare($sql);
# the data we want to insert
$data = [$id];
# execute width array-parameter
$stmt->execute($data);
$message .= "<br>Raden raderades.<br>";
}
catch(PDOException $e)
{
$message .= $sql . "<br>" . $e->getMessage();
}
} else {
//$message .= "<br>";
}
echo $message;
// Ouput table with all posts
/*** The SQL SELECT statement ***/
$sql = "SELECT * FROM kompisar";
$stmt = $dbconn->prepare($sql);
// fetch width column names, create a table
$data = [];
$stmt->execute($data); // empty array just for consistency
$output = " <table id='data'>
<caption>
<strong>Kompisar</strong>
</caption>
<br><br>";
while ($response = $stmt->fetch(PDO::FETCH_ASSOC)) {
$getId = htmlentities($response['id']);
$getFirstname = htmlentities($response['firstname']);
$getLastname = htmlentities($response['lastname']);
$getMobile = htmlentities($response['mobile']);
$getEmail = htmlentities($response['email']);
$output .= "
<tr>
<td>$getId</td>
<td>$getFirstname</td>
<td>$getLastname</td>
<td>$getMobile</td>
<td>$getEmail</td>
<td>
<form method='post' action=''>
<input type='hidden' name='id' value='$getId'>
<button type='submit'>Ta bort</button>
</form>
</td>
</tr>";
}
$output .= "</table>";
echo $output;
$dbconn = null;
?>
</body>
</html>