[low priority] 'spider' file

[applebiz89]

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 int 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 int 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);

?>

 

[corbin]

I would guess that the $ are causing problems.

 

 

 

Try changing from double to single quotes.

[applebiz89]

I just tried it. didn't make a difference. even removed the line to see what happened then the error passed onto the next line...not sure what I have done to it for it to do this.

[.josh]

problem is the line before it is missing a ; it helps if you actually post what the error is (or you know, actually read the error).

[applebiz89]

yeah I noticed that after I posted it. but theres another problem..

 

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>";
		}
	}
	}
?>

 

There error is a parse error. Im not sure why this function isnt working...what I want it to do is to stop words from the stop file going into the database...any suggestions?

 

[Ken2k7]

Missing a closing parenthesis on your first if statement.

[.josh]

i count 3 ( in your initial if statement, but only 2 ).  Come on man, syntax errors are not exactly rocket science...

[applebiz89]

ok...could you point what them errors are? Im only new to php so Im not entirely sure what im looking for if there is a problem thats why I posted on the forum

[Potatis]

if(is_bool(strpos($stoplist, $duplicates[i]))

 

should be:

 

if(is_bool(strpos($stoplist, $duplicates[i])))

 

You were missing a closing bracket, like the last 2 replies said.

[applebiz89]

haha cheers. I thought they were talking about '}' s..thats why I was clueless because I couldnt find any