set_charset('utf8mb4'); $dbh->query('CREATE DATABASE IF NOT EXISTS EMPLOYEE_DB'); $dbh->select_db('EMPLOYEE_DB'); $dbh->query('CREATE TABLE IF NOT EXISTS `Employee` (`EID` INT PRIMARY KEY AUTO_INCREMENT, `Ename` VARCHAR(255), `Address` TEXT, `Phno` VARCHAR(20), `Salary` DECIMAL(10,2), `Category` ENUM("GEN", "SC", "ST", "OBC"), `Language` VARCHAR(255))'); return $dbh; } function html_prologue($title) { ?> <?php echo $title; ?>

Insertion successful.

Operation failed

Reason:

Employee Form














prepare('INSERT INTO `Employee` (`Ename`, `Address`, `Phno`, `Salary`, `Category`, `Language`) VALUES (?, ?, ?, ?, ?, ?)'); $stmt->bind_param('sssdss', $ename, $address, $phno, $salary, $category, $languages); $stmt->execute(); $stmt->close(); display_success(); } } function display_employee_records($dbh) { $order_by = isset($_POST['order_by']) ? $_POST['order_by'] : 'Ename'; $desc_order = isset($_POST['desc_order']); $field_labels = [ 'EID' => 'Employee ID', 'Ename' => 'Name', 'Address' => 'Address', 'Phno' => 'Phone Number', 'Salary' => 'Salary', 'Category' => 'Category', 'Language' => 'Language' ]; $allowed_fields = array_keys($field_labels); if (!in_array($order_by, $allowed_fields)) display_failure('Invalid order_by field.'); $order_clause = $order_by . ($desc_order ? ' DESC' : ''); $result = $dbh->query('SELECT * FROM `Employee` ORDER BY ' . $order_clause); html_prologue('Employee Records'); ?>

Employee Records

>
fetch_assoc()) { ?> $label) { ?>

Menu

close(); } else { show_employee_form(); } } elseif ($path === '/display') { $dbh = connect_to_database(); display_employee_records($dbh); $dbh->close(); } else { display_menu(); echo '

Path ' . htmlspecialchars($path) . ' was not found.

'; die(); } } else { display_menu(); } } catch (mysqli_sql_exception $e) { display_error($e->getMessage()); }