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

Timestamp:

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

Author:

tbretz

Message:

Updated mysql calls.

File:

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

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

@@ -134 +134 @@
 // ================================================================
 
-$db = mysql_connect($dbhost,$dbuser,$dbpass);
-if (!$db)
-    die(mysql_error());
-
-if (!mysql_select_db($dbname, $db))
-    die(mysql_error());
+$db = new mysqli($dbhost,$dbuser,$dbpass);
+if ($db->connect_error)
+    die($db->connect_error);
+
+if (!$db->select_db($dbname))
+    die($db->error);
 
 $query = "SELECT * FROM MeasurementType";
 
-$sql = mysql_query($query);
+$sql = $db->query($query);
 if (!$sql)
-    die(mysql_error());
+    die($db->error);
 
 $measurements = array();
-while($row = mysql_fetch_assoc($sql))
+while($row = $db->fetch_assoc($sql))
     $measurements[$row['fMeasurementTypeKey']] = $row;
 
@@ -271 +271 @@
 
 foreach ($queries as $query)
-    if (!mysql_query($query))
-        die(mysql_error());
-
-mysql_close($db);
+    if (!$db->query($query))
+        die($sql->error);
+
+$db->close();
 
 ?>