Simple book database

Barrucadu · 12-26-2008, 03:25 PM

I made a database to keep track of all my books earlier this week (features/screenshots here), and thought I'd give it away in case anyone wants something similar.
I haven't tested it on anything other than Apache 2.2.11, PHP 5.2.7, MySQL 5.0.68, and Opera 9.63 - so if you use anything else, use it at your own risk. I didn't pay any attention to security when making it, so it's not really appropriate for anything else than running on your own computer.

Download

The SQL to set up the database is located in database.php, where you also need to enter the database details. Note: cover images must have the same name as the book (sans any '?', '!', ''', ':', '\', or '/') and be located in a folder relative to book.php called ./covers/ and be .jpg files (I included a blank folder for you).

Daniel · 12-26-2008, 03:35 PM

Neat!

Perhaps add ISBN Lookup support? Would be useful and fairly easy.

Barrucadu · 12-26-2008, 03:49 PM

Done! The zip file has been updated. Now click the [+] next to the ISBN number to be taken to the isbndb.com page (if it exists).

Barrucadu · 12-28-2008, 05:14 AM

I've updated the script:

ISBN numbers are now separated by hyphens, not spaces. When entering them you can use either hyphens or spaces.
The blurb now has a "" before and a "" after.
There is now bbcode-like replacement of certain characters in the blurb:
- " - " becomes " — "
- "\r\n\r\n" becomes ""
- "\r\n" becomes " "
- "..." becomes "…"
- "[ i]" becomes ""
- "[ /i]" becomes ""
- "[ b]" becomes ""
- "[ /b]" becomes ""
- "[ u]" becomes ""
- "[ /u]" becomes ""

????: NamePros.com http://www.namepros.com/code/545743-simple-book-database.html
Note: There are no spaces in the bbcode tags, I just had to put them there to stop VB parsing them.

12-26-2008, 03:25 PM	THREAD STARTER #1 (permalink)
Barrucadu Senior Member Join Date: Aug 2005 Location: East Yorkshire, England Posts: 2,689 Follow @barrucadu	Simple book database I made a database to keep track of all my books earlier this week (features/screenshots here), and thought I'd give it away in case anyone wants something similar. I haven't tested it on anything other than Apache 2.2.11, PHP 5.2.7, MySQL 5.0.68, and Opera 9.63 - so if you use anything else, use it at your own risk. I didn't pay any attention to security when making it, so it's not really appropriate for anything else than running on your own computer. Download The SQL to set up the database is located in database.php, where you also need to enter the database details. Note: cover images must have the same name as the book (sans any '?', '!', ''', ':', '\', or '/') and be located in a folder relative to book.php called ./covers/ and be .jpg files (I included a blank folder for you). __________________ Website \| Blog Arch Hurd developer; GNU Webmaster; FSF member #8385

12-26-2008, 03:35 PM	#2 (permalink)
Daniel Danltn.com Join Date: May 2007 Location: Danltn.com / Nottingham, UK Posts: 1,201	Neat! Perhaps add ISBN Lookup support? Would be useful and fairly easy. __________________ :lala: *VERY CHEAP ADVANCED* BULK DOMAIN-STATISTICS LOOKUP** :kickass: Danltn's Blog - Daniel Neville's Site Spoof your links! Submit your blog NOW! Putting bloggers on the map!

12-26-2008, 03:49 PM	THREAD STARTER #3 (permalink)
Barrucadu Senior Member Join Date: Aug 2005 Location: East Yorkshire, England Posts: 2,689 Follow @barrucadu	Done! The zip file has been updated. Now click the [+] next to the ISBN number to be taken to the isbndb.com page (if it exists). __________________ Website \| Blog Arch Hurd developer; GNU Webmaster; FSF member #8385

12-28-2008, 05:14 AM	THREAD STARTER #4 (permalink)
Barrucadu Senior Member Join Date: Aug 2005 Location: East Yorkshire, England Posts: 2,689 Follow @barrucadu	I've updated the script: ISBN numbers are now separated by hyphens, not spaces. When entering them you can use either hyphens or spaces. The blurb now has a "<p>" before and a "</p>" after. There is now bbcode-like replacement of certain characters in the blurb: " - " becomes " — " "\r\n\r\n" becomes "</p><p>" "\r\n" becomes "<br/>" "..." becomes "…" "[ i]" becomes "<em>" "[ /i]" becomes "</em>" "[ b]" becomes "<strong>" "[ /b]" becomes "</strong>" "[ u]" becomes "<span style="text-decoration:underline;">" "[ /u]" becomes "</span>" ????: NamePros.com http://www.namepros.com/code/545743-simple-book-database.html Note: There are no spaces in the bbcode tags, I just had to put them there to stop VB parsing them. __________________ Website \| Blog Arch Hurd developer; GNU Webmaster; FSF member #8385 Last edited by Barrucadu; 12-28-2008 at 05:20 AM.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)