array_push($row, $result); } return $row; } function count_alias($size_type_id) { $sql = "SELECT COUNT(*) AS rows FROM tbl_size WHERE size_type_id = '{$size_type_id}' ORDER BY size_order"; $query = $this->conn->query($sql); $result = $query->fetch_object(); return $result; } } $_ajax = new AJAX(); $size_type_id = filter_var($_POST["size_type_id"], FILTER_SANITIZE_STRING); $type_order = filter_var($_POST["type_order"], FILTER_SANITIZE_NUMBER_INT); $count = $_ajax->count_alias($size_type_id); $check_array = $_ajax->get_alias($size_type_id); if ($count->rows > 0) { foreach ($check_array as $key => $check_array) { ?> <div class="form-group row" id="lbl_size_qty"> <label class="col-xs-3 control-label" for="Stock"> <?php if ($key == 0) { ?> Sizes<?php } ?> </label>
# ---------------------------------------------------------------------- # AJAX: CHECK ALIAS # ---------------------------------------------------------------------- */ if ($_POST) { require_once '../../../static/_header.php'; class AJAX { private $conn; function __construct() { $this->conn = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME); } function count_alias($product_alias, $product_id) { $sql = "SELECT COUNT(*) AS rows FROM tbl_product WHERE `product_alias` = '{$product_alias}' AND id != '{$product_id}'"; $query = $this->conn->query($sql); $result = $query->fetch_object(); return $result; } } $_ajax = new AJAX(); $product_alias = filter_var($_POST["product_alias"], FILTER_SANITIZE_STRING); $product_id = filter_var($_POST["product_id"], FILTER_SANITIZE_NUMBER_INT); $count_alias = $_ajax->count_alias($product_alias, $product_id); if ($count_alias->rows > 0) { echo 'existed'; } else { echo 'ok'; } }