Thanks for sharing your results. I'm glad you found some content. FWIW, I can only pull about 1600 returns right now, the aws server is probably real busy. Try again later maybe. I usually get 2500 results, the current limit.
No problems, thanks again, great script, looks like 500-600 is about the most my server is handling, so I'm just varying the keywords and getting a few thousand results that way. Here's the store btw : www.buyjoggingstrollers.com/baby-books/ Mark
Actually varying the keywords is giving some nice results, working in a lot of topics that are not thrown up by the primary KW I'm using.
The templates work just fine, real easy to work out, I just wrapped everything in the simple css layout I use for the rest of the site, took about 30 minutes I suppose.
I thought of a flaw. There is code to expire books that are a week old when you pull. However using live pricing data on the purchase pages we can cache the other data for 3 months. So... I will get rid of the weekly expire code and leave it up to the store owner to follow the TOS and do the 3 month updates. Keep a list of the keywords you pull. Thanks. EDIT: oops, I'll just make it 90 day expire code.
Joeychgo informed me this morning that I forgot to make it so our titles and descriptions can be dynamic with book information in the header.html template. So I made that so. This is a huge SEO improvement I just over looked. DOH! Anyway, 1.03 is released and this also automates the install by just running p3.php which auto creates the tables if they don't exist and then populates the database. You could have a book store in under 15 minutes in most cases. BTW upgrading from 1.02 is painless too. Replace the 3 php files and do an edit to your header.html template to make the title and description dynamic. FREEBS - Free Book Store
I was laying in bed thinking about this during my regular 4:00am insomnia period. How about changing the $keyword to an array and storing the $keyword corresponding to a returned book against the book record? You would need to do your amazon pull in a loop and add your own field to the returned records but the actual MySQL stuff would be the same. Then you could have widely varying <title> <h1> tags allowing to target a range of related KW...... Something to think about anyway. Mark
Yep, making $keyword an array for the pull would work. But, I would make a new array and use it instead. Leaving $keyword for a default on display. Then after getting a record from the DB use that keyword instead. A list of like 4 keywords would be good, making for about a half hours work for p3.php. I'm sure folks would test the limits of that list length. hehe We add a field to the items table called keyword and store it. No problem there. I'll think on it.
Well I got mind working pretty good. Great Script. Of course you can add my link to your list. Hell its your script.
I've just done a little breadcrumb mod for the individual book pages, just added this code to the header.html file: if (THIS_PAGE== 'book') { if (strcmp(strtolower(substr($name,0,3)),'the')==0) { $first_char=$name[4]; } else { $first_char=$name[0]; } echo '<B><a href="index.php">'.$keyword.' Book Store</a> > <a href="index.php?key='.$first_char.'">'.$keyword.' books beginning with '.strtoupper($first_char).'</a></B>'; } else { echo '<B><a href="index.php">'.$keyword.' Book Store</a></B>'; } ?> Code (markup): Mark
oh ok, sorry. Ummmm when you're on a book page it displays links back to the main index plus the index page for the first letter of the book you're looking at Like this: Foo Book Store > Books Beginning with Letter F
You can easily add the DigitalPoint Ad Network ads to your FREEBS - Free Book Store installation. Follow the simple instructions below. How to add the DigitalPoint Ad Network to FREEBS Thanks
I added the actual DB key to a variable to enhance your function. In the next version you can shorten your code to... <?php if (THIS_PAGE== 'book') { echo '<B><a href="index.php">'.$keyword.' Book Store</a> > <a href="index.php?key='.$bookkey.'">'.$keyword.' books beginning with '.strtoupper($bookkey).'</a></B>'; } else { if( THIS_PAGE == 'index' ) echo '<b>'.$keyword.' Book Store</b>'; else echo '<B><a href="index.php">'.$keyword.' Book Store</a></B>'; } ?> PHP: Thanks for the tip.