nirjharlo / wp-plugin-framework

plugin/Src/Db.php

<?php
namespace NirjharLo\WP_Plugin_Framework\Src;

if ( ! defined( 'ABSPATH' ) ) exit;

/**
 * DB installation class
 *
 * @author     Nirjhar Lo
 * @package    wp-plugin-framework
 */
if ( ! class_exists( 'Db' ) ) {

	class Db {

		/**
		 * @var String
		 */
		public $table;


		/**
		 * @var String
		 */
		public $sql;


		/**
		 * Instantiate the db class
		 *
		 * @return Void
		 */
		public function __construct() {

			$this->up_path = ABSPATH . 'wp-admin/includes/upgrade.php';

The constant NirjharLo\WP_Plugin_Framework\Src\ABSPATH was not found. Maybe you did not declare it correctly or list all dependencies?

The property up_path does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.

		}


		/**
		 * Define the necessary database tables
		 *
		 * @return Void
		 */
		public function build() {

			global $wpdb;
			$wpdb->hide_errors();
			$this->table_name = $wpdb->prefix . $this->table;

The property table_name does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.

			update_option( '_plugin_db_exist', 0 );

The function update_option was not found. Maybe you did not declare it correctly or list all dependencies?

			if ( $wpdb->get_var( "SHOW TABLES LIKE '$this->table_name'" ) != $this->table_name ) {
				$execute_sql = $this->execute( $this->table_name, $this->collate(), $this->sql );
				dbDelta( $execute_sql );

The function dbDelta was not found. Maybe you did not declare it correctly or list all dependencies?

			}
		}


		/**
		 * Define the variables for db table creation
		 *
		 * @return String
		 */
		public function collate() {

			global $wpdb;
			$wpdb->hide_errors();
			$collate = "";
		    if ( $wpdb->has_cap( 'collation' ) ) {
				if( ! empty($wpdb->charset ) )
					$collate .= "DEFAULT CHARACTER SET $wpdb->charset";
				if( ! empty($wpdb->collate ) )
					$collate .= " COLLATE $wpdb->collate";
		    }
    		require_once( $this->up_path );
			return $collate;
		}


		/**
		 * SQL query to create the main plugin table.
		 *
		 * @param String $table_name
		 * @param String $collate
		 * @param String $sql
		 *
		 * @return String
		 */
		public function execute( $table_name, $collate, $sql ) {

			return "CREATE TABLE $table_name ( $sql ) $collate;";
		}


		/**
		 * Check options and tables and output the info to check if db install is successful
		 *
		 * @return String
		 */
		public function __destruct() {

			global $wpdb;

			$this->table_name = $wpdb->prefix . $this->table;

The property table_name does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.

			if ( $wpdb->get_var( "SHOW TABLES LIKE '$this->table_name'" ) == $this->table_name ) {

				update_option( '_plugin_db_exist', 1 );

The function update_option was not found. Maybe you did not declare it correctly or list all dependencies?

			}
		}
	}
} ?>

It is not recommended to use PHP's closing tag ?> in files other than templates.