This plugin does allow theming. Check out the “Other Notes” tab in the plugin page. As far as making it sortable, your path of least resistance is to use javascript. Here’s a jQuery plugin that will do (almost) all the work for you. Hope that helps! Cheers~
$countreviews = $wpdb->get_var( $wpdb->prepare( ‘SELECT COUNT(ID) FROM ‘ . $wpdb->prefix . ‘wpcreviews WHERE page_id = %d’, get_the_ID() ) );
CSS is the answer. If you look at the HTML code of each row (<tr>), you will see that it has classes that include post ID, post status, post tags, categories, and so on. So, you can easily apply CSS rules based on that classes and based on post tags. For example, this is a … Read more
Database with mixed collation (utf8mb4 & utf8_general_ci)
[Note: @marwyk87 posted his answer while I was composing this, which represents another way to fix the problem] You’ve got a simple syntax error in your SQL, because of the way you’re referencing the table name. You should just say $sql = $wpdb->prepare( ” SELECT * FROM {$wpdb->prefix}quotes ORDER BY RAND() LIMIT 1 “); and … Read more
TablePress is simply a plugin that allows you to create tables without coding. You can upload a CSV, sure, but once it’s uploaded, if you want the data to reflect the source CSV, you’ll have to upload the updated CSV to that specific table in TablePress again. Fortunately, TablePress makes this pretty easy with its … Read more
Finally got it running with few pieces of extra buttons too :): <?php $tinymce_options = array(‘plugins’ => “table,lists,link,textcolor,hr”, ‘toolbar1’=>”fontsizeselect,forecolor,backcolor,bold,italic,underline,strikethrough,alignleft,aligncenter,alignright,alignjustify”,’toolbar2’=>”blockquote,hr,table,bullist,numlist,undo,redo,link,unlink”); $editor_config= array(‘teeny’=>true, ‘textarea_rows’=>5, ‘editor_class’=>’csec_text’, ‘textarea_name’=>’csec_text’, ‘wpautop’=>false, ‘tinymce’=>$tinymce_options); wp_editor($content, $id, $editor_config); ?> Check: wp_editor in add_meta_boxes does not show gallery for better option working in accordance with WordPress.
Write a function that uses $wpdb->prefix as a fallback. Something like this: function wpse65880_table_with_prefix($table) { // should define array in config file, rather than hard coding $my_tables = array(“table1”, “table2”, “table3”, “table4”); if (in_array($table, $my_tables)) { // “qa_” should also be a config file setting return “qa_” . $table; } else return $wpdb->prefix . $table; … Read more
$wpdb is outside the scope of your plugin file, you need global $wpdb; before using $wpdb->prefix
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