<?php $mydb = new wpdb(‘uid’,’passwd’,’database’,’localhost’); $mydb->show_errors(); $query = “SELECT DATE_FORMAT(col1, ‘%d-%b’) AS Pdate, DATE_FORMAT(col1, ‘%Y’) AS Pyear, col2, col3, col4, col5 AS fname FROM table ORDER BY col1 DESC LIMIT 50”; $result = $mydb->get_results($query); echo $mydb->num_rows . ‘ in table ‘; ?>
I would use the Theme My Login for this and register people who fill out the form as users. You’d also need to get their email but you can easily redirect them to their profile after submitting and they’d have access to any of the data from the form. If for some reason you don’t … Read more
Here’s a way to add an extra Comment Status field to the posts list table: add_filter(‘manage_post_posts_columns’, function ( $columns ) { $_columns = []; foreach( (array) $columns as $key => $label ) { $_columns[$key] = $label; if( ‘title’ === $key ) $_columns[‘wpse_comment_status’] = esc_html__( ‘Comment Status’, ‘mydomain’ ); } return $_columns; } ); add_action( ‘manage_post_posts_custom_column’, … Read more
Ah I found it. You can use after_setup_theme action hook. So it will be like add_action(‘after_setup_theme’, [‘\Recruitment\recruitment’, ‘create_table’]); Updated Code $theme = wp_get_theme(); if ( $theme->name == ‘My THEME NAME’ ) { global $wpdb; global $charset_collate; $sql = “CREATE TABLE IF NOT EXISTS … $charset_collate;”; require_once ABSPATH . ‘wp-admin/includes/upgrade.php’; dbDelta( $sql ); add_option( ‘ab_db_version’, self::$db_version … Read more
The canonical solution for this kind of problems is to use a custom post type and “get” with zero effort admin framework and caching when object caching is used. Any attribute that is needed can be stored as a meta. Depending on what are your specific needs are, you can register such a post type … Read more
In wp-config.php for your second site, define the following two constants: define(‘CUSTOM_USER_TABLE’, ‘yourfirstprefix_users’); define(‘CUSTOM_USERMETA_TABLE’, ‘yourfirstprefix_usermeta’); You’ll have to add some custom logic to your second site limiting logins by user role.
These bigger plugins are often “too cool” to use post_meta/post_custom – thats why you were unable to retrieve the data via the normal plugin way of storing additional info. The dev documentation for ai1ec in bleak, I couldn’t find any functions to simplify the task you were after (though they do exist in the source … Read more
your live site jquery code ( missing (function($) {
1) In order to check what kind of prefix used by current installantion you can goto wp-config.php in a root directory and find line with $table_prefix = ‘PREFIX_HERE’; variable 2) Backup the DB before making any action! 3) Additionally check if other tables with different prefixes/name_patters are not used by badly-written 3rd party plugins. They … Read more
register_activation_hook() only attaches a function to run on activation of your plugin, not on updating. See the docs for full details, particularly this part: 3.1 : This hook is now fired only when the user activates the plugin and not when an automatic plugin update occurs (#14915). Of course, you could force your hook to … Read more