MCM Semester 3 PHP My-Sql

University Syllabus Course and Classes Tuitions For MCM PHP MySql Semester 3

 

Atlanta Computer Institute Nagpur conducts Tuition Classes for MCM First Year ( Part 1 ) ,MCM Second Year ( Part 2 ) for all universities in India . The Following syllabus is of Nagpur University. Final Year Projects Training is also given to MCM Students.

Paper - III: Elective


Elective - I: PHP & My-SQL :

UNIT - I

Introducing PHP- Why PHP and MySQL?, What Is PHP?, What Is MySQL?. Server-
Side Scripting Overview- Static HTML,Client-Side Technologies, What Is Server-Side
Scripting Good For? Learning PHP Syntax and Variables - PHP Is Forgiving, HTML Is
Not PHP, PHP‘s Syntax Is C-Like, Comments, Variables, Types in PHP: Don‘t Worry, Be
Happy, Type Summary, The Simple Types, Output.
Learning PHP Control Structures
and Functions-
Boolean Expressions, Branching, Looping, Alternate Control Syntaxes,
Terminating Execution, Using Functions, Function Documentation, Defining Your Own
Functions, Functions and Variable Scope, Function Scope. Passing Information with
PHP - HTTP Is Stateless, GET Arguments, A Better Use for GET-Style URLs, POST
Arguments, Formatting Form Variables, PHP Superglobal Arrays. Learning PHP String
Handling - Strings in PHP, String Functions. Learning Arrays - The Uses of Arrays,
What Are PHP Arrays?, Creating Arrays, Retrieving Values, Multidimensional Arrays,
Inspecting Arrays, Deleting from Arrays, Iteration.
Learning PHP Number Handling-
Numerical    Types,    Mathematical    Operators,    Simple    Mathematical    Functions,
Randomness.  PHP  Gotchas-  Installation-Related  Problems,  Rendering  Problems,
Failures to Load Page, Parse Errors, Missing Includes, Unbound Variables, Function
Problems, Math Problems.

UNIT - II

Introducing Databases and MySQL- What Is a Database?, Why a Database?, PHP-
Supported Databases. Installing MySQL- Obtaining MySQL, Installing MySQL on Linux,
Installing MySQL on Microsoft Windows.
Learning Structured Query Language (SQL)-
Relational Databases and SQL, SQL Standards, The Workhorses of SQL, Database
Design, Privileges and Security. Learning Database Administration and Design -
Basic MySQL Client Commands, MySQL User Administration, Backups, Replication,
Recovery.  Integrating  PHP  and  MySQL-  Connecting  to  MySQL,  Making  MySQL
Queries, Fetching Data Sets, Getting Data about Data, Multiple Connections, Building in
Error Checking, Creating MySQL Databases with PHP, MySQL Functions. Performing
Database Queries -
HTML Tables and Database Tables, Complex Mappings, Creating
the Sample Tables. Integrating Web Forms and Databases- HTML Forms, Basic Form
Submission  to  a  Database,  Self-Submission,  Editing  Data  with  an  HTML  Form.
Improving Database Efficiency- Connections — Reduce, Reuse, Recycle, Indexing
and  Table  Design,  Making  the  Database  Work  for  You.  MySQL  Gotchas-  No
Connection, Problems with Privileges, Unescaped Quotes, Broken SQL Statements, Too
Little Data, Too Much Data, Specific SQL Functions, Debugging and Sanity Checking.

 UNIT - III

Introducing Object-Oriented PHP - What Is Object-Oriented Programming?, Basic
PHP Constructs for OOP, Advanced OOP Features, Introspection Functions, Extended
Example: HTML Forms, Gotchas and Troubleshooting, OOP Style in PHP. Advanced
Array Functions - Transformations of Arrays, Stacks and Queues, Translating between
Variables and Arrays, Sorting, Printing Functions for Visualizing Arrays.
Examining 

