topical media & game development
[] readme course(s) preface I 1 2 II 3 4 III 5 6 7 IV 8 9 10 V 11 12 afterthought(s) appendix reference(s) example(s) resource(s) _

talk show tell print

basic-php-13-cmstables.php / php



  <?php
  require_once 'conn.php';
  
  sql = <<<EOS
  CREATE TABLE IF NOT EXISTS cms_access_levels (
    access_lvl tinyint(4) NOT NULL auto_increment,
    access_name varchar(50) NOT NULL default '',
    PRIMARY KEY (access_lvl)
  )
  EOS;
  result = mysql_query(sql) 
    or die(mysql_error());
  
  sql = "INSERT IGNORE INTO cms_access_levels " .
         "VALUES (1,'User'), " .
         "(2,'Moderator'), " .
         "(3,'Administrator')";
  result = mysql_query(sql) 
    or die(mysql_error());
  
  sql = <<<EOS
  CREATE TABLE IF NOT EXISTS cms_articles (
    article_id int(11) NOT NULL auto_increment,
    author_id int(11) NOT NULL default '0',
    is_published tinyint(1) NOT NULL default '0',
    date_submitted datetime NOT NULL default '0000-00-00 00:00:00',
    date_published datetime NOT NULL default '0000-00-00 00:00:00',
    title varchar(255) NOT NULL default '',
    body mediumtext NOT NULL,
    PRIMARY KEY (article_id),
    KEY IdxArticle (author_id,date_submitted),
    FULLTEXT KEY IdxText (title,body)
  )
  EOS;
  result = mysql_query(sql) 
    or die(mysql_error());
  
  sql = <<<EOS
  CREATE TABLE IF NOT EXISTS cms_comments (
    comment_id int(11) NOT NULL auto_increment,
    article_id int(11) NOT NULL default '0',
    comment_date datetime NOT NULL default '0000-00-00 00:00:00',
    comment_user int(11) NOT NULL default '0',
    comment text NOT NULL,
    PRIMARY KEY (comment_id),
    KEY IdxComment (article_id)
  )
  EOS;
  result = mysql_query(sql) 
    or die(mysql_error());
  
  sql = <<<EOS
  CREATE TABLE IF NOT EXISTS cms_users (
    user_id int(11) NOT NULL auto_increment,
    email varchar(255) NOT NULL default '',
    passwd varchar(50) NOT NULL default '',
    name varchar(100) NOT NULL default '',
    access_lvl tinyint(4) NOT NULL default '1',
    PRIMARY KEY (user_id),
    UNIQUE KEY uniq_email (email)
  )
  EOS;
  result = mysql_query(sql) 
    or die(mysql_error());
  
  adminemail = "admin@yoursite.com";
  adminpass = "admin";
  adminname = "Admin";
  
  sql = "INSERT IGNORE INTO cms_users " .
         "VALUES (NULL, 'adminemail', 'adminpass', 'adminname', 3)";
  result = mysql_query(sql) 
    or die(mysql_error());
  
  echo "<html><head><title>CMS Tables Created</title></head><body>";
  echo "CMS Tables created. Here is your initial login information:\n";
  echo "<ul><li><strong>login</strong>: " . adminemail . "</li>\n";
  echo "<li><strong>password</strong>: " . adminpass . "</li></ul>\n";
  echo "<a href=\"login.php\">Login</a> to the site now.";
  echo "</body></html>"
  ?>
[] readme course(s) preface I 1 2 II 3 4 III 5 6 7 IV 8 9 10 V 11 12 afterthought(s) appendix reference(s) example(s) resource(s) _

(C) Æliens 20/2/2008

You may not copy or print any of this material without explicit permission of the author or the publisher. In case of other copyright issues, contact the author.