Untitled

<!DOCTYPE html>
<html>
    <head>
        <meta charset="UTF-"8>
    </head>
<body>
    <b>
        <span class="cell">File</span>
        <span class="cell">artist</span>
        <span class="year">Year</span>
        <span class="cell">Album</span>
        <span class="year">Number</span>
        <span class="cell">Title</span>
    </b>
    <br>
<?php
$servername = "localhost";
$username = "root";
$password = "kovi66kovi";
?>
<style>
    .cell{
        display: inline-block;
        width: 360px;
    }
    .year{
        display: inline-block;
        width: 100px;
    }
</style>
<?php

//apt-get install php-getid3??
require_once('getid3/getid3.php');
$sBase = $_SERVER['SCRIPT_FILENAME'];
$sBase = substr($sBase, 0, strrpos($sBase, '/')).'/';

listDir($sBase.'music');
function listDir($sDir){
    $sBase = $GLOBALS['sBase'];
    $servername = $GLOBALS['servername'];
    $username = $GLOBALS['username'];
    $password = $GLOBALS['password'];
    try {
//        $rConn = new PDO("mysql:host=$servername;dbname=radio;charset=UTF8", $username, $password);
        $rConn = new PDO("mysql:host=$servername;dbname=radio;", $username, $password);
        $rConn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

//        $rConn->exec("TRUNCATE TABLE playlist");
        $rConn->exec("TRUNCATE TABLE track;");
//        sleep(1);
//        echo "Connected successfully";
        }
    catch(PDOException $e){
        echo "Connection failed: " . $e->getMessage();
        var_dump($e);
    }
    $getID3 = new getID3;
    $sScan = substr($sDir, strrpos($sDir, '/')+1);
    $aDir = scandir($sDir);
    foreach($aDir AS $sElement){
        if($sElement == '.' || $sElement == '..'){
            continue;
        }
        elseif(is_dir($sDir.'/'.$sElement)){
            listDir($sDir.'/'.$sElement);
        }
        else{
            $aFileInfo = $getID3->analyze($sDir.'/'.$sElement);
            getid3_lib::CopyTagsToComments($aFileInfo);
            $aTags = $aFileInfo['id3v1'];

            $artist = $aTags['artist'];
            $title = $aTags['title'];
            $route = str_replace($sBase, '', $sDir).'/'.$sElement;
            $route = utf8_decode($route);
            $year = $aTags['year'];
            $album = $aTags['album'];
            $number = $aTags['track'];

            $sSelect = "SELECT * FROM track WHERE artist = '$artist' AND title = '$title'";
            $sInsert = "INSERT INTO track (route, artist, year, album, number, title) VALUES('$route', '$artist', $year, '$album', $number, '$title')";
            if($title == null){
                $title = $sElement;
                $title = utf8_decode($title);
                $sSelect = "SELECT * FROM track WHERE title = '$title'";
                $sInsert = "INSERT INTO track (route, title) VALUES('$route', '$title')";
            }
            try{
                $rRes = $rConn->query($sSelect);
                if($rRes->rowCount() > 0){
                    echo 'ilyen már van';
                }
                else{
                    $rConn->exec($sInsert);
                }
            } catch (Exception $ex) {
                echo 'hiba:<br>';
                echo $sInsert;
                var_dump($ex);
            }

            echo '<span class="cell">', $sElement, '</span>';
            echo '<span class="cell">', $aTags['artist'], '</span>';
            echo '<span class="year">', $aTags['year'], '</span>';
            echo '<span class="cell">', $aTags['album'], '</span>';
            echo '<span class="year">', $aTags['track'], '</span>';
            echo '<span class="cell">', $aTags['title'], '</span>';
            echo '<br>';
            flush();
        }
    }
}