We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>


Looking For Something at vustudents.ning.com? Click Here to Search

Assignment No. 03

Graded
Semester: Spring 2017

CS310: Open Source Web Application Development

Total Marks: 15

 

Due Date:14/07/2017

 

Instructions:

 

Please read the following instructions carefully before submitting assignment. It should be clear that your assignment will not get any credit if:

 

  • The assignment is submitted after due date.
  • The submitted assignment does not open or file is corrupt.
  • Assignment is copied(partial or full) from any source (websites, forums, students, etc)

 

Note:

  1. You have to upload .php file in zip/winRaR format. Assignment in any other format (extension) will not be accepted and will be awarded with zero marks.

 

  1. Marks will be given to those assignments which will be in running form. Incomplete assignment or having run time errors will not be given any credit.

 

  1.  

Objective:

 

The objective of this assignment is to provide hands on experience of:

 

  • Write a script to create database and to add table in it.
  • Write php code to add, retrieve, edit and delete the records

 

 

For any query about the assignment, contact at cs310@vu.edu.pk

 

 

 

 

 

 

 

 

 

Assignment 

 

Write php code that can perform CRUD operations (Create, Read, Update, and Delete) on a database.

 

The acronym CRUD refers to all of the major functions that are implemented in relational database applications. Each letter in the acronym can map to a standard SQL statement.

 

Operation

SQL

Create

INSERT

Read  (Retrieve)

SELECT

Update (Modify)

UPDATE

Delete (Destroy)

DELETE

Procedure:

  1. Create a Database (student id>>_DB) which should contain a table (Employee) and the table should contain the following fields (empid, name,address, DOB, Sal, timeIn).

For example:

 

 

  1. User Interface may be like this. This UI is just for reference, you may design your own User Interface.

 

 

  1. On clicking Create DB button a database will be created. Database name should be studentID_DB e.g. if my id is mc123456 then DB name will be mc123456_DB.
  2. On clicking create table button. Table named Employee will be created having all the required fields. So that EmployeeID, Name, address, date of birth, salary and timein could be saved.
  3. By entering empID in “Search By EmpID” text box then search button will search a record from the database and display all the information in the corresponding textboxes.
  4. Add button will insert a new record in the table Employee.
  5. Update button will modify a record after searching and editing a record.
  6. Delete button will destroy a record after searching a specific record.
  7. Clear button will clear all the information in the textboxes.

 

 

Structure of Employee Table

Name

Type

Constraints

empID

Int

Primary Key, Auto Increment

Name

Varchar(20(

Not NULL

Address

Varchar(50),

Not NULL

Dateofbirth

Date

Not NULL

Salary

Int

 

Timein

time

 

 

 

     Data in Employee

empID

name

address

DOB

Sal

timeIn

1

Ali

H.No 4 Phase 2 Sector 8 Hayatabad Karachi

22-2-1980

50000

8:00 AM

2

Imran

H.No 55 B/2 Gulberg 3 Multan

15-6-1981

45000

9:00 AM

3

Farman

H.no 44 Street F-3 Canal Road Lahore

7-9-1979

75000

4:00 PM

 

 

Helping Material:

You may visit www.w3schools.com , locate PHP5 tutorial page and navigate to PHP Forms section. It will help you in this assignment.

 

 

BEST OF LUCK!

 

+ Click Here To Join also Our facebook study Group.

..How to Join Subject Study Groups & Get Helping Material?..


See Your Saved Posts Timeline

Views: 408

.

+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

+ Click Here to Search (Looking For something at vustudents.ning.com?)

Attachments:

Replies to This Discussion

Please gys aaj extended day hai. aaj koi ye assignment solution upload krlo.

Hello, any body there; for assignment 3

Please Discuss here about this assignment.Thanks

Our main purpose here discussion not just Solution

We are here with you hands in hands to facilitate your learning and do not appreciate the idea of copying or replicating solutions. Read More>>

 

Note:-

For Important Helping Material related to this subject (Solved MCQs, Short Notes, Solved past Papers, E-Books, FAQ,Short Questions Answers & more). You must view all the featured Discussion in this subject group.

For how you can view all the Featured discussions click on the Back to Subject Name Discussions link below the title of this Discussion & then under featured Discussion corner click on the view all link.

Or visit this link 

Click Here For Detail.

&

.•°How to Download past papers from study groups°•.

 

Please Click on the below link to see…

.... How to Find Your Subject Study Group & Join .... 

for this assignment i don't have any tools so please help me with this
1

RSS

© 2019   Created by + M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service