FREEBS Feature and Functionality Suggestions

[Greg]

Originally Posted by rocket98

Hi,

I just installed your script... works great.

? On the initial results page how can I display a image beside book listings. Right now only images I see are on a further detail page and for similiar items. These image URL's are already stored in DB [yes/no] so it could be added?


Works great

Thanks.

The images are URLS, they are not stored. We were trying to keep the outbound links down I think.

[onewhosellsbooks]

Know FREEBS doesn't have this capability, but thought you may know of a php script/way to do it..
Want to list our Amazon marketplace books via our website, where they are searchable, with data pulled from Amazon, and our inventory adjusted automatically as books are sold directly on Amazon. In other words, not maintained by a local database but through AWS or a data feed. Amazon Hacks book had an asp example, but I don't use asp. You would think this would be a common need, but have had hard time finding a way to do it.

[Greg]

It's in the API to search. I have alot on my plate, but an aws search is a necessity and I'll make that my next project.

The database is meerly to have pages of on topic titles. An SEO thing.

[reDDevil]

I think it is a good suggestion to create a "book alphabetic index" automatically according the "bkeys" of items added to a database to prevent empty pages without any book. Or is it easy to make it myself? Sorry for probably stupid question - I am a novice with php

[Greg]

Originally Posted by reDDevil

I think it is a good suggestion to create a "book alphabetic index" automatically according the "bkeys" of items added to a database to prevent empty pages without any book. Or is it easy to make it myself? Sorry for probably stupid question - I am a novice with php

Maybe I don't understand, but the main page is an alpha index. Can you be more specific?

[minstrel]

Hi, noppid. I finally got around to settting this up (Amazon.ca version complete with changes to the Amazon image and search code) at [url]http://store.psychlinks.ca[/url] - I see a few people have asked about a search feature. What I want is the capability not to search Amazon but to search the "local" bookstore - i.e., just the titles listed in my database.

I suck at SQL queries. How difficult would that be to implement?

[Greg]

Originally Posted by minstrel

Hi, noppid. I finally got around to settting this up (Amazon.ca version complete with changes to the Amazon image and search code) at http://store.psychlinks.ca - I see a few people have asked about a search feature. What I want is the capability not to search Amazon but to search the "local" bookstore - i.e., just the titles listed in my database.

I suck at SQL queries. How difficult would that be to implement?

I'll research what it will take to index the title so the query is not a cpu killer or table walking.

[minstrel]

Thanks, noppid

[Greg]

Ok, in the items table, if there is an index on the field 'name', drop it.

Add a Full Text index to the field 'name' in the items table.

You can use phpmyadmin to do this.

Then this query will do your search. Of course this is just the basics. We need an input form, input sanitation, input lenght verification and probably some other stuff I forgot.

And here's the Query.

PHP Code:

// begin full text
// get the titles
$searchWord = 'whacko';
$searchs = mysql_query("SELECT asin,name 
        FROM ". TABLE_PREFIX ."items 
        WHERE match(name) against('addslashes($searchWord)')");
echo mysql_error();    

echo '<pre>';

while( $search = mysql_fetch_Array($searchs) )
{
    print_r($search);
}
echo '</pre>';
exit; 


Then using the title and asin you can link to book.php or isbnxxxxxxxxxx.html on your site to display the book.

[minstrel]

Thanks, noppid - I'll give it a try when I've had some sleep