$sql = 'INSERT INTO employees (first_name, second_name, middle_name, id_position) VALUES (?, ?, ?, ?)';
$pdo->prepare($sql)->execute([$_POST['f_name'], $_POST['s_name'], $_POST['m_name'], $_POST['list-position']]);$stmt = $pdo->prepare("SELECT id, name, price, amount FROM table WHERE id = ?");
$stmt->execute([$id]);
$row = $stmt->fetch();$stmt = $mysqli->prepare("SELECT id, name, price, amount FROM table WHERE id = ?");
$stmt->bind_param("i", $id);
$stmt->bind_result($id, $name, $price, $amount);
$stmt->execute();
$rows = array();
while ($stmt->fetch())
$rows[] = array(
'id' => $id;
'name' => $name;
'price' => $price;
'amount' => $amount;
);
}$stmt = $pdo->prepare("SELECT * FROM table WHERE id = ?");
$stmt->execute([$id]);
$rows = $stmt->fetchAll();$check->execute(array(":domainid" => $domainid , ":vhostid" => $vhostid, ":userid" => $login));
$mainname = $check->fetchColumn();
if ($mainname) {}$connect = new PDO("mysql:host=127.0.0.1;dbname=***", "***", "***",[PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]);You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'index)
class article {
public function __construct($pdo)
$this->pdo = $pdo;
}
public function get_all_db() {
$sql = "SELECT `articles_id`, `title`, `keywords`, `description` FROM `articles`";
return $this->pdo->query($sql)->fetchAll();
}
public function get_one_db($id){
$sql = "SELECT `articles_id`, `title`, `keywords`, `description` FROM `articles` WHERE articles_id = ?";
$stmt = $this->pdo->prepare($sql);
$stmt->execute([$id]);
return $stmt->fetch();
}
}Удаленное подключение к Mysql является оправданным решением в разработке системы или же нет?
Подойдет ли Mysql для загруженных систем?
подкиньте литературу, у кого есть по этому направлению?
$name = $mysqli->real_escape_sring($_GET['name']);
$price = $mysqli->real_escape_sring($_GET['price']);
$color = $mysqli->real_escape_sring($_GET['color']);
$sql = "SELECT * FROM goods WHERE name = '$name' and color = '$color' and price > '$price'";
$res = $mysqli->query($sql);
$result = [];
while ($row = mysqli_fetch_assoc($res)) {
$result[] = $row;
}
echo json_encode($result);$stmt = $pdo->prepare("SELECT * FROM goods WHERE name = ? and color = ? and price > ?");
$stmt->execute([$_GET['name'],$_GET['price'],$_GET['color']]);
echo json_encode($stmt->fetchAll());public function countOrders($user_id)
{
$stmt = $this->pdo->prepare("SELECT count(1) FROM orders WHERE user_id =?");
$stmt->execute([$user_id]);
return $stmt->fetchColumn();
}
// и использование
echo $obj->countOrders($_SESSION['user_session']);$data = array(
'email' => $_POST['email'],
'id' => $_POST['id']
);
$res = DB::prepare("UPDATE `users` SET `email` = :email WHERE `id` = :id")->execute($data);$host = '127.0.0.1';
$db = 'test';
$user = 'root';
$pass = '';
$charset = 'utf8';
$dsn = "mysql:host=$host;dbname=$db;charset=$charset";
$opt = [
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
PDO::ATTR_EMULATE_PREPARES => false,
];
$pdo = new PDO($dsn, $user, $pass, $opt);
$ujasnaya_kavychka = '"""""';
// подготавливаем запрос, заменяя все переменные знаками вопроса
$stmt = $pdo->prepare("INSERT INTO table (pole_s_kavychkoy) VALUES (?)");
// исполняем его, передавая все переменные отдельно
$stmt->execute([$ujasnaya_kavychka]);<input type="text" value="<?=row['pole_s_kavychkoy']"><input type="text" value="артель "рога и копыта">
if (isset($this->products[$id])) {
$this->products[$id] = 1;
} else
$this->products[$id]++;
}$pdo->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, FALSE);$pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);