By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,813 Members | 2,269 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,813 IT Pros & Developers. It's quick & easy.

Search engine for books

P: 1
I have zero programming skills so I am posting this question so that some one helps me through this.
I have some books in my PC, numbering about 5 to 7 thousand. I intend to download more. Now I want to create a program that can allow me to first tag my books with tags, and then allows me to search through my files using those tags.
For example.
I would like to tag "Catcher in the Rye" with tags,"coming of age" , "murder", "lost childhood", "books which inspired crimes".
And Then I would like that program to 1) allow me to browse through all the tags I have created and 2) Allow me to search for Catcher in the Rye with using the tag "murder". I.E I type murder in my box and it spills out the books which are tagged with murder.
Oct 4 '14 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 1,035
Create tables like:
Expand|Select|Wrap|Line Numbers
  1. CREATE TABLE `books` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `title` varchar(200) DEFAULT NULL,
  4.   PRIMARY KEY (`id`)
Expand|Select|Wrap|Line Numbers
  1. CREATE TABLE `tags` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `description` varchar(200) DEFAULT NULL,
  4.   PRIMARY KEY (`id`)
Expand|Select|Wrap|Line Numbers
  1. CREATE TABLE `booktags` (
  2.   `book_id` int(11) DEFAULT NULL,
  3.   `tag_id` int(11) DEFAULT NULL,
  4.   UNIQUE KEY `book_id` (`book_id`,`tag_id`)
and start coding.....

oops, "I have zero programming skills" .....
Oct 4 '14 #2

Post your reply

Sign in to post your reply or Sign up for a free account.