PHP Classes

File: SQL.sql

Recommend this page to a friend!
  Classes of Ersin Güvenç   SEO link factory class   SQL.sql   Download  
File: SQL.sql
Role: Auxiliary data
Content type: text/plain
Description: sql file
Class: SEO link factory class
Retrieve friendly URLs from a database
Author: By
Last change: use seo_example added
Date: 15 years ago
Size: 684 bytes
 

Contents

Class file image Download 

CREATE DATABASE IF NOT EXISTS seo_example;
USE seo_example;

CREATE TABLE IF NOT EXISTS `articles` (
  `article_id` int(11) NOT NULL auto_increment,
  `title` varchar(500) character set utf8 NOT NULL,
  `article` text character set utf8 NOT NULL,
  `link` varchar(600) character set utf8 NOT NULL,
  PRIMARY KEY  (`article_id`),
  KEY `link` (`link`)
);

INSERT INTO `articles` (`article_id`, `title`, `article`, `link`) VALUES
(1, 'çğü._eğş08ÀØñ', 'blablabla blab lbal balb la', 'cgu-_egs08aqn'),
(2, 'i See dead peoPle', 'i see bla bla bla blab bla', ''),
(3, 'çğü._eğş08ÀØñ', 'test test test 123 blab bla bla', 'cgu-_egs08aqn-1');