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

ALEENA replied to + IUUOƆƎUT +'s discussion How Can You Get Secured of Being Banned On Ning
7 minutes ago
ayesha added 4 discussions to the group CS614 Data Warehousing
8 minutes ago
ALEENA liked + IUUOƆƎUT +'s discussion How Can You Get Secured of Being Banned On Ning
9 minutes ago
Aisha RD replied to + M.Tariq Malik's discussion EDU601 Philosophy of Education Assignment No 01 Fall 2019 Solution & Discussion in the group EDU601 Philosophy of Education
12 minutes ago
Aisha RD joined + M.Tariq Malik's group
12 minutes ago
RAjpoot* updated their profile
29 minutes ago
+ ! ! ! ! ! ! ! ! ! AG replied to + ! ! ! ! ! ! ! ! ! ! ! ! ! ! !'s discussion Happy Birth Day Zargiyah (Tasha <3)
42 minutes ago
+ Danial liked + ! ! ! ! ! ! ! ! ! ! ! ! ! ! !'s discussion Happy Birth Day Zargiyah (Tasha <3)
48 minutes ago
+ ! ! ! ! ! ! ! ! ! AG liked Muhammad Younas Rajpoot's discussion ECO404 assignment 1 fall semester dated 19-11-2019
49 minutes ago
+ ! ! ! ! ! ! ! ! ! AG liked waqas ahmad's discussion isl 201
49 minutes ago
+ ! ! ! ! ! ! ! ! ! AG liked zobialatif's discussion hazrat ali says
49 minutes ago
+ ! ! ! ! ! ! ! ! ! AG liked + IUUOƆƎUT +'s discussion Kabhi aye haqeeqat e muntizir
49 minutes ago
+ ! ! ! ! ! ! ! ! ! AG liked Abdul Majid Jamil's discussion for assignment of zoogy on topic wildlife counting
49 minutes ago
+ ! ! ! ! ! ! ! ! ! AG liked Azhar Sagar's discussion How to make srs Software Requirements Specification
49 minutes ago
+ ! ! ! ! ! ! ! ! ! AG liked Moji's discussion MCM301 assignment no 1
49 minutes ago
+ ! ! ! ! ! ! ! ! ! AG liked Aijaz khan's discussion CS608 - Software Verification and Validation Assignment No. 2 Need Solution
49 minutes ago
+ ! ! ! ! ! ! ! ! ! AG liked 彡JK彡 ❤️'s discussion If you have sOmething stupid to saY............
49 minutes ago
+ ! ! ! ! ! ! ! ! ! AG liked zohaib iftikhar's discussion ...* NASEEB TAK RASAI ...*
49 minutes ago
+ ! ! ! ! ! ! ! ! ! AG liked 彡JK彡 ❤️'s discussion Don't Look for Perfection........ LOVE lies in imperfection
49 minutes ago
+ ! ! ! ! ! ! ! ! ! AG liked +! ! ! "Asнтαℓғαн's discussion Happy wala Birthday tashy patashy ❤ (Tasha)
49 minutes ago

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

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