false, // turn off emulation mode for "real" prepared statements PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, //turn on errors in the form of exceptions PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC, //make the default fetch be an associative array ]; try { $pdo = new PDO($dsn, "$dbLogin", "$dbPasswd", $options); } catch (Exception $e) { error_log($e->getMessage()); //In production if ($debug) echo "ERROR: " . $e->getMessage().PHP_EOL; echo "ERROR: " . $e->getMessage().PHP_EOL; exit('ERROR: Something weird happened'); //something a user can understand } #mySqlTest($sqlCmd,$pdo,$title) ; function mySqlTest($sqlCmd,$pdo,$title) { echo "TEST CONNECTION: "; $sqlCmd="select fidId, fidTot, fidCurdate from fidelity limit 5"; $title="test connection"; showDataTable($sqlCmd,$pdo,$title) ; } function showDataTable($sqlCmd,$pdo,$title,$tblName = "dataTable1", $actionTitle = "") { try { $stmt = $pdo->prepare($sqlCmd); $stmt->execute(); // Fetch all rows into an array $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); $columnNames = array_keys($rows[0]); echo '
'; echo "sqlCmd = $sqlCmd"; echo '
'; echo '
'; $idNum=$idNum+1; echo '
'. $title. '
'; // Print table header echo '
'; echo ''; echo ''; $row=0; $col=1 foreach ($columnNames as $columnName) { echo ''; } // Print data rows echo ''; foreach ($rows as $row) { $row++; $column=1; echo ''; foreach ($row as $value) { $id="R".$row."C"$col++; if (is_numeric($value) && $value < 9000) { echo ''; } elseif (is_numeric($value) ) { echo ''; } elseif (is_string($value)) { echo ''; } else { echo ''; } } echo ''; } echo ''; echo '
' . $columnName . '
' . $value . ''; } elseif (strtotime($value) > strtotime(0)) { echo '' . $value . '' . $value . 'default:' . $value . '
'; echo '
'; //print_r($rows); $jRow = json_encode($row); //echo "
Here for jRow
"; //print_r($jRow); // Store column names in an array $columnNames = $row[0]; $colNum = sizeOf($row[0]); #echo NL."colNum=$colNum".NL; for ($i=0; $i < $colNum; $i++ ){ echo "$row[0][$i]"; } #echo "end of heading"; #exit; ?> ' . $title. ''; echo ''; echo ''; foreach ($stmt->fetch(PDO::FETCH_ASSOC) as $columnName => $value) { echo ''; } echo ''; while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { echo ''; foreach ($row as $value) { echo ''; } echo ''; } echo '
' . htmlspecialchars($columnName) . '
' . htmlspecialchars($value) . '
'; $dsn = null; //Close Database } catch (PDOException $e) { echo "Error: " . $e->getMessage(); } } function isDate($value) { if (strtotime($value) !== false) { return true; } else { return false; } } ?>