Dva nova videa u Školi

Dva nova videa u Školi:
1. https://www.youtube.com/watch?v=1Uc8EcGvP9w

Download: http://kartedium.com.hr/cms_skola/video35i36.zip

CMS Škola - Relacijska baza podataka
- SQL na 100%

CREATE DATABASE blog1;
USE blog1;
CREATE TABLE menu (
menu_id int AUTO_INCREMENT PRIMARY KEY,
heading varchar(100),
content text,
published date,
pic varchar(100) NULL,
views_counter int
);
CREATE TABLE comments ( comment_id int AUTO_INCREMENT PRIMARY KEY,
menu_id int,
CONSTRAINT menuid
FOREIGN KEY (menu_id)
REFERENCES menu(menu_id)
ON DELETE CASCADE ON UPDATE CASCADE,
nickname varchar(100) NOT NULL,
content text NOT NULL,
published date NOT NULL,
approved bit DEFAULT 0
);

2. https://www.youtube.com/watch?v=FirpNXT6j7g

Sažetak: - PHP na 100% - tražilica - konstante za spoj na bazu podataka - prepered statement - petlja While - link Škola za učenike: http://kartedium.com.hr/index.php