Helper for WordPress database.

database.php

<?php
/**
 * Helper for WordPress database.
 *
 * @author Pixelbart
 */
class Database_Helpers
{
	/**
	 * Checks if a database exists.
	 *
	 * @global $wpdb
	 *
	 * @return bool
	 */
	public static function table_exists( $table_name )
	{
		global $wpdb;

		$table_name = sanitize_text_field( $table_name );
		
		if ( $table_name != $wpdb->get_var( "SHOW TABLES LIKE '$table_name'" ) ) {
			return false;
		}

		return true;
	}

	/**
	 * Optimizes a database table.
	 *
	 * @global $wpdb
	 *
	 * @return void
	 */
	public static function table_optimize( $table_name )
	{
		global $wpdb;

		$table_name = sanitize_text_field( $table_name );

		$wpdb->query( "OPTIMIZE TABLE $table_name" );
	}
}