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?
PHP and databases
Moderator: General Moderators
Re: PHP and databases
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).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?
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
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.