function db_query_user_subscription_series($mysqli) { $user_id = $_SESSION["user_id"]; $query = "SELECT DISTINCT title FROM subsribes WHERE user_id='" . $user_id . "'"; $return_str = ""; if ($result = $mysqli->query($query)) { while ($row = $result->fetch_assoc()) { $title = $row["title"]; $return_str .= db_query_series($mysqli, $title); if (empty($return_str)) { echo "<p>EMPTY</p>"; // $return_str="EMPTY"; } } mysqli_free_result($result); } return $return_str; }
<?php include 'prefix_admin.php'; ?> <root> <?php include_once 'includes/db_connect.php'; include_once 'includes/functions.php'; sec_session_start(); if (login_check($mysqli) == true) { $to_present = "<usercatalog>"; $user_id = $_SESSION["user_id"]; $to_present .= db_query_all_users($mysqli); $to_present .= "</usercatalog>"; $to_present .= "<seriescatalog>"; $to_present .= db_query_series($mysqli, ""); $to_present .= "</seriescatalog>"; print utf8_encode($to_present); } else { header("Location: index.php?"); } ?> </root> <?php include 'postfix_admin.php';
<?php include 'prefix.php'; ?> <root> <seriescatalog> <?php include_once 'includes/db_connect.php'; include_once 'includes/functions.php'; $to_present = db_query_series($mysqli); print utf8_encode($to_present); //subscribe("24", $mysqli); ?> </seriescatalog> </root> <?php include 'postfix.php';