Skip to content

Instantly share code, notes, and snippets.

View mikelemus27's full-sized avatar

Miguel Angel Gallardo Lemus mikelemus27

10 followers · 20 following
View GitHub Profile
@mikelemus27
mikelemus27 / php-pdo-2-mysql-show-procedure-status.php
Created August 17, 2020 05:20
<?php
/*$direccion = "localhost";
$usuario = "root";
$contrasenia= "";
$BD = "gestion_bd_clase";
$conn = new mysqli($direccion, $usuario, $contrasenia, $BD);*/
/*$driver = 'mysql';
@mikelemus27
mikelemus27 / php-pdo-2-mysal-procedures-calculadora-simple.php
Created August 17, 2020 05:10
<?php
if (isset($_GET['Enviar'])) {
//=============CONECTAR A DATA BASE============================================
try {
$conn = new PDO('mysql:host=localhost;port=3307;dbname=operaciones', 'root', 'contrasena');
}catch(PDOException $e){
@mikelemus27
mikelemus27 / php-pdo-2-mysql-create-functions-calculadora-simple.php
Created August 17, 2020 05:07
VIDEO: https://web.microsoftstream.com/video/49b5dd09-a8c1-41c4-926c-c46307678d78
========== CÓDIGO PHP ==========
<?php
//=============CONECTAR A DATA BASE============================================
try {
@mikelemus27
mikelemus27 / mysql-transactions-in-store-proc.sql
Last active July 31, 2020 15:10
#Con IF
DELIMITER $$
CREATE PROCEDURE `sp_fail`()
BEGIN
DECLARE `_rollback` BOOL DEFAULT 0;
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SET `_rollback` = 1;
START TRANSACTION;
INSERT INTO `tablea` (`date`) VALUES (NOW());
INSERT INTO `tableb` (`date`) VALUES (NOW());
@mikelemus27
mikelemus27 / php-mysql-var-proc-call.php
Last active July 16, 2020 19:40
<?php
// this procedures must exts in db
//========================================
// Drop procedure if exists ProcSuma;
// DELIMITER //
// CREATE PROCEDURE ProcSuma(IN nm1 INT, IN nm2 INT, OUT value INT)
// BEGIN
// SET value = nm1+nm2;
// END //
@mikelemus27
mikelemus27 / php-pdo-show-procs-mysql.php
Created July 14, 2020 17:21
<?php
/*$direccion = "localhost";
$usuario = "root";
$contrasenia= "";
$BD = "gestion_bd_clase";
$conn = new mysqli($direccion, $usuario, $contrasenia, $BD);*/
/*$driver = 'mysql';
@mikelemus27
mikelemus27 / mysql-funcion-operaciones-if.sql
Created July 12, 2020 04:39
DROP FUNCTION IF EXISTS operacionesif;
DELIMITER //
CREATE FUNCTION operacionesif(op INT, num1 INT, num2 INT)
RETURNS VARCHAR(255) DETERMINISTIC
BEGIN
IF op=1 THEN
RETURN CONCAT(num1,' + ',num2,' = ',num1+num2);
ELSEIF op=2 THEN
RETURN CONCAT(num1,' - ',num2,' = ',num1-num2);
ELSEIF op=3 THEN
@mikelemus27
mikelemus27 / mysql-trigger2proc-insert.sql
Created July 12, 2020 01:53
DELIMITER //
CREATE PROCEDURE ProcSuma(IN nm1 INT, IN nm2 INT, OUT value INT)
BEGIN
SET value = nm1+nm2;
END; //
CREATE PROCEDURE ProcResta(IN nm1 INT, IN nm2 INT, OUT value INT)
BEGIN
SET value = nm1-nm2;
@mikelemus27
mikelemus27 / mysql-functions-examples.sql
Last active July 10, 2020 15:09
#'\\' is a delimiter
select version() as 'mysql version';
drop function if exists test;
create function test (opcion int,num1 int, num2 int)
returns int
BEGIN
declare res INT DEFAULT 0;
declare mensaje TEXT;
IF opcion=1 THEN
@mikelemus27
mikelemus27 / mysql-loop-1.sql
Created July 10, 2020 05:45
DELIMITER $$
CREATE PROCEDURE `my_proc_LOOP` (IN num INT)
BEGIN
DECLARE x INT;
SET x = 0;
loop_label: LOOP
INSERT INTO number VALUES (rand());
SET x = x + 1;
IF x >= num
THEN