Exam Details
| Subject | web programming with php & mysql | |
| Paper | ||
| Exam / Course | m.sc food chemistry & food processing | |
| Department | ||
| Organization | loyola college | |
| Position | ||
| Exam Date | November, 2017 | |
| City, State | tamil nadu, chennai |
Question Paper
1
LOYOLA COLLEGE (AUTONOMOUS), CHENNAI 600 034
B.Sc. B.C.A. DEGREE EXAMINATION COMPUTER SCIENCE APPLI.
FIFTH SEMESTER NOVEMBER 2017
CS/CA 5512 WEB PROGRAMMING WITH PHP MYSQL
Date: 08-11-2017 Dept. No. Max. 100 Marks
Time: 09:00-12:00
SECTION- A
ANSWER ALL THE QUESTIONS: 10 X 2 20
1. Define Open source.
2. What is PHP?
3. State the use of break statement in PHP.
4. What is static variable?
5. List out the string functions used in PHP.
6. Define cookies.
7. What are the types of storage engines in MySQL?
8. How to join two tables in MySQL?
9. Write the syntax for inserting a value in a table using MySQL.
10. Write the code for adding links to the table.
SECTION B
ANSWER ALL THE QUESTIONS: 5 X 8 40)
11. Explain the steps involved in executing a PHP script.
Explain the relationship between Apache, MySQL and PHP.
12. Discuss in brief about the static and global variable with an example.
Write a PHP script to get a numeric input from the user and find the sum of that number until it
reduces to a single digit. For e.g. 345=12
13 Explain Date functions in PHP with an example.
2
Explain Form elements with examples.
14. Discuss in detail about referencing two tables in MySQL.
b)Explain in detail about the types of MySQL tables.
15. Explain briefly about manipulations of data in a table with example.
Explain about the DDL commands with syntax and example.
SECTION-C
ANSWER ANY TWO QUESTIONS: 2 X 20 40
16. Discuss in detail about the history and features of PHP.
Describe integrating HTML with PHP.
17. How would you set a cookie and retrieve values from the cookie?
Explain the types of join with MYSQL tables.
18. Explain about the connectivity of PHP and MYSQL using an example and retrieve the records from
the table student in MySQL.
Explain error handling in PHP.
LOYOLA COLLEGE (AUTONOMOUS), CHENNAI 600 034
B.Sc. B.C.A. DEGREE EXAMINATION COMPUTER SCIENCE APPLI.
FIFTH SEMESTER NOVEMBER 2017
CS/CA 5512 WEB PROGRAMMING WITH PHP MYSQL
Date: 08-11-2017 Dept. No. Max. 100 Marks
Time: 09:00-12:00
SECTION- A
ANSWER ALL THE QUESTIONS: 10 X 2 20
1. Define Open source.
2. What is PHP?
3. State the use of break statement in PHP.
4. What is static variable?
5. List out the string functions used in PHP.
6. Define cookies.
7. What are the types of storage engines in MySQL?
8. How to join two tables in MySQL?
9. Write the syntax for inserting a value in a table using MySQL.
10. Write the code for adding links to the table.
SECTION B
ANSWER ALL THE QUESTIONS: 5 X 8 40)
11. Explain the steps involved in executing a PHP script.
Explain the relationship between Apache, MySQL and PHP.
12. Discuss in brief about the static and global variable with an example.
Write a PHP script to get a numeric input from the user and find the sum of that number until it
reduces to a single digit. For e.g. 345=12
13 Explain Date functions in PHP with an example.
2
Explain Form elements with examples.
14. Discuss in detail about referencing two tables in MySQL.
b)Explain in detail about the types of MySQL tables.
15. Explain briefly about manipulations of data in a table with example.
Explain about the DDL commands with syntax and example.
SECTION-C
ANSWER ANY TWO QUESTIONS: 2 X 20 40
16. Discuss in detail about the history and features of PHP.
Describe integrating HTML with PHP.
17. How would you set a cookie and retrieve values from the cookie?
Explain the types of join with MYSQL tables.
18. Explain about the connectivity of PHP and MYSQL using an example and retrieve the records from
the table student in MySQL.
Explain error handling in PHP.
Other Question Papers
Subjects
- agro products and processing
- analytical and instrumentation techniques
- applications of spectroscopy (mc)
- biochemistry lab
- biochemistry-food microbiology-practical-3 [mc]
- business communication [ed]
- c# programming with asp .net
- chemistry of dairy products(mc)
- chemistry of food additives
- chemistry of food additives [mc]
- computing techniques:excel for
- dairy & beverage processing
- effective communication[ed]
- entrepreneurs for food industries
- food analysis lab - iii
- food analysis lab – i
- food analysis lab – ii
- food biodeterioration and reservation [se]
- food biotechnology
- food biotechnology[se]
- food chemistry - i
- food chemistry – ii
- food chemistry-practical-6 [mc]
- food chemists [su]
- food from animal sources [mc]
- food from animal sources & processing techniques
- food microbiology
- food microbiology [se]
- food microbiology lab
- food preservation and food safety
- food processing lab - i
- food processing lab - ii
- food processing- agro products [mc]
- food processing-animal products[mc]
- food processing-practical 6 [mc]
- food product development & packaging techniques
- food safety, laws & regulations
- functional foods and nutraceuticals
- fundamentals of agro products [mc]
- fundamentals of management [ed]
- herbs and spices[se]
- human nutrition (mc)
- human nutrition & biochemistry
- inorganic, physical & chem. components of food
- inorganic, physical andanalytical chemistry(mc)
- instrumental methods of analysis-practical-4 [mc]
- introduction to data communication
- introduction to food processing
- life skills training
- livestock processing
- management of lifestyle diseases
- medical labtechnology [su]
- nutritional biochemistry
- nutritional biochemistry(mc)
- object oriented tech. & software engineering
- operating systems
- organic analysis and preparation-practical- 2 [mc]
- organic chemistry of food - ii
- organic chemistry of food –i (mc)
- organic chemistry of food –ii (mc)
- plant product processing
- project [mc]
- project and viva voice
- quantitative analysis practical–1 [mc]
- res. methodology & biostatistics
- science and society[mc]
- scientific research methodology [mc]
- seminar- i [mc]
- seminar-i [mc]
- seminar-ii [mc]
- summer training programme
- sustainable food management
- techniques in food analysis
- web programming with php & mysql