Welcome aboard! We are happy you are here and wish you good net-raft!
// index.php
<?php
require_once ("/Includes/connectDB.php");
require_once ("/Includes/myfunctions.php");
?>
// connectDB.php
<?php
require_once ("/Includes/myconnectiondata.php");
// Create database connection
$databaseConnection = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
if ($databaseConnection->connect_error)
{
die("Database selection failed: " . $databaseConnection->connect_error);
}
else
{
echo "Connection created!";
}
?>
// myconnectiondata.php
<?php
define('DB_NAME', 'xxx');
define('DB_USER', 'xxx');
define('DB_PASSWORD', 'xxx');
define('DB_HOST', 'localhost');
?>
// myfunctions.php
<?php
insert_record($databaseConnection);
function insert_record($databaseConnection)
{
$query_insert = "INSERT INTO MYTABLE1 (username, password) VALUES ('myuser', 'mypassword')";
if ($databaseConnection->query($query_insert)) {
echo "</br>Record created!";
}
else
{
echo "</br>An error has occurred!";
}
mysqli_close($databaseConnection);
}
?>
The most helpful PHP solutions