Changeset 20052 for trunk/FACT++/www/schedule/load.php

Timestamp:

03/24/21 22:28:33 (4 years ago)

Author:

tbretz

Message:

Updated mysql calls.

File:

• trunk/FACT++/www/schedule/load.php (modified) (2 diffs)

trunk/FACT++/www/schedule/load.php

@@ -9 +9 @@
 // ================================================================
 
-function query($query)
+function query($sql, $query)
 {
-   $sql = mysql_query($query);
+   $sql = $sql->query($query);
    if (!$sql)
-        die(mysql_error());
+        die($sql->error);
 
    $rows = array();
-   while($row = mysql_fetch_assoc($sql))
+   while($row = $sql->fetch_assoc())
       $rows[] = $row;
 
@@ -43 +43 @@
 require_once 'config.php';
 
-$db = mysql_connect($dbhost,$dbuser,$dbpass);
-if (!$db)
-   die(mysql_error());
+$sql = new mysqli($dbhost, $dbuser, $dbpass);
 
-if (!mysql_select_db($dbname, $db))
-   die(mysql_error());
+if ($sql->connect_error)
+    die($sql->connect_error);
+
+if (!$sql->select_db($dbname))
+    die($sql->error);
 
 /*mixed date_sunrise ( int $timestamp [, int $format = SUNFUNCS_RET_STRING [, float $latitude = ini_get("date.default_latitude") [, float $longitude = ini_get("date.default_longitude") [, float $zenith = ini_get("date.sunrise_zenith") [, float $gmt_offset = 0 ]]]]] )*/
 
-query("SELECT DISTINCT(DATE(ADDTIME(fStart, '-12:00'))) AS 'd' FROM Schedule");
-query("SELECT fSourceKEY AS 'key', fSourceName AS 'val' FROM Source WHERE fSourceTypeKEY=1");
-query("SELECT fMeasurementTypeKEY AS 'key', fMeasurementTypeName AS 'val' FROM MeasurementType");
-query("SELECT * FROM Schedule WHERE DATE(ADDTIME(fStart, '-12:00:00')) = '".$_POST['n']."'".$cut."ORDER BY fStart ASC, fMeasurementID ASC");
+query($sql, "SELECT DISTINCT(DATE(ADDTIME(fStart, '-12:00'))) AS 'd' FROM Schedule");
+query($sql, "SELECT fSourceKEY AS 'key', fSourceName AS 'val' FROM Source WHERE fSourceTypeKEY=1");
+query($sql, "SELECT fMeasurementTypeKEY AS 'key', fMeasurementTypeName AS 'val' FROM MeasurementType");
+query($sql, "SELECT * FROM Schedule WHERE DATE(ADDTIME(fStart, '-12:00:00')) = '".$_POST['n']."'".$cut."ORDER BY fStart ASC, fMeasurementID ASC");
 
 //sleep(3);