General Programming Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community ForumsProgrammingGeneral Programming Help

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old January 26th, 2003, 06:40 PM
chuckfx chuckfx is offline
Junior Member
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jan 2003
Posts: 5 chuckfx User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Exclamation User(s) Login and some Content Manegement

I reposted this due to the fact i broke the rules...sry

OK, first off, I stink at making any type of PHP, but i REALLY need this script for my site...so please give me a hand. It's for a game site of mine with reviews and codes and media, and I just can't find anything that could help me. Heres how I want it to work:
-I want there to be a page with the letters #-Z (links) and then, about a line down, I want there to be somthing that says "Newly Added" and the 5 newest reviews (all links) to be listed under there (see EX. 1). Then, say somone clicks the letter B, they then should be taken to a page with all the reviews (there titles, all links) starting with B, and if they click one of them, they are taken to the review of that things title. (see EX. 2-3)
-It all can be done with HTML (except displaying the 5 newest articles) I know, but theres a catch...
-I want there to be a login page where staff members can login with a username and Password that I create and then they can be taken to a page where they can add Reviews, Codes or media (see EX. 4) Here they can just fill in custom feilds i make and click post and It would appear under the title of the first letter on the page (see EX. 5)
-I would really apprcuate it if someone could help me, and I will dispaly a link to there site and/or there name if they wish.

EX1
#|A|B|C|D|etc

Newly added:
Thing 1
Thing 2
etc.

EX2
#|A|B|C|D|etc

Thing with B 1
Thing with B 2
etc

EX3
#|A|B|C|D|etc
(Game tiltle)
This game blah blah blah

EX4
Username:
Password:
(link) Login
Then they are taken to somthing like:
Add Reviews
Add Media
Add Codes

EX5
(for reviews)
Game Starts with: (drop down box, so when it is posted, it goes under the correct letter)
Game Title: (They fill in info here)
Review: (They fill in info here)
Finall score: (They fill in info here)

Last edited by chuckfx : January 27th, 2003 at 05:56 PM.

Reply With Quote
  #2  
Old January 28th, 2003, 06:11 PM
baines baines is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Nov 2002
Posts: 33 baines User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 12 m 51 sec
Reputation Power: 7
Have a look at http://www.devarticles.com/art/1/163

Page 3 takes you through using a form for checking username and passwords stored in a MySQL database.

While I couldn't get the scripts to work for me, trying to sort them out explained all I needed to know and I have now got a very good user login system running on several sites, all based on this article.

As for retrieving the last five articles. One way would be to store the entry date along with the review, somthing like

Code:
INSERT INTO reviews SET article_text='$text', date_added=NOW()


You could then retrieve these by doing something like

Code:
SELECT article_text FROM reviews ORDER BY date_added DESC LIMIT 5


I'm not certain if the above is 100% accurate but I'm sure you get the picture.

And getting a list of all reviews beginning with a letter could be done with

Code:
SELECT article_text FROM reviews WHERE article_TEXT LIKE 'A%'


Again, check the details for the SELECT function but it should be close enough.

Good luck with the project

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsProgrammingGeneral Programming Help > User(s) Login and Content Manegement


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 4 hosted by Hostway
Stay green...Green IT