Jump to content


Photo

Best way to offer specific item info


  • Please log in to reply
2 replies to this topic

#1 kruzayn

kruzayn
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 28 April 2006 - 05:51 PM

I have a PDF right now that is 400 pages long. It contains advanced item information. On an ecommerce website i want to link to the product info of only the product that is being looked at and not all 400 pages. I am willing to do the work to make it easier, but creating 400 individual html files isnt what i want to do. What is the best way to do this with PHP/MySQL.

Thanks for any feedback, i really appretiate it.

Kruzayn

#2 ober

ober
  • Staff Alumni
  • Advanced Member
  • 5,337 posts
  • LocationEast Coast, USA

Posted 28 April 2006 - 07:42 PM

There's not going to be an easy way to do this unless you can programatically grab the information out of the PDF and stuff it into a database. You're still going to have to go through the content and do formatting and so on. My suggestion is to create a table for "topics" or "products" or whatever you want to call them. Put the content for each item in a seperate record and then create one page that pulls the correct information out of the database. If the layout for each item is similar, you can leave most of the formatting to the one PHP page and seperate your product content into various fields (item number, serial number, description, etc) and format it as you pull it out of the database.

I don't know what you're looking for as far as a specific answer, so I hope that helps.

Info: PHP Manual


#3 Barand

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

Posted 28 April 2006 - 07:43 PM

I would recommend that, when user selects an item, you create the PDF page for that item "on-the-fly" using something like FPDF

EDIT : As Ober, who types faster than me, said.
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