то скрипт наглухо кладет сервер минут на 10
SELECT
`id`,
`viewed`
FROM `class_aqq`
WHERE `user_id` = 6310
ORDER BY `viewed` DESC
LIMIT 1$test находится не сам массив записей, а объект для доступа к результату запроса. Вам же сначала нужно разбирать результат $result = $test->fetch_assoc();, а затем анализировать $result. Сделайте var_dump($result); и сразу поймёте что нужно.
$login = $connection->query('SELECT * FROM `users`');SELECT * FROM `users` WHERE `login` = 'login' AND `password` = 'pass';Начал изучать php
UPDATE `oc_product` SET `image` = REPLACE(`image`, 'к', 'k');$result = $mysqli ->$query($mysqli,$sql);
$result = $mysqli->query($mysqli,$sql);
...
<?php foreach ($post as $users) { ?>
<form method="post" action="nedost.php">
<tbody>
<tr>
<td><input type="hidden" name="form_id" value="<?=$users['id']?>"></td>
<td><?=htmlspecialchars($users['delivery_adress'], ENT_QUOTES)?></td>
<td><?=htmlspecialchars($users['delivery_time'], ENT_QUOTES)?></td>
<td><?=htmlspecialchars($users['surname'], ENT_QUOTES)?> <?=htmlspecialchars($users['name'], ENT_QUOTES)?> <?=htmlspecialchars($users['second_name'], ENT_QUOTES)?></td>
<td><?=htmlspecialchars($users['manager_comment'], ENT_QUOTES)?></td>
<td><button type="submit" formmethod="post" name="delivered" formaction="dost.php" class="btn btn-xs btn-success mb-3" id="delivered">Отдал</button></td>
<td><button type="submit" formmethod="post" name="undelivered" formaction="nedost.php" class="btn btn-xs btn-danger mb-3">Отказ</button></td>
<td><button type="button" formmethod="post" name="delivery" class="btn btn-xs btn-warning mb-3" data-toggle="modal" data-target="#exampleModalLong">Перенос</button></td>
</tr>
</tbody>
</form>
<?php } ?>
...class DBObject
{
protected $db = null;
public function __construct()
{
//Тут код для инициализации соединения с БД
$this->db = $connection;
}
}class Script extends DBObject {
function GetNewOrders() {
$query = $this->db->query(...);
//Ну и так далее
}
}INSERT IGNORE INTO `base_3` (
SELECT
`id` AS `id`,
`name` AS `username`,
`pass` AS `password`,
`email` AS `email`,
NULL AS `ip`,
NULL AS `db`
FROM `base_1`
UNION
SELECT
`id` AS `id`,
`user` AS `username`,
`password` AS `password`,
`email` AS `email`,
`ip` AS `ip`,
NULL AS `db`
FROM `base_2`
)jQuery.getJSON( url [, data ] [, success ] )