#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '<?php include "connection.php"' at line 1

Zany · September 28, 2021

<?php
include "connection.php";
?>

<html lang="en">
<head>
<title>belgicaAct2_Add/Edit/Delete/View</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/js/bootstrap.min.js"></script>
</head>
<body

<div class="container">
<div class="col-lg-4">
<h2>Course & Learning Management System</h2>
<h2>Add/Edit/Delete/View</h2>
<form action="" name="form1" method="post">
<div class="form-group">
<label for="email">firstname</label>
<input type="text" class="form-control" id="firstname" placeholder="Enter firstname" name="firstname">
</div>
<div class="form-group">
<label for="pwd">lastname</label>
<input type="text" class="form-control" id="lastname" placeholder="Enter lastname" name="lastname">
</div>
<div class="form-group">
<label for="pwd">email</label>
<input type="text" class="form-control" id="email" placeholder="Enter email" name="email">
</div>
<div class="form-group">
<label for="pwd">contact</label>
<input type="text" class="form-control" id="contact" placeholder="Enter contact" name="contact">
</div>
<button type="submit" name="insert" class="btn btn-default">Insert</button>
<button type="submit" name="update" class="btn btn-default">Update</button>
<button type="submit" name="delete" class="btn btn-default">Delete</button>
</form>
</div>
</div>

<table class="table table-bordered">
<thead>
<tr>
   <th>#</th>
<th>Firstname</th>
<th>Lastname</th>
<th>Email</th>
       <th>Contact</th>
       <th>Edit</th>
       <th>Delete</th>
</tr>
</thead>
<tbody>

   <?php
   $result=mysqli_query($link,"select * from table1");
   while($row=mysqli_fetch_array($result))
   {
   echo "<tr>";
   echo "<td>"; echo $row["id"]; echo "</td>";
   echo "<td>"; echo $row["firstname"]; echo "</td>";
   echo "<td>"; echo $row["lastname"]; echo "</td>";
   echo "<td>"; echo $row["email"]; echo "</td>";
   echo "<td>"; echo $row["contact"]; echo "</td>";
   echo "<td>"; ?> <a href="edit.php?id=<?php echo $row["id"]; ?> "><button type="button" class="btn btn-success">Edit</button></a> <?php echo "</td>";
   echo "<td>"; ?> <a href="delete.php?id=<?php echo $row["id"]; ?> "><button type="button" class="btn btn-danger">Delete</button></a> <?php echo "</td>";

   echo "</tr>";


   }

   ?>


</tbody>
</table>

</div>

</body>

<?php
if(isset($_POST["insert"]))
{
mysqli_query($link,"insert into table1 values(NULL,'$_POST[firstname]','$_POST[lastname]','$_POST','$_POST[contact]')");

?>
<script type="text/javascript">
window.location.href=window.location.href;
</script>
<?php

}

if(isset($_POST["delete"]))
{
   mysqli_query($link, "delete from table1 where firstname='$_POST[firstname]'") or die(mysqli_error($link));
   ?>
<script type="text/javascript">
window.location.href=window.location.href;
</script>
<?php

}

if(isset($_POST["update"]))
{
mysqli_query($link, "update table1 set firstname='$_POST[lastname]' where firstname='$_POST[firstname]'") or die(mysqli_error($link));
?>
<script type="text/javascript">
window.location.href=window.location.href;
</script>
<?php
}

?>

</html>