CakePHP 4 Tutorial - #2 Quick Tour

Published: 28 November 2020
on channel: Coffee Coding

11,641

100

In this video we dive deeper into CakePHP and provides a quick overview of what it is and how it functions. We connect to the database and create our first model-classes.

** MYSQL TO CREATE TABLES **
CREATE TABLE u sers (
id INT AUTO_INCREMENT PRIMARY KEY,
email VARCHAR(255) NOT NULL,
password VARCHAR(255) NOT NULL,
created DATETIME,
modified DATETIME
);

CREATE TABLE articles (
id INT AUTO_INCREMENT PRIMARY KEY,
user_id INT NOT NULL,
title VARCHAR(255) NOT NULL,
slug VARCHAR(191) NOT NULL,
body TEXT,
published BOOLEAN DEFAULT FALSE,
created DATETIME,
modified DATETIME,
UNIQUE KEY (slug),
FOREIGN KEY user_key (user_id) REFERENCES users(id)
) CHARSET=utf8mb4;

CREATE TABLE tags (
id INT AUTO_INCREMENT PRIMARY KEY,
title VARCHAR(191),
created DATETIME,
modified DATETIME,
UNIQUE KEY (title)
) CHARSET=utf8mb4;

CREATE TABLE articles_tags (
article_id INT NOT NULL,
tag_id INT NOT NULL,
PRIMARY KEY (article_id, tag_id),
FOREIGN KEY tag_key(tag_id) REFERENCES tags(id),
FOREIGN KEY article_key(article_id) REFERENCES articles(id)
);

INSERT INTO users (email, password, created, modified)
VALUES
('cakephp@example.com', 'secret', NOW(), NOW());

INSERT INTO articles (user_id, title, slug, body, published, created, modified)
VALUES
(1, 'First Post', 'first-post', 'This is the first post.', 1, NOW(), NOW());

On this page of the site you can watch the video online CakePHP 4 Tutorial - #2 Quick Tour with a duration of hours minute second in good quality, which was uploaded by the user Coffee Coding 28 November 2020, share the link with friends and acquaintances, this video has already been watched 11,641 times on youtube and it was liked by 100 viewers. Enjoy your viewing!

1,069