Uploading files content to Mysql

[levyta]

I'm new to php and mysql.

My sql server version: 5.1.41

I have table (named: upload) including  two columns:

Filename: varchar(200)

Content: mediumtext

 

I'm trying to upload the content of html files in a directory to the table, using the following php script:

 

<?php

$connection = mysql_connect("localhost","root","mysql")

  or die("ERROR: Could not connect to database!");

  $db = mysql_select_db("try1",$connection)

                    or die ("Couldn't select database");

$directory = "./";

$directory = (!strstr($directory,"*") || $directory =="./" ) ? $directory."*" : $directory;

$files = glob($directory= "*.htm");

for($i=0;$i++){

$href = basename($files[$i]);

$content = file_get_contents ($files[$i]);

mysql_query("INSERT INTO `try1`.`upload` (`name`, `content`) VALUES ('$href','$content')");

}

    mysql_close($connection);

?>

 

None of the files is uploaded. I can't find why.

 

Any help is appreciated.