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';
