prefix.'atpf_options'; $charset_collate = $wpdb->get_charset_collate(); $sql = "CREATE TABLE $table_name ( footer varchar(250) ) $charset_collate;"; require_once( ABSPATH.'wp-admin/includes/upgrade.php' ); dbDelta( $sql, true ); } function atpf_first_insert() { global $wpdb; $table_name = $wpdb->prefix.'atpf_options'; $sql = "INSERT INTO $table_name VALUES ( __( 'Insert here what you want to add to footer of each post', 'add-to-post-footer' ) );"; require_once( ABSPATH.'wp-admin/includes/upgrade.php' ); dbDelta( $sql, true ); } function atpf_select_text() { global $wpdb; $table_name = $wpdb->prefix.'atpf_options'; $sql = "SELECT * FROM $table_name;"; $array = $wpdb->get_results( $sql, ARRAY_A ); return $array[0]['footer']; } function atpf_update_footer_text($text) { global $wpdb; $table_name = $wpdb->prefix.'atpf_options'; $sql = "UPDATE $table_name SET footer='$text';"; require_once( ABSPATH.'wp-admin/includes/upgrade.php' ); dbDelta( $sql, true ); } ?>