Jump to content


Photo

First Time - Building a database, a learning project


  • Please log in to reply
2 replies to this topic

#1 SeanDempsey

SeanDempsey
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 25 June 2006 - 04:24 AM

I am beginning to learn PHP, and I have found it to be very interesting and fun. Until, I have only edited and modified packages like WordPress or CS-Cart/OSCommerce, but I would like to start making my own stuff from scratch, so I am starting a project, but I have no idea how to begin.

Here is what I want to end up with: A page that displays a list of (in this case) video games, sorted with the newest release date at the top. The game titles would click to a website (amazon, whatever).

The admin would allow me to enter the game title, select the system, and enter a release date. I'd want to be able to list the games in the admin and edit them individually.

Also, the scary part (for me) is that I want to enter the games and the system in the admin, and have the main page only display one type of system at a time, and the user selects which system he wants to see, and it repopulates the list on a refresh.

This really is just a database list, I Am sure that you guys have made this sort of thing countless times. But to me, this is all new. I am hoping that by doing this project, I'll learn alot.

I have the latest Php and SQL on my server, all running fine.

Any help, links, tutorials, or just advice would be appreciated. Thanks

#2 Drumminxx

Drumminxx
  • Members
  • PipPipPip
  • Advanced Member
  • 92 posts
  • LocationUSA

Posted 25 June 2006 - 04:41 AM

get this book its great and easy to understand. I have an older version but this newer one should be just as good if not better.

[a href=\"http://www.amazon.com/exec/obidos/tg/detail/-/0321336577/qid=1151210165/sr=8-1/ref=sr_8_1/103-1155768-2811805?v=glance&n=507846\" target=\"_blank\"]Larry Ullman, PHP and MySQL for Dynamic Websites[/a]

its also great to keep around for a reference
:: gucci.com ::
:: blockbuster.com ::

--------------------

#3 Barand

Barand
  • Moderators
  • Sen . ( ile || sei )
  • 18,021 posts

Posted 25 June 2006 - 08:08 PM

A series of articles by Kevin Yank started me off with PHP/MySQL

[a href=\"http://www.sitepoint.com/article/publishing-mysql-data-web\" target=\"_blank\"]http://www.sitepoint.com/article/publishing-mysql-data-web[/a]
If you are still using mysql_ functions, STOP! Use mysqli_ or PDO. The longer you leave it the more you will have to rewrite.

Donations gratefully received






moon.png

|baaGrid| easy data tables - and more
|baaChart| easy line, column and pie charts




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users