MNHS Databse

1. Start Xampp(Apache and Mysql)
2. Open a browser
3. Type in the url "localhost/phpmyadmin"
4. Add new database by clicking "New" in the left sidebar
5. Enter a database name (Current Databasename: epiz_25140388_db_mnhscls)
6. Then click create
7. After that select the database that you have created
8. Then go to the nav-menu: SQL
9. Then Copy the code below from starting in the query of creating table book up to the last query
10. Then Click the button 'Go' to insert the query

Note: If you have changed the db name (for ex. db_mnhs) you need to change the config.php file then change its name
Sample :
<?php
//current dbname
//$db = mysqli_connect("sql307.epizy.com","epiz_25140388","mark301234","epiz_25140388_db_mnhscls");

//replace dbname
$db = mysqli_connect("localhost","root","","db_mnhs");
 ?>



CREATE TABLE `books` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `book_title` varchar(100) NOT NULL DEFAULT 'No Book Title',
  `isbn` varchar(100) NOT NULL,
  `date_added` date NOT NULL,
  `quantity` int(11) NOT NULL DEFAULT 1,
  `location` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=102 DEFAULT CHARSET=latin1;

INSERT INTO books VALUES("101","sampleto","1234527890111","2020-02-28","222","Library");



CREATE TABLE `borrow` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `student_name` varchar(110) NOT NULL,
  `section` varchar(110) NOT NULL,
  `book_title` varchar(110) NOT NULL,
  `isbn` varchar(110) NOT NULL,
  `quantity` int(11) NOT NULL,
  `date_borrowed` date NOT NULL,
  `period_of_days` int(11) NOT NULL,
  `conditions` varchar(11) NOT NULL,
  `remarks` varchar(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=74 DEFAULT CHARSET=latin1;

INSERT INTO borrow VALUES("73","asd","asd","asd","1234527890111","1","2020-02-28","2","Very Good","12");



CREATE TABLE `issue` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `book_title` varchar(110) NOT NULL,
  `isbn` varchar(110) NOT NULL,
  `date_added` date NOT NULL,
  `quantity` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

INSERT INTO issue VALUES("6","asd1","3012341400661","1212-12-12","123");



CREATE TABLE `lost` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `student_name` varchar(110) NOT NULL,
  `section` varchar(110) NOT NULL,
  `book_title` varchar(110) NOT NULL,
  `isbn` varchar(110) NOT NULL,
  `quantity` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;

INSERT INTO lost VALUES("14","ryan","4m1","Infinite Dendograma","2320539520587","1");



CREATE TABLE `returns` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `student_name` varchar(110) NOT NULL,
  `section` varchar(110) NOT NULL,
  `book_title` varchar(110) NOT NULL,
  `isbn` varchar(13) NOT NULL,
  `quantity` int(11) NOT NULL,
  `date_returned` date NOT NULL,
  `conditions` varchar(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=54 DEFAULT CHARSET=latin1;

INSERT INTO returns VALUES("49","Mark Lorenz Gervacio","Heron","Kimetsu no Yaiba","8441783107321","3","2020-02-12","Good");



CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `password` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

INSERT INTO users VALUES("1","mark301234","mlgervacio0017@gmail.com","7f4bf56100fb45d04eff1cd23bab58d4");
INSERT INTO users VALUES("2","admin","admin@gmail.com","21232f297a57a5a743894a0e4a801fc3");
INSERT INTO users VALUES("3","sample3","sample3@gmail.com","d35f70211135de265bc7c66df4dd3605");
INSERT INTO users VALUES("4","admin2","admin@yahoo.com","c84258e9c39059a89ab77d846ddab909");
INSERT INTO users VALUES("5","admin","admin@yahoo.com","1a1dc91c907325c69271ddf0c944bc72");
INSERT INTO users VALUES("6","Ryan","ryan@yahoo.com","10c7ccc7a4f0aff03c915c485565b9da");


CREATE TABLE `visitors` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `gender` varchar(100) NOT NULL,
  `purpose` varchar(100) NOT NULL,
  `book_used` varchar(110) NOT NULL DEFAULT 'None',
  `isbn` varchar(110) NOT NULL,
  `time_in` datetime NOT NULL,
  `time_out` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

INSERT INTO visitors VALUES("9","Sample","Male","Sample","Sample","3012341400661","2020-12-12 02:01:00","2020-12-12 00:12:00");