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');