- <?php
- $dbhost='localhost';
- $dbuser='root';
- $dbpass='user@123';
- $conn=mysqli_connect($dbhost,$dbuser,$dbpass);
- if($conn->connect_error)
- {
- die("Connection failed:".$conn->connect_error);
- }
- else
- {
- echo "Connected Successfully";
- }
- echo "<br>";
- $sql = "CREATE DATABASE TESTDB";
- echo $sql;
- if (mysqli_query ($conn,$sql))
- {
- echo "Database created successfully";
- }
- else
- {
- echo "Error creating database: " ,mysqli_error($conn);
- }
- ?>