Changeset 42834 for trunk/ippMonitor/raw/ipp.php

Timestamp:

May 9, 2025, 9:11:12 AM (14 months ago)

Author:

eugene

Message:

add example to use PDO database access methods

Location:

trunk/ippMonitor

Files:

• . (modified) (1 prop)
• raw/ipp.php (modified) (1 diff)

trunk/ippMonitor/raw/ipp.php

@@ -100 +100 @@
   // define the DSN strings. NOTE: PDO uses a different format from DB or MDB2
   if ($database == $CZARDBNAME) {
-    $dsn_pdo = "mysql:host=$DBHOST;dbname=$database";
+    $dsn_pdo = "mysql:host=$CZARDBHOST;dbname=$database"; // note this is case sensitive
     $dsn = "mysql://$DBUSER:$DBPASS@$CZARDBHOST/$database";
     $dsnerr = "mysql://$DBUSER:XXX@$CZARDBHOST/$database"; // only used to report the error
   } else {
-    $dsn_pdo = "mysql:host=$CZARDBHOST;dbname=$database"; // note this is case sensitive
+    $dsn_pdo = "mysql:host=$DBHOST;dbname=$database";
     $dsn = "mysql://$DBUSER:$DBPASS@$DBHOST/$database";
     $dsnerr = "mysql://$DBUSER:XXX@$DBHOST/$database"; // only used to report the error