Changeset 70 for oceandb/jQuery_Prototype/data/get_data.php

Timestamp:

Mar 5, 2009, 4:09:03 PM (15 years ago)

Author:

jazz

Message:

• get_data.php
  • 加入 website 資訊
• 加入開啟 InforWindow? 視窗的程式

File:

• oceandb/jQuery_Prototype/data/get_data.php (modified) (2 diffs)

oceandb/jQuery_Prototype/data/get_data.php

@@ -1 +1 @@
 <?
   require_once('../db-config/connect-mysql.php');
-  $query = "SELECT data_type.serial AS type_id, maincase_new.owner_org, maincase_new.loc1_lon, maincase_new.loc1_lat FROM data_type, maincase_new, maincase_detail WHERE maincase_detail.maincase_id = maincase_new.serial AND maincase_detail.type_id = data_type.serial AND type_id =" . $_GET['type_id'] . " AND owner_org = '" . $_GET['owner_org'] . "' ORDER BY loc1_lon, loc1_lat";
+  $query = "SELECT data_type.serial AS type_id, maincase_new.owner_org, maincase_new.loc1_lon, maincase_new.loc1_lat, maincase_new.description, maincase_new.website FROM data_type, maincase_new, maincase_detail WHERE maincase_detail.maincase_id = maincase_new.serial AND maincase_detail.type_id = data_type.serial AND type_id =" . $_GET['type_id'] . " AND owner_org = '" . $_GET['owner_org'] . "' ORDER BY loc1_lon, loc1_lat";
   if ($database_connect) mysql_select_db($database_connect) or die('USE '.$database_connect.' failed!');
   $result = mysql_query($query) or die("Query failed! $query");
@@ -11 +11 @@
     {
       $col= mysql_fetch_row($result);
-      echo "{ \"type_id\" : " . $col[0] . ", \"owner_org\" : \"" . $col[1] . "\", \"loc1_lon\" : \"" . $col[2] . "\", \"loc1_lat\" : \"" . $col[3] . "\"},\n";
+      echo "{ \"type_id\" : " . $col[0] . ", \"owner_org\" : \"" . $col[1] . "\", \"loc1_lon\" : \"" . $col[2] . "\", \"loc1_lat\" : \"" . $col[3] . "\", \"description\" : \"" . $col[4] . "\", \"website\" : \"" . $col[5] . "\"},\n";
     }
     echo "]";