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

www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

+ Link For Past Papers, Solved MCQs, Short Notes & More


Dear Students! Share your Assignments / GDBs / Quizzes files as you receive in your LMS, So it can be discussed/solved timely. Add Discussion

How to Add New Discussion in Study Group ? Step By Step Guide Click Here.

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!

 

+ How to Follow the New Added Discussions at Your Mail Address?

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

+ How to become Top Reputation, Angels, Intellectual, Featured Members & Moderators?

+ VU Students Reserves The Right to Delete Your Profile, If?


See Your Saved Posts Timeline

Views: 424

.

+ 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?)

+ Click Here To Join (Our facebook study Group)

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

Latest Activity

Profile IconAzam, Ehtisham Ul Haq, arslan khan and 28 more joined Virtual University of Pakistan
6 minutes ago
+ ! ! ! ! ! ! ! Mobi updated their profile
21 minutes ago
ALEEM QAMAR replied to + M.Tariq Malik's discussion SOC101 Assignment No 01 Fall 2019 Solution & Discussion Due Date: 21-11-2019 in the group SOC101 Introduction to Sociology
23 minutes ago
+ M.Tariq Malik liked +!!! Annie !!!+'s discussion EDU433 Professionalism in Teaching Assignment No 01 Fall 2019 Solution & Discussion
24 minutes ago
+ M.Tariq Malik replied to +!!! Annie !!!+'s discussion EDU654 Addressing problems of learning through technology and pedagogy Assignment No 01 Fall 2019 Solution & Discussion in the group EDU654 Addressing problems of learning through technology and pedagogy
29 minutes ago
+ M.Tariq Malik liked +!!! Annie !!!+'s discussion EDU654 Addressing problems of learning through technology and pedagogy Assignment No 01 Fall 2019 Solution & Discussion
29 minutes ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion ENG201 Business and Technical English Writing Assignment No 01 Fall 2019 Solution & Discussion in the group ENG201 Business and Technical English Writing
34 minutes ago
彡JK彡 ❤️ and Naser Javed (BBIT-6) are now friends
35 minutes ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion EDU302 Human Development and Learning Assignment No 01 Fall 2019 Solution & Discussion in the group EDU302 Human Development and Learning
44 minutes ago
+ M.Tariq Malik liked + !! "AS" !!'s discussion Baat Karna ...
46 minutes ago
zobialatif posted photos
48 minutes ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion MTH302 Business Mathematics & Statistics Assignment No 01 Fall 2019 Solution & Discussion in the group MTH302 Business Mathematics & Statistics
48 minutes ago
Mr khan posted a status
"Admin sab plz find out my assignment solution"
49 minutes ago
+ M.Tariq Malik liked + !! "AS" !!'s discussion Yaha Har Cheez ..
50 minutes ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion CS625 Professional Practices Assignment No 01 Fall 2019 Solution & Discussion in the group CS625 Professional Practices
1 hour ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion CS625 Professional Practices Assignment No 01 Fall 2019 Solution & Discussion in the group CS625 Professional Practices
1 hour ago
+ M.Tariq Malik replied to + !! "AS" !!'s discussion Jis Tarah ..
1 hour ago
+ M.Tariq Malik liked + !! "AS" !!'s discussion Jis Tarah ..
1 hour ago
+ M.Tariq Malik replied to + !! "AS" !!'s discussion Alfaaz Ki Nisbat..
1 hour ago
+ M.Tariq Malik liked + !! "AS" !!'s discussion Alfaaz Ki Nisbat..
1 hour ago

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

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