Create New Item
Item Type
File
Folder
Item Name
Search file in folder and subfolders...
Are you sure want to rename?
File Manager
/
Design
/
fileman
/
Fusion
/
CRUD01
:
insert.php
Advanced Search
Upload
New Item
Settings
Back
Back Up
Advanced Editor
Save
<?php include('database connection.php'); include('function.php'); if(isset($_POST["operation"])) { if($_POST["operation"] == "Add") { $statement = $connection->prepare(" INSERT INTO course (course, students) VALUES (:course, :students)"); $result = $statement->execute( array( ':course' => $_POST["course"], ':students' => $_POST["students"] ) ); } if($_POST["operation"] == "Edit") { $statement = $connection->prepare( "UPDATE course SET course = :course, students = :students WHERE id = :id"); $result = $statement->execute( array( ':course' => $_POST["course"], ':students' => $_POST["students"], ':id' => $_POST["course_id"] ) ); } } ?>