无法在Mysql数据库中删除或插入数据[重复]

Question

This question already has an answer here:

• PHP parse/syntax errors; and how to solve them? 17 answers

This is the adminuses.php I am trying to insert and delete data from the database. It shows the following error.

Parse error: syntax error, unexpected '{' in C:\xampp\htdocs\Library Management\adminuses.php on line 4

adminuses.php

<?php
include ("connection.php");
 if (isset($_POST['passbookid'])
 {
     $id= $_POST['passbookid'];
     $query= "delete from passbook where pid ='".$id."'";
     $result = mysqli_query($sql, $query);
     if ($result)
     {
         header('location:adminlogin.php');
     }
 } 

</div>

Answer 1

You forgot a )

<?php
include ("connection.php");
 if (isset($_POST['passbookid']))
 {
     $id= $_POST['passbookid'];
     $query= "delete from passbook where pid ='".$id."'";
     $result = mysqli_query($sql, $query);
     if ($result)
     {
         header('location:adminlogin.php');
     }
 } 
 if (isset($_POST['userid']))
 {
    $id= $_POST['userid'];
    $isbn=$_POST['isbn'];
    $submt=$_POST['submitdate'];
    $issuedt= date("d-m-Y");
    $query= "insert into passbook (user_id, isbn, issuedt, submitdt) values('$id','$isbn','$issuedt','$submt')";
    $result = mysqli_query($sql, $query);
    if ($result)
    {
        header ('location:adminlogin.php');
    }
 }

?>

Make sure to always check the brackets and curly brackets when you open and close things