'wpzillow_widget', 'description' => 'Widget for WP Zillow Review Slider Plugin. Allows you to display your reviews in your widget areas.' );
parent::__construct( 'wpzillow_widget', 'WP Zillow Review Slider', $widget_options );
}
// Create the widget output.
public function widget( $args, $instance ) {
$templateid = apply_filters( 'widget_title', $instance[ 'template' ] );
$templateid = strip_tags($templateid);
$title = apply_filters( 'widget_title', $instance[ 'title' ] );
//db function variables
global $wpdb;
$table_name = $wpdb->prefix . 'wpzillow_post_templates';
//$templatedetails = $wpdb->get_row("SELECT * FROM $table_name WHERE id='".$templateid."'");
$templatedetails = $wpdb->get_row($wpdb->prepare("SELECT * FROM $table_name WHERE id=%d",$templateid));
//print_r($templatedetails);
echo $args['before_widget'] . $args['before_title'] . $title . $args['after_title'];
if($templatedetails){
//echo out widget template here, can include from a file based on which template chosen
$a['tid']=$templatedetails->id;
include plugin_dir_path( __FILE__ ) . 'partials/wp-zillow-review-slider-public-display-widget.php';
}
echo $args['after_widget'];
}
// Create the admin area widget settings form.
public function form( $instance ) {
$template = ! empty( $instance['template'] ) ? $instance['template'] : '';
$title = ! empty( $instance['title'] ) ? $instance['title'] : '';
//echo esc_attr( $template );
//create select box of widget templates, pull from db
//db function variables
global $wpdb;
$table_name = $wpdb->prefix . 'wpzillow_post_templates';
$widgettemplates = $wpdb->get_results("SELECT id, title, template_type FROM $table_name WHERE template_type='widget'");
//print_r($widgettemplates);
?>