Untitled

<?php

$dbhost = 'localhost';
$dbuser = 'admin';
$dbpass = 'root';
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');

$dbname = 'files';
mysql_select_db($dbname);


mysql_query("TRUNCATE files_tbl");
$thelist='';
if ($handle = opendir('./pdf/')) {
    while (false !== ($file = readdir($handle)))
    {
        if ($file != "." && $file != ".."){

            if ( ($file = @scandir('./pdf/') && (count($file) > 0) ) ) {

                try{
                    $thelist .= '<font face="Calibri" size="4"><p><b><img src="images/document.png"> '.$file.'<br></b></p></a></font>';
                    $query = "INSERT INTO files.files_tbl(Name) VALUES ('$file');";
                    mysql_query($query) or die('Error, Insert query failed' . mysql_error());
                }catch (Exception $e){
                    die ($e->getMessage);
                }
            }else{
                die($thelist = '<font face="Calibri" size="4"><p><b><img src="images/document.png"> No Files In Database <br></b></p></a></font>');
            }

       }

    }

  closedir($handle);
}


?>

<html>
    <head>
    <link rel="stylesheet" href="style.css" type="text/css">
        <title>Search the Database</title>
    </head>

    <body>

    <div align="right"><form action="search.php" method="post">
    <div align="left"><font face="Arial" size="8" ><b>Document Database</b> </font></div>
     <font face="Arial" size="5px" ><b> Search: <input type="text" name="term" style="border:1px dashed #216DAB"/></b></font>

    &nbsp;

    <input type="image" src="images/search1.png"  name="submit" value="Search" align="right"/>
    </form>
    <hr size="20" noshade="noshade" color="#216DAB">
    </div>
    </body>
</html>

<P><font face="Arial" Size="6px" color="black" ><b>List of files</b></font></p>
<P><center><table border="0" bgcolor="#E0E0E0" style="border:1px dotted black"><td><?=$thelist?></td></table></center></p>