WordPress.org
Get WordPress

Plugin Directory

Changeset 2118804


Ignore:
Timestamp:
07/07/2019 06:40:51 AM (7 years ago)
Author:
devjoe2016
Message:

Revision 1.6.2, minor text changes

Location:
database-operations/trunk
Files:
4 edited

Legend:

Unmodified
Added
Removed

  • database-operations/trunk/admin/class-database-operations-admin.php

    r2118598 r2118804  
    168168           
    169169            if($db_op_tb1 == "" && $db_op_tb2 == ""){
    170                 $res = '<h4>Select At Least A Table</h4>';
     170                $res = '<h4> Select At Least A Table</h4>';
    171171                return $res;
    172172            }
    … …  
    189189               $qryop = 'UNION';
    190190            }
    191                 $repl = str_replace('wp_', '', $db_op_tb1);
    192                 $repl1 = str_replace('wp_', '', $db_op_tb2);
     191                //$repl = str_replace('wp_', '', $db_op_tb1);
     192                //$repl1 = str_replace('wp_', '', $db_op_tb2);
    193193                $query = "
    194194                    SELECT *
    195                     FROM {$wpdb->$repl} {$qryop}
     195                    FROM {$db_op_tb1} {$qryop}
    196196                    SELECT *
    197                     FROM {$wpdb->$repl1}";
     197                    FROM {$db_op_tb2}";
    198198                $mytables = $wpdb->get_results($query);
    199199                if (empty($mytables)) {
    200                     $res = '<h4>To use this UNION clause, each SELECTED TABLE must have</br>
     200                    $res = ' <h4>To use this UNION clause, each SELECTED TABLE must have</br>
    201201                               
    202202                                - The same number of columns selected</br>
    … …  
    213213    $cols = $db_op_cols;
    214214    $mytables = $mytables;
    215     $res = '<div style="overflow:auto;"><table  class="table table-hover" > <h4> Displaying Last Saved Query Information of Table(s) ' . $db_op_tb1. ' / ' . $db_op_tb2.'</h4><thead class="thead-light"><tr class="table-info">';
     215    $res = '<div style="overflow:auto;"><table  class="table table-hover" > <h4> Table(s) ' . $db_op_tb1. ' / ' . $db_op_tb2.'</h4><thead class="thead-light"><tr class="table-info">';
    216216    if($cols != ""){
    217217    foreach ($cols as $t)

  • database-operations/trunk/admin/views/database-operations-admin-display.php

    r2118598 r2118804  
    1515    <div class="ms-panel-div">
    1616        <textarea style="display:none;" id="ct_ms_content" name="ct_ms_content"><?php echo $res; ?></textarea>
    17         <?php echo '<h4>Use With Shortcode [database_operations id='.
     17        <?php echo '<h4> Use With Shortcode [database_operations id='.
    1818        //get_post_meta(get_the_ID, "post_ID", true );
    1919         get_the_ID().']</h4>
    2020        </br>
    21     <h4>    please donate www.antechncom.wordpress.com 💙</h4></br>
     21    <h4>    please donate www.antechncom.wordpress.com 💙 </h4></br>
    2222         ';
    2323        //get_post_custom_values('tb1', get_the_ID())

  • database-operations/trunk/db_op.php

    r2118598 r2118804  
    44Plugin URI: https://antechncom.wordpress.com/
    55Description: This plugin connects Wordpress and the MY_SQL database, thus allowing a user fetch data from the MY_SQL database, a user can display a table or perform a simple 'UNION' on two tables. Copy shortcodes to use on any page.
    6 Version: 1.6.1
     6Version: 1.6.2
    77Author: Antechn
    88Author URI: https://antechncom.wordpress.com/about-us/

  • database-operations/trunk/readme.txt

    r2118598 r2118804  
    55Requires at least: 4.6
    66Tested up to: 5.2
    7 Stable tag: 1.6.1
     7Stable tag: 1.6.2
    88Requires PHP: 5.2.4
    99License: GPLv2 or later
    … …  
    6666* Minor Code Changes
    6767
     68= 1.6.2 =
     69* Changed Query Results Header Text
    6870
    6971
     72
Note: See TracChangeset for help on using the changeset viewer.