OpenBiblio

OpenBiblio是開放原始碼的圖書管理系統。

OpenBiblio

v.0.6.0

install instruction

• Check the requirement: PHP 4.2+ & MySQL 4.0.12+
• Setup the MySQL: {openbiblio}/database_constants.php

more on OpenBiblio Install Instructions

• run the http://localhost/openbiblio/install/index.php

localization

• copy the {openbiblio}/locale/en to {openbiblio}/locale/en_utf
• modify the {openbiblio}/locale/en_utf8/metadata.php

   "locale_description" => "English_utf8" 

image host on flickr

Setup the library

• Click the admin label
• login the default admin account
• click the library settings
  • Locale: switch to English_utf8
  • HTML Charset: modify iso-8859-1 to utf-8
• click the Update button

When create DB (for MySQL5)

SQL:

 create database openbiblio CHARACTER SET utf8 COLLATE utf8_general_ci;

Modify PHP source

openbiblio\Query.php

add line: $rc = Query::act( 'SET NAMES UTF8' ); so that all connection will be UTF8

 function connect_e() {
   list($this->_link, $e) = Query::_connect_e();   
   $rc = Query::act( 'SET NAMES UTF8' );
   return $e;
 }

Validation

• click the Cataloging label -> New Bibliography
• add a new Bibliography in Chinese
• & search Bibliography Search in Chinese
• Check MySQL DB table biblio, to see if the string store in Chinese. You can use freeware Toad for MySQL to do it.
• Try again in Simplified Chinese

Reference

• OpenBiblio | Main / TranslatingOpenBiblio browse