INSERT INTO `patients` (`id`, `name`, `phone`, `gender`, `health_condition`, `doctor_id`, `nurse_id`, `created`) VALUES `health_condition` varchar(255) NOT NULL, INSERT INTO `nurses` (`id`, `name`, `email`, `password`, `phone`, `created`) VALUES

INSERT INTO `doctors` (`id`, `name`, `email`, `password`, `phone`, `gender`, `specialist`, `created`) VALUES `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP & here’s the SQL script for this database Database Script SET SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO' Here’s the Database I’m going to use with the name “hospital_db” You can use the database of your Web or Mobile App for which you are developing your Application. I’m going to use very simple Hospital Database with 4 Tables, “doctors”, “nurses”, “patients” & “admins”. It’s time to create a database for our Web Application. Run your server, go to your “htdocs” Folder inside “XAMPP” Forder & create a new folder there as “medibed” Creating Database I’m going to install XAMPP because It installs both PHP & MySQL for us. So, the first step is to have a server to run our application. To work on your local system you need to have PHP & MySQL installed on your system. There are many Free Templates Available, for this Tutorial, I’m going to use This Beautiful Admin Template by almasaeed.

Instert fa logo into button text html