Xampp server || Xampp phpmyadmin || xampp sql server || Tasks perform using Xampp Server Assignment on Xampp Server

Xampp is used to build database for the application such as Desktop, Mobile, and web etc. it provides its user very easy to use and GUI for creating and perform different operations on Databases simple interface of Xampp shown blew:

For creating database for application user need to start two main services of the Xampp application one named Apache which provides HTTP Server MariaDB database, and interpreters for scripts written in the PHP and Perl programming languages & MySQL Services which works as a database component which is required to start in order to access phpMyAdmin. You must keep in your mind that for these services to start and perform their operations you must shutdown all application which use port 80 as this port is use to communicate Apache server and if this port is occupied service will not start and you will get error some application such as Skype and TeamViewer might use this port so please make sure to shut them down before working with xampp that might serve the purpose. For starting the services please click the start button right next to the Apache and MySql services names and your interface will turn into like this below:

Now you can access the phpMyAdmin panel where you actually start you working on databases you can create as many databases as you want using simple GUI. For accessing phpMyAdmin you can use MySql service’s Admin button or just typing this URL on the browser “ localhost/phpMyAdmin” after successfully execute this URL and all services in the running state you will landed on the interface provided by the aforementioned URL for crating and manipulating databases. PhpMyAdmin interface showing blow:

Now you can create the databases and tables for storing different information in the databases. For performing different operation such as inserting, searching, updating, and deleting you need to learn basic SQL language if you want to perform such operation on the database’s created table you need to select the table first then go the SQL section as shown below:

You can use SQL Queries for performing different operations provided by the interface by clicking the button having tags like insert, update, delete, select * etc. just edit the auto generated query as you want and just click on Go.

Assignment for the Xampp Tool evaluation:                                                                   (20 marks)

You are instructed to create databases named as RiphahUniversityFCS inside the created database you need to create 2 tables first table name is student can store information such as name, CMS, semester, phone_number,email. And second table name is courses which can store information as course_id, course name, course_title. Please note don't use spaces between name of database and tables or even in the columns you have created.

Perform Tasks on the Created Tables:

1.     Creating required database and tables with primary keys in each table. (5 marks)
2.    Insert at least 3-5 rows in each table student and courses           (3 marks).
3.    Show all the information inserted in the student table.             (1 marks).
4.    Show all information inserted in the courses table.                  (1 marks).
5.    Update any information using update query need to show both updated and old records. (4 marks).
6.    Delete any record using primary key concept.      (3 marks)
7.    Show only name in students table.                        (3 marks).

Assignment Submission Rules (Must Read and Follow otherwise marks will be deduct):

1.     This is very important assignment and have more weightage in your assignment and quizzes section for the Lab work.
2.       Copy assignment will result 0 for both students.
3.       Name your file according to the format such as Name_CMS_XAMPP.doc
4.       Attach all the required screenshots & Queries within your word file and submit only one file at the given link.
5.       Link for the Assignment Submission Please Click
6.       Last date for the Link and Assignment Submission is 14/05/2020
7. Assignment Submission can be done by Clicking Add Submission. 
8.       No submission after due date and student who do not follow these mentioned rules.