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

get-from-db.php in JetFormBuilder — Dynamic Blocks Form Builder 1.1.0, at includes/generators/get-from-db.php

57 lines 927 B

Raw Download Zip

1	<?php
2
3	namespace Jet_Form_Builder\Generators;
4
5	class Get_From_DB extends Base {
6
7	/**
8	* Returns generator ID
9	*
10	* @return string
11	*/
12	public function get_id() {
13	return 'get_from_db';
14	}
15
16	/**
17	* Returns generator name
18	*
19	* @return string
20	*/
21	public function get_name() {
22	return __( 'Get values list from database', 'jet-engine' );
23	}
24
25	/**
26	* Returns generated options list
27	*
28	* @return array
29	*/
30	public function generate( $field ) {
31
32	global $wpdb;
33
34	$result = array();
35	$table = $wpdb->postmeta;
36	$rows = $wpdb->get_results(
37	$wpdb->prepare( "SELECT `meta_value` FROM `$table` WHERE `meta_key` = '%s'", $field ),
38	ARRAY_A
39	);
40
41	if ( empty( $rows ) ) {
42	return $result;
43	}
44
45	foreach ( $rows as $row ) {
46	$result[] = array(
47	'value' => $row['meta_value'],
48	'label' => $row['meta_value'],
49	);
50	}
51
52	return $result;
53
54	}
55
56	}
57