Add PDF files to be indexed - Solution
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 ?>">
|