You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '12', '23', '12', '12', '12', '12', '12 ')' at line 1
Here is my code:
<?php
$conn = new mysqli("localhost","sgane5","loreburn","sgane5_IA2") or die(mysqli_error($conn));
if (isset($_POST["submit"])) {
$State = $_POST["State"];
$ConfirmedCases = $_POST["ConfirmedCases"];
$Deaths = $_POST["Deaths"];
$Recovered = $_POST["Recovered"];
$ActiveCases = $_POST["ActiveCases"];
$TestConducted = $_POST["TestConducted"];
$TestPerMillion = $_POST["TestPerMillion"];
$Hospitalisation = $_POST["Hospitalisation"];
$query = mysqli_query($conn, "INSERT INTO Covid ( State, ConfirmedCases, Deaths, Recovered, ActiveCases, TestConducted, TestPerMillion, Hospitalisation) VALUES ( '$State, '$ConfirmedCases', '$Deaths', '$Recovered', '$ActiveCases', '$TestConducted', '$TestPerMillion', '$Hospitalisation ')") or die(mysqli_error($conn));
}
$query = mysqli_query($conn, "SELECT * FROM Covid") or die(mysqli_error());
while ($row = mysqli_fetch_array($query)) {
printf("<form action='Addbook.php' method='post'>
<input type='text' name='State' value='%s'>
<input type='text' name='ConfirmedCases' value='%s'>
<input type='text' name='Deaths' value='%s'>
<input type='text' name='Recovered' value='%s'>
<input type='text' name='ActiveCases' value='%s'>
<input type='text' name='TestConducted' value='%s'>
<input type='text' name='TestPerMillion' value='%s'>
<input type='text' name='Hospitalisation' value='%s'>
<input type='submit' value='Update'>
</form>", $row['State'], $row['ConfirmedCases'], $row['Deaths'], $row['Recovered'], $row['ActiveCases'], $row['TestConducted'], $row['TestPerMillion'], $row['Hospitalisation']);
}
?>
</body>
</html>
<form name = "search" action ="<?php echo $_SERVER["PHP_SELF"];?>" method="POST">
<input type="text" placeholder="Acronyms Only" name="search">
<input type="Submit" value="Search">class="fa fa-search"></button>
</form>
<print>Coronavirus Tables Click to reset table ----> <a href="SearchStats.php">Here</a></print>
<?php
$conn = new mysqli("localhost","sgane5","loreburn","sgane5_IA2") or die(mysqli_error($conn));
if (isset($_POST["search"])) {
$Search = $_POST['search'];
$query = mysqli_query($conn, "SELECT State ConfirmedCases, Deaths, Recovered, ActiveCases, TestConducted, TestPerMillion, Hospitalisation
FROM Covid WHERE State LIKE '%$Search%'") or die(mysqli_error($conn));
print("<table border=\"1\">");
print("<tr><td>State</td>
<td>ConfirmedCases</td>
<td>Deaths</td>
<td>Recovered</td>
<td>ActiveCases</td>
<td>TestConducted</td>
<td>TestPerMillion</td>
<td>Hospitalisation</td>");
while($row = mysqli_fetch_array($query)) {
printf("<tr><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td></tr>",
$row['State'], $row['ConfirmedCases'], $row['Deaths'], $row['Recovered'], $row['ActiveCases'], $row['TestConducted'], $row['TestPerMillion'], $row['Hospitalisation']);
}
print("</table>");
} else {
$query = mysqli_query($conn, "SELECT State ConfirmedCases, Deaths, Recovered, ActiveCases, TestConducted, TestPerMillion, Hospitalisation
FROM Covid") or die(mysqli_error($conn));
print("<table border=\"1\">");
print("<tr><td>State</td>
<td>ConfirmedCases</td>
<td>Deaths</td>
<td>Recovered</td>
<td>ActiveCases</td>
<td>TestConducted</td>
<td>TestPerMillion</td>
<td>Hospitalisation</td>");
while ($row = mysqli_fetch_array($query)) {
printf("<tr><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td></tr>",
$row['State'], $row['ConfirmedCases'], $row['Deaths'], $row['Recovered'], $row['ActiveCases'], $row['TestConducted'], $row['TestPerMillion'], $row['Hospitalisation']);
}
print("</table>");
}
?>
What I have tried:
I've tried all i can think about, i keep getting this error and my database table won't update