<?php
//Start Config
$databaseHost = 'localhost';
$databaseName = 'custbahd_tourism';
$databaseUsername = 'custbahd_customassistname';
$databasePassword = 'Rwatangabo1son';
$mysqli = mysqli_connect($databaseHost, $databaseUsername, $databasePassword, $databaseName);
?>
<?php
$host="localhost";//host name
$username="custbahd_customassistname"; //database username
$password="Rwatangabo1son";//database word
$db_name="custbahd_tourism";//database name
$tbl_name="listings"; //table name
$con=mysqli_connect("$host", "$username", "$password","$db_name")or die("cannot connect");//connection string
?>
<?php
define('DB_SERVER', 'localhost');
define('DB_USERNAME', 'custbahd_customassistname');
define('DB_PASSWORD', 'Rwatangabo1son');
define('DB_NAME', 'custbahd_tourism');
/* Attempt to connect to MySQL database */
$link = mysqli_connect(DB_SERVER, DB_USERNAME, DB_PASSWORD, DB_NAME);
// Check connection
if($link === false){
die("ERROR: Could not connect. " . mysqli_connect_error());
}
//End Config
?>
<?php
//Start Conn
$servername='localhost';
$username='custbahd_customassistname';
$password='Rwatangabo1son';
$dbname = "custbahd_tourism";
$conn=mysqli_connect($servername,$username,$password,"$dbname");
if(!$conn){
die('Could not Connect My Sql:' .mysql_error());
}
?>
<?php
//MySQLi Procedural
$conn = mysqli_connect("localhost","custbahd_customassistname","Rwatangabo1son","custbahd_tourism");
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
//End Conn
?>
<?php
//Start Connection
$db = mysqli_connect('localhost', 'custbahd_customassistname', 'Rwatangabo1son') or
die ('Unable to connect. Check your connection parameters.');
mysqli_select_db($db, 'custbahd_tourism' ) or die(mysqli_error($db));
?>
<?php
//for MySQLi OOP
$conn = new mysqli('localhost', 'custbahd_customassistname', 'Rwatangabo1son', 'custbahd_tourism');
if($conn->connect_error){
die("Connection failed: " . $conn->connect_error);
}
//End Connection
?>
<?php
//Start Db
$db = mysqli_connect("localhost","custbahd_customassistname","Rwatangabo1son","custbahd_tourism");
if(!$db)
{
die("Connection failed: " . mysqli_connect_error());
}
//End Db
?>
<?php
//Start Search
$connect = mysqli_connect("localhost", "custbahd_customassistname", "Rwatangabo1son",
"custbahd_tourism");
//End Search
?>
<?php
//Start dbcontroller
class DBController {
private $host = "localhost";
private $user = "custbahd_customassistname";
private $password = "Rwatangabo1son";
private $database = "custbahd_tourism";
private $conn;
function __construct() {
$this->conn = $this->connectDB();
}
function connectDB() {
$conn = mysqli_connect($this->host,$this->user,$this->password,$this->database);
return $conn;
}
function runQuery($query) {
$result = mysqli_query($this->conn,$query);
while($row=mysqli_fetch_assoc($result)) {
$resultset[] = $row;
}
if(!empty($resultset))
return $resultset;
}
function numRows($query) {
$result = mysqli_query($this->conn,$query);
$rowcount = mysqli_num_rows($result);
return $rowcount;
}
}
//End dbcontroller
?>