Changeset 14783 for trunk/FACT++/www/smartfact/index.php

Timestamp:

01/21/13 12:25:38 (12 years ago)

Author:

tbretz

Message:

Added an option which allows to retrieve a complete list of all sources from the db.

File:

• trunk/FACT++/www/smartfact/index.php (modified) (1 diff)

trunk/FACT++/www/smartfact/index.php

@@ -108 +108 @@
 }
 
+if (isset($_GET['sourcelist']))
+{
+    $server = mysql_connect($dbhost, $dbuser, $dbpass);
+    if (!$server)
+        die(mysql_error());
+
+    if (!mysql_select_db($dbname, $server))
+        die(mysql_error());
+
+    $result = mysql_query("SELECT fSourceName AS name FROM source", $server);
+    if (!$result)
+        die(mysql_error());
+
+
+//    var res = db.query("SELECT fSourceName, fRightAscension, fDeclination ",
+//              "FROM source");
+
+   // store the record of the "example" table into $row
+
+    // Print out the contents of the entry
+
+    while ($row=mysql_fetch_array($result, MYSQL_NUM))
+        print("'".$row[0]."'\n");
+
+    mysql_close($server);
+
+    return;
+
+}
+
 if (isset($_GET['logout']))
 {