[solved]-Anyone Help Question 5 6 Soon Possible Connecterror Die Conn Connecterror Isset Post Delet Q39055628

Can anyone help me with question 5 and 6 as soon aspossible.

<?php // sqltest.php
require_once ‘login.php’;
$conn = new mysqli($hn, $un, $pw, $db);
if ($conn->connect_error) die($conn->connect_error);

if (isset($_POST[‘delete’]) &&isset($_POST[‘isbn’]))
{
$isbn = get_post($conn, ‘isbn’);
$query = “DELETE FROM classics WHERE isbn=’$isbn'”;
$result = $conn->query($query);
   if (!$result) echo “DELETE failed: $query<br>”.
$conn->error . “<br><br>”;
}

if (isset($_POST[‘author’]) &&
isset($_POST[‘title’]) &&
isset($_POST[‘category’]) &&
isset($_POST[‘year’]) &&
isset($_POST[‘isbn’]))
{
$author = get_post($conn, ‘author’);
$title = get_post($conn, ‘title’);
$category = get_post($conn, ‘category’);
$year = get_post($conn, ‘year’);
$isbn = get_post($conn, ‘isbn’);
$query = “INSERT INTO classics VALUES” .
“(‘$author’, ‘$title’, ‘$category’, ‘$year’, ‘$isbn’)”;
$result = $conn->query($query);

   if (!$result) echo “INSERT failed:$query<br>” .
$conn->error . “<br><br>”;
}

echo <<<_END
<form action=”sqltest.php” method=”post”><pre>
Author <input type=”text” name=”author”>
Title <input type=”text” name=”title”>
Category <input type=”text” name=”category”>
Year <input type=”text” name=”year”>
ISBN <input type=”text” name=”isbn”>
<input type=”submit” value=”ADD RECORD”>
</pre></form>
_END;

$query = “SELECT * FROM classics”;
$result = $conn->query($query);
if (!$result) die (“Database access failed: ” .$conn->error);

$rows = $result->num_rows;
  
for ($j = 0 ; $j < $rows ; ++$j)
{
$result->data_seek($j);
$row = $result->fetch_array(MYSQLI_NUM);

echo <<<_END
<pre>
Author $row[0]
Title $row[1]
Category $row[2]
Year $row[3]
ISBN $row[4]
</pre>
<form action=”sqltest.php” method=”post”>
<input type=”hidden” name=”delete” value=”yes”>
<input type=”hidden” name=”isbn” value=”$row[4]”>
<input type=”submit” value=”DELETERECORD”></form>
_END;
}
  
$result->close();
$conn->close();
  
function get_post($conn, $var)
{
return $conn->real_escape_string($_POST[$var]);
}
?>

5- Change sqltest.php to print the classics rows as html table with the header as seen in Figure2, point your file to the external table.css file. Add a checkbox for each row to be selected for deletion. The red-highlighted checkbox is check/uncheck all checkboxes that call a JavaScript function with check_all() name. Delete buttons will redirect you back to sqltest.php where all selected (checked rows) will be deleted. 6- check_all() function must be implemented in checkboxes.js file, checkboxes.js must be stored and access from js folder. Author Title Category Year ISBN ADD RECORD Delete Author Title Category Year Title Mark Twain The Adventures of Tom Sawyer Fiction 18769781598184891 D Jane Austen Pride and Prejudice Fiction 1811 9780582506206 Charles Darwin The Origin of Species Non-Fiction 18569780517123201 Charles Dickens The Old Curiosity Shop Fiction 1841 9780099533474 D William Shakespeare Romeo and Juliet Play 15949780192814968 Figure 2: the assignment has to look like this figure Show transcribed image text 5- Change sqltest.php to print the classics rows as html table with the header as seen in Figure2, point your file to the external table.css file. Add a checkbox for each row to be selected for deletion. The red-highlighted checkbox is check/uncheck all checkboxes that call a JavaScript function with check_all() name. Delete buttons will redirect you back to sqltest.php where all selected (checked rows) will be deleted. 6- check_all() function must be implemented in checkboxes.js file, checkboxes.js must be stored and access from js folder.
Author Title Category Year ISBN ADD RECORD Delete Author Title Category Year Title Mark Twain The Adventures of Tom Sawyer Fiction 18769781598184891 D Jane Austen Pride and Prejudice Fiction 1811 9780582506206 Charles Darwin The Origin of Species Non-Fiction 18569780517123201 Charles Dickens The Old Curiosity Shop Fiction 1841 9780099533474 D William Shakespeare Romeo and Juliet Play 15949780192814968 Figure 2: the assignment has to look like this figure

Expert Answer

---

Answer to Can anyone help me with question 5 and 6 as soon as possible. … . . .