WordPress.org

Plugin Directory

Changeset 450027


Ignore:
Timestamp:
10/11/11 20:49:15 (3 years ago)
Author:
MrWiblog
Message:

Fixed SQL for column names which are keywords.

Location:
database-browser/trunk
Files:
2 edited

Legend:

Unmodified
Added
Removed
  • database-browser/trunk/database-browser.php

    r328797 r450027  
    55Description: Easily browse the data in your database, and download in CSV, XML and JSON format 
    66Author: Chris Taylor 
    7 Version: 1.1.1 
     7Version: 1.1.2 
    88Author URI: http://www.stillbreathing.co.uk/ 
    99*/ 
     
    1616$register->slug = "databasebrowser"; 
    1717$register->name = "Database Browser"; 
    18 $register->version = "1.1.1"; 
     18$register->version = "1.1.2"; 
    1919$register->developer = "Chris Taylor"; 
    2020$register->homepage = "http://www.stillbreathing.co.uk"; 
     
    2626     
    2727        // set some properties 
    28         var $version = "1.1.1"; 
     28        var $version = "1.1.2"; 
    2929        var $tables = array(); 
    3030        var $table = null; 
     
    256256            $sql = "SELECT SQL_CALC_FOUND_ROWS "; 
    257257            foreach( $this->columns as $column ) { 
    258                 $sql .= $column->Field . ", "; 
     258                $sql .= "`" . $column->Field . "`, "; 
    259259            } 
    260260            $sql = trim( trim( $sql ), "," ); 
     
    266266            // using an order by 
    267267            if ( !empty( $_POST["orderby"] ) ) { 
    268                 $sql .= " ORDER BY " . stripslashes( $_POST["orderby"] ); 
     268                $sql .= " ORDER BY `" . stripslashes( $_POST["orderby"] ) . "`"; 
    269269            } 
    270270            // using a limit 
  • database-browser/trunk/readme.txt

    r328797 r450027  
    44Tags: database, table, browse, query, download, export 
    55Requires at least: 3.0.1 
    6 Tested up to: 3.0.4 
    7 Stable tag: 1.1.1 
     6Tested up to: 3.2.1 
     7Stable tag: 1.1.2 
    88 
    99Easily query and browse tables in your database, and download in XML, JSON, CSV and HTML format 
     
    4040== Changelog == 
    4141 
     42= 1.1.2 (2011/10/11) = 
     43 
     44Fixed SQL for column names which are keywords. 
     45 
    4246= 1.1.1 (2011/01/04) = 
    4347 
Note: See TracChangeset for help on using the changeset viewer.