Tiny File Manager | FMSqlMapping.php

Back Back Up Advanced Editor

<?php

/**
 * Class FMModelFormMakerSQLMapping_fmc
 */
class FMModelFormMakerSQLMapping_fmc extends CFMAdminModel {

/**
   * Get query by id.
   *
   * @param $id
   * @return array|null|object|void
   */
  function get_query( $id = 0 ) {
    global $wpdb;
    $rows = $wpdb->get_row("SELECT * FROM " . $wpdb->prefix . "formmaker_query where id=" . $id);

return $rows;
  }

/**
   * Get labels by id.
   *
   * @param  int $id
   * @return (string|null) $rows
   */
  function get_labels( $id = 0 ) {
    global $wpdb;
    $rows = $wpdb->get_var("SELECT label_order_current FROM " . $wpdb->prefix . "formmaker where id=" . $id);

return $rows;
  }

/**
   * Get tables.
   *
   * @return object $tables
   */
  function get_tables() {
    global $wpdb;
    $con_type = WDW_FM_Library(self::PLUGIN)->get('con_type', NULL);
    if ( $con_type == 'local' ) {
      $query = "SHOW TABLES";
      $tables = $wpdb->get_col($query);
    }
    else {
      if ( $con_type == 'remote' ) {
        $username = WDW_FM_Library(self::PLUGIN)->get('username', '');
        $password = WDW_FM_Library(self::PLUGIN)->get('password', '');
        $database = WDW_FM_Library(self::PLUGIN)->get('database', '');
        $host = WDW_FM_Library(self::PLUGIN)->get('host', '');
        $port = WDW_FM_Library(self::PLUGIN)->get('port', '');
        if ($port) {
          $host .= ':' . $port;
        }
        $wpdb_temp = new wpdb($username, $password, $database, $host);
        $query = "SHOW TABLES";
        $tables = $wpdb_temp->get_col($query);
      }
    }

return $tables;
  }

return $tables;
  }

return $table_struct;
  }

return $table_struct;
  }
}