impetrator

Back Back Up Advanced Editor

<?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