弱小PHPerの憂鬱

    __  __     ____                               __    __
   / / / /__  / / /___       _      ______  _____/ /___/ /
  / /_/ / _ \/ / / __ \     | | /| / / __ \/ ___/ / __  / 
 / __  /  __/ / / /_/ /     | |/ |/ / /_/ / /  / / /_/ /  
/_/ /_/\___/_/_/\____( )    |__/|__/\____/_/  /_/\__,_/   
                     |/                                   
--------------------------------------------------------------------------------
    /\// ___   /\//  /\//  __   /\//  /\//
  _//\/_|_  |_//\/__//\/__/ _)_//\/__//\/_
 / __ `/ __// __ `/ __ `/ | |/ __ `/ __ `/
/ /_/ /____/ /_/ / /_/ / || / /_/ / /_/ / 
\__,_/     \__,_/\__,_/| |_/\__,_/\__,_/  
                      (__/               

    ___ @
   /   |@
  / /| |@
 / ___ |@
/_/  |_|@
        @@
    ____ @
   / __ )@
  / __  |@
 / /_/ / @
/_____/  @
         @@
   ______@
  / ____/@
 / /     @
/ /___   @
\____/   @
         @@

<?php
    #初期設定
    session_start();
    header("Content-type: text/html; charset=utf-8");
   
    #引数があれば認証チェック
    if(isset($_REQUEST) && is_array($_SESSION['images'])){
        $error=0;
        foreach($_SESSION['images'] as $key=>$val){
            if($val['flg']==0 && isset($_REQUEST[$key])){$error=1;break;}
            if($val['flg']==1 && empty($_REQUEST[$key])){$error=1;break;}
        }
        if($error==1){print("認証失敗\n");}else{print("認証成功\n");}
    }
   
    #猫クラス
    require_once('./catAuth.class.php');
    $cat = new catAuthModel();
   
    #オプション変更方法
    //$cat->setOptions(array('cat_ok'=>'2','cat_ng'=>'4'));
   
    #認証用画像取得
    $_SESSION['images']=$cat->makeCats();
   
    #表示
    print('<form method="POST" action="'.htmlspecialchars($_SERVER["PHP_SELF"]).'">');
        foreach($_SESSION['images'] as $key=>$val){
            print('<input type="checkbox" id="'.$key.'" name="'.$key.'" value="1">');
            print('<label for="'.$key.'"><img src="'.$val['filename'].'"></label>'."\n");
        }
    print('<input type="submit" value="送信">');
    print('</form>');

    print("<pre>");var_dump($_SESSION['images']);
?>

<!--[if IE]><script type="text/javascript">
    window.onload=function(){
        var lbs = document.getElementsByTagName('label');
        for(var i=0;i<lbs.length;i++){
            var cimgs = lbs[i].getElementsByTagName('img');
            for(var j=0;j<cimgs.length;j++){
                cimgs[j].formCtrlId = lbs[i].htmlFor;
                cimgs[j].onclick = function(){document.getElementById(this.formCtrlId).click()};
            }
        }
    }
</script><![endif]-->

<?php    
    #初期設定
    session_start();
    require_once('./captcha.class.php');
    $captcha = new pearCaptchaModel();    
    
    #表示文字列を設定
    $phrase[0]=rand(10,99);
    $phrase[1]='+';
    $phrase[2]=rand(10,99);
   
    $_SESSION['phrase']=$phrase[0]+$phrase[2];
    $phrase=$phrase[0].$phrase[1].$phrase[2];
   
    #オプション変更
    $captcha->setOptions(array('phrase'=>$phrase));
   
    #画像作成
    $cap['image']=$captcha->makeImage();
    $cap['phrase']=$captcha->getPhrase();
    $cap['filename']=$captcha->getImageFile();

    #表示
    print('<img src="'.$cap['filename'].'">');
    print("<pre>");var_dump($cap,$_SESSION);die();

<?php
    //初期設定
    define('PEAR_DIR',$_SERVER['DOCUMENT_ROOT'].'/src/php/pear/');
    ini_set('include_path',PEAR_DIR.PATH_SEPARATOR.ini_get('include_path'));
    require_once(PEAR_DIR.'Text_CAPTCHA/CAPTCHA.php');

    class pearCaptchaModel {
        //メンバ変数
        private $imageOptions = array();
       
        //コンストラクタ
        public function __construct(){
           
            //出力テキスト設定
            $imageOptions = array(
                'font_size'        => 24,
                'font_path'        => './',
                'font_file'        => 'COUR.TTF',
                'text_color'       => '#DDFF99',
            );
        $c = Text_CAPTCHA::factory('Image');
    }

<?php
    //初期設定
    define('IMAGE_DIR',getcwd().'/images/');
    define('PEAR_DIR',$_SERVER['DOCUMENT_ROOT'].'/src/php/pear/');
    ini_set('include_path',PEAR_DIR.PATH_SEPARATOR.ini_get('include_path'));
    require_once(PEAR_DIR.'Text/CAPTCHA.php');

    class pearCaptchaModel {
        //メンバ変数
        private $options = array();
        private $filename = '';
        private $c = '';
       
        //コンストラクタ
        public function __construct(){
            //前回の画像を削除
            $image_file=scandir(IMAGE_DIR);
            foreach($image_file as $val){
                if($val=='.' || $val=='..'){continue;}
                unlink(IMAGE_DIR.$val);
            }
            //デフォルトの出力テキスト設定
            $imageOptions = array(
                'font_size'        => 24,
                'font_path'        => './',
                'font_file'        => 'COUR.TTF',
                'text_color'       => '#DDFF99',
            );
            //デフォルトの出力画像設定
            $this->options = array(
                'width' => 200,
                'height' => 80,
                'output' => 'png',
                //'phrase' => 'aaaaa',
                'imageOptions' => $imageOptions
            );
        }
       
        //出力テキスト設定を上書きセット
        public function setImageOptions($imageOptions=array()){
            foreach($imageOptions as $key=>$val){
                $this->options['imageOptions'][$key]=$val;
            }
            return true;
        }
       
        //出力画像設定を上書きセット
        public function setOptions($options=array()){
            foreach($options as $key=>$val){
                $this->options[$key]=$val;
            }
            return true;
        }
       
        //イメージを作成
        public function makeImage(){
            $this->c = Text_CAPTCHA::factory('Image');
            $retval = $this->c->init($this->options);
            if (PEAR::isError($retval)) {
                printf('CAPTCHA 作成時にエラー: %s!',
                    $retval->getMessage());
                exit;
            }
            return true;
        }
       
        //作成したフレーズを取得
        public function getPhrase(){
            return $this->c->getPhrase();
        }
       
        //画像を取得
        public function getImageFile(){
            $image = $this->c->getCAPTCHA();
            if (PEAR::isError($image)) {
                echo 'CAPTCHA 作成時にエラー!';
                echo $image->getMessage();
                exit;
            }
            $this->filename=IMAGE_DIR.md5(session_id()).'.'.$this->options['output'];
            file_put_contents($this->filename,$image);
            return $this->filename;
        }
    #↓クラスのおわり
    }

<?php
    #初期設定
    session_start();
    require_once('./captcha.class.php');
    $captcha = new pearCaptchaModel();
    
    #オプション変更方法
    //$captcha->setOptions(array('output'=>'jpg'));
    //$captcha->setImageOptions(array('text_color'=>'#ff00ff'));
   
    #画像作成
    $cap['image']=$captcha->makeImage();
    $cap['phrase']=$captcha->getPhrase();
    $cap['filename']=$captcha->getImageFile();
   
    #セッションに入れる
    $_SESSION['phrase']=$cap['phrase'];

    #表示
    print('<img src="'.$cap['filename'].'">');
    print("<pre>");var_dump($cap);die();

<?php        
        #初期設定
        require_once('./rsslist.php');
        require_once('./rssreader.class.php');
        $rss = new pearMagpieRSSModel();
        $i=0;max=10;

        #引数チェック
        if(empty($_REQUEST['key']))            {die();}
        if(empty($rsslist[$_REQUEST['key']]))    {die();}
        $rsslist=$rsslist[$_REQUEST['key']];

        #RSS取得
        $ret=$rss->setUrl($rsslist);
        if(!$ret){die('rss->setUrl');}

        #チャンネル情報
        $channel=$rss->getRssChannel($rsslist);

        #内容
        $data=$rss->getAllItem($rsslist);
        //表示
        foreach($data as $key=>$val){
            if($i++>$max){die();}
            $val['summary']=mb_substr(strip_tags($val['summary']),0,500);
            print('<div class="title"><a href="'.htmlspecialchars($val['link']).'" target="_blank">'.htmlspecialchars($val['title']).'</a></div>');
            print('<div class="summary">'.htmlspecialchars($val['summary']).'</div>');
        }

<?php
    //初期設定
    define('PEAR_MAGPIERSS_DIR',$_SERVER['DOCUMENT_ROOT'].'/src/php/pear/MagpieRSS/');
    define('MAGPIE_OUTPUT_ENCODING', 'UTF-8');
    define('MAGPIE_CACHE_DIR',PEAR_MAGPIERSS_DIR.'cache/');
    define('MAGPIE_CACHE_AGE',3600);
    require_once(PEAR_MAGPIERSS_DIR.'rss_fetch.inc');

    class pearMagpieRSSModel {

        //メンバ変数
        private $rss_array=array();
        
        //コンストラクタ
        public function __construct(){}
        
        //RSS取得
        public function setUrl($rss){
            $this->rss_array[$rss['name']] = fetch_rss($rss['url']);

                if(isset($this->rss_array[$rss['name']]->channel['dc']['date'])){
                    $this->rss_array[$rss['name']]->channel['dc']['timestamp']=parse_w3cdtf($this->rss_array[$rss['name']]->channel['dc']['date']);
                }else{
                    $this->rss_array[$rss['name']]->channel['dc']['timestamp']='';
                }
            return true;
        }

        //RSS情報
        public function getRssChannel($rss){
            if($this->rss_array[$rss['name']]){
                return $this->rss_array[$rss['name']]->channel;
            }else{
                return false;
            }
        }
        
        //各記事の内容
        public function getAllItem($rss){
            if($this->rss_array[$rss['name']]){
                foreach($this->rss_array[$rss['name']]->items as $key=>$val){
                    $ret[$key]['title']            =$val['title'];
                    $ret[$key]['link']            =$val['link'];
                    $ret[$key]['summary']        =$val['summary'];
                    $ret[$key]['desc']            =$val['description'];
                    if(isset($val['date_timestamp'])){$ret[$key]['date_timestamp']=$val['date_timestamp'];}else{$ret[$key]['date_timestamp']='';}
                }
                return $ret;                
            }else{
                return false;
            }
        }

    #↓クラスのおわり
    }

<?php
    require_once('rsslist.php');
?>

<html xmlns="http://www.w3.org/1999/xhtml">

    <head>
    <META http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <META HTTP-EQUIV="Content-Style-Type" CONTENT="text/css">
    <title>RSS</title>
    <STYLE TYPE="text/css">
        <!--
        .title    {margin-bottom:5px;margin-top:10px;}
        .summary{width:90%;margin-left:10px;padding:5px;background-color:#faffff;border:1px solid;}
        -->
    </STYLE>
    <script type="text/javascript" src="./index.js"></script>
    </head>

    <body>
            <div id="rssSelect">
                <form name="rssSelectForm">
                    <select name="rssSelectOpt" id="rssSelectId" onChange="rssLoad();">
                        <option value="index">RSSを選択</option>
                        <?php
                            foreach($rsslist as $key=>$val){
                                if($key==0){continue;}
                                print('<option value="'.$key.'">'.$val['name'].'</option>');
                            }
                        ?>
                    </select>
                </form>
            </div>            
            <div id="rssPrint"></div>
    </body>
</html>

    //グローバル変数
    var xmlhttp;
    var oldquery;

    /*----------------------------------------------------------*/
    /* HTTPリクエスト作成関数 */
    function rssLoad(){        
        
        var rssSelectOpt=document.rssSelectForm.rssSelectOpt.value;
        var rssPrint=document.getElementById("rssPrint");

        //0番目なら終了
        if(rssSelectOpt=="index"){rssPrint.style.display = "none";return;}
        //既にXMLHttpRequestがあったら破棄
        if (xmlhttp){xmlhttp.abort();}

        xmlhttp = createXmlHttpRequest();

        //検索文字列が空なら何も出力しない
        if (rssSelectOpt==""){
            rssPrint.style.display = "none";

        //検索文字が更新されたら
        } else if (oldquery != rssSelectOpt) {
            //クエリを作成
            xmlhttp.open("GET", "rssreader.php?key="+rssSelectOpt, true);
            //クエリの返答が帰ってきたら表示を更新する無名関数
            xmlhttp.onreadystatechange = function() {
                //正しいレスポンスが来た
                if (xmlhttp.readyState == 4 && xmlhttp.status == 200) {
                    //返り値が入っていれば
                    if(xmlhttp.responseText){
                        rssPrint.style.display = "block";
                        rssPrint.innerHTML = xmlhttp.responseText;
                    //正しく終了していなければ
                    }else{
                        rssPrint.style.display = "block";
                        rssPrint.innerHTML = "ファイルが見つかりません"+xmlhttp.status;
                    }
                }
            }
                //クエリ送信
            xmlhttp.send(null);
        }
            //検索文字のチェック用
        oldquery = query;
    }

    /*==========================================================*/
    //サブルーチン

        /*----------------------------------------------------------*/
        /* HTTPリクエスト作成関数 */
        function createXmlHttpRequest() {
            var xmlhttp = false;
                if( window.XMLHttpRequest) {
                    xmlhttp = new XMLHttpRequest();
                } else if(window.ActiveXObject) {
                    try {
                        xmlhttp = new ActiveXObject("Msxml2.XMLHTTP");
                    } catch(e) {
                        xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
                    }
                }
            return xmlhttp;
        }

<?php

    //初期設定
    define('PEAR_MAGPIERSS_DIR',$_SERVER['DOCUMENT_ROOT'].'/src/php/pear/MagpieRSS/');
    define('MAGPIE_OUTPUT_ENCODING', 'UTF-8');
    define('MAGPIE_CACHE_DIR',PEAR_MAGPIERSS_DIR.'cache/');
    define('MAGPIE_CACHE_AGE',3600);

    require_once(PEAR_MAGPIERSS_DIR.'rss_fetch.inc');

class pearMagpieRSSModel {

    //メンバ変数
    private $rss_array=array();
    
    //コンストラクタ
    public function __construct(){}
   
    //RSS取得
    public function setUrl($rss){
        $this->rss_array[$rss['name']] = fetch_rss($rss['url']);
            if(isset($this->rss_array[$rss['name']]->channel['dc']['date'])){
                $this->rss_array[$rss['name']]->channel['dc']['timestamp']=parse_w3cdtf($this->rss_array[$rss['name']]->channel['dc']['date']);
            }else{
                $this->rss_array[$rss['name']]->channel['dc']['timestamp']='';
            }
        return true;
    }

    //RSS情報
    public function getRssChannel($rss){
        if($this->rss_array[$rss['name']]){
            return $this->rss_array[$rss['name']]->channel;
        }else{
            return false;
        }
    }
    
    //各記事の内容
    public function getAllItem($rss){
        if($this->rss_array[$rss['name']]){
            foreach($this->rss_array[$rss['name']]->items as $key=>$val){
                $ret[$key]['title']            =$val['title'];
                $ret[$key]['link']            =$val['link'];
                $ret[$key]['summary']        =$val['summary'];
                $ret[$key]['desc']            =$val['description'];
                if(isset($val['date_timestamp'])){$ret[$key]['date_timestamp']=$val['date_timestamp'];}
            }
            return $ret;            
        }else{
            return false;
        }
    }

#↓クラスのおわり
}

<?php

    #テスト用に固定値を与える
    $_REQUEST['key']=1;
    $rsslist[1]=array('name'=>'日経トレンディ','url'=>'http://trendy.nikkeibp.co.jp/rss/trendy.rdf');
    
    #初期設定
    //require_once('./rsslist.php');
    require_once('./rssreader.class.php');
    $rss = new pearMagpieRSSModel();

    #引数チェック
    if(empty($_REQUEST['key']))                {die();}
    if(empty($rsslist[$_REQUEST['key']]))    {die();}
    $rsslist=$rsslist[$_REQUEST['key']];

    #RSSをセット
    $ret=$rss->setUrl($rsslist);
    if(!$ret){die('rss->setUrl');}

    #チャンネル情報
    $channel=$rss->getRssChannel($rsslist);

    #内容
    $data=$rss->getAllItem($rsslist);

    #表示
    foreach($data as $key=>$val){
        print('<div class="title"><a href="'.$val['link'].'" target="_blank">'.$val['title'].'</a></div>');
        print('<div class="summary">'.$val['summary'].'</div>');
    }

<?php
    define('PEAR_MDB2_DIR',$_SERVER['DOCUMENT_ROOT'].'/src/php/pear/MDB2/');
    require_once(PEAR_MDB2_DIR.'MDB2.php');

    class pearMDB2Model {
        
        //メンバ変数
        protected $db_dsn = array(
            'phptype'  => 'mysqli',
            'username' => 'testuser',
            'password' => 'testpass',
            'hostspec' => 'localhost',
            'database' => 'testdb'
            );
        protected $db='';
        protected $res='';
        protected $sql_insert='';
        protected $sql_update='';
        protected $sql_select='';

        //コンストラクタ
        public function __construct(){
            //接続
                ini_set('include_path',PEAR_MDB2_DIR.PATH_SEPARATOR.ini_get('include_path'));
                $this->db= & MDB2::singleton($this->db_dsn,'charset=utf8');
                if (PEAR::isError($this->db)) {
                    die($this->db->getMessage());
                }
                $this->db->setFetchMode(MDB2_FETCHMODE_ASSOC);
                $this->db->query('SET NAMES UTF8');          

            //insert文の用意
                $sql_insert =' INSERT INTO books ';
                $sql_insert.=' (name,author,publisher,price,isbn,date,comment,created_at) ';
                $sql_insert.=' values ';
                $sql_insert.=' ( :name , :author , :publisher , :price , :isbn , :date , :comment , now() )';
                $this->sql_insert=$this->db->prepare($sql_insert);
                
            //update文の用意
                $sql_update ='UPDATE books SET ';
                $sql_update.='  name= :name ';
                $sql_update.=', author= :author ';
                $sql_update.=', publisher= :publisher ';
                $sql_update.=', price= :price ';
                $sql_update.=', isbn= :isbn ';
                $sql_update.=', date= :date ';
                $sql_update.=', comment=:comment ';
                $sql_update.=', updated_at=now() ';
                $sql_update.=' where id= :id ';
                $this->sql_update=$this->db->prepare($sql_update);
                
            //select文の用意
                $sql_select =' SELECT * FROM books ';
                $sql_select.=' WHERE ';
                $sql_select.=' name LIKE :name ';
                $sql_select.='and author LIKE :author ';
                $sql_select.='and publisher LIKE :publisher ';
                $sql_select.='and price LIKE :price ';
                $sql_select.='and isbn LIKE :isbn ';
                $sql_select.='and date LIKE :date ';
                $sql_select.='and comment LIKE :comment ';
                $this->sql_select=$this->db->prepare($sql_select);
        }

        //インサート
        public function insert_prepare($sql_array){
            $res=$this->sql_insert->execute($sql_array);
            if (PEAR::isError($this->res)){
                return false;
            }else{
                return $this->db->lastInsertId();
            }
        }

        //セレクト
        public function select_prepare($sql_array){
            if(isset($sql_array['name']))        {$sql_array['name']='%'.$sql_array['name'].'%';                }else{$sql_array['name']='%%';}
            if(isset($sql_array['author']))        {$sql_array['author']='%'.$sql_array['author'].'%';            }else{$sql_array['author']='%%';}
            if(isset($sql_array['publisher']))    {$sql_array['publisher']='%'.$sql_array['publisher'].'%';    }else{$sql_array['publisher']='%%';}
            if(isset($sql_array['price']))        {$sql_array['price']='%'.$sql_array['price'].'%';            }else{$sql_array['price']='%%';}
            if(isset($sql_array['isbn']))        {$sql_array['isbn']='%'.$sql_array['isbn'].'%';                }else{$sql_array['isbn']='%%';}
            if(isset($sql_array['comment']))    {$sql_array['comment']='%'.$sql_array['comment'].'%';        }else{$sql_array['comment']='%%';}

            $res=$this->sql_select->execute($sql_array);
            $res=$res->fetchAll();
            if (PEAR::isError($this->res)){
                return false;
            }else{
                return $res;
            }
        }

        //アップデート
        public function update_prepare($id,$sql_array){
            $sql_array['id']=$id;
            $res=$this->sql_update->execute($sql_array);
            if (PEAR::isError($this->res)){
                return false;
            }else{
                return $this->db->lastInsertId();
            }
        }       

        //プリペアードステートメント使わないセレクト
        public function select($sql_array){
            $sql =' select * from books ';
            $sql.=' where deleted_at is null ';
            foreach($sql_array as $key=>$val){
                $sql.=" and ".$key." like ".$this->db->quote('%'.$val.'%','text');
            }
            $res=$this->db->query($sql);
            $res=$res->fetchAll();
            if (PEAR::isError($this->res)){
                return false;
            }else{
                return $res;
            }
        }

        //プリペアードステートメント使わないアップデート
        public function update($id,$sql_array){
            $sql =' update books set update_date=now(), ';
            foreach($sql_array as $key=>$val){
                $sql.=$key."=".$this->db->quote($val,'text')." , ";
            }
            $sql.=' where id='.$this->db->quote($id,'text');            
            $res=$this->db->query($sql);
            $res=$res->fetchAll();
            if (PEAR::isError($this->res)){
                return false;
            }else{
                return $res;
            }
        }

#↓クラスのおわり
}

<?php
    require_once('./peardb.class.php');
    $db = new pearMDB2Model();

    $ins_array['name']            ='恋空〈上〉';
    $ins_array['author']        ='美嘉';
    $ins_array['publisher']        ='スターツ出版';
    $ins_array['price']            ='1050';
    $ins_array['isbn']            ='978-4883810451';
    $ins_array['date']            ='2006-10-01';
    $ins_array['comment']        ='スイーツ(笑)';
    
    $ret1=$db->insert_prepare($ins_array);
    $ret2=$db->select_prepare($ins_array);
    print("<pre>");var_dump($ret1,$ret2);

<?php

    define('PEAR_MDB2_DIR',$_SERVER['DOCUMENT_ROOT'].'/src/php/pear/MDB2/');
    require_once(PEAR_MDB2_DIR.'MDB2.php');

    class pearMDB2Model {
        //メンバ変数
        protected $db_dsn = array(
            'phptype'  => 'mysqli',
            'username' => 'testuser',
            'password' => 'testpass',
            'hostspec' => 'localhost',
            'database' => 'testdb'
        );
        protected $db='';
        protected $res='';

        //接続
        public function __construct(){
            $this->db=MDB2::singleton($this->db_dsn);
            if (PEAR::isError($this->db)) {
                die($this->db->getMessage());
            }
            $this->db->query('SET NAMES UTF8');
            $this->db->setFetchMode(MDB2_FETCHMODE_ASSOC);
        }

        //インサート
        public function insert($name,$author,$publisher,$price,$comment,$isbn,$date){
            $sql =' INSERT INTO books ';
            $sql.=' (name,author,publisher,price,isbn,date,comment,created_at) ';
            $sql.=' values ';
            $sql.=' ( ';
            $sql.=$this->db->quote($name,'text');
            $sql.=' ,'.$this->db->quote($author,'text');
            $sql.=' ,'.$this->db->quote($publisher,'text');
            $sql.=' ,'.$this->db->quote($price,'integer');
            $sql.=' ,'.$this->db->quote($isbn,'text');
            $sql.=' ,'.$this->db->quote($date,'text');
            $sql.=' ,'.$this->db->quote($comment,'text');
            $sql.=' ,now() ';
            $sql.=' )';

            $this->res=$this->db->exec($sql);
            if (PEAR::isError($this->res) || $this->res==0){
                return false;
            }else{
                return true;
            }
        }

    //読み取り
        public function getAllBooks(){
            $sql =' select * from books ';
            $sql.=' where deleted_at is null ';

            $ret=$this->db->query($sql);
            $ret=$ret->fetchAll();

            if (PEAR::isError($ret)){
                return false;
            }else{
                return $ret;
            }
        }
    

    #↓クラスのおわり
    }

<?php
    require_once('./peardb.class.php');
    $db = new pearMDB2Model();

    $name='恋空〈上〉';
    $author='美嘉';
    $publisher='スターツ出版';
    $price='1050';
    $isbn='978-4883810451';
    $date='2006/10/01';
    $comment='スイーツ(笑)';
    
    $db->insert($name,$author,$publisher,$price,$comment,$isbn,$date);

    $a=$db->getAllBooks();
    print("<pre>");var_dump($a);

      public function __construct($file_name){

            $file_name=dirname(__FILE__)."/".$file_name;

            $tmp=file($file_name,FILE_SKIP_EMPTY_LINES);
            
            if($tmp===false){
                  return false;
            }
            
            foreach($tmp as $tmp_loop){
                  $tmp_ex=explode("\t",$tmp_loop);
                  $tmp_array[$tmp_ex[0]]=trim($tmp_ex[1]);
            }

            $this->file_name=$file_name;
            $this->contents=$tmp_array;
            return true;
      }