[RESOLVED] Need help creating dropdown list please??

Lee_W

Hi guys,

I am trying to scan a folder & create a dropdown list which contains the contents of the folder but when I run the script there is nothing in the dropdown list.

I have created a function which is below: -

<?php
function pricelist('c:/htdocs/panasonic_system_pricing') {
// Execute code if the folder can be opened, or fail silently
if ($contents = @ scandir('c:/htdocs/panasonic_system_pricing')) {
// initialize an array for matching files
$found = array();
// Create an array of file types
$fileTypes = array('jpg','jpeg','gif','png','pdf','xls','doc');
// Traverse the folder, and add filename to $found array if type matches
$found = array();
foreach ($contents as $item) {
$fileInfo = pathinfo($item);
if (array_key_exists('extension', $fileInfo) && in_array($fileInfo['extension'],$fileTypes)) {
$found[] = $item;
}
}

// Check the $found array is not empty
if ($found) {
  // Sort in natural, case-insensitive order, and populate menu
  natcasesort($found);
  foreach ($found as $filename) {
    echo "<option value='$filename'>$filename</option>\n";
    }
  }
}

}
?>[/B]

Any ideas?

laserlight

Do not use the error suppression operator @ as you need to know what are the errors. So, for starters, change the code to:

<?php
function pricelist($folder) {
    // Execute code if the folder can be opened, or fail silently
    if ($contents = scandir($folder)) {
        // initialize an array for matching files
        $found = array();
        // Create an array of file types
        $fileTypes = array('jpg','jpeg','gif','png','pdf','xls','doc');
        // Traverse the folder, and add filename to $found array if type matches
        $found = array();
        foreach ($contents as $item) {
            $fileInfo = pathinfo($item);
            if (array_key_exists('extension', $fileInfo) && in_array($fileInfo['extension'],$fileTypes)) {
                $found[] = $item;
            }
        }

    // Check the $found array is not empty
    if ($found) {
        // Sort in natural, case-insensitive order, and populate menu
        natcasesort($found);
        foreach ($found as $filename) {
            echo "<option value='$filename'>$filename</option>\n";
        }
    }
}
}

pricelist('c:/htdocs/panasonic_system_pricing');
?>

Notice that I indented the code and posted it within [php][/php] bbcode tags to make it easier to read. I also corrected the code by providing a parameter and showing an example of how pricelist() might be called with your desired folder name.

Lee_W

Thanks Lazerlight.

The first thing I did was remove the error operator but it's giving no errors.

I am also calling the function as per your example.

laserlight

hmm... just in case, but did you remember to print the <select></select> tags?

Lee_W

This should happen in the last line.

Lee_W

This is a copy of the actual form page where I call the function if this helps: -

<?php include('includes/title.inc.php'); ?>

<?php include('includes/panasonic_system_pricelist_upload.inc.php'); ?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"
"http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head>
<title>Trust Distribution Intranet<?php echo "—($title)"; ?></title>
<link rel="stylesheet" type="text/css" href="trust intranet.css" />
</head>

<body>
	<?php include('includes/header.inc.php'); ?>

	<?php include('includes/menu.inc.php'); ?>

	<?php
	//if the form has been submitted, display result
	if (isset($result))
  {
  echo "<p>$result</p>";
  }
?>

<form action="" method="post" enctype="multipart/form-data" name="upload_pricelist" id="upload_pricelist">

  <p>
    <label for="panasonic_system_pricelist">Upload pricelist:</label>
    <input type="hidden" name="MAX_FILE_SIZE" value="<?php echo MAX_FILE_SIZE; ?>" />
    <input type="file" name="panasonic_system_pricelist" id="panasonic_system_pricelist" />
  </p>

  <p>
    <input type="submit" name="upload" id="upload" value="upload" />
  </p>

</form>

<form`action="" method="post" name="download_pricelist" id="download_pricelist">

    <select name="pricelist" id="pricelist">
      <option value="">Select a pricelist</option>

<?php include('includes/panasonic_system_pricelist_dropdown.inc.php');
pricelist('c:/htdocs/panasonic_system_pricing');
?>

    </select>

</form>


	<?php include('includes/footer.inc.php'); ?>

</body>
</html>[/B]

laserlight

In a separate test script, try this:

<?php
function pricelist($folder) {
    // Execute code if the folder can be opened, or fail silently
    if ($contents = scandir($folder)) {
        // initialize an array for matching files
        $found = array();
        // Create an array of file types
        $fileTypes = array('jpg','jpeg','gif','png','pdf','xls','doc');
        // Traverse the folder, and add filename to $found array if type matches
        $found = array();
        foreach ($contents as $item) {
            $fileInfo = pathinfo($item);
            if (array_key_exists('extension', $fileInfo) && in_array($fileInfo['extension'],$fileTypes)) {
                $found[] = $item;
            }
        }

    // Check the $found array is not empty
    if ($found) {
        // Sort in natural, case-insensitive order, and populate menu
        natcasesort($found);
        foreach ($found as $filename) {
            echo htmlspecialchars($filename) . "<br />\n";
        }
    } else {
        echo 'No matches.';
    }
} else {
    echo 'Could not open folder.';
}
}

pricelist('c:/htdocs/panasonic_system_pricing');
?>

Lee_W

Another thing I have noticed is that with the following code the footer is missed off the page as if the footer include file doesn't exist but when I take this code out the footer re-appears:-

<form`action="" method="post" name="download_pricelist" id="download_pricelist">

<select name="pricelist" id="pricelist">
<option value="">Select a pricelist</option>

<?php include('includes/panasonic_system_pricelist_dropdown.inc.php');
pricelist('c:/htdocs/panasonic_system_pricing');
?>

</select>

</form>

Any help would be appreciated.

laserlight

Have you tried my most recent suggestion?

Lee_W

Do I replace the $folder with the directory of the folder I want to scan?

laserlight

Lee W wrote:
Do I replace the $folder with the directory of the folder I want to scan?

No, call the function. The purpose of my suggestion is to determine what is happening in the function.

Lee_W

Sorry not to sure what you mean.

laserlight

This is a statement that calls the function named pricelist:

pricelist('c:/htdocs/panasonic_system_pricing');

It sounds like you need to brush up on your understanding of functions. I suggest that you read the PHP manual on functions.

Lee_W

Laserlight thank you very much for your help.

I know where I went wrong.

It was simple when you look at it.

I was escaping out of the PHP code in the include file & not putting a <?php tag before I call the function on the form page.

However, Having a dropdown list of files is nice but how could I open the file by clicking on it?

Sorry, I did not state that I am a complete beginner with numerous books that I am studying but as you can appreciate they don't fully explain everything so your help is appreciated.