Пример #1
0
function printMyRecipes()
{
    $conn = getConn();
    $userid = $_SESSION["userid"];
    $sql = " SELECT * FROM recipe\n\t\t\t\tWHERE author = '{$userid}'";
    $result = $conn->query($sql);
    printResultWithX($result);
}
Пример #2
0
function printMyCookbooks()
{
    $userid = $_SESSION["userid"];
    $conn = getConn();
    $sql = " SELECT * FROM cookbook \n\t\t\t\tWHERE cookbook_id in (\n\t\t\t\t\tSELECT cookbook_id FROM cookbook_list\n\t\t\t\t\tWHERE user_id = '{$userid}')";
    $result = $conn->query($sql);
    printResultWithX($result);
}