Razvan Raducanu

Database programming

Part I. MySQL Language. Applications in PHP

  • MySQL programming with PDO(PHP Data Object)
  • MySQL Language; table joins in MySQL
  • PDO class
  • User-defined variables in MySQL
  • Stored procedures in MySQL; PHP implementation using PDO
  • MySQL triggers; PHP implementation using PDO


Part II. Applications of MySQL using Laravel Framework

  • Introduction to Laravel Framework
  • Controller-view type examples in Laravel Framework
  • Sessions, cookies, HTML forms in Laravel Framework
  • OOP: classes, objects, inheritances in Laravel
  • MySQL in Laravel; how to define a Laravel model
  • MVC(Model-View- Controller) examples, where the model is a MySQL table
  • MySQL basic operations in Laravel: CRUD
  • MySQL stored procedures and triggers in Laravel Framework


Part III. Applications of MongoDB

  • Introduction in MongoDB
  • MondoDB variables, syntax
  • MongoDB queries
  • MongoDB queries in PHP
  • CRUD op with PHP and MongoDB
  • Search in MongoDB with PHP
  • Stored procedures in MongoDB


Part IV. XML programming. Applications in PHP

  • PHP parsers: SimpleXML and DOM
  • XML structure, DTD, XML Schema
  • XPath, XQuery -- applications in PHP
  • XSL stylesheets-- applications in PHP
  • CRUD operations in XML using PHP


Exam requirements

Project 1 (MySQL classic)

  • Make a PHP/MySQL project that manages a MySQL database and implements the basic operations: create, insert, search, update and delete. The site should implement(create and call from PHP code!!! ) 3 stored procedures and 3 triggers in a "classical sens", using PDO.
  • upload the project on a web server


Project 2 (Laravel)

Make a PHP/MySQL project that manages a MySQL database using the Laravel Framework, and implements the basic operations: create, insert, search, update and delete. The site should:
  • use cookies and sessions and
  • implement (create and call from PHP code!!!) 3 stored procedures and 3 triggers using Laravel Framework
  • upload pictures into Mysql & display pictures from MySQL
  • use a Bootstrap site template
  • upload the project on a web server


Project 3 (MongoDB)

Make a PHP/MongoDB project that manages a MongoDB database, and implements the basic operations: create, insert, search, update and delete. The site should:
  • use cookies and sessions and
  • use a Bootstrap site template
  • upload pictures into MongoDB & display pictures from MongoDB

Make 3 MongoDB stored procedures and call them from MongoDB.


Project 4 (XML)

Make a PHP project that manages an XML document. The site should:
    Make a PHP/XML project that manages a XML database, and implements the basic operations: create, insert, search, update and delete. The site should:
    • use cookies and sessions and
    • use a Bootstrap site template
    • have at least one XML document with an attached XSL stylesheet
    • have a DTD or XML Schema attached to the XML document
    • have a hyperlink using XML, XLink and XSL, implemented in PHP
    • implement a register/login sistem with the data from an XML file
    • store and display images in an XML document (using PHP)
    • upload the project on a web server

    The XML document should also contain a math formula written in MathML and embedded in XML and a SVG image, also embedded in XML.


Project 1 an 4 have 2 points each. Project 2 and 3 have 3 points each.


For students