SELECT @left_key := `left_key`, @right_key := `right_key`
FROM `tree`
WHERE `id` = $id;
SELECT *
FROM `tree`
WHERE `left_key` <= @left_key AND `right_key` >= @right_key
ORDER BY `left_key`;$byFoo = 0; $foo = '';
$byBar = 0; $bar = '';
if (isset($_GET['foo']) {
$foo = $_GET['foo'];
$byFoo = 1;
}
if (isset($_GET['bar']) {
$bar = $_GET['bar'];
$byBar = 1;
}
$query = "SELECT * FROM `baz` WHERE (? = 0 OR `foo` = ?) AND (? = 0 OR `bar` = ?)";
$mysqli->bind_param('isis', $byFoo, $foo, $byBar, $bar);document.getElementById('id').innerHtml = newContent;$('#id').html(newContent);
SELECT * FROM `streets` WHERE name like '%$b%' LIMIT 1GROUP BY `c`.`id`, только серверу добавится работы.
<form>
<textarea id='test' maxlength='200'></textarea><br>
<span id='rest'></span>
</form>$('#test').on('keydown', function(event) {
var MAXLEN = 200;
var str = $(this).val();
var newLines = str.split('\n').length-1;
var len = str.length+newLines*99;
if (event.which == 13) {
if (len > MAXLEN-100)
return false;
else
newLines++;
}
$(this).attr('maxlength', MAXLEN-newLines*99);
return true;
});
$('#test').on('paste', function(event) {
var MAXLEN = 200;
var str = $(this).val()+event.originalEvent.clipboardData.getData('Text');
var newLines = str.split('\n').length-1;
var len = str.length+newLines*99;
if (len > MAXLEN)
return false;
return true;
});
$('#test').on('keyup', function() {
$('#rest').text($(this).val().length+'/'+$(this).attr('maxlength'));
});