mattm100 Posted November 9, 2012 Share Posted November 9, 2012 Hi, I am having issues with finding an efficient way of displaying products from my database, in terms of a paper catalogue. I have a list of products in a sql database, what I am currently using is a separate webpage which I have made a very basic print stylesheet. I briefly tried publisher (as I read somewhere that you can populate your catalogue from a database) but I quickly discovered my provider does not allow remote access. So if anyone has any ideas that could point me in a better direction I am all ears. Thanks, Matt. Quote Link to comment https://forums.phpfreaks.com/topic/270505-product-catalogue-from-sql-database/ Share on other sites More sharing options...
fenway Posted November 13, 2012 Share Posted November 13, 2012 I'm not sure exactly what you're asking. Quote Link to comment https://forums.phpfreaks.com/topic/270505-product-catalogue-from-sql-database/#findComment-1391938 Share on other sites More sharing options...
mattm100 Posted November 13, 2012 Author Share Posted November 13, 2012 Sorry if I didn't explain myself very well, I will try and make it clearer. I have a website where I have a catalogue for my products which are all stored within a mysql database. I would like to be able to create a printed version of this catalogue, what I have attempted so far is creating a css stylesheet but that does not give me the desired layout I am looking for. I have also tried using Microsoft publisher but that cannot be an option to me now as my hosting does not allow remote access to the database. Is there a program out there that I could design my pages, for example 6 products per page, image, name, description and then I could populate the pages from my sql database? Quote Link to comment https://forums.phpfreaks.com/topic/270505-product-catalogue-from-sql-database/#findComment-1392124 Share on other sites More sharing options...
Barand Posted November 15, 2012 Share Posted November 15, 2012 You could put a copy of the DB on your own PC. Quote Link to comment https://forums.phpfreaks.com/topic/270505-product-catalogue-from-sql-database/#findComment-1392493 Share on other sites More sharing options...
fenway Posted November 16, 2012 Share Posted November 16, 2012 MySQL does offer an embedded server, and InnoDB has a ready-only option for CD-ROMs and such. Quote Link to comment https://forums.phpfreaks.com/topic/270505-product-catalogue-from-sql-database/#findComment-1392831 Share on other sites More sharing options...
mattm100 Posted November 22, 2012 Author Share Posted November 22, 2012 Thank you for your help guys, got it sorted. I've been downloading a copy of database to print all along but it never clicked in my head to use that. Also the version of Publisher I had was 2002, so it never had the Catalog Merge option, now I have the 2010 version I seemed to have sorted it. Quote Link to comment https://forums.phpfreaks.com/topic/270505-product-catalogue-from-sql-database/#findComment-1394428 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.