Regular Expressions - Tokenizing and Parsing Functions, Why Regular Expressions?,
Perl-Compatible Regular Expressions, Example: A simple link-scraper, Advanced String
Functions. Working with the File system - Understanding PHP File Permissions, File
Reading and Writing Functions, Filesystem and Directory Functions, Network Functions,
Date and Time Functions, Calendar Conversion Functions.
Working with Cookies and
Sessions- What‘s a Session?, Home-grown Alternatives, How Sessions Work in PHP,
Sample Session Code, Session Functions, Configuration Issues, Cookies, Sending
HTTP Headers, Gotchas and Troubleshooting. Handing Exceptions with PHP - Error
Handling in PHP, Other Methods of Error Handling, Logging and Debugging. Debugging
PHP Programs -
General Troubleshooting Strategies, A Menagerie of Bugs, Using Web
Server Logs, PHP Error Reporting and Logging, Error-Reporting Functions. Learning
PHP Style- The Uses of Style, Readability, Maintainability, Robustness, Efficiency and
Conciseness, HTML Mode or PHP Mode?, Separating Code from Design.

 UNIT - IV

Sending E-Mail with PHP- Sending E-Mail with PHP, Sending Mail from a Form,
Integrating PHP and Java- PHP for Java programmers, Integrating PHP and Java.
Integrating PHP and JavaScript- Outputting JavaScript with PHP, PHP as a Backup for
JavaScript, Static versus Dynamic JavaScript.
Integrating PHP and XML- What Is
XML?, Working with XML, Documents and DTDs, SAX versus DOM, DOM, SAX,
SimpleXML API, A Sample XML Application, Gotchas and Troubleshooting. Creating
and Consuming Web Services with PHP- The End of Programming as We Know It,
REST, XML-RPC, SOAP, .NET, Current Issues with Web Services, Project: A REST
Client. Creating Graphics with PHP- Your Options, HTML Graphics, Creating images
using gd, Gotchas and Troubleshooting.

  

Text Book:

1.   Steve Suehring, Tim Converse & Joyce Park, PHP and MySQL, Wiely.

 Reference Books:

1.   Joel Murach & Ray Harris, murach‘s PHP and MySQL, Shroff Publishers.

2.   Timothy Boronczyk, Elizabeth Naramore, Jason Gerner, Yann Le Scouarnec,
      Jeremy  Stolz,  Michael  K.  Glass,  Beginning  PHP6,  Apache,  MySQL  Web
Development, Wiley.

3.   Jason Gilmore, Beginning PHP and MySQL.

4.   Teach Yourself MySQL in 21 days - Techmedia

.

Practical List of PHP & My-SQL

31. Write an algorithm, draw a flowchart and Write a PHP script to get the PHP version
     
and configuration information.

32. Write an algorithm, draw a flowchart and Write a PHP script to print the Fibonacci
     
series up to the entered range.

33. Write an algorithm, draw a flowchart and Write a PHP script to change the color of
     
first character of a word.

34. Write an algorithm, draw a flowchart and Write a PHP script to test whether a number
      is greater than 30, 20 or 10 using ternary operator.

35. Write an algorithm, draw a flowchart and Write a PHP script to calculate the factorial
     
of a number (non-negative integer) using function.

36. Write an algorithm, draw a flowchart and Write a PHP script to insert a new item in an
      array on any position.

37. Write an algorithm, draw a flowchart and Write a PHP script to sort an array of
     
positive integers using the Sort function asort() and ksort().

38. Write an algorithm, draw a flowchart and Write a PHP script to

a) Transform a string all uppercase letters.

b) Transform a string all lowercase letters.

c) Make a string's first character uppercase.

d) Make a string's first character of all the words uppercase.

39. Write an algorithm, draw a flowchart and Write a PHP script to display all the
     
numbers between 200 and 250 that are divisible by 4

40. Write an algorithm, draw a flowchart and Write a PHP class which displays an
     
introductory message like "Hello All,Good Morning ", where "Morning" is an argument value of the method within the class.

41. Write an algorithm, draw a flowchart and Write a PHP Calculator class which will
      accept two values as arguments, then add them, subtract them, multiply them
together, or divide them on request.

42. Write an algorithm, draw a flowchart and Write a PHP script to convert a date from
     
yyyy - mm - dd to dd - mm - yyyy.

43. Write  an  algorithm,  draw  a  flowchart  and  Write  a  PHP  script  to  remove  the
     
whitespaces from a string.

44. Write an algorithm, draw a flowchart and Write a PHP function that checks if a string is
     
all lower case.

45. Write an algorithm, draw a flowchart and Write a PHP script to check whether a entered
      string is palindrome or not

46. Write an algorithm, draw a flowchart and Write a PHP script to print Fibonacci series
     
using recursion.

47. Write an algorithm, draw a flowchart and Write a PHP script using switch case and
      dropdown list display a - Hello‖ message depending on the language selected in
drop down list.

48. Write an algorithm, draw a flowchart and Write a PHP script to replace the first 'the' of
      the following string with 'That' -

