Skip to main content
fixed title, formatting and added a tag
Source Link
fuxia
  • 107.1k
  • 38
  • 255
  • 459

I'm trying to pull data from a remote wordpress database

I am trying to pull some data from a remote wordpress database here. Here is the code I have

$server = "my server code"; $user = "my username"; $password = "my password"; $db = "mydb"; $con = mysql_connect($server,$user,$password); if (!$con) { die("database connection error");

} else {

mysql_select_db($db, $con);

function dp_get_user_liked_posts($user_id, $fields = '') {:

$server = "my server code";
$user = "my username";
$password = "my password";
$db = "mydb";
$con = mysql_connect($server,$user,$password); 
if (!$con) {
    die("database connection error");

} else {

mysql_select_db($db, $con);

function dp_get_user_liked_posts($user_id, $fields = '') {

    global $wpdb;

    $tempDB = $wpdb;

$wpdb = new wpdb($user, $password, $db, $server);


$wpdb = new wpdb($user, $password, $db, $server);

    // Get user settings
    $settings = get_option('dp_post_likes');

        $login_required = !empty($settings['login_required']) ? true : false;

            if($login_required && !is_user_logged_in()) {

                echo '<p class="must-login">'.sprintf(__('You must <a href="%1$s">register</a> and <a href="%2$s">login</a> to view your liked videos.', 'dp'),  site_url('wp-login.php?action=register', 'login'), wp_login_url()).'</p>';

            } else {

    $settings = get_option('dp_post_likes');
    $user = get_current_user_id();
    $user_id = 2;
    $likes=query_posts(array(
                            'post_type' => 'post',
                            'ignore_sticky_posts' => true,
                            'filter_type' => 'user_liked',
                            'filter_user' => $user_id
                        ));
                    
                global $wp_query;
                 $likes= array();
                 while (have_posts()) : 
                            $likes[]=the_post() ;
                        endwhile;
                            
}}}   
        mysql_close($con);

$wpdb = $tempDB;

}}}
mysql_close($con);

$wpdb = $tempDB;

but it is not display $likes anyone have any idea what I$likes. What is did wrong??

I'm trying to pull data from a remote wordpress database

I am trying to pull some data from a remote wordpress database here is the code I have

$server = "my server code"; $user = "my username"; $password = "my password"; $db = "mydb"; $con = mysql_connect($server,$user,$password); if (!$con) { die("database connection error");

} else {

mysql_select_db($db, $con);

function dp_get_user_liked_posts($user_id, $fields = '') {

global $wpdb;

$tempDB = $wpdb;

$wpdb = new wpdb($user, $password, $db, $server);

// Get user settings
$settings = get_option('dp_post_likes');

    $login_required = !empty($settings['login_required']) ? true : false;

        if($login_required && !is_user_logged_in()) {

            echo '<p class="must-login">'.sprintf(__('You must <a href="%1$s">register</a> and <a href="%2$s">login</a> to view your liked videos.', 'dp'),  site_url('wp-login.php?action=register', 'login'), wp_login_url()).'</p>';

        } else {

$settings = get_option('dp_post_likes');
$user = get_current_user_id();
$user_id = 2;
$likes=query_posts(array(
                        'post_type' => 'post',
                        'ignore_sticky_posts' => true,
                        'filter_type' => 'user_liked',
                        'filter_user' => $user_id
                    ));
                
            global $wp_query;
             $likes= array();
             while (have_posts()) : 
                        $likes[]=the_post() ;
                    endwhile;
                        

}}}
mysql_close($con);

$wpdb = $tempDB;

but it is not display $likes anyone have any idea what I did wrong??

pull data from a remote wordpress database

I am trying to pull some data from a remote wordpress database. Here is the code I have:

$server = "my server code";
$user = "my username";
$password = "my password";
$db = "mydb";
$con = mysql_connect($server,$user,$password); 
if (!$con) {
    die("database connection error");

} else {

mysql_select_db($db, $con);

function dp_get_user_liked_posts($user_id, $fields = '') {

    global $wpdb;

    $tempDB = $wpdb;

$wpdb = new wpdb($user, $password, $db, $server);

    // Get user settings
    $settings = get_option('dp_post_likes');

        $login_required = !empty($settings['login_required']) ? true : false;

            if($login_required && !is_user_logged_in()) {

                echo '<p class="must-login">'.sprintf(__('You must <a href="%1$s">register</a> and <a href="%2$s">login</a> to view your liked videos.', 'dp'),  site_url('wp-login.php?action=register', 'login'), wp_login_url()).'</p>';

            } else {

    $settings = get_option('dp_post_likes');
    $user = get_current_user_id();
    $user_id = 2;
    $likes=query_posts(array(
                            'post_type' => 'post',
                            'ignore_sticky_posts' => true,
                            'filter_type' => 'user_liked',
                            'filter_user' => $user_id
                        ));
                    
                global $wp_query;
                 $likes= array();
                 while (have_posts()) : 
                            $likes[]=the_post() ;
                        endwhile;
                            
}}}   
        mysql_close($con);

$wpdb = $tempDB;

but it is not display $likes. What is did wrong?

Source Link

I'm trying to pull data from a remote wordpress database

I am trying to pull some data from a remote wordpress database here is the code I have

$server = "my server code"; $user = "my username"; $password = "my password"; $db = "mydb"; $con = mysql_connect($server,$user,$password); if (!$con) { die("database connection error");

} else {

mysql_select_db($db, $con);

function dp_get_user_liked_posts($user_id, $fields = '') {

global $wpdb;

$tempDB = $wpdb;

$wpdb = new wpdb($user, $password, $db, $server);

// Get user settings
$settings = get_option('dp_post_likes');

    $login_required = !empty($settings['login_required']) ? true : false;

        if($login_required && !is_user_logged_in()) {

            echo '<p class="must-login">'.sprintf(__('You must <a href="%1$s">register</a> and <a href="%2$s">login</a> to view your liked videos.', 'dp'),  site_url('wp-login.php?action=register', 'login'), wp_login_url()).'</p>';

        } else {

$settings = get_option('dp_post_likes');
$user = get_current_user_id();
$user_id = 2;
$likes=query_posts(array(
                        'post_type' => 'post',
                        'ignore_sticky_posts' => true,
                        'filter_type' => 'user_liked',
                        'filter_user' => $user_id
                    ));
                
            global $wp_query;
             $likes= array();
             while (have_posts()) : 
                        $likes[]=the_post() ;
                    endwhile;
                        

}}}
mysql_close($con);

$wpdb = $tempDB;

but it is not display $likes anyone have any idea what I did wrong??