DELIMITER $$
CREATE PROCEDURE build_email_list (INOUT email_list varchar(4000))
BEGIN
DECLARE v_finished INTEGER DEFAULT 0;
DECLARE v_email varchar(100) DEFAULT "";
-- declare cursor for employee email
DEClARE email_cursor CURSOR FOR
SELECT email FROM employees;
-- declare NOT FOUND handler
DECLARE CONTINUE HANDLER
FOR NOT FOUND SET v_finished = 1;
OPEN email_cursor;
get_email: LOOP
FETCH email_cursor INTO v_email;
IF v_finished = 1 THEN
LEAVE get_email;
END IF;
-- build email list
SET email_list = CONCAT(v_email,";",email_list);
END LOOP get_email;
CLOSE email_cursor;
END$$
DELIMITER ;По учебнику Трепачева кстати, да и везде стоит сначала session_start(), и это должно быть правильно.
<?php
if (isset($_POST['do_changes'])){
session_start();
$user = R::findOne('users', 'id = ?', [ $_SESSION['logged_user']['id'] ] );
$user->name = $_POST['new_name'];
$user->email = $_POST['new_email'];
$user->phone = $_POST['new_phone'];
R::store($user);
}$query = mysql_query("INSERT INTO `subs` VALUES ($login,$pass)");
WITH recursive hours (n) AS (
SELECT (@q:=0) n FROM dual
UNION ALL
SELECT (@q:=@q+1) n FROM hours WHERE @q<24
)
SELECT hours.n, ваш_запрос.* FROM ваш_запрос
RIGHT JOIN hours ON ваш_запрос.час = hours.nWITH recursive hours (n) AS (
SELECT CONCAT("0",CAST(@q:=0 as varchar(1))) n FROM dual
UNION ALL
SELECT LPAD(CAST(@q:=@q+1 as varchar(2)),2,"0") n FROM hours WHERE @q<24
)
SELECT hours.n, ваш_запрос.* FROM ваш_запрос
RIGHT JOIN hours ON ваш_запрос.час = hours.nfunction format($size,$prefix=0){
if (is_numeric($size) && $size>=1000 && $prefix<8) {
$size = format(floor($size/1000),$prefix+1);
return $size;
} else {
$prefixName = ["B","KB","MB","GB","TB","PB","EB","ZB","YB"];
return $size . $prefixName[$prefix];
}
}SELECT
CASE WHEN status="В наличии" THEN 1
WHEN status="На заказ" THEN 2
WHEN status="Нет в наличии" THEN 3
ELSE null END sort_id,
*
FROM table$result_array=[];
foreach (array_keys($array1) as $key){
$result_array[$key]=$array2[$key];
}
var_dump($result_array);Warning: Cannot modify header information - headers already sent by (output started at C:\OSPanel\domains\localhost\scripts\create_user.php:1)
$search = array('/(\!)+/', '/(\?)+/', '/(\,)+/', '/(\.){4,}/', '/(\.){2}/');