$sql = 'SELECT * FROM vocabulary ORDER BY word_date DESC LIMIT ?, ?';
$lines = $db->query($sql, [$_POST['slimit'], $_POST['limit']]);
public function query($sql, $params = false) {
$query = $this->db->prepare($sql);
if ( $params ) {
$query->execute($params);
}else {
$query->execute();
}
return $query->fetchAll(\PDO::FETCH_ASSOC);
}public function getVars () {
foreach ($_POST as $key => $value) {
$this->$key = $value;
}
}$query = $con->query("SELECT name FROM tbl_name WHERE age='21'");
$arr = $query->fetchAll();
echo $arr[0]['name']; //John
echo $arr[1]['name']; //James
// OR
$query = $con->query("SELECT name FROM tbl_name WHERE age='21'");
while ($row = $query->fetch()) {
echo $row['name'];
}if ( isset($_GET['action']) ) {
$actionName = $_GET['action'];
} else {
$actionName = 'index';
}$actionName = $_GET['action'] ?? 'index';(condition) ? /* value to return if condition is true */
: /* value to return if condition is false */ ;$a = 1;
echo $a === 1 ? 'Переменная $a равна 1' : 'Переменная $a не равна 1';/app/library/widget/)namespace Library\Widget;
use Phalcon\Mvc\User\Component;
class Widget extends Component
{
...
public function output ($widget) { // к примеру
...Форма:
{{ widget.output('Form') }}{% Include('shared/form_view') %}
//или
{{ partial('shared/form_view') }}{{ partial('shared/form_view', ['show_submit':true]) }}$qMarks = str_repeat('?,', count($ids) - 1) . '?';
$sth = $db->prepare("SELECT * FROM `table` WHERE `country` LIKE ? AND `id` NOT IN ($qMarks)");
$sth->execute($ids); // не забыть сделать array_merge с $ids для параметра "LIKE ?"