MySql
. 3
MySQL. 4
MySQL. 5
. 7
. , MySql 7
.. 7
-. 8
. 9
. 12
.. 13
, . , .
. . , , . ().
, Web-, MySQL. , . MySQL PHP, PHP MySQL. MySQL SQL.
SQL . SQL : , , , .. , Oracle, Interbase, Microsoft SQL Server.
, MySQL phpMyAdmin.
MySQL
SQL , . SQL . SQL , :
- , ;
- , ;
- , ;
- / , , ;
|
|
- , .
SQL . . . , .
.1
() () 1.. ( ) . 1 customer orders, . , . - orders products. prod_id, , ( custjd). . .
MySQL
PHP-, . , PHP, , , MySQL. , PHP : , , .
, connect.php. , , USE SQL-, , . :
connect.php
<?php
error_reporting(0);
$db_host = 'localhost';
$db_user = 'root';
$db_password = '';
$db_name = 'users';
$link = mysqli_connect($db_host, $db_user, $db_password, $db_name);
if (!$link) {
die('<p style="color:red">'.mysqli_connect_errno().' - '.mysqli_connect_error().'</p>');
}
echo "<p> MySQL!</p>";
, PHP , - , , localhost, " ". :
index.php
<?php
require_once 'connect.php';
?>
<!DOCTYPE HTML>
<html>
<head>
<meta charset="utf-8">
<title> PHP MySQL</title>
</head>
<body>
</body>
</html>
: mysqli_connect , , , .
, ; mysqli_connect() false - , , .
|
|
mysqli_connect_errno() , mysqli_connect_error() - . mysqli_connect , , PHP die, " MySQL!".