Create a single database named: citahati
Create a table named: student
CREATE TABLE IF NOT EXISTS `senior` (
`id_senior` varchar(6) NOT NULL,
`student_name` varchar(100) NOT NULL,
`class` varchar(6) NOT NULL,
`gender` varchar(1) NOT NULL,
`parents_name` varchar(150) NOT NULL,
`address` varchar(255) NOT NULL,
`phone_number` varchar(100) NOT NULL,
`notes` text NOT NULL,
`academic_year` varchar(9) NOT NULL
)
Create a table named: teacher
CREATE TABLE IF NOT EXISTS `teachers` (
`username` varchar(15) NOT NULL,
`password` varchar(10) NOT NULL,
`fullname` varchar(50) NOT NULL,
`gender` varchar(1) NOT NULL,
`position` varchar(30) NOT NULL,
`subject` varchar(50) NOT NULL,
`level` varchar(5) NOT NULL,
`active` int(11) NOT NULL DEFAULT ‘0’
)
Insert some random data in both of your tables (at least 10 records)
Create a user interface to display the data from both tables using PHP. Use a table and design it nicely!
Example:

Administrator Page

Tags: , ,