Home arrow MySQL arrow Page 4 - Creating the Admin Script for a PHP/MySQL Blogging System

The Links - MySQL

In this part of the series we will be writing the administration of the blog. The idea is to give the owner of the blog the ability to manage the blog by being able to remove users and articles as required, or to alter the status of users by upgrading them to admin status or banning them. It is also a place where the administrator can start new topics that will then garner their own replies.

  1. Creating the Admin Script for a PHP/MySQL Blogging System
  2. The Admin script
  3. Functions.php
  4. The Links
By: Jacques Noah
Rating: starstarstarstarstar / 33
October 17, 2006

print this article



The "create new user" link takes you to the register script, but this time a variable is sent with the link. This variable enables a new row called "level" to be shown in the form, as you can see below:


This row enables the admin to register a user as admin. If you register normally, this option is not available.

The "create new thread" link goes to a page called new_post.php. This page is similar to the form on the comments page, but requires that the title and category of the article be specified as below:

I created this page so that the admin can start a new topic or thread. The normal page that the users use to post a new message does not have the title or category sections.


The admin area can of course be improved a lot. With this script Iíve not only touched on the basics, but have also laid the foundation that could lead to a much more robust administration script being developed.

>>> More MySQL Articles          >>> More By Jacques Noah

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort


- Oracle Unveils MySQL 5.6
- MySQL Vulnerabilities Threaten Databases
- MySQL Cloud Options Expand with Google Cloud...
- MySQL 5.6 Prepped to Handle Demanding Web Use
- ScaleBase Service Virtualizes MySQL Databases
- Oracle Unveils MySQL Conversion Tools
- Akiban Opens Database Software for MySQL Use...
- Oracle Fixes MySQL Bug
- MySQL Databases Vulnerable to Password Hack
- MySQL: Overview of the ALTER TABLE Statement
- MySQL: How to Use the GRANT Statement
- MySQL: Creating, Listing, and Removing Datab...
- MySQL: Create, Show, and Describe Database T...
- MySQL Data and Table Types
- McAfee Releases Audit Plugin for MySQL Users

Developer Shed Affiliates


Dev Shed Tutorial Topics: