'; $MyPmWiki_Username = ''; $MyPmWiki_Password = ''; $MyPmWiki_DBName = ''; $MyPmWiki_TableFmt = ''; include_once('cookbook/mypmwiki.php'); to a local customization file. This script is based on ideas by JamesDavis, but has been rewritten to work wiht PmWiki v2. Version 0.2 change Markup vom _begin to inline Version 2019-01-26 (Siegfried Seibert) update for PHP 7.2 compatibility */ $RecipeInfo['MyPmWiki']['Version'] = '2019-01-26'; if($GLOBALS['VersionNum'] < 2002056) { # we want the cookbook to also work with older PmWiki versions Markup('MyPmWiki','inline','/\(:MyPmWiki *(.+):\)/e',"MyPmWiki('\$1')"); } else { Markup('MyPmWiki','inline','/\(:MyPmWiki *(.+):\)/',"MarkupMyPmWiki"); } function MarkupMyPmWiki($m) { return MyPmWiki($m[1]); } function MyPmWiki($SQL) { global $MyPmWiki_Hostname, $MyPmWiki_Username, $MyPmWiki_Password, $MyPmWiki_DBName, $MyPmWiki_TableFmt; global $action; global $FarmD; $ExtraErrMsg = "Please contact the administrator of this wiki."; if (!isset($MyPmWiki_Hostname)) $MyPmWiki_Hostname = "localhost"; if (!isset($MyPmWiki_TableFmt)) $MyPmWiki_TableFmt = "border='1'"; if (!isset($MyPmWiki_Username)) return "Error: \$MyPmWiki_Username not defined. $ExtraErrMsg"; if (!isset($MyPmWiki_Password)) return "Error: \$MyPmWiki_Password not defined. $ExtraErrMsg"; if (!isset($MyPmWiki_DBName)) return "Error: \$MyPmWiki_DBName not defined. $ExtraErrMsg"; if (!$dbh = mysqli_connect ($MyPmWiki_Hostname, $MyPmWiki_Username, $MyPmWiki_Password)) return "Connection Error: ".mysqli_error($dbh)." $ExtraErrMsg";; if(!mysqli_select_db ($dbh,$MyPmWiki_DBName)) $resultStr = "Error: ".mysqli_error($dbh)." $ExtraErrMsg"; elseif($result = mysqli_query($dbh,$SQL)) { $resultStr = ""; for ($i = 0; $i < mysqli_num_fields($result); $i++) { $resultStr .= ""; } $resultStr .= ""; while($row = mysqli_fetch_row($result)) { $resultStr .= ""; foreach ($row as $field) $resultStr .= ""; $resultStr .= ""; } $resultStr .= "

".mysqli_fetch_field_direct($result, $i)->name."
$field

"; } else $resultStr = "SQL Error: ".mysqli_error($dbh).""; mysqli_close($dbh); return $resultStr; } ?>