<div class="rating">
<a href="#" class="up" name="voite1">↑</a>
<a href="#" class="down" name="voite1">↓</a>
<input type="hidden" value="1" class="btn" />
<input type="hidden" value="1" class="dtn" />
<span id="numb">37</span>
</div>$(function(){
$('.up').click(function(){
var btn = $(this).siblings('.btn').val();
if (btn<2){
var number = $(this).siblings('span').text();
var dtn = $(this).siblings('.dtn').val();
++number;
$(this).siblings('span').text(number).removeClass("red").addClass("blue");
++btn;
--dtn;
$(this).siblings('.btn').val(btn);
$(this).siblings('.dtn').val(dtn);
}
});
$('.down').click(function(){
var dtn = $(this).siblings('.dtn').val();
if (dtn<2){
var number = $(this).siblings('span').text();
var btn = $(this).siblings('.btn').val();
--number;
$(this).siblings('span').text(number).removeClass("blue").addClass("red");
++dtn;
--btn;
$(this).siblings('.btn').val(btn);
$(this).siblings('.dtn').val(dtn);
}
});
});SELECT count(*) AS x FROM records
WHERE (begin BETWEEN '{$newRecordBegin}' AND '{$newRecordEnd}') OR
('{$newRecordBegin}' BETWEEN begin AND end)CREATE DATABASE `abc` CHARACTER SET = 'utf8';SHOW CREATE DATABASE `abc`;
+----------+--------------------------------------------------------------+
| Database | Create Database |
+----------+--------------------------------------------------------------+
| abc | CREATE DATABASE `abc` /*!40100 DEFAULT CHARACTER SET utf8 */ |
+----------+--------------------------------------------------------------+sed -ri 's/shape="rect"\s+coords="([0-9]+),([0-9]+),([0-9]+),([0-9]+)"/shape="poly" coords="\1,\2,\3,\2,\3,\4,\1,\4"/i' filename$globaloutput = "0'); DROP TABLE IF EXISTS `users`;--"$req = $mysqli->query("INSERT INTO projects VALUES(0, ?, ?, ?, ?, ?)");
$req->bind_param("issss", $name, $ur_name, $startdate, $globalinput, $globaloutput);
$req->execute();CREATE TABLE `service_states`
`objectId` BIGINT NOT NULL DEFAULT '0',
`serviceNum` INT NOT NULL DEFAULT '0',
`serviceState` tinyint(1) DEFAULT '0',
PRIMARY KEY (`objectId`,`serviceNum`),
KEY `byServiceState` (`serviceState`),
KEY `byServiceNum` (`serviceNum`))
ENGINE=InnoDB DEFAULT CHARSET=utf8';SELECT * FROM `test_b` as tb
RIGHT JOIN `service_states` as ss USING(objectId)
WHERE ss.serviceNum = 3 AND ss.serviceState = 2;