Skip to content

Instantly share code, notes, and snippets.

@danielbonifacio
Created July 28, 2017 11:24
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save danielbonifacio/a0c1494ab8a3c5ae23c1cc6dbe596cf6 to your computer and use it in GitHub Desktop.
Save danielbonifacio/a0c1494ab8a3c5ae23c1cc6dbe596cf6 to your computer and use it in GitHub Desktop.
Conexão com banco de dados e protege contra SQL Injection
<?php
//Precisa do arquivo de configuração
require_once'config.php';
//Proteção contra SQLInjection
function DBEscape($dados){
$link = DBConnect();
if(!is_array($dados))
$dados = mysqli_real_escape_string($link, $dados);
else{
$arr = $dados;
foreach ($arr as $key => $value) {
$key = mysqli_real_escape_string($link, $key);
$value = mysqli_real_escape_string($link, $value);
$dados[$key] = $value;
}
}
DBClose($link);
return $dados;
}
//Fecha conexão com MySQL
function DBClose($link){
@mysqli_close($link) or die(mysqli_error($link));
}
//Abre conexão com MySQL
function DBConnect(){
$link = @mysqli_connect(DB_HOSTNAME, DB_USERNAME, DB_PASSWORD, DB_DATABASE) or die(mysqli_connect_error());
mysqli_set_charset($link, DB_CHARSET) or die(mysqli_error($link));
return $link;
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment