<?php
    header('Content-Type: text/html; charset=UTF-8');
    $con=new mysqli ("localhost","root","","chroniclemark");
    mysqli_set_charset($con, 'utf8mb4');
    if($con->connect_error)
    {
        echo $con->connect_errno;
        die("Database Connection Failed");
    }


    $sqlget = "SELECT nome FROM galeria";
    $sqldata = mysqli_query($con,$sqlget) or die ('error getting database');

    while ($row = mysqli_fetch_array($sqldata, MYSQLI_ASSOC)) {
        $lol[] = $row['nome'] ;

     }
?>