- <?php
- $dbhost='localhost';
- $dbuser='user';
- $dbpass='root';
- //create connection
- $conn=mysqli_connect($dbhost,$dbuser,$dbpass);
- //check connection
- if($conn->connect_error)
- {
- die("connection failed:".$conn->connect_error);
- }
- else
- {
- echo"connected successfully";
- echo</br>;
- }
- //create database
- $sql="create database testdb"
- if(mysqli_query(.$conn,$sal)
- {
- echo"database created successfully";
- }
- else
- {
- echo "error creating table:".$conn->error;
- }
- mysqli_close($conn);
- ?>