Member Avatar for shujjah

I would be grateful if anyone could help me
i need a reviews and a news script for my gaming website written in php and sql
i want a reviews,and a news script. i mean i want a script that will allow me to add reviews and some other editors to ad reviews or news. but it shoud not be like i have to create a new html page every time for a review but it should something like each review or news will have its own id and when you wil open it it will open like this or something like that anyone willing to help me and plz give me the link if there is any script not exactly like this but like this for me do download and i might edit it a bit with your help of course :P :D

and if noone can do it for me for free than i think i can make the databse then i would want to know that how many scripts i will need and what each script will do so that i can try to make it myself if noone is willing to do it :P

  • 3 Contributors
  • 3 Replies
  • 189 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by justinm

Dani AI

Generated

asked for a PHP/MySQL reviews-and-news system where each item has its own dynamic URL and multiple editors can add content. correctly noted that blog software covers the basic flow for news; the difference for reviews is structured fields (rating, pros/cons, platform, score). ’s suggestion to consult tutorials is sensible for learning — below is a compact, practical blueprint that fills the gaps: table design, the set of scripts needed, and essential security/performance points.

A minimal schema (example) — posts hold both news and reviews; users store editors/admins:

CREATE TABLE posts (
  id INT AUTO_INCREMENT PRIMARY KEY,
  type ENUM('news','review') NOT NULL,
  title VARCHAR(255) NOT NULL,
  slug VARCHAR(255) UNIQUE,
  content TEXT NOT NULL,
  author_id INT NOT NULL,
  status ENUM('draft','published','archived') DEFAULT 'draft',
  rating TINYINT UNSIGNED NULL,
  platform VARCHAR(80) NULL,
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

CREATE TABLE users (
  id INT AUTO_INCREMENT PRIMARY KEY,
  username VARCHAR(50) UNIQUE NOT NULL,
  password_hash VARCHAR(255) NOT NULL,
  role ENUM('author','editor','admin') DEFAULT 'author',
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP
);

Core scripts and their roles: a listing/index page (paginated); a single-item view (view.php?id=… or post/slug via rewrite); admin/login and session handling; admin post editor (create/edit/publish); admin post list (moderation/history); user/role management; media/upload handler; optional RSS/API endpoint. Each admin action must enforce role checks and CSRF protection.

Key cautions and best practices: use PDO with prepared statements, password_hash() for passwords, escape output (htmlspecialchars) to prevent XSS, validate and sanitize uploads, limit DB user privileges, and add indexes on frequently queried columns (id, slug, author_id). For reviews add rating normalization and allow drafts/scheduling. Prefer a single “post” handler with a type field rather than separate scripts for news vs reviews — it simplifies maintenance and multi-author workflows.

Recommended Answers

All 3 Replies

Member Avatar for Puckdropper

Sounds like what you want is blog software. I have implemented my blog software as an update section on my web page, but have yet to really integrate it.

http://www.puckdroppersplace.us/blog/index.php
http://www.puckdroppersplace.us/updates/index.php

Look like what you want? Support for multiple authors would mean giving them full access to the admin section of the blog, I did not think about adding such a feature. (I think I'll put it on the todo list, though.)

Member Avatar for shujjah

what noone? in such a big communtiy no one?

Member Avatar for justinm

what noone? in such a big communtiy no one?

make your own?
look in the tutorials area...

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.