<?php

/*Подключение к БД для для ЗАДАНИЯ 9
БД: sql_db9
ТАБЛИЦЫ: authors, news
ИЗМЕНЯЮЩЕЕСЯ ПОЛЕ: cipher
*/

/********************подключение к базе данных********************/
    $host = 'localhost';            // адрес сервера
    $database = 'sql_db9';          // имя базы данных
    $user = 'root';                 // имя пользователя
    $password = 'new_password';     // пароль
    $link = mysqli_connect($host, $user, $password, $database)
        or die("Ошибка " . mysqli_error($link));
/********************\подключение к базе данных\********************/


/********************массивы данных для заполнения таблиц********************/
    $author =       ['ivan','alexander','mihail','artyom','vladimir','maria','peter','alexey','dmitry','daniil'];
    $rating = ['9','4','8','3','2','10','6','8','7','5'];

    $author_news = ['vladimir','mihail','alexander','alexey','ivan','dmitry','peter','artyom','maria','daniil'];
    $topic = ['sport','policy','economy','military','security','other','animals','sport','computers','high-tec'];
    $title = ['Russian hockey','Ukrainian crisis','Why the dollar falls','Army 2018','Information in safe','Apartments in Moscow','Dolphins','Russian football','CPUs vulnerabilities','Polymeric materials'];
/********************\массивы данных для заполнения таблиц\********************/

    $query = "DROP TABLE authors";
    $result = mysqli_query($link,$query)
        or die(mysqli_error($link));

    $query = "DROP TABLE news";
    $result = mysqli_query($link,$query)
        or die(mysqli_error($link));

    $query = "CREATE TABLE authors (id int(10) AUTO_INCREMENT, author varchar(20) NOT NULL, rating int(2) NOT NULL, PRIMARY KEY (id));";
    $result = mysqli_query($link,$query)
        or die(mysqli_error($link));

    $query = "CREATE TABLE news (id int(10) AUTO_INCREMENT, topic varchar(20) NOT NULL, title varchar(40) NOT NULL, author varchar(20) NOT NULL, cipher varchar(20) NOT NULL, PRIMARY KEY (id));";
    $result = mysqli_query($link,$query)
        or die(mysqli_error($link));

    for ($i = 0; $i < 10; $i++)
    {
        $key = '';
        $array = array_merge(range('0','9'));
        $c = count($array);
        for ($j = 0; $j < 10; $j++) { $key .= $array[rand(0,$c)]; }

        $query = "INSERT INTO authors (author,rating) VALUES ('$author[$i]','$rating[$i]')";
        $result = mysqli_query($link,$query)
            or die(mysqli_error($link));

        $query = "INSERT INTO news (topic,title,author,cipher) VALUES ('$topic[$i]','$title[$i]','$author_news[$i]','$key')";
        $result = mysqli_query($link,$query)
            or die(mysqli_error($link));
    }

    mysqli_close($link);
    $query = '';
?>