Changeset 42834

Timestamp:

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

Author:

eugene

Message:

add example to use PDO database access methods

Location:

trunk/ippMonitor

Files:

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

trunk/ippMonitor/INSTALL

@@ -39 +39 @@
 # $CZARPLOTDIR and $METRICSPLOTDIR will be generated as links in the same folder as ippMonitor  
 # the structure of the names for these two directories are defined in Makefile.in a
+
 # pltdir is for ippMetrics and czartool_plots hyperlinked from /export/ipp113.0/ipp/ in /var/www/localhost/htdocs/ippMonitor
 # pltdir in ipp117 is /var/www/localhost/htdocs/ippMonitor
 # ippMetrics -> /export/ipp113.0/ipp/ippMetrics/
 # czartool_plots -> /export/ipp113.0/ipp/czartool_plots/
-psconfigure --htdocs /var/www/localhost/htdocs --wwwbin /var/www/localhost/wwwbin --pltdir /var/www/localhost/htdocs/ippMonitor --site ~/ippconfig/ippmonitor.config 
+# --usePDO selects a modern PHP/mysql interface
+psconfigure --htdocs /var/www/localhost/htdocs --wwwbin /var/www/localhost/wwwbin --pltdir /var/www/localhost/htdocs/ippMonitor --site ~/ippconfig/ippmonitor.config --usePDO
+
+# note that modern php requires the use of PDO, the older MDB2 and DB mysql interfaces have been deprecated
 
 ## NOTES:

trunk/ippMonitor/Makefile.in

@@ -69 +69 @@
 $(DESTWWW)/ipp.czartool.dat \
 $(DESTWWW)/czartool_labels.php \
-$(DESTWWW)/czartool_labels_old.php \
 $(DESTWWW)/czartool_getplot.php \
 $(DESTWWW)/czartool_exposures.php \

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