PHP and databases

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
erikaleonard
Forum Newbie
Posts: 2
Joined: Mon Jun 16, 2008 9:50 am

PHP and databases

Post by erikaleonard »

I am extremely new to php, actually this is only my 5th day or so working with it. I've taught myself how to use it with my Microsoft Access database to pull in data. I've also figured out how to make the data I pull in into links.
My database is a huge listing of processes for my office mainframe. Right now there are over 400 in it and its less than halfway done. Each job has certain information about it that the user needs to view by clicking on the specific job. What I'm wondering, is if there is a way to display the information without creating 1000 pages. Is my best bet to have one LONG page with all of the Jobs and their info(with a "name" link) and route the users to that place on the page? Or is there another way I can do this so that only the information I want shows on a single page?
User avatar
califdon
Jack of Zircons
Posts: 4484
Joined: Thu Nov 09, 2006 8:30 pm
Location: California, USA

Re: PHP and databases

Post by califdon »

erikaleonard wrote:I am extremely new to php, actually this is only my 5th day or so working with it. I've taught myself how to use it with my Microsoft Access database to pull in data. I've also figured out how to make the data I pull in into links.
My database is a huge listing of processes for my office mainframe. Right now there are over 400 in it and its less than halfway done. Each job has certain information about it that the user needs to view by clicking on the specific job. What I'm wondering, is if there is a way to display the information without creating 1000 pages. Is my best bet to have one LONG page with all of the Jobs and their info(with a "name" link) and route the users to that place on the page? Or is there another way I can do this so that only the information I want shows on a single page?
Your question is so broad that it is difficult to give you a specific answer, but if you are asking what I think you are, the answer is that you would almost never display the entire contents of any database. You would use queries to select only the one or perhaps several record(s) that the user is interested in. So you would have to have a form where the user inputs the name or number that identifies the record(s) of interest, then run the query to retrieve just that (or those) record(s).

You might find articles like this one helpful to reach an understanding of queries: http://www.dotnetheaven.com/UploadFile/ ... e1c35a617f
erikaleonard
Forum Newbie
Posts: 2
Joined: Mon Jun 16, 2008 9:50 am

Re: PHP and databases

Post by erikaleonard »

Thanks for your reply. Sorry for being so broad. I understand how to use queries and the such. What I guess I meant to ask was how to use certain criteria in the query such as pulling it through the URL (like with ?id=1234). I did some more research and figured it out. Thanks for your help though.
Post Reply