1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
|
$link = mysql_connect("xxx", "xxx", "xxx") or die("Impossible de se connecter : " . mysql_error());
echo 'Connecté correctement';
mysql_select_db("cg90", $link) or die('Could not select database.');
mysql_query("--
-- DELIMITER ;
--
-- Fonctions
--
CREATE DEFINER=`root`@`%` FUNCTION `validation_CircuitPluginSpe`(
input TEXT,
delimiter VARCHAR(10),
valeur varchar(255)
) RETURNS int(11)
SQL SECURITY INVOKER
BEGIN
DECLARE retour INT;
call split_string(input,delimiter);
SELECT COUNT(*) INTO retour FROM SplitValues WHERE valeur IN (SELECT * FROM SplitValues);
RETURN retour;
END")or die('Requête invalide : ' . mysql_error());
mysql_close($link); |
Partager