INSERT INTO `donors` (`id`, `username`, `password`, `fullname`, `dob`, `sex`, `bloodgroup`, `mobile`, `email`, `town`, `state`, `lastdate`) VALUES ![]() ![]() ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci `lastdate` timestamp NOT NULL DEFAULT ' 18:30:00' `state` varchar(30) NOT NULL DEFAULT 'Patna', Create a file name donors.sql inside the project and paste this code there. We will import the SQL file to create the necessary tables and prefill the table with sample data. ![]() If successful you will see a screen something like this After that go to the import button and select the file and click the import button on the bottomĤ. After that, fill in the text box with ‘ bld_dntn’ and hit create buttonģ. To import the SQL file, first, visit in your browser. To make the required tables we will add a new table by the name ‘ bld_dntn’ in the PHPMyAdmin and then import the SQL file. So first, we will create the database and the table for the donors. Before we go into more detail, we will create the database and the table for the donors. We will create a new folder with the name blood-donation and open it in VS code. We will do all the code in the C:\xampp\htdocs folder. If you don’t have xampp installed, follow this link.īefore Jumping right into code make sure that you have Xampp installed and these 2 essential processes running: ![]() View Blood types, addresses, and mobile numbers of donors.
0 Comments
Leave a Reply. |