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: 425

.

+ 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

+ !!!R❤G liked + !!!R❤G's discussion Ikhalaq ki ahmiyat
23 minutes ago
+ !!!R❤G posted a discussion
24 minutes ago
+ !!!R❤G liked UMER UMER's discussion What is Love?
39 minutes ago
+ !!!R❤G liked + IUUOƆƎUT +'s discussion کہو تو لوٹ جاتے ہیں ۔ ۔ ۔
39 minutes ago
+ !!!R❤G liked + IUUOƆƎUT +'s discussion How Can You Get Secured of Being Banned On Ning
39 minutes ago
+ !!!R❤G liked UMER UMER's discussion What is Love?
39 minutes ago
+ !!!R❤G liked + ! ! ! ! ! ! ! ! ! ! ! ! ! ! !'s discussion Happy Birth Day Zargiyah (Tasha <3)
39 minutes ago
+ !!!R❤G liked +! ! ! "Asнтαℓғαн's discussion Happy wala Birthday tashy patashy ❤ (Tasha)
39 minutes ago
+ !!!R❤G liked 彡JK彡 ❤️'s discussion Don't Look for Perfection........ LOVE lies in imperfection
40 minutes ago
+ !!!R❤G liked 彡JK彡 ❤️'s discussion If you have sOmething stupid to saY............
40 minutes ago
+ !!!R❤G liked Waseem Khan's discussion Edu 402 Assinment No. 1 Solution
40 minutes ago
+ !!!R❤G liked Moji's discussion MCM301 assignment no 1
40 minutes ago
+ !!!R❤G liked + M.Tariq Malik's discussion VU Students Reserves The Right to Delete Any Profile On the Site
40 minutes ago
+ !!!R❤G and + ! ! ! ! ! ! ! ! ! AG are now friends
45 minutes ago
Zain Arshad 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
1 hour ago
Muhammad Rashid liked + M.Tariq Malik's discussion ACC501 GDB Fall 2019 Solution & Discussion
1 hour ago
Sucana Shafiq liked + M.Tariq Malik's discussion CS101 Mid Term Papers Spring 2019 & All Solved Past Papers, Solved MCQs & Helping Material
1 hour ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion CS302 Digital Logic Design Assignment No 02 Fall 2019 Solution & Discussion in the group CS302 Digital Logic Design
2 hours ago
+ M.Tariq Malik liked + M.Tariq Malik's discussion CS302 Digital Logic Design Assignment No 02 Fall 2019 Solution & Discussion
2 hours ago
+ ! ! ! ! ! ! ! ! CuTe DrAmA updated their profile
2 hours ago

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

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