SQL-сервер и его использование

Базы данных

mySQL

Реляционная база данных.

apt-get install mysql-server

mysql -uroot -p

create database users;
use users;
create table person (
	id INT AUTO_INCREMENT PRIMARY KEY, 
	name CHAR(50), 
	year_of_birth INT, 
	comment TEXT);
show tables;
INSERT INTO person (name, year_of_birth, comment) 
VALUES 
	("Vasya", 1950, "blah-blah-blah"), 
	("Petya", "2000", "Tra-ta-ta");
	
SELECT * FROM person;

UPDATE person SET name = "Petya II" 
WHERE year_of_birth = 1950;

DELETE FROM person WHERE name LIKE '%II';

apt-get install phpmyadmin

Взаимодействие с базами из php

### Осторожно, быдлокод!

<?php
	$link = mysql_connect(
		'localhost', 
		'root', 
		'123');
	
	mysql_select_db("users") or die("Could not select db");
	
	$results = mysql_query("SELECT * FROM person");
	
?>
	<table cellpadding="0" cellspacing="0" style="border: solid 1px black">
<?php
	while ($row = mysql_fetch_assoc($results))
	{
?>
		<tr style="border: solid 1px black">
<?php
		echo "<td style='padding: 3px; border: solid 1px'>".$row["name"]."</td>";
		echo "<td style='padding: 3px; border: solid 1px'>".$row["year_of_birth"]."</td>";
		echo "<td style='padding: 3px; border: solid 1px'>".$row["comment"]."</td>";
?>
		</tr>
<?php
	}
?>

	</table>

Written on May 11, 2016