private function isNormalFileSize($filename) {
clearstatcache(TRUE, $filename); // сброс кэша
return (file_exists($filename) && (filesize($filename) < 1048576));
}
function total_price($cart) {
$total_price = 0.0;
db_connect(); /* Надо переписать на mysqli */
if(is_array($cart)){
$query = $mysqli->prepare("SELECT `price` FROM `sdvd_products` WHERE `id` = ?");
$query->bind_param('i', $id);
$query->bind_result($item_price);
foreach($cart as $id => $qty) {
$query->execute();
if ($query->fetch())
$total_price += $item_price * $qty;
}
$query->close();
}
return $total_price;
}
SELECT `today`.`user_id`, `today`.`value`, `yesterday`.`value`, `users`.`name`
FROM `values` AS `today`
INNER JOIN `values` AS `yesterday` ON `yesterday`.`user_id` = `today`.`user_id`
LEFT JOIN `users` ON `users`.`id` = `values`.`user_id`
WHERE `today`.`date` = CURDATE()
AND `yesterday`.`date` = CURDATE()-INTERVAL 1 DAY
AND `yesterday`.`value` > `today`.`value`
UPDATE `table` SET
`email` = IF(LOCATE('Мыло|', `info`) = 0, NULL,
SUBSTRING_INDEX(SUBSTRING_INDEX(`info`, 'Мыло|', -1), '|', 1)),
`phone` = IF(LOCATE('Телефон|', `info`) = 0, NULL,
SUBSTRING_INDEX(SUBSTRING_INDEX(`info`, 'Телефон|', -1), '|', 1)),
`skype` = IF(LOCATE('Skype|', `info`) = 0, NULL,
SUBSTRING_INDEX(SUBSTRING_INDEX(`info`, 'Skype|', -1), '|', 1));
if (isset($_GET['field'], $_GET['order']) &&
in_array($_GET['field'], $allowedFieldsList) &&
($_GET['order'] == 'desc' || $_GET['order'] == 'asc'))
$_SESSION['sort'] = array('field' => $_GET['field'], 'order' => $_GET['order']);
if (isset($_GET['field'], $_GET['rel']) &&
in_array($_GET['field'], $allowedFieldsList) &&
in_array($_GET['rel'], $allowedRelationsList))
$_SESSION['filter'][$_GET['field']] = array('relation' => $_GET['rel'],
'value1' => $_GET['value1'],
'value2' => $_GET['value2']);