comparison models/home.php @ 77:97c1e5102a22 extractapp

New: export table for a file from LGService
author Zoe Hong <zhong@mpiwg-berlin.mpg.de>
date Thu, 16 Apr 2015 14:53:22 +0200
parents 840cdb52f476
children f1f849d31272
comparison
equal deleted inserted replaced
76:c49192885290 77:97c1e5102a22
1 <?php 1 <?php
2 2
3 class HomeModel { 3 class HomeModel {
4 public function Index() {
5 return array("Index Value 1", "Value 2", "Value 3");
6 }
7 4
8 public function Test() {
9
10
11 return;
12 }
13 public function MergeBooksInfoToBooks() { 5 public function MergeBooksInfoToBooks() {
6 /**
7 * This function is used to update book table in database.
8 * It merged some fields in books_info table into books table, but it has not been used now.
9 */
10
14 /* uncomment to do the merge 11 /* uncomment to do the merge
15 // merge books table with books_info table 12 // merge books table with books_info table
16 $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"; 13 $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";
17 14
18 $result = mysql_query($query); 15 $result = mysql_query($query);