WS101 PHP with MySQL Past Paper PDF

WS101 WEEK 10 PHP with MySQL - DCL (Data Control Language) HIERARCHY CHART Used to control access to data within the - Help to document a program. database. - Representa...

WS101 WEEK 10 PHP with MySQL - DCL (Data Control Language) HIERARCHY CHART Used to control access to data within the - Help to document a program. database. - Representation of information in a EX. COMMANDS: GRANT, REVOKE database. BASIC SQL EXPRESSION CLAUSES HIERARCHY PATH - SELECT is used to retrieve data - Ordered sequence of segments, tracing - FROM is used to list the relations to be the hierarchical structure. scanned. Used to specify the table from which to select or delete data. PREORDER TRAVERSAL - WHERE is used to filter records based on - also called the hierarchical sequence or specific conditions. the left-list path. THREE BASIC STATEMENTS RELATIONAL DATABASE - INSERT enables you to add data into a - Dr. E.F. Codd British scientist who table. worked for IBM. He invented the - UPDATE used to edit data in a table. relational model for database - DELETE deletes entire rows. management. - Relational model. A relational database organizes data into tables. Consisting of WEEK 11 PHP with MySQL rows and tables. ERD (Entity-Relationship Diagram) - Primary key is a unique identifier. - Foreign key references primary key. can express the overall logical structure of a database in a graphical way. SQL (Structured Query Language) CARDINALITY Manages and manipulate relational database. Allows users to Create, Read, Update and - Cardinality Notation Delete (CRUD) data in a database. - Crow’s Foot Notation - DDL (Data Definition Language) Enables you to create and modify database itself. EX. COMMANDS: CREATE, ALTER, DROP - DML (Data Manipulation Language) Module of the SQL. Allows to manipulate data, EX. COMMANDS: INSERT, UPDATE, DELETE, SELECT UML (Unified Modeling Language) WEEK 12 LARAVEL an approach that can be used to model all 8 BENEFITS OF LARAVEL FRAMEWORK different aspects of software development for object-oriented systems. It’s quick and simple Security is key Types: Better website performance Class Diagram: Illustrates the static Great for Traffic-Handling structure of a system by showing Really Flexible classes, their attributes, methods, and Easy third-party integrations relationships. Simple Website Maintenance Use Case Diagram: Represents how The cost of a Laravel Site users (actors) interact with the system from their perspective. ROUTING, A STATIC METHOD State Diagram: Depicts the various 'Route' is a class that has a static method ‘get’ states of an object and the transitions that returns a ‘view’ method which presents a between those states. web page. Sequence Diagram: Shows the order of interactions between objects over time. WEEK 13-14 LARAVEL Activity Diagram: Visualizes the step- by-step workflow of processes within a CONTROLLER CLASS system. - Model, View, Controller (MVC) Component Diagram: Breaks down a - system into smaller components and - In MVC framework controller has a illustrates their relationships. definite role. It primarily controls the flow PHP MYSQL DATABASE between model and view. - The controller serves as a bridge - PHP allows you to connect to and between the model and the view, manipulate databases. managing data flow and application logic. - MySQL is the most popular database system. MANIPULATING DATABASE TABLE VIEW AND BLADE In the MVC framework, the part ‘view’ has an important role. First, it should look good and appealing. It deals with HTML, CSS, JavaScript, and many other codes that make a page look great. Responsible for presenting data to the user and rendering the user interface. It receives data from the model and displays it accordingly. ENVIRONMENT It tells us about the database connections. DATABASE MIGRATION Database migration in Laravel is a technique that helps us to create, update, or delete the table and its columns. In a developmental scenario, when you work on a project participating from different destinations, you can easily modify or manipulate your database through a few simple PHP commands.