Add PDF files to be indexed - Solution

[chazter]

I hope this helps for future reference. In one of my PHP pages, I created a variable in PHP to hold my list of PDF files to be indexed from an array and put that variable in a hidden html tag.

====================
<?php

//Create Query

$sql = ("SELECT * FROM newsdetail");
$mysql_result=mysql_query($sql,$connection);

$num_rows=mysql_num_rows($mysql_result);

//Initialize $listURLAll variable

$listURLAll="";

//Check to see if Query returns Records

if ($num_rows != 0) {

//If records exist create array

while ($row = mysql_fetch_array($mysql_result)) {


//$pID represents a specific category of PDF files

$pID = $row["NewsDetail_ID"];

//Optional Switch Statement. I have pdf files in different locations


switch($pID) {
case 1:
$dir = "filings/";
break;
case 2:
$dir = "advisories/";
break;
case 3:
$dir = "headlines/";
break;
case 4:
$dir = "newsletter/";
break;
case 5:
$dir = "press/";
break;
case 6:
$dir = "reports/";
break;

}

$pTitle = $row["NewsDetail_Title"];
$pFile = $row["NewsDetail_FileName"];
$pext = ".pdf";

//$listURL represents a URL path of a pdf file per record

$listURL=("<a href=$dir$pFile$pext target=blank>$pTitle</a><br>");

//$listURLALL represents a list of URL paths to be appended after each record pass

$listURLAll = $listURLAll.$listURL;

} // End While

} // End If
?>

<!-- hidden text tag, the VALUE represents the $listURLAll to be indexed for the PHPdig spider. -->

<input type="hidden" name="hiddenURL" value="<?php echo $listURLAll ?>">