Skip to content

Instantly share code, notes, and snippets.

@tommcfarlin
Last active September 4, 2018 12:29
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tommcfarlin/83522e41b58ba2ee8633282cb03e6a60 to your computer and use it in GitHub Desktop.
Save tommcfarlin/83522e41b58ba2ee8633282cb03e6a60 to your computer and use it in GitHub Desktop.
[WordPress] Database Queries in WordPress
<?php
global $wpdb;
$results = $wpdb->get_results(
$wpdb->prepare(
"
",
$userId
),
ARRAY_A
);
if (empty($results)) {
return;
}
$results = array_map($results, 'column_name');
<?php
global $wpdb;
$results = $wpdb->get_results(
$wpdb->prepare(
"
SELECT
user_id,
meta_value
FROM $wpdb->usermeta
WHERE meta_key LIKE %s
AND user_id = %d
",
'%wc_authorize_net_cim_customer_profile_id%',
wp_get_current_user()->ID;
),
ARRAY_A
);
if (empty($results)) {
return [];
}
$results = array_map($results, 'meta_value');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment