view models/home.php @ 51:840cdb52f476 extractapp

add book_meta into file
author Zoe Hong <zhong@mpiwg-berlin.mpg.de>
date Thu, 26 Mar 2015 15:42:50 +0100
parents 886f43b26ee2
children 97c1e5102a22
line wrap: on
line source

<?php

class HomeModel {
	public function Index() {
		return array("Index Value 1", "Value 2", "Value 3");
	}
    
    public function Test() {

    	
        return;
    }
    public function MergeBooksInfoToBooks() {
        /* uncomment to do the merge
        // merge books table with books_info table
        $query = "SELECT books_info.volume, books_info.author, books_info.edition, books_info.books_id FROM books INNER JOIN books_info ON books.id=books_info.books_id";
        
        $result = mysql_query($query);
        if (!$result) {
            return json_encode("Failed during selecting books, books_info table.");
        }
        $query = "ALTER TABLE books_v1 ADD Column volume VARCHAR(50), ADD Column author VARCHAR(100), ADD Column edition VARCHAR(100);"
        $result_alter = mysql_query($query);

        while ($row = mysql_fetch_assoc($result)) {
            // insert row into books_v1 table
            echo $row['volume'].$row['author'].$row['edition'].$row['books_id'];
            
            $query_update = "UPDATE books_v1 SET `volume`='".$row['volume']."', `author`='".$row['author']."',`edition`='".$row['edition']."' WHERE `id`='".$row['books_id']."'";
                      
            $result_update= mysql_query($query_update);
            if (!$result_update) {
                echo json_encode("error");

            }
        }
        */
        return;

    }
    
}



?>