Created
July 14, 2020 17:21
-
-
Save mikelemus27/fb3c1bf213304ffb8d6b0e6aa82c5194 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
/*$direccion = "localhost"; | |
$usuario = "root"; | |
$contrasenia= ""; | |
$BD = "gestion_bd_clase"; | |
$conn = new mysqli($direccion, $usuario, $contrasenia, $BD);*/ | |
/*$driver = 'mysql'; | |
$username = 'root'; | |
$password = 'contrasena'; | |
$host="localhost"; | |
$port = "port=3307"; | |
$db="operaciones";*/ | |
//=============CONECTAR A DATA BASE============================================ | |
/*$database = "dbname=$db"; | |
$dsn = "$driver:host=localhost;$port;$database"; | |
echo " $dsn, "." $username, "." $password, ";*/ | |
try { | |
//$conn = new PDO($dsn, $username, $password); | |
$conn = new PDO('mysql:host=localhost;port=3307;dbname=operaciones', 'root', 'contrasena'); | |
}catch(PDOException $e){ | |
echo $e->getMessage(); | |
} | |
if ($conn ==true) | |
{ | |
echo "\nDatabase Connected\n\n"; | |
} | |
//=================== MOSTRAR PROCEDIMIENTOS EN BD OPERACIONES ========================== | |
try { | |
// select all users | |
$sql = "SHOW PROCEDURE STATUS WHERE DB='operaciones'"; | |
$stmt = $conn->prepare($sql); | |
$stmt->execute(); | |
echo "SHOW PROCEDURE ejecutado\n"; | |
} catch(PDOException $e) { | |
echo $sql . "<br>" . $e->getMessage(); | |
} | |
if ($stmt->rowCount() > 0) { | |
//Row has been found | |
//Do ...... | |
while($row = $stmt->fetch(PDO::FETCH_ASSOC)){ | |
echo "\n\nSi hay procedimientos en bd operaciones\n\n"; | |
foreach($row as $value) | |
{ | |
echo sprintf("%s, ", $value)."<br>"; | |
} | |
echo "\n"; | |
} | |
} else { | |
//No row found | |
//Do.... | |
echo "Consulta sin resultados"; | |
echo "\n"; | |
} | |
echo "\n\n======== Aquí finaliza la consulta de muestra de procedimientos de la bd Operaciones ========<br><br>"; | |
//=================== MOSTRAR PROCEDIMIENTOS DONDE HAY UN PATRÓN ========================== | |
try { | |
// select all users | |
$sql = "SHOW PROCEDURE STATUS LIKE '%suma%'"; | |
$stmt = $conn->prepare($sql); | |
$stmt->execute(); | |
echo "<br>SHOW PROCEDURE LIKE ejecutado<br>"; | |
} catch(PDOException $e) { | |
echo $sql . "<br>" . $e->getMessage(); | |
} | |
if ($stmt->rowCount() > 0) { | |
//Row has been found | |
//Do ...... | |
while($row = $stmt->fetch(PDO::FETCH_ASSOC)){ | |
echo "<br>Si hay procedimientos en la bd Operaciones que corresponden al parámetro de consulta<br>"; | |
foreach($row as $value) | |
{ | |
echo sprintf("%s, ", $value)."\n\n"; | |
} | |
echo "\n"; | |
} | |
} else { | |
//No row found | |
//Do.... | |
echo "Consulta sin resultados"; | |
echo "\n"; | |
} | |
echo "<br>======== Aquí finaliza la consulta de muestra de procedimientos de la bd Operaciones con parámetros ========<br>"; | |
?> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment