Page 1 of 1

could you help me on this ..

Posted: Sun Dec 08, 2002 8:55 pm
by Ajnadeen
In The Name of Allah ,

Dear php Programmer's

After Peace On You all

Could any one tell me how to make an articles organizer using php and mysql ?

for any questions please don't hesitate : Me4arab@hotmail.com

---------------------------------------------------------------------------------
Mohamed Eed ,
Egypt

Posted: Mon Dec 09, 2002 12:47 am
by Sunthas
You mean a simple one like this one: http://www.sunthas.com/psn/

Posted: Mon Dec 09, 2002 4:12 pm
by Ajnadeen
yes sir , i mean one like this

please tell me how or contact me on

me4arab@hotmail.com

but is this limit the topics on the main page or display all ??

Posted: Mon Dec 09, 2002 4:32 pm
by Sunthas
Its in a really crude form right now. I looked at all of the news article content management systems on the web and decided they were much more complicated than I wanted, and I figured what better way to learn than to do one myself.

I can zip up the source and put it link to it up this evening.

Essentially I have 4 tables in my database.
Articles
Categories
Links
Users

Articles contains Article Key, Headline, Date, User who Posted, Category Key, Article.

Then each time I add an article it displays it right away doing querries each time the page is loaded. I'm sure its inefficient but its fairly simple. I'm making a new version that uses CSS but its not complete yet.

If you look at the bottom of the page you will see a link to Admin.html which is where I add my articles and categories and stuff.

Pretty Simple News

Posted: Mon Dec 09, 2002 8:57 pm
by Sunthas
You can download the source files my news articles here and go through it.

http://www.sunthas.com/psn/prettysimplenews.zip

As I said above the basic table design is pretty simple and I believe its normalized.

Links Table contains LinkKey, LinkName, and Link.
Category Table contains CategoryKey and Category.
User Table contians UserKey, LoginName, FirstName, LastName, Password, JoinedDate, LastAccessDate(currently not used), UserLevel, and UserEmail.

P.S. let me know if you have any questions.