75 lines
1.8 KiB
PHP
75 lines
1.8 KiB
PHP
<?php
|
|
|
|
//**URL & FOLDERS**\\
|
|
define('URL', 'pt.kvewijk.nl'); //Base url of site
|
|
define('ROOT', '/'); //Root folder of project (if URL -> /)
|
|
define('PHP', '/php/'); //PHP folder
|
|
|
|
//**DATABASE**\\
|
|
define('DATABASE_NAME', 'kennybo1_portfolio'); //Database name
|
|
define('DATABASE_USER', 'kennybo1_user'); //Database user
|
|
define('DATABASE_PASS', ''); //Database password
|
|
|
|
//-- Global Config Variables --\\
|
|
|
|
function ExceptionHandler($exception) {
|
|
echo "An exception occured: " . $exception->getMessage();
|
|
exit;
|
|
}
|
|
set_exception_handler('ExceptionHandler');
|
|
|
|
|
|
$mysqli = new mysqli("localhost", DATABASE_USER, DATABASE_PASS, DATABASE_NAME);
|
|
|
|
if ($mysqli->connect_errno) {
|
|
echo "Sorry, this website is experiencing problems.";
|
|
echo "Error: Failed to make a MySQL connection, here is why: \n";
|
|
echo "Errno: " . $mysqli->connect_errno . "\n";
|
|
echo "Error: " . $mysqli->connect_error . "\n";
|
|
exit;
|
|
}
|
|
|
|
//Query
|
|
function ExecQuery($sql)
|
|
{
|
|
global $mysqli;
|
|
|
|
if (!$result = $mysqli->query($sql)) {
|
|
echo "Error: Query failed: \n";
|
|
echo "Query: " . $sql . "\n";
|
|
echo "Errno: " . $mysqli->errno . "\n";
|
|
echo "Error: " . $mysqli->error . "\n";
|
|
exit;
|
|
}
|
|
|
|
return $result;
|
|
}
|
|
|
|
define('RANDOM_ALPAHNUMERIC', 0);
|
|
define('RANDOM_NUMERIC', 1);
|
|
define('RANDOM_ALPHA', 2);
|
|
|
|
function RandomString($length, $mode)
|
|
{
|
|
$characters = '';
|
|
|
|
if($mode == RANDOM_ALPAHNUMERIC)
|
|
$characters = '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ';
|
|
else if($mode == RANDOM_NUMERIC)
|
|
$characters = '0123456789';
|
|
else if($mode == RANDOM_ALPHA)
|
|
$characters = 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ';
|
|
|
|
//Generate Session ID
|
|
$str = '';
|
|
for ($i = 0; $i < $length; $i++) {
|
|
$str .= $characters[rand(0, strlen($characters) - 1)];
|
|
}
|
|
|
|
return $str;
|
|
}
|
|
|
|
$connected = true;
|
|
?>
|
|
|