LtsmrAg4

1<?php
2    $mysqli = new mysqli('localhost', 'root', 'root');
3    if($mysqli->connect_error){
4        die('Errore di connessione (' . $mysqli->connect_errno . ')' . $mysqli->connect_error);
5    }else{
6        echo 'Connesso. ' . $mysqli->host_info . "\n";
7    }
8
9
10    //$query_string = "CREATE DATABASE IF NOT EXISTS corso14";
11    //$mysqli->query($query_string);
12    $query_string = "USE corso13";
13    $mysqli->query($query_string);
14
15    $query_string = "CREATE TABLE IF NOT EXISTS `persone` (
16        `id` INT(10) AUTO_INCREMENT PRIMARY KEY,
17        `nome` VARCHAR(50) NOT NULL,
18        `cognome` VARCHAR(50) NOT NULL,
19        `eta` TINYINT(3) NOT NULL,
20        `email` VARCHAR(50) NOT NULL,
21        `password` VARCHAR(256) NOT NULL
22        )";
23    $mysqli->query($query_string);
24
25    $nome = "Gaetano";
26    $cognome = "Crisafulli";
27    $eta = 54;
28    $email = "gaetano.crisafulli@stevejobs.academy";
29    $password = "Quest@èlamiapassword";
30
31    $password_hash = hash('sha256', $password);
32
33    $query_string = "INSERT INTO `persone` (`id`, `nome`, `cognome`, `eta`, `email`, `password`) 
34                     VALUES (NULL, '$nome', '$cognome', '$eta', '$email', '$password_hash');";
35    $mysqli->query($query_string);
36
37    echo $query_string;
38    /*
39    if($res){
40        echo "Creato";
41    }else{
42        echo "Errore";
43    }
44    */
45
46?>