getFavouriteCategories.php

<?php

$dbhost = "localhost"; 
$dbname = "checkboxlistview";            
$dbuser = "root";                   
$dbpass = "";           


if(isset($_GET["email"]))
{
    $email=$_GET['email'];

    $con=mysqli_connect($dbhost,$dbuser,$dbpass,$dbname) or die('Database not connected');

    $query1 = "select distinct fc.categoryId as 'id',c.categoryName,'true' as 'selected' FROM favouritecategories fc join categories c on c.id = fc.categoryId where fc.email = '$email'
    union
    select *,'false' as 'selected' from categories c where Id not in (SELECT distinct fc.categoryId FROM favouritecategories fc
    join categories c on c.id = fc.categoryId where fc.email = '$email')
    order by categoryName
    ";

    $result1 = mysqli_query($con, $query1) or die("Error in Selecting " . mysqli_error($connection));
    $temparray = array();
    while($row =mysqli_fetch_assoc($result1))
    {
        $temparray[] = $row;
    }

    echo json_encode($temparray);
}
?>