Ticket #18407: wpdb_float_test.php

<?php
/*
Plugin Name: WPDB Float Test
Plugin URI: http://core.trac.wordpress.org/ticket/18407
Description: Tests use of %f in wpdb queries.
Author: dllh
Version: 0.1
Author URI: http://profiles.wordpress.org/users/dllh
*/

class WPDB_Float_Test {

        function activate() {
                global $wpdb;

                $sql = "CREATE TABLE {$wpdb->prefix}float_test (
                                id int(10) unsigned not null primary key auto_increment,
                                entered varchar(100),
                                num float( 10, 4 )
                );";

                require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
                dbDelta( $sql );
        }

        function deactivate() {
                global $wpdb;
                $wpdb->query( "DROP TABLE {$wpdb->prefix}float_test" );
        }

        function menu() {
                add_management_page('WPDB Float Test', 'WPDB Float Test', 'manage_options', 'wpdb-float-test-id', array( 'WPDB_Float_Test', 'options' ) );
        }

        function options() {
                global $wpdb;

                if (!current_user_can('manage_options'))  {
                        wp_die( __( 'You do not have sufficient permissions to access this page.' ) );
                }

                print "<h2>WPDB Float Test</h2>\n";
                print "<form method='post'>\n";
                print "<input id='float' name='float' type='text' value='Enter a float' onfocus='this.value=\"\"' /><br />\n";
                print "<input type='submit' value='Add' />\n";
                print "</form>\n";
                
                if( isset( $_POST['float'] ) ) {
                        $wpdb->query( $wpdb->prepare( "INSERT INTO {$wpdb->prefix}float_test ( entered, num ) VALUES ( %s, %f )", $_POST['float'], $_POST['float'] ) );
                }

                print "<h3>The Last 10 Floats Inserted</h3>";

                print "<table cellpadding='5' cellspacing='5'>\n";
                print "<tr><th>Value Entered</th><th>Float Value</th></tr>\n";
                foreach( $wpdb->get_results( "SELECT entered, num FROM {$wpdb->prefix}float_test ORDER BY id DESC LIMIT 10" ) as $row ) {
                        print "<tr><td>" . esc_html( $row->entered ) . "</td><td aligh='right'>{$row->num}</td></tr>";
                }
                print "</table>\n";
        }

}

register_activation_hook( __FILE__, array( 'WPDB_Float_Test', 'activate' ) );
register_deactivation_hook( __FILE__, array( 'WPDB_Float_Test', 'deactivate' ) );
add_action('admin_menu', array( 'WPDB_Float_Test', 'menu' ) );