Sample: 'the quick brown fox jumps over the lazy dog.'

Expected Result: That quick brown fox jumps over the lazy dog.

49. Write an algorithm, draw a flowchart and Write a PHP script to check that email id is
     
valid or not.

50. Write an algorithm, draw a flowchart and Write a PHP script to create a simple
     
'birthday countdown' script, the script will count the number of days between current

day and birth day.

51. Write a SQL statement to create simple table countries including columns country_id,
     
country_name and region_id.

52. Write a SQL statement to create table countries including columns country_id,
     
country_name and region_id and make sure that the column country_id will be unique and store an auto incremented value.

53. Write  a  SQL  statement  to  create  a  table  named  countries  including  columns
      country_id, country_name and region_id and make sure that no countries except
Italy, India and China will be entered in the table.

54. Write a SQL statement to insert a record with your own value into the table countries
     
against each columns region_id.

55. Write a SQL statement to rename the table countries to country_new.

56. Write an algorithm, draw a flowchart and Write a PHP script to which will receive the
      data captured by the HTML form, display the name of the form and also display the
message Data Entered Successfully on the HTML form page after performing the validations.

57. Write an algorithm, draw a flowchart and Write a PHP script to creating, retrieving
     
and deleting data from the cookie using POST Method.

58. Write an algorithm, draw a flowchart and Write a PHP script to create, retrieve and
     
deleting the session data.

59. Write an algorithm, draw a flowchart and Write a PHP script to navigate the HTML
     
Page with the use of JavaScript and PHP.

60. Write an algorithm, draw a flowchart and Write a PHP script to create login form with
     
the fields‘ username and password with validation.

61. Write an algorithm, draw a flowchart and Write a PHP script to send e-mail from a
     
form.

62. Write an algorithm, draw a flowchart and Write a PHP script to demonstrate the use
     
of REST.

63. Write an algorithm, draw a flowchart and Write a PHP script to demonstrate the use
     
of SOAP.

64. Create a table in MySQL named Programmer having the fields‘ id, sex, age,
     
Language, OS, and Country with constraint, insert up to 20 values and write a PHP

Script to generate a Bar Graph according to specific column the user selected.

65. Write an algorithm, draw a flowchart and Write a PHP script to create a registration
     
form having two buttons Submit and Reset with validations. The form data should be

submitted in MySQL databasewith coding to integrate the MySQL with PHP




New MCM Syllabus Semester Pattern From 2016 - 17

MCM Semester 1

Theory

1. Fundamental of Information Technology

2. Programming in C & OOPs Concept

3. Introduction to Operating Systems

4. Computerized Accounting ( Tally ERP 9 )

Practical

1. Practical-I : Programming in C & Operating Systems

2. Practical-II : Tally ( ERP 9 ) & MS-Office

MCM Semester 2

Theory

1. Management Information Systems

2. Core Java

3. Quantitative Techniques & Operation Research

4. E-Commerce and Web Designing

Practical

1. Practical-I : Core Java

2. Practical-II : HTML, JavaScript

MCM Part-II

MCM Semester 3

(A) Theory

1. Advanced Database Management System

2. Principles & Techniques of Management

3. Electives

( i ) PHP & My-SQL

( ii ) VB.Net

( iii ) C#.Net

4. Research Methodology

(B) Practical

1. Practical-I : SQL & PL/SQL

2. Practical-II : Electives

MCM Semester 4

(A) Theory

1. ASP.Net

2. Electives : (i) Advanced Java

(ii) Android Programming

(iii) Python

3. Electives : ( i ) Big Data & Hadoop

( ii ) Software Engineering

( iii )Strategic Management

(B) Practical

1. Practical-I : ASP.Net

2. Practical-II : Electives

(C) Project

1. PROJECT

BCA Bachelor Of Computer Application, BCCA, Bachelor of Commerce & Computer Application BE IT/CS, Information technology/Computer Science MCA, Master of Computer Application MCM, Master of Computer Management Diploma , Polytechnic B.Arch Bachelor Of Architecture, Others,

Basic Programming

C / C++ ,

Testing

Software Testing,

Hardware & Networking

CCNA, MCSE, Hardware, Networking

Courses at Atlanta

New Batches start Every week On Mondays and Wednesdays.

New Batch Starting Date & Timing

Copyright © 2010-2017 All Right Reserved - Atlanta Computer Institute, Nagpur. Site Map