Extension:SQLselect

include("extensions/SQLselect.php");

 <?php
 # Tag : 
 #   <sqlselect>valid sql query</sqlselect>
 #   i.e. <sqlselect>title like '%ubuntu%' or title like '%linux%'</sqlselect> 
 #
 # Requires :
 #   -
 # 
 # To activate the extension :
 # - include it at the end of your LocalSettings.php: include("extensions/SQLselect.php");
 # 
 $wgExtensionFunctions[] = 'wfsqlselect';
 $wgExtensionCredits['parserhook'][] = array(
        'name' => 'sqlselect',
        'description' => 'embed the output of SQL queries in wiki pages' ,                        
        'author' => 'stixuser',
        'url' => 'http://www.mediawiki.org/wiki/Extension:SQLselect'
 );
 function wfsqlselect() {
        global $wgParser;
        $wgParser->setHook('sqlselect', 'rendersqlselect');
 }
 # The callback function for converting the input SQL query to HTML output
 function rendersqlselect($input, $argv, &$parser )
 {
  #important: caching must be disabled for this page!
  $parser->disableCache();
  global $wgScriptPath, $wgUploadPath;
  if (!defined(title))
  {
    define("title","title"); 
    define("filename","filename"); 
  }
  # enter your own SQL DB definitions here (or use an include)
  $hostname = "localhost"; 
  $username = "myuser"; 
  $password = "mypassword"; 
  $dbname   = "books"; 
  # open the database
  mysql_connect($hostname, $username, $password) or die(mysql_error()); 
  mysql_select_db("$dbname") or die(mysql_error()); 
  # execute the SQL query ; note that there's no errorchecking on the inputstring in arr[0]
  # see the Discussion page for comments on the next line
  $query = "select * from `books` where ".$arr[0]." order by title"; 
  $result = mysql_query($query) or die(mysql_error()); 
  $number = mysql_num_rows($result); 
  $output = '';
  # the following code processes the results of the query. Adapt to your own needs.
  $i = 0; 
  while ($i < $number)
  { 
    $row = mysql_fetch_array($result); 
    $filename = $row[filename]; 
    $title    = $row[title]; 
    $icon     = "file_icon.gif";
    $dotpos   = strrpos($filename,".");
    if ($dotpos)
    {
      $ext = substr($filename,$dotpos+1);
      if ($ext == "pdf") $icon = "pdf_icon.gif";
    }
    $output = $output.'<img src="'.$wgUploadPath.'/'.$icon.'">&nbsp;<a href="'.$wgUploadPath.$filename.'" target="_book">'.$title.'</a><br>';
    $i++;
  } 
  return $output;
 }