The wpdb object can be used to access any database and query any table. Absolutely no need to be WordPress related, which is very interesting.

Simply create a new wpdb object:

  $wpdb_mydb = new wpdb('username','password','database','localhost');

And use it in your functions as you do for the wp database:

  global $wpdb_mydb;

  $sql = $wpdb_mydb->prepare("SELECT * FROM {$wpdb->prefix}my_table_name WHERE FileName = %s", $FileName);
  if (current_user_can('administrator'))
    $wpdb_mydb->show_errors();
  $Results = $wpdb_mydb->get_results($sql, ARRAY_A);
  if (count($Results) > 0)
    return(true);
  else
    return(false);
Feel free to comment if you can add help to this page or point out issues and solutions you have found. I do not provide support on this site, if you need help with a problem head over to stack overflow.

Comments

Your email address will not be published. Required fields are marked *