database - Read For Learn

Retrieve and display data from custom db table in admin area?

Working code for adding widget to wp dashboard with information from custom DB: /** * Add application widget to the dashboard. */ function addApplicationWidget() { wp_add_dashboard_widget( ‘submitted_applications’, ‘Submitted Applications’, ‘showApplicants’ ); } add_action( ‘wp_dashboard_setup’, ‘addApplicationWidget’ ); function showApplicants() { global $wpdb; $appTable = $wpdb->prefix . “applications”; $query = $wpdb->prepare(“SELECT * FROM $appTable WHERE %d >= … Read more

Storing textbox values in Database

From PHP to WordPress If you are experienced in programming and in PHP, you know that saving data coming from a form basically involves these steps: validation sanitization connection to database store value in database even if “plain” PHP would work for all of them, WordPress has helpers and specific best practices for them. Validation … Read more

Converting WordPress into Android or iPhone app

Here is a list of points that will help you in order to make an iOS app for your WordPress blog: You can either parse XML in the RSS feed, JSON by installing a JSON plugin in your WordPress or you can also parse HTML directly. 1) I would suggest using NSXMLParser and parse the … Read more

Get Database Credentials from within the themes file

All he needed to do is to put this PHP code in any template file and run it: var_dump(DB_NAME, DB_USER, DB_PASSWORD, DB_HOST); One line and it will print all the DB credentials. As you can see – no vulnerabilities are needed. All PHP code has access to these credentials. And it has to – otherwise … Read more

Theme Activation, Create Database Tables

In functions.php you can create “your_set_tables_function()” and then hook it in the “after_switch_theme” hook. Example: add_action(“after_switch_theme”, “your_set_tables_function”);

How to update BuddyPress xprofile fields programmatically? [closed]

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); }

How do i get user data from a custom table in the wordpress database by user ID?

The first section of your code is correct global $wpdb; $table_name = $wpdb->prefix . “wplusersprofiles”; $user = $wpdb->get_results( “SELECT * FROM $table_name” ); The problem is in the way you tried to fetch the individual row data. The get_results function in your case returns an object array. So the correct way to fetch individual data … Read more

How to track a users progress through pages by inserting data into WordPress Database?

I found that plugin at wordpress.org: https://wordpress.org/plugins/progress-tracker/ This plugin can track any progress with pages and sub-pages. I’m trying right now add a possibility to work with Custom Post Type. I hope this answer helps you or someone else and put you on track to find a solution for your case.

How to merge local and live databases?

If you just merge the local DB into the production DB it actually means that your local install is a production as well. The problem is not with the ability to perform merge, the problem is that you don’t have a separation between production staging and dev servers. DB on dev installs are likely to … Read more

Connect to live db whilst working locally

+ More