Your cart is currently empty!
Khóa học miễn phí PHP & MySQL – Create Database nhận dự án làm có lương
PHP & MySQL – Create Database Example
PHP uses mysqli query() or mysql_query() function to create or delete a MySQL database. This function takes two parameters and returns TRUE on success or FALSE on failure.
Syntax
$mysqli->query($sql,$resultmode)
| Sr.No. | Parameter & Description |
|---|---|
| 1 |
$sql Required – SQL query to create a MySQL database. |
| 2 |
$resultmode Optional – Either the constant MYSQLI_USE_RESULT or MYSQLI_STORE_RESULT depending on the desired behavior. By default, MYSQLI_STORE_RESULT is used. |
Example
Try the following example to create a database −
Copy and paste the following example as mysql_example.php −
<html>
<head><title>Creating MySQL Database</title></head>
<body>
<?php
$dbhost = ''localhost
$dbuser = ''root
$dbpass = ''root@123
$mysqli = new mysqli($dbhost, $dbuser, $dbpass);
if($mysqli->connect_errno ) {
printf("Connect failed: %s<br />", $mysqli->connect_error);
exit();
}
printf(''Connected successfully.<br />'');
if ($mysqli->query("CREATE DATABASE TUTORIALS")) {
printf("Database TUTORIALS created successfully.<br />");
}
if ($mysqli->errno) {
printf("Could not create database: %s<br />", $mysqli->error);
}
$mysqli->close();
?>
</body>
</html>
Output
Access the mysql_example.php deployed on apache web server and verify the output.
Connected successfully. Database TUTORIALS created successfully.
Khóa học lập trình tại Toidayhoc vừa học vừa làm dự án vừa nhận lương: Khóa học lập trình nhận lương tại trung tâm Toidayhoc
Leave a Reply