LMS-Library-Management-System/add_book_case_insert_code.php at main · murtazanoori/LMS-Library-Management-System · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
<?php
 session_start();
include 'connection_DB.php';
if (isset($_POST['done'])) {
    # code...
    $book_case_id= $_POST['book_case_id'];
    $c_row = $_POST['c_row'];
    $c_column = $_POST['c_column'];


    $sql = "INSERT INTO `book_case`(`book_case_id`, `c_row`, `c_column`) VALUES ('$book_case_id','$c_row','$c_column');";
    $query = mysqli_query($con,$sql);
    header("location:add_book_case.php?Data_Inserted");
        $_SESSION['response']="Data Saved Success!";
        $_SESSION['res_type']="success";
}


if (isset($_POST['delete_btn_set'])) {

    $del_id = $_POST['delete_id'];

    $q = "DELETE FROM book_case WHERE 	b_c_id = '$del_id'";
    $query = mysqli_query($con,$q);
    if ($query) {
        # code...
        echo "delete";
    }else{
        echo "filed";
    }
}


if (isset($_POST['edit_bookCase'])) {

    $b_c_id = $_POST['b_c_id'];
    $book_case_id = $_POST['book_case_id'];
    $c_row = $_POST['c_row'];
    $c_column = $_POST['c_column'];
    $query_edit = "UPDATE `book_case` SET `book_case_id` = '$book_case_id',`c_row` = '$c_row',`c_column` = '$c_column' WHERE `book_case`.`b_c_id` = '$b_c_id'";
    $result_set = mysqli_query($con,$query_edit);

    if ($result_set) {
      # code...
      header("location:book_case_list?Data_updated");
      $_SESSION['response']="Data Updated Success!";
      $_SESSION['res_type']="success";

      //echo "data update it.";
    }else {
      # code...
      header("location:book_case_list?somting wrong updating");
      $_SESSION['response']="Hopes! Somting Wrong Data Cant Update Success!";
      $_SESSION['res_type']="success";

      //echo "data cant update it.!";
    }

    # code...


  }

?>