FormsController.php 865 B

123456789101112131415161718192021222324252627282930313233343536
  1. <?php
  2. final class NF_Database_FormsController
  3. {
  4. private $db;
  5. private $factory;
  6. private $forms_data = array();
  7. public function __construct()
  8. {
  9. global $wpdb;
  10. $this->db = $wpdb;
  11. }
  12. public function setFormsData()
  13. {
  14. try {
  15. $sql = "SELECT `id`, `title`, `created_at` FROM `{$this->db->prefix}nf3_forms` ORDER BY `title`";
  16. $forms_data = $this->db->get_results($sql, OBJECT_K);
  17. } catch( Exception $e ) {
  18. return array();
  19. }
  20. // Provided as array of
  21. // object {id => Str, title => Str, created_at => Str}
  22. return $forms_data;
  23. }
  24. public function getFormsData()
  25. {
  26. if( empty( $this->forms_data ) ) {
  27. $this->forms_data = $this->setFormsData();
  28. }
  29. return( array_values( $this->forms_data ) );
  30. }
  31. }