File "get_users_data.php"

Full Path: /home/magicrsz/public_html/Paypal/admin/ajax/mini_categories/get_users_data.php
File size: 1.18 KB
MIME-type: text/x-php
Charset: utf-8

<?php
session_start();
include("../database.php");

$article_id=$_POST['article_id'];

$query="SELECT * from user_login where role!='1'";
$users=db::getRecords($query);

//echo($content_id);
//print_r($producers[2]);

$size=0;

if($users!=NULL)
{
    $size=sizeof($users);
}

$query="SELECT * from article_shared where article_id='$article_id'";
$articles_shared=db::getRecords($query);
//print_r($singers_contest);

foreach($users as $user)
{

    $flag=0;

    for($i=0;$i<$size;$i++)
    {   

        if($user['id'] == $articles_shared[$i]['user_id'])
        {
            $user_id = $user['id'];

            $query="SELECT * from user_login where id='$user_id'";
            $user_data=db::getRecord($query);
            echo "<option value='".$user_data['id']."' selected >".$user_data['f_name'] .$user_data['l_name']."</option>";
            $flag=1;
        }
    }

    if($flag==0)
    {
        $user_id = $user['id'];

        $query="SELECT * from user_login where id='$user_id'";
        $user_data=db::getRecord($query);
        echo "<option value='".$user_data['id']."'>".$user_data['f_name'] .$user_data['l_name']."</option>"; 
    }

}

?>