Scribd
Upload
77 views6 pages

Presentation 1111

The document describes the steps to create a database called AMS in phpMyAdmin with two tables called learner and attendance. The learner table has fields for learner ID, first name, last name, grade level, and section. The attendance table has fields for barcode, time in, time out, status, and date.

Uploaded by

Marlowe Marquez
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
77 views6 pages

Presentation 1111

The document describes the steps to create a database called AMS in phpMyAdmin with two tables called learner and attendance. The learner table has fields for learner ID, first name, last name, grade level, and section. The attendance table has fields for barcode, time in, time out, status, and date.

Uploaded by

Marlowe Marquez
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
You are on page 1/ 6

• Open XAMPP Panel

• Start Apache and MySQL services


• Click Admin button of MySQL
• In localhost of phpMyAdmin in your web browser, create database.
• Database name: AMS
• Tables: learner, attendance
• Learner fields
Firstname
Lastname
Grade Level
Section
• Open XAMPP Panel
• Start Apache and MySQL services
• Click Admin button of MySQL
• In localhost of phpMyAdmin in your web browser, create database.
• Database name: AMS
• Tables: learner, attendance
• learner fields
LRN (varchar),length(100)
Firstname (varchar) , length(100)
Lastname (varchar), length(100)
Grade Level (int), length(50)
Section (varchar), length(100)
• Open XAMPP Panel
• Start Apache and MySQL services
• Click Admin button of MySQL
• In localhost of phpMyAdmin in your web browser, create database.
• Database name: AMS
• Tables: learner, attendance
• learner fields • attendance fields
LRN (varchar),length(100) Barcode (varchar),length(100)
Firstname (varchar) , length(100) time_in (varchar),length(100)
Lastname (varchar), length(100) time_out (varchar),length(100)
Grade Level (int), length(50) status (varchar),length(100)
Section (varchar), length(100) date (date), length(100)
• Open XAMPP Panel
• Start Apache and MySQL services
• Click Admin button of MySQL
• In localhost of phpMyAdmin in your web browser, create database.
• Database name: AMS
• Tables: learner, attendance
• learner fields
• attendance fields
LRN (varchar),length(100)
Barcode (varchar),length(100)
Firstname (varchar) , length(100)
time_in (varchar),length(100)
Lastname (varchar), length(100)
time_out (varchar),length(100)
Grade Level (int), length(50) status (varchar),length(100)
Section (varchar), length(100) date (date), length(100)
*This will be your output for today. Kindly screenshot your code as well as your Forms
The first Form to display when you run your code is the
Log In Form
Display AMS User Interface FORM after
LOGIN FORM
clicking the Go to AMS Interface label

Display Admin Form after successful log in

ADMIN FORM

AMS Interface Form

*This will be your output for today. Kindly screenshot your code as well as your Forms

You might also like