You could use a foreach loop – function mp_install_name_data() { global $wpdb; $table_name = $wpdb->prefix . “names”; $rows = array( array( ‘id’ => ‘1’, ‘name’ => ‘matt’, ‘age’ => ’20’, ‘point_one’ => ‘0.45’, ‘point_two’ => ‘0.22’ ), array( ‘id’ => ‘2’, ‘name’ =>’james’, ‘age’ => ‘6’, ‘point_one’ => ‘0.27’, ‘point_two’ => ‘0.17’ ) ); foreach( … Read more
You pretty much answered it – legacy code. WordPress is the result of years of code evolution, refactoring and (most importantly) multiple developers/coders/authors – whilst they’re getting pretty good at enforcing coding standards/consistency, there will always be a trail of the past.
You unserialize() it. Be aware that most WordPress functions will automatically unserialize() database content before using it. See, for example, the Used By list for maybe_unserialize(). This is by no mean an exhaustive list, I’m sure. But if you’re retrieving data directly from the database — because there’s not a WordPress function to achieve what … Read more
A convenient way to use $wpdb in plugins, with custom tables and custom functions is write a class or a couple of functions that get the wp object, and configure it. An example: /* Return global wpdb aready setup with custom tables */ my_plugin_get_db( wpdb $wpdb = NULL ) { static $db; if ( is_null($db) … Read more
This is how I would update a field named ‘Address’: function updateAddress() { global $current_user; get_currentuserinfo(); $newAddress=”123 New Street”; xprofile_set_field_data(‘Address’, $current_user->id, $newAddress); }
Visual Editor freezing on text highlight since 4.3
While I am a big fan of tweaking wordpress as much as it could because it allows us to, I think the best way forward is to have the best algorithm before coding. Reading your question, I came across ” Actually, I have created two custom post type named ‘truck’ and ‘drivers’ “. Issue: Linking … Read more
Why not extend WP_List_Table? It creates responsive tables that collapse to an accordion when the table width exceeds the screen size. See Class Reference/WP List Table. You might take a look at the code in this plugin to get started: Custom List Table Example
The <br/> tags are added by wpautop function that is hooked into the_content filter. So you need to unhook it from the page where your table is displayed. There are several ways to do this. With PHP you can do something like this (change the ‘your_page/post_id’ with the actual ID) function wpdg_91929_remove_autop_for_page( $content ) { … Read more
I hope you will pull the code from here. Now you have table id get_option(‘table_press’ .$table_name .”_”. $table_id); so you can chage shortcode id dynamiclly using do_shortcode().