| |
|
 |
Building a News Management System by: sm0ke |
Page: 1 of 5
(View All) |
Introduction
The 3 things we need initially will be:
- PHP (Hypertext preprocessor)
- MySQL (Structured Query Language)
- Apache (Web Server)
- PHPMyAdmin is also a useful tool to use.
Got them? Right on with the show.
Create Table
Firstly we need to make sure we have a table created on our database:
The code above wll create a table on your MySQL Database called "news" with the following fields created:
- id - The unique identifior of the news post
- title - The title of your news post
- content - The main body of your news post
- author - The name of the author
- date - The date and time of the news post (this will be formatted to a readable string using another file we create later on)
Login
So now that we have a table created we need a way to log into the database. This code will create a database connection. Save the file as "site.inc.php" in a directory called "site"
OK so now we have a database with a table called news, and a small file which contains the database login information along with the functions to log in and out of the database. The file is very important, because it eliminates the need to write your DB access details accross many files.
Comments:
| mangoacid |
| Subject: "User Access"
Date: Mar 31 2008 at 11:57 pm
|
|
|
|
|
Is there a way
to set multiple
access levels?
I want to allow
moderators to
post, but not
delete admin
posts or other
mod posts, just
post news. And
then allow
basic user
access for
viewing.
|
| s141797 |
| Subject: "typing error"
Date: Nov 16 2008 at 10:41 am
|
|
|
|
|
the row gets
deleted from
the table but
then the entire
PURPOSE of the
script is gone.
|
|
|
 |
Tutorial Stats |
| 546,654 |
Views |
| 6 |
Total Comments |
| 0 |
Rating of 5 ( Votes) |
|
