--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/classes/basemodel.php	Tue Mar 17 10:54:13 2015 +0100
@@ -0,0 +1,124 @@
+<?php
+
+abstract class BaseModel {
+	
+    /*
+    protected $get_text_from_fileId_url = "http://localgazetteers-dev/LGServer/rest/text/getFileText?fileId=";
+    protected $get_text_from_sectionId_url = "http://localgazetteers-dev/LGServer/rest/text/getSectionText?sectionId=";
+    protected $save_to_LGService_url = "http://localgazetteers-dev/LGServer/rest/text/save";
+    protected $save_new_to_LGService_url = "http://localgazetteers-dev/LGServer/rest/text/saveNew";
+
+    */
+    protected $get_text_from_fileId_url, $get_text_from_sectionId_url, $save_to_LGService_url, $save_new_to_LGService_url;
+
+	public function __construct() {
+        global $mysql_database, $mysql_server, $mysql_user, $mysql_password, $systemNAME, $lgserver_url;
+        $this->systemNAME = $systemNAME;
+        
+        $this->get_text_from_fileId_url = $lgserver_url."rest/text/getFileText?fileId=";
+        $this->get_text_from_sectionId_url = $lgserver_url."rest/text/getSectionText?sectionId=";
+        $this->save_to_LGService_url = $lgserver_url."rest/text/save";
+        $this->save_new_to_LGService_url = $lgserver_url."rest/text/saveNew";
+        
+        set_time_limit(0);
+        ini_set('memory_limit', '-1');
+
+        $link_mysql = mysql_connect($mysql_server, $mysql_user, $mysql_password);
+        mysql_query("SET NAMES utf8");
+
+        if (!$link_mysql) {
+            die('Could not connect: ' . mysql_error());
+        }
+        $db_selected = mysql_select_db($mysql_database, $link_mysql);
+        if (!$db_selected) {
+
+            die ('Can\'t use foo : ' . mysql_error());
+        }
+        $this->topic = 2;   // set the default topic to product_name (物產)
+	}
+    
+    protected function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") {
+        $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
+
+        $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
+
+        switch ($theType) {
+            case "text":
+                $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
+                break;    
+            case "long":
+            case "int":
+                $theValue = ($theValue != "") ? intval($theValue) : "NULL";
+                break;
+            case "double":
+                $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
+                break;
+            case "date":
+                $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
+                break;
+            case "defined":
+                $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
+                break;
+        }
+        return $theValue;
+    }
+
+    protected function GetWordlist() {
+        $query = sprintf("SELECT * FROM `wordlist` WHERE `systemName`='%s' ORDER BY `name` ASC", $this->systemNAME);
+        $result = mysql_query($query);
+        if (!$result){
+            return json_encode("Failed during selecting wordlist table.");;
+        }
+        return $result;
+    }
+
+    protected function GetSectionsByID($section_id) {
+        $query = sprintf("SELECT * FROM `sections` WHERE `id`=\"%s\"", $section_id);
+        $result = mysql_query($query);
+        if (!$result){
+            echo json_encode("Failed during selecting sections table");
+            return;
+        }
+        return $result;
+    }
+
+    protected function GetTaglist() {
+        $query = sprintf("SELECT * FROM `taglist` WHERE `systemName`='%s' ORDER BY `tag` ASC", $this->systemNAME);
+        $result = mysql_query($query);
+        if (!$result) {
+            return json_encode("Failed during selecting taglist table.");
+        }
+        return $result;
+    }
+
+    protected function GetBooksByID($bookId) {
+        $query = sprintf("SELECT * FROM `books` WHERE id=\"%s\"", $bookId);
+        $result = mysql_query($query);
+        if (!$result) {
+            return json_encode("Failed during selecting books table.");
+        }
+        return $result;
+    }
+
+    protected function GetTopiclist() {
+        $query = sprintf("SELECT * FROM `topics`");
+        $result = mysql_query($query);
+        if (!$result) {
+            return json_encode("Failed during selecting topics table.");
+        }
+        return $result;
+    }
+
+    protected function GetTopicByID($topic_id) {
+        $query = sprintf("SELECT * FROM `topics` WHERE  id=\"%s\"", $topic_id);
+        $result = mysql_query($query);
+        if (!$result) {
+            return json_encode("Failed during selecting topics table.");
+        }
+        return $result;
+    }
+
+        
+}
+
+?>