$result = $link->query("SELECT * FROM `Exiting Users` where email='Aruba'");
$user = $result->fetch_assoc();
echo $user ? "Нашол" : "Нинашол";<?php
mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
$link = mysqli_connect("localhost", "tsecret1_Sys", "FB,******0iu", "tsecret1_users");
mysqli_set_charset($mysqli, $charset);
$link->query("CREATE TABLE `tsecret1_users`.`uid ` ( `PassWord` TEXT NOT NULL ) ENGINE = MyISAM");
$link->query("INSERT INTO `uid`(`PassWord`) VALUES (`pass2_hash`");$search = '%'.$_GET['q'].'%';
$sql = "SELECT * FROM questions WHERE body LIKE ? OR title LIKE ?, LIMIT ?,?";
$stmt->prepare($sql);
$stmt->bind_param("ss", $search, $search, $limit, $offset);
$stmt->execute();
$rows = $stmt->get_result()->fetch_all(MYSQLI_ASSOC);class Database
{
public $pdo;
public function __construct()
{
$options = [
\PDO::ATTR_ERRMODE => \PDO::ERRMODE_EXCEPTION,
\PDO::ATTR_DEFAULT_FETCH_MODE => \PDO::FETCH_ASSOC,
\PDO::ATTR_EMULATE_PREPARES => false,
];
$config = require_once 'config.php';
$dsn = 'mysql:host='.$config['host'].';dbname='.$config['db'].';charset='.$config['charset'];
$this->pdo = new \PDO($dsn, $config['username'], $config['password'], $options);
}
public function query($sql, $params)
{
$sth = $this->pdo->prepare($sql);
$sth->execute($params);
return $sth;
}
}$db = new Database();
$sql = "INSERT INTO `reviews`(`id`, `name`, `descriptions`, `url_image`, `rating`) VALUES(:name, :description, :url_image, :rating)";
$db->query($sql, $reviewUser);
echo "Запись успешно создана!";<?php
$login = $_POST['login'] ?? '';
$password = $_POST['password'] ?? '';
$hash = '$2y$10$e6RRGG8zFvsE6Bl7at/Vx./igFslOmnLo6poA6N1QoNWrgrkedHqO';
if ($login !== 'login' || !password_verify($password, $hash)) {
die('Неверный логин');
}
echo 'рендер кода страницы с формами для создания новых файлов на сервере';<img src="../images/lame.jpg">, а <img src="/images/lame.jpg"><?php
require 'mysqli.php';
$query = "INSERT INTO message (name, email, phone, message) VALUES(?,?,?,?)";
$stmt = $mysqli->prepare($query);
$stmt->bind_param("ssss", $name, $email, $phone, $message);
$stmt->execute();
echo "Запись добавлена!";