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