connect to database

php

class CDatabase
{
	
	private $con;

	function connect()
	{
		echo "connecting to db ....<br>";

		$con = new mysqli('localhost', 'root', 'root');

		// Check connection
		if (mysqli_connect_errno())
		  {
		  echo "Failed to connect to MySQL: " . mysqli_connect_error();
		  }
		  else
		  {
		  	echo "connected to db ... <br>";
		  }

	}


	function disconnect()
	{
		echo "disconnecting<br>";
		$con->close();
	}

	function createDatabase($name)
	{

	if (mysqli_connect_errno()) {
	  echo('Connect failed: '. mysqli_connect_error());
	}

		echo "create $name <br>";

//		$sql = "CREATE DATABASE `tests` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci";



		if($con->query("CREATE DATABASE test") === TRUE)			
			echo 'Database "tests" successfully created<br>';
		else
			echo "database wasn't created<br>"; 
		
	
	}
}

Neformátovaný

Přidáno: 6.7.2017
Expirace: Neuvedeno

Autor: gomess