92 lines
2.0 KiB
PHP
92 lines
2.0 KiB
PHP
<?php
|
|
|
|
require_once __DIR__ . '/../../vendor/autoload.php';
|
|
|
|
if (!isset($_ENV['DB_HOST'])) {
|
|
Dotenv\Dotenv::createImmutable(__DIR__ . '/../../')->safeLoad();
|
|
}
|
|
|
|
class Dropdown
|
|
{
|
|
private $host;
|
|
private $username;
|
|
private $password;
|
|
private $dbname;
|
|
private $connection;
|
|
|
|
//establish connection
|
|
public function __construct()
|
|
{
|
|
$this->host = $_ENV['DB_HOST'] ?? 'localhost';
|
|
$this->username = $_ENV['DB_USERNAME'] ?? '';
|
|
$this->password = $_ENV['DB_PASSWORD'] ?? '';
|
|
$this->dbname = $_ENV['DB_DATABASE'] ?? '';
|
|
|
|
try {
|
|
$this->connection = new mysqli($this->host, $this->username, $this->password, $this->dbname);
|
|
} catch (Exception $e) {
|
|
echo "Connection error " . $e->getMessage();
|
|
}
|
|
}
|
|
|
|
//fetch all country records from database
|
|
public function fetchCountry()
|
|
{
|
|
$data = null;
|
|
|
|
$query = "SELECT * FROM article_type ORDER BY article_type.name_articletype";
|
|
|
|
if ($sql = $this->connection->query($query)) {
|
|
while ($rows = mysqli_fetch_assoc($sql)) {
|
|
$data[] = $rows;
|
|
}
|
|
}
|
|
|
|
return $data;
|
|
}
|
|
|
|
//fetch model records from database depend upon country id
|
|
public function fetchModel($idarticletype)
|
|
{
|
|
$data = null;
|
|
|
|
$query = "SELECT * FROM modelarticle WHERE idarticletype='" . $idarticletype . "' ";
|
|
|
|
if ($sql = $this->connection->query($query)) {
|
|
while ($rows = mysqli_fetch_assoc($sql)) {
|
|
$data[] = $rows;
|
|
}
|
|
}
|
|
|
|
return $data;
|
|
}
|
|
|
|
//fetch Charact records from database depend on article type
|
|
public function fetchCharact($idarticletype)
|
|
{
|
|
$data = null;
|
|
|
|
$idarticletype = (int)$idarticletype;
|
|
|
|
$query = "
|
|
SELECT DISTINCT
|
|
ac.*
|
|
FROM article_characteristic ac
|
|
INNER JOIN standards s
|
|
ON s.idarticlecharacteristic = ac.idarticlecharacteristic
|
|
AND s.idarticletype = ac.idarticletype
|
|
WHERE ac.idarticletype = $idarticletype
|
|
AND s.active = 'Y'
|
|
ORDER BY ac.name_articlecharacteristic
|
|
";
|
|
|
|
if ($sql = $this->connection->query($query)) {
|
|
while ($rows = mysqli_fetch_assoc($sql)) {
|
|
$data[] = $rows;
|
|
}
|
|
}
|
|
|
|
return $data;
|
|
}
|
|
}
|