| 1 |
<?php |
| 2 |
class Poll_Answer_Results{ |
| 3 |
private $plugin_name; |
| 4 |
|
| 5 |
public function __construct( $plugin_name ) { |
| 6 |
$this->plugin_name = $plugin_name; |
| 7 |
} |
| 8 |
|
| 9 |
// Get Polls |
| 10 |
public function get_polls(){ |
| 11 |
global $wpdb; |
| 12 |
$polls_table = $wpdb->prefix."ayspoll_polls"; |
| 13 |
$sql = "SELECT id,title FROM ".$polls_table; |
| 14 |
$result = $wpdb->get_results($sql , "ARRAY_A"); |
| 15 |
return $result; |
| 16 |
} |
| 17 |
|
| 18 |
// Get answers |
| 19 |
public function get_poll_answers($id){ |
| 20 |
global $wpdb; |
| 21 |
$answers_table = $wpdb->prefix."ayspoll_answers"; |
| 22 |
$sql = "SELECT * FROM ".$answers_table." WHERE poll_id=".$id." AND show_user_added = 1"; |
| 23 |
$result = $wpdb->get_results($sql , "ARRAY_A"); |
| 24 |
return $result; |
| 25 |
} |
| 26 |
} |
| 27 |
?> |