$result= mysqli_query($conn, "SELECT value FROM _main WHERE variable = 'logo'");
$row = mysqli_fetch_assoc($result);
$logo = $row['value'];$logo = $pdo->query("SELECT value FROM _main WHERE variable = 'logo'")->fetchColumn();$settings = $pdo->query("SELECT variable, value FROM _main")->fetchAll(PDO::FETCH_KEY_PAIR);
echo $settings['logo'];$query = $pdo->query('SELECT * FROM `telephone` ORDER BY `fullname`');
$data = $query->fetchAll(PDO::FETCH_ASSOC));<select class="viewing-select">
<?php foreach ($data as $row): ?>
<option value="<?= $row['id'] ?>"><?= $row['fullname'] ?></option>
<?php endforeach ?>
</select>И если человек захочет узнать полную информацию о человеке, то есть по клике на кнопку, должна открываться полная информация о человеке, то есть где он живет и его номер.
$mywe = mysqli_fetch_array($result, MYSQLI_ASSOC);
if ($mywe) {
echo 'Найдено совпадение: '; echo $mywe['adress'];
} else {
echo "текст";
}$stmt = $mysqli->query("INSERT INTO $db_table (name,mobnumber,modelandbrandcar,yearissue,scheduledmain,repairs,paintwork,additionalequip,technicalinsp,other,detail) VALUES (?,?,?,?,?,?,?,?,?,?,?)");
$stmt->bind_param("sssssssssss", $name, $mobnumber, $modelandbrandcar, $yearissue, $scheduledmain, $repairs, $paintwork, $additionalequip, $technicalinsp, $other, $detail);
$stmt->execute();mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);class DB
{
public $pdo;
public function __construct() {
$host = "localhost";
$user = "root";
$password = "";
$dbname = "dbtest";
$charset = "utf8";
$dsn = "mysql:host=$host;dbname=$dbname;charset=$charset";
$this->opt = [
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
PDO::ATTR_EMULATE_PREPARES => FALSE
];
$this->pdo = new PDO($dsn, $user, $password, $opt);
}
public function query($sql, $args = NULL)
{
if (!$args)
{
return $this->pdo->query($sql);
}
$stmt = $this->pdo->prepare($sql);
$stmt->execute($args);
return $stmt;
}
public function __destruct() {
$pdo = NULL;
}
}сlass Settings {
public function __construct($db) {
this->db = $db;
}
public function getSiteName() {
$stmt = $this->db->query("SELECT Value FROM configs WHERE Name = 'SiteName'");
return $stmt->fetchColumn();
}
}$sql = $conn->prepare("INSERT INTO MyGuests2 (text2) VALUES (?)");
$sql->bind_param("s", $_POST["name"]);
$sql->exeсute();
echo "Успешно созданы новые записи";if(substr($str, 0, 3) == "\xEF\xBB\xBF") {
$str = substr($str, 3);
}public function query($sql, $params = []) {
$stmt = $this->db->prepare($sql);
$stmt->execute($params);
return $stmt;
}PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,