MySQL ON DELETE CASCADE
A foreign key with cascade delete means that if a record in the parent table is deleted, then the corresponding records in the child table (using the foreign key) will…
PHP Security
Sessions: http://phpsec.org/projects/guide/4.html Forms: https://www.w3schools.com/php/php_form_validation.asp
PHP OOP 1
This is a series of notes that I've taken from the excellent "The Net Ninja" tutorials on youtube with regards to PHP OOP. Once an object is instantiated, the php…
Database normalization
Notes taken from Brian Green's excellent video on normalization on youtube : https://www.youtube.com/watch?v=QqlPXKxN6LQ Normalisation is a process of removing anomalies from a database. These anomalies include: insertion, update and deletion…
Ajax using POST
A very simple ajax call <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <title>Test</title> </head> <body> <p onclick="loadDoc()">Click</p> <p id="ajaxOutputHere"></p> </body> </html> <script type="text/javascript"> // call the function immediately when the…
INSERT INTO … ON DUPLICATE KEY UPDATE
CREATE TABLE devices ( id INT AUTO_INCREMENT PRIMARY KEY, uniqueID int NOT NULL UNIQUE, firstName VARCHAR(100), secondName VARCHAR(100) ); INSERT INTO devices (firstName, secondName)VALUES ('James','Froggatt'); ... now INSERT INTO devices…
PHP Objects step by step
<?php # person.class class Person{ var $name; # this is a property function set_name($new_name){ # this is a method $this->name=$new_name; } function get_name(){ # this is a method echo $this->name;…
PHP Objects Inheritance
<?php class Person{ // constructor public function __construct($first_name, $last_name) { $this->first_name = $first_name; $this->last_name = $last_name; } public function say_my_name() { echo "My name is " . $this->first_name . "…
PHP Objects (general)
<?php class Person{ // constructor public function __construct($first_name, $last_name) { $this->first_name = $first_name; $this->last_name = $last_name; } public function say_my_name() { echo "My name is " . $this->first_name . "…
Setting up ZOOM from email received
Click on link on email 2) Download will automatically start if you don't already have zoom on your computer 3) Once downloaded click on the link 4) When you click…