File: /var/www/html/check.php
<?php include('Connections/videoondemand.php');
if(!empty($_GET['mytitle']))
{
$mytitle = trim(strtolower($_GET['mytitle']));
$mytitle = mysqli_real_escape_string($link,$mytitle);
$query = "SELECT * FROM profilepicture WHERE title = '$mytitle' LIMIT 1";
$result = mysqli_query($query,$link) or die("select Failed:" . mysql_error());
$num = mysql_num_rows($result);
echo $num;
}
if(!empty($_GET['alphabet']))
{
$alphabet = trim(strtolower($_GET['alphabet']));
$alphabet = mysqli_real_escape_string($link,$alphabet);
$catalogid = $_GET['catalogid'] ;
$query = "SELECT * FROM 3dfonts WHERE title LIKE '%$alphabet%' AND catalogid != '$catalogid' LIMIT 1";
$result = mysqli_query($query,$link) or die("select Failed:" . mysql_error());
$num = mysql_num_rows($result);
echo $num;
}
if(!empty($_POST['catalogname']))
{
$catalogname = trim(strtolower($_POST['catalogname']));
$catalogname = mysqli_real_escape_string($link,$catalogname);
$query = "SELECT * FROM users WHERE catalogname = '$catalogname' LIMIT 1";
$result = mysqli_query($query,$link) or die("select Failed:" . mysql_error());
$num = mysql_num_rows($result);
echo $num;
}
if(!empty($_POST['slug']))
{
$slug = trim(strtolower($_POST['slug']));
$slug = mysqli_real_escape_string($link,$slug);
$query = "SELECT * FROM users WHERE slug = '$slug' LIMIT 1";
$result = mysqli_query($query,$link) or die("select Failed:" . mysql_error());
$num = mysql_num_rows($result);
echo $num;
}
mysql_close();
?>