jmillsapps Posted February 16, 2011 Share Posted February 16, 2011 I have an sql database that is updated via a PHP website. It is to track inventory. I can read from the DB and display the information and photos on the page. What I need is to be able to click on an item number of any listing on the page and pull up more info (ie photos) on another page of that listing. Kind of like a car dealership. You search for a vehicle, and several vehicles are displayed. You click on the vehicle you want and are sent to a page with more information on the selected vehicle. If any of this doesnt make sense, let me know. Quote Link to comment https://forums.phpfreaks.com/topic/227881-inventory-database/ Share on other sites More sharing options...
Maq Posted February 16, 2011 Share Posted February 16, 2011 What exactly are you having trouble with? You put this in the MySQL section, I can move it to PHP if it's more than SQL help. The pseudo design would look something like: - Display all the results with links that contain the unique ID. - When the user clicks the ID, send them to a page that handles inventory item details. - Use the ID to query the database for that specific item and extract the appropriate information and display it. Quote Link to comment https://forums.phpfreaks.com/topic/227881-inventory-database/#findComment-1175077 Share on other sites More sharing options...
jmillsapps Posted February 16, 2011 Author Share Posted February 16, 2011 I think it would be related more to PHP. Sorry. Quote Link to comment https://forums.phpfreaks.com/topic/227881-inventory-database/#findComment-1175091 Share on other sites More sharing options...
jmillsapps Posted February 16, 2011 Author Share Posted February 16, 2011 Can you point me to make a link out of the unique ID and how to query a new page using that ID? Quote Link to comment https://forums.phpfreaks.com/topic/227881-inventory-database/#findComment-1175111 Share on other sites More sharing options...
Jessica Posted February 16, 2011 Share Posted February 16, 2011 You need to show us what you have now, and then attempt something. Then we can help. Quote Link to comment https://forums.phpfreaks.com/topic/227881-inventory-database/#findComment-1175112 Share on other sites More sharing options...
Maq Posted February 16, 2011 Share Posted February 16, 2011 Can you point me to make a link out of the unique ID and how to query a new page using that ID? If you can: I can read from the DB and display the information and photos on the page. then displaying details for the specific item should be similar. I assume you have these items in your database? For your link, pass the value via HTTP: itemDetail.php?id=5 then to extract the id in "itemDetail.php" you use $_GET: echo $_GET['id']; Now you should have enough information to extract all the information you need form the data base. Quote Link to comment https://forums.phpfreaks.com/topic/227881-inventory-database/#findComment-1175117 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.