This is my first attempt at relational database, I am getting this error(s):
Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /Library/WebServer/Documents/comics/index.php on line 92
Add your own comic
Here are all the comics in the database:
Notice: Undefined variable: comicinfo in /Library/WebServer/Documents/comics/comics.html.php on line 12
Warning: Invalid argument supplied for foreach() in /Library/WebServer/Documents/comics/comics.html.php on line 12
<body>
<p><a href="?addcomic">Add your own comic</a></p>
<p>Here are all the comics in the database:</p>
<?php foreach ($comicinfo as $comicinfo): ?>
<form action="?deletecomic" method="post">
<blockquote>
<p>
<?php echo htmlspecialchars($Comics['ComicNumber'], ENT_QUOTES,
'UTF-8'); ?>
<?php echo htmlspecialchars($Comics['ComicName'], ENT_QUOTES,
'UTF-8'); ?>
<?php echo htmlspecialchars($Comics['ComicTitle'], ENT_QUOTES,
'UTF-8'); ?>
<?php echo htmlspecialchars($Comics['ComicDate'], ENT_QUOTES,
'UTF-8'); ?>
<input type="hidden" name="id" value="<?php
echo $Comics['id']; ?>"/>
<!-- <input type="submit" value="Delete"/> -->
(by <?php echo htmlspecialchars($Comics['ComicAuthor'], ENT_QUOTES,
'UTF-8'); ?>)
</p>
</blockquote>
</form>
<?php endforeach; ?>
</body>
</html>
<body>
<form action="?" method="post">
<div>
<label for="ComicNumber">Comic Number:</label>
<textarea id="ComicNumber" name="ComicNumber" rows="1" cols="10"></textarea>
<label for="ComicName">Comic Name:</label>
<textarea id="ComicName" name="ComicName" rows="1" cols="10"></textarea>
<label for="ComicTitle">Comic Title:</label>
<textarea id="ComicTitle" name="ComicTitle" rows="1" cols="10"></textarea>
<label for="ComicDate">Comic Date:</label>
<textarea id="ComicDate" name="ComicDate" rows="1" cols="10"></textarea>
</div>
<div><input type="submit" value="Add"/></div>
</form>
</body>
</html>
if (isset($_POST['ComicNumber']))
{
$comicinfo = mysqli_real_escape_string($link, $_POST['ComicNumber']);
$sql = 'INSERT INTO Comics SET
ComicNumber="' . $ComicNumber . '",
ComicName="' . $ComicName . '",
ComicTitle="' . $ComicTitle . '",
ComicDate="' . $ComicDate . '"';
if (!mysqli_query($link, $sql))
{
$error = 'Error adding submitted Comic: ' . mysqli_error($link);
include 'error.html.php';
exit();
}
header('Location: .');
exit();
}
if (isset($_GET['deletejoke']))
{
$id = mysqli_real_escape_string($link, $_POST['id']);
$sql = "DELETE FROM joke WHERE id='$id'";
if (!mysqli_query($link, $sql))
{
$error = 'Error deleting joke: ' . mysqli_error($link);
include 'error.html.php';
exit();
}
header('Location: .');
exit();
}
$result = mysqli_query($link,
'SELECT Comics.id, ComicNumber, ComicName, ComicTitle, ComicDate, ComicAuthor
FROM Comics INNER JOIN ComciAuthor
ON AuthorId = ComicAuthor.id');
/*if (!$result)
{
$error = 'Error fetching Comics: ' . mysqli_error($link);
include 'error.html.php';
exit();
}
*/
while ($row = mysqli_fetch_array($result))
{
$Comics[] = array('id' => $row['id'], 'ComicNumber' => $row['ComicNumber'],
'ComicName' => $row['ComicName'], 'ComicTitle' => $row['ComicTitle'],
'ComicDate' => $row['ComicDate'], 'ComicAuthor' => $row['ComicAuthor']);
}
include 'comics.html.php';
?>