I was working on my program the other day, and I decided to add in a function to create database and tables, but since then it is telling me that line 64 being the '$pattern = (\.php)' section has an error...but this was fine before

If anyone could take a look at my code and see if they can spot anything as to why would be greatly appreciated

 
<?php

$dbh = mysql_connect("localhost", "root", "")
  OR die("Unable to connect to MySQL");
print "Connected to MYSQL<br>";

// create database
if (mysql_query("CREATE DATABASE websearcher", $dbh))
  {
  echo "Database created";
  }
else
  {
  echo "Error creating database: ";
  }
// create tables
$selected = mysql_select_db("websearcher", $dbh)
 or die("Could not select websearcher");
$sql_table1 = "CREATE TABLE header
(
headerId integer not null auto_increment,
fileName varchar(255) not null,
primary key headerId
)";
if(mysql_query($sql_table1, $dbh))
{
 print "table 1 created  <p>";
}

$sql_table2 = "CREATE TABLE vals
(
headerFk integer not null,
word varchar(255) not null,
primary key (headerFk, word)
)";
if(mysql_query($sql_table2,$dbh))
{
 print "table 2 created  <p>";
}

function opening($file)
{
$stoplist = "F:/xampplite/htdocs/worksheets/stoplist.txt"
$pattern = "(\.txt$)| (\.php$)";
if(eregi($pattern, $file)){
 $file_handle = fopen($file, "r");
 $contents = file($file);
 if(sizeof($contents)>0)
 {
  $query_header="INSERT INTO HEADER (filename) values ('$file')";
  mysql_query($query_header);
     //get back header id value
  $headerId=mysql_insert_id();
 }
 while (!feof($file_handle)){
  $data = fgets($file_handle);
  $words = explode(' ' , $data);
  $duplicates = array_unique($words);
  sort($duplicates);
  if(is_bool(strpos($stoplist, " $duplicates[i] "))
  foreach($duplicates as $word)
  {
   $word = serialize($word);
   $sql = "INSERT INTO vals (headerFk, word) VALUES($headerId, '$word')";
   if (mysql_query($sql))
   {
    print "successful <p>";
   }
  }
}
}
else {
echo "Cant open that file type <p>"; }
}
 
function getfiles($dirname=".")
{
$pattern = "(\.txt$)| (\.php$)| (\.html)| (\.html)";
$file = array($file);
if($handle = opendir($dirname)) {
 while(false !== ($file = readdir($handle))){
  if(eregi($pattern, $file) || is_dir($file))
  echo "$file <br />";
  opening($file);
 
}
closedir($handle);
}
return($file);
}

getfiles("F:/xampplite/htdocs/worksheets");
 

mysql_close($dbh);
?>

there are two lines having that pattern you mentioned. wonder which one you are having the problem with. or if you are having the problem with both.

but I just have some note concerning the second one

PHP Code:

$pattern = "(\.txt$)| (\.php$)| (\.html)| (\.html)"; 


wonder what is the point you write \.html two times. also wonder why there is no $ sign in the end of .\html while there is one with both txt and php patterns.
may be fixing these things would fix the problem or at least clear up the problem

btw. patterns may work with some php series and doesn't work with the other one. you should also make sure your hosting didn't change php version or something.