# jetformbuilder/1.0.3/includes/generators/get-from-db.php

JetFormBuilder — Dynamic Blocks Form Builder, version 1.0.3. 57 lines.

- Page: https://pluginprobe.com/plugins/jetformbuilder/1.0.3/code/includes/generators/get-from-db.php
- Raw: https://pluginprobe.com/plugins/jetformbuilder/1.0.3/raw/includes/generators/get-from-db.php
- Modified: 2021-02-23T13:35:24+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/jetformbuilder/1.0.3/code/includes/generators/get-from-db.php#L10-L20`.

```php
<?php

namespace Jet_Form_Builder\Generators;

class Get_From_DB extends Base {

	/**
	 * Returns generator ID
	 *
	 * @return string
	 */
	public function get_id() {
		return 'get_from_db';
	}

	/**
	 * Returns generator name
	 *
	 * @return string
	 */
	public function get_name() {
		return __( 'Get values list from database', 'jet-engine' );
	}

	/**
	 * Returns generated options list
	 *
	 * @return array
	 */
	public function generate( $field ) {

		global $wpdb;

		$result = array();
		$table  = $wpdb->postmeta;
		$rows   = $wpdb->get_results(
			$wpdb->prepare( "SELECT `meta_value` FROM `$table` WHERE `meta_key` = '%s'", $field ),
			ARRAY_A
		);

		if ( empty( $rows ) ) {
			return $result;
		}

		foreach ( $rows as $row ) {
			$result[] = array(
				'value' => $row['meta_value'],
				'label' => $row['meta_value'],
			);
		}

		return $result;

	}

}

```