bk_check_valid_catname.php

/admin/app/webroot/bk_check_valid_catname.php

https://bitbucket.org/fxrialab/tickets
PHP | 75 lines | 74 code | 1 blank | 0 comment | 20 complexity | 213d9b6019cb1bc0040b7acddc973480 MD5 | raw file
Possible License(s): LGPL-2.1, AGPL-1.0, GPL-2.0, MIT


<?php

ob_start();

include("ajax_db_connec.php");



if($_REQUEST['topic']=="valid_cat_name")

{

	if($_REQUEST['screen'] != "")

	{

			$qry="select cat_name from classified_cat_masters  where cat_name='".$_REQUEST['screen']."'";

			$cat_name_exists=mysql_num_rows(mysql_query($qry));

			if($cat_name_exists>0)

			{

				$str = ob_get_clean();

				echo "Classified category name already exists";

				echo $str."^chkcatname";

			}

	}

 }

 if($_REQUEST['topic']=="valid_cat_name_edit")

{

	if($_REQUEST['screen'] != "")

	{

			$qry="select cat_name from classified_cat_masters  where cat_name = '".$_POST['screen']."' and cat_name not in ('".$_POST['prev']."')";

			$cat_name_exists=mysql_num_rows(mysql_query($qry));

			if($cat_name_exists>0)

			{

				$str = ob_get_clean();

				echo "Classified category name already exists";

				echo $str."^chkcatnameedit";

			}

	}

 }

 if($_REQUEST['topic']=="valid_subcat_name")

{

	if($_REQUEST['screen'] != "")

	{

			$qry="select cat_name from classified_cat_masters  where cat_name='".$_REQUEST['screen']."'";

			$cat_name_exists=mysql_num_rows(mysql_query($qry));

			if($cat_name_exists>0)

			{

				$str = ob_get_clean();

				echo "Classified sub category name already exists";

				echo $str."^chksubcatname";

			}

	}

 }

 if($_REQUEST['topic']=="valid_subcat_name_edit")

{

	if($_REQUEST['screen'] != "")

	{

			$qry="select cat_name from classified_cat_masters  where cat_name = '".$_POST['screen']."' and cat_name not in ('".$_POST['prev']."')";

			$cat_name_exists=mysql_num_rows(mysql_query($qry));

			if($cat_name_exists>0)

			{

				$str = ob_get_clean();

				echo "Classified sub category name already exists";

				echo $str."^chksubcatnameedit";

			}

	}

 }

if($_REQUEST['topic']=="valid_abuse")

{

	if($_REQUEST['screen'] != "")

	{

			$qry="select words from abusive_words  where words='".$_REQUEST['screen']."'";

			$cat_name_exists=mysql_num_rows(mysql_query($qry));

			if($cat_name_exists>0)

			{

				$str = ob_get_clean();

				echo "Abusive word already exists";

				echo $str."^chkabusive";

			}

	}

 }

?>