# wp-data-access/5.5.84/WPDataAccess/Plugin_Table_Models/WPDA_App_Apps_Model.php

WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards, version 5.5.84. 103 lines.

- Page: https://pluginprobe.com/plugins/wp-data-access/5.5.84/code/WPDataAccess/Plugin_Table_Models/WPDA_App_Apps_Model.php
- Raw: https://pluginprobe.com/plugins/wp-data-access/5.5.84/raw/WPDataAccess/Plugin_Table_Models/WPDA_App_Apps_Model.php
- Modified: 2026-09-16T18:01:32+00:00

Line numbers below start at 1. Link to a line or a range by appending a fragment to the
page URL, for example `https://pluginprobe.com/plugins/wp-data-access/5.5.84/code/WPDataAccess/Plugin_Table_Models/WPDA_App_Apps_Model.php#L10-L20`.

```php
<?php

namespace WPDataAccess\Plugin_Table_Models {

	use WPDataAccess\WPDA;

	class WPDA_App_Apps_Model extends WPDA_Plugin_Table_Base_Model {

		const BASE_TABLE_NAME = 'wpda_app_apps';

		public static function select_all( $app_id ) {

			global $wpdb;
			return $wpdb->get_results( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- plugin table
				$wpdb->prepare(
					'SELECT * FROM `%1s` WHERE app_id = %d order by seq_nr', // phpcs:ignore WordPress.DB.PreparedSQLPlaceholders
					array(
						WPDA::remove_backticks( self::get_base_table_name() ),
						$app_id,
					)
				), // db call ok; no-cache ok.
				'ARRAY_A'
			); // phpcs:ignore

		}

		public static function list() {

			global $wpdb;
			return $wpdb->get_results( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- plugin table
				$wpdb->prepare('
						SELECT * 
						FROM %i
						ORDER BY app_id, seq_nr, app_id_detail
					',
					array(
						WPDA::remove_backticks( self::get_base_table_name() )
					)
				),
				'ARRAY_A'
			);

		}

		public static function create(
			$app_id,
			$app_id_detail,
			$seq_nr
		) {

			global $wpdb;
			if ( 1 === $wpdb->insert( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery -- plugin table
					static::get_base_table_name(),
					array(
						'app_id'        => $app_id,
						'app_id_detail' => $app_id_detail,
						'seq_nr'        => $seq_nr,
					)
				)
			) {
				return true;
			} else {
				return false;
			}
		}

		public static function delete( $app_id, $delete_as_detail = false ) {

            global $wpdb;

            if ( $delete_as_detail ) {
                $wpdb->delete( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- plugin table
                    static::get_base_table_name(),
                    array(
                        'app_id_detail' => $app_id,
                    )
                );
            }

			return $wpdb->delete( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- plugin table
				static::get_base_table_name(),
				array(
					'app_id' => $app_id,
				)
			);

		}

		public static function update(
			$app_id,
			$app_apps
		) {

			self::delete( $app_id );
			foreach ( $app_apps as $index => $app_detail_id ) {
				self::create( $app_id, $app_detail_id, $index );
			}

		}

	}

}
```