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

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

Sheraz Ali posted a discussion
23 minutes ago
Imran Khan replied to +¢αяєℓєѕѕ gιяℓ's discussion CS506 - Web Design and Development Assignment No.1 Due Date Nov 15, 2019 in the group CS506 Web Design and Development
1 hour ago
Imran Khan joined + M.Tariq Malik's group
1 hour ago
+ ! ! ! ! Mehαr Mαh꧂ liked + M.Tariq Malik's discussion PSC401 Final Term Papers Spring 2019 (24 August ~ 04 September 2019) & All Solved Past Papers, Solved MCQs & Helping Material
1 hour ago
Hamza Hameed replied to + M.Tariq Malik's discussion CS611 Software Quality Engineering Assignment No 01 Fall 2019 Solution & Discussion Due Date: 15-11-2019 in the group CS611 Software Quality Engineering
2 hours ago
+Umar Amin+ replied to + M.Tariq Malik's discussion Criteria Required for Award Badges, Featured Members & Moderators
2 hours ago
+ !! SARAH replied to MIT's discussion Operating Systems(CS604) Assignment # 01 Deadline Date 16-11-2019 in the group CS604 Operating Systems
2 hours ago
+ !! SARAH joined + M.Tariq Malik's group
2 hours ago
November 2019 replied to + M.Tariq Malik's discussion CS401 Assignment No 01 Fall 2019 Solution & Discussion in the group CS401 Computer Architecture and Assembly Language Programming
3 hours ago
Hamza Hameed updated their profile
3 hours ago
Profile IconHamza Hameed, +.Ãŋɠɜʆḁ.+ and Aijaz khan joined + M.Tariq Malik's group
3 hours ago
Profile IconHamza Hameed and Purple Work joined + M.Tariq Malik's group
3 hours ago
Hamza Hameed joined + M.Tariq Malik's group
3 hours ago
Hamza Hameed joined + M.Tariq Malik's group
3 hours ago
Arham Shah replied to + M.Tariq Malik's discussion CS401 Assignment No 01 Fall 2019 Solution & Discussion in the group CS401 Computer Architecture and Assembly Language Programming
3 hours ago
Arham Shah joined + M.Tariq Malik's group
3 hours ago
khurram us salam replied to + M.Tariq Malik's discussion MGT402 Cost & Management Accounting Online Quiz No 01 Fall 2019 Solution Discussion in the group MGT402 Cost & Management Accounting
3 hours ago
khurram us salam joined + M.Tariq Malik's group
3 hours ago
+ ! ! ! ! ! ! ! ! ! AG liked + ! ! ! ! ! MySterIouS's blog post + Beginning +
3 hours ago
+ ! ! ! ! ! ! ! ! ! AG liked Mani Siddiqui BS VIII's discussion Kash Main Doure Payamber
3 hours ago

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

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