Learn VBA & Macros in 1 Week!

PHP - Directory Dropdown Problem

Full Excel VBA Course - Beginner to Expert

Directory Dropdown Problem	View Content

I am using the code below to select a folder for an image upload. It works fine in that it does show all of the sub folders of the images folder but the first two options in the dropdown are . and ..

I am not sure where they are coming from (although they do make me think of 'up one level' and 'go to top level option's) but cannot work out how to remove them.

Also, I have been searching for a way to list the folders alphabetically but am stuck on that too!

Thanks in advance for any suggestions
Steve

$dirs = scandir('/path/to/images');
foreach ($dirs as $dir)
{
if (is_dir('/path/to/'.$dir))
{
echo '<option value="'.$dir.'">'.$dir.'</option>';
}
}

Full Excel VBA Course - Beginner to Expert

Similar Tutorials

Assigning A File Directory From Dropdown To Image Upload

Problem Setting Directory

Problem With Getting Directory Listings

Searching Through And Listing A Remote Directory (directory Listings Enabled)

Directory Scan Snippet Problem

Delete Files From Directory / Sub-directory

Dropdown Problem

Problem With Dropdown Filter

Looping Through Dropdown List Problem

Mysql Form Dropdown Box Problem

What Day Is It? Buried Dropdown List Option Problem

Foreach To Create Dropdown List Problem

Echo $form['catcher_id'] Dropdown List Problem

Echo Directory And Sub Directory's

Dynamic Dropdown Question, Submit 2 Values From Dropdown To A Form??

Populate Dropdown On The Basis Of Another Dropdown Value In Php Using Jquery Ajax

Fetching Selected Value From One Dropdown To Populate Another Dropdown

Problem With "sort By" Dropdown Menu?

Dropdown Populating From Another Dropdown

Learn VBA & Macros for Excel in 1 Week!

Assigning A File Directory From Dropdown To Image Upload

Similar Tutorials

I have this code where I add records:

Code: [Select]
<?php

ini_set('display_errors',1);
error_reporting(-1);

require_once ('./includes/config.inc.php');

require_once (MYSQL);

$add_cat_errors = array();

if ($_SERVER['REQUEST_METHOD'] == 'POST')
{
// Check for a name:
if (empty($_POST['product'])) {
$add_cat_errors['product'] = 'Please enter the name!';
}

// Check for a description:
if (empty($_POST['prod_descr'])) {
$add_cat_errors['prod_descr'] = 'Please enter the description!';
}

// Check for a category:
if (!isset($_POST['cat']) || !filter_var($_POST['cat'], FILTER_VALIDATE_INT, array('min_range' => 1))) {
$add_cat_errors['cat'] = 'Please select a category!';
}

// Check for a price:
if (empty($_POST['price']) || !filter_var($_POST['price'], FILTER_VALIDATE_FLOAT) || ($_POST['price'] <= 0)) {
$add_cat_errors['price'] = 'Please enter a valid price!';
}

// Check for a category:
if (!isset($_POST['directory']) || !filter_var($_POST['directory'], FILTER_VALIDATE_INT, array('min_range' => 1))) {
$add_cat_errors['directory'] = 'Please select a directory!';
}

// Check for an image:
if (is_uploaded_file ($_FILES['image']['tmp_name']) && ($_FILES['image']['error'] == UPLOAD_ERR_OK)) {

$file = $_FILES['image'];

$size = ROUND($file['size']/1024);

// Validate the file size:
if ($size > 512) {
$add_cat_errors['image'] = 'The uploaded file was too large.';
}

// Validate the file type:
$allowed_mime = array ('image/jpeg', 'image/JPG', 'image/jpg');
$allowed_extensions = array ('.jpg', 'jpeg');
$image_info = getimagesize($file['tmp_name']);
$ext = substr($file['name'], -4);
if ( (!in_array($file['type'], $allowed_mime))
||   (!in_array($image_info['mime'], $allowed_mime) )
||   (!in_array($ext, $allowed_extensions) )
) {
$add_cat_errors['image'] = 'The uploaded file was not of the proper type.';
}

// Move the file over, if no problems:
if (!array_key_exists('image', $add_cat_errors)) {

// Create a new name for the file:
$new_name = (string) sha1($file['name'] . uniqid('',true));

// Add the extension:
$new_name .= ((substr($ext, 0, 1) != '.') ? ".{$ext}" : $ext);
//$new_name = $dir . '/' . $new_name;
$dest =  "../db/images/$new_name";

// Move the file to its proper folder but add _tmp, just in case:

//$dest =  "../db/images/$new_name";
$dirs = array('full_heads', 'human_hair', 'lip_tattoos', 'ponytails', 'synthetic_hair');

if (move_uploaded_file($file['tmp_name'], $dest)) {

// Store the data in the session for later use:
$_SESSION['image']['new_name'] = $new_name;
$_SESSION['image']['file_name'] = $file['name'];

// Print a message:
echo '<h4>The file has been uploaded!</h4>';

} else {
trigger_error('The file could not be moved.');
unlink ($file['tmp_name']);
}

} // End of array_key_exists() IF.

} elseif (!isset($_SESSION['image'])) { // No current or previous uploaded file.
switch ($_FILES['image']['error']) {
case 1:
case 2:
$add_cat_errors['image'] = 'The uploaded file was too large.';
break;
case 3:
$add_cat_errors['image'] = 'The file was only partially uploaded.';
break;
case 6:
case 7:
case 8:
$add_cat_errors['image'] = 'The file could not be uploaded due to a system error.';
break;
case 4:
default:
$add_cat_errors['image'] = 'No file was uploaded.';
break;
} // End of SWITCH.

} // End of $_FILES IF-ELSEIF-ELSE.

// Check for a stock:
if (empty($_POST['stock']) || !filter_var($_POST['stock'], FILTER_VALIDATE_INT, array('min_range' => 1))) {
$add_cat_errors['stock'] = 'Please enter the quantity in stock!';
}

if (empty($add_cat_errors))
{
$query = "INSERT INTO product (product, prod_descr, catID, price, dirID, image, stock) VALUES (?, ?, ?, ?, ?, ?, ?)";
// Prepare the statement:
$stmt = mysqli_prepare($dbc, $query);
// For debugging purposes:
// if (!$stmt) echo mysqli_stmt_error($stmt);

// Bind the variables:
mysqli_stmt_bind_param($stmt, 'ssssssi', $name, $desc, $_POST['cat'], $_POST['price'], $_POST['directory'], $_SESSION['image']['new_name'], $_POST['stock']);

// Make the extra variable associations:
$name = strip_tags($_POST['product']);
$desc = strip_tags($_POST['prod_descr']);
// Execute the query:
mysqli_stmt_execute($stmt);

if (mysqli_stmt_affected_rows($stmt) == 1) { // If it ran OK.

// Print a message:
echo '<h4>The product has been added!</h4>';

// Clear $_POST:
$_POST = array();

// Clear $_FILES:
$_FILES = array();

// Clear $file and $_SESSION['image']:
unset($file, $_SESSION['image']);

} else { // If it did not run OK.
trigger_error('The product could not be added due to a system error. We apologize for any inconvenience.');
unlink ($dest);
}

} // End of $errors IF.

} else { // Clear out the session on a GET request:
unset($_SESSION['image']);
} // End of the submission IF.

require_once ('./includes/form_functions.inc.php');
?>

<form enctype="multipart/form-data" action="add_product.php" method="post" accept-charset="utf-8">

<input type="hidden" name="MAX_FILE_SIZE" value="524288" />

Product<br /><?php create_form_input('product', 'text', $add_cat_errors); ?>

Description<br /><?php create_form_input('prod_descr', 'textarea', $add_cat_errors); ?>

Category<br /><select name="cat"<?php if (array_key_exists('cat', $add_cat_errors)); ?>>
<option>Select One</option>
<?php // Retrieve all the categories and add to the pull-down menu:
$q = 'SELECT catID, cat FROM category ORDER BY cat ASC';
$r = mysqli_query ($dbc, $q);
while ($row = mysqli_fetch_array ($r, MYSQLI_NUM)) {
echo "<option value=\"$row[0]\"";
// Check for stickyness:
if (isset($_POST['cat']) && ($_POST['cat'] == $row[0]) ) echo ' selected="selected"';
echo ">$row[1]</option>\n";
}
?>
</select><?php if (array_key_exists('cat', $add_cat_errors)) echo $add_cat_errors['cat']; ?>

Price<br /><?php create_form_input('price', 'text', $add_cat_errors); ?>

Directory<br /><select name="directory"<?php if (array_key_exists('directory', $add_cat_errors)); ?>>
<option>Select One</option>
<?php // Retrieve all the categories and add to the pull-down menu:
$q = 'SELECT dirID, directory FROM directory ORDER BY directory ASC';
$r = mysqli_query ($dbc, $q);
while ($row = mysqli_fetch_array ($r, MYSQLI_NUM)) {
echo "<option value=\"$row[0]\"";
// Check for stickyness:
if (isset($_POST['directory']) && ($_POST['directory'] == $row[0]) ) echo ' selected="selected"';
echo ">$row[1]</option>\n";
}
?>
</select><?php if (array_key_exists('directory', $add_cat_errors)) echo $add_cat_errors['directory']; ?>
</select>

Image<br /><?php

// Check for an error:
if (array_key_exists('image', $add_cat_errors)) {

echo $add_cat_errors['image'] . '<br /><input type="file" name="image"/>';

} else { // No error.

echo '<input type="file" name="image" />';

// If the file exists (from a previous form submission but there were other errors),
// store the file info in a session and note its existence:
if (isset($_SESSION['image'])) {
echo "<br />Currently '{$_SESSION['image']['file_name']}'";
}

} // end of errors IF-ELSE.
?>
<br />

Stock<br /><?php create_form_input('stock', 'text', $add_cat_errors); ?>

<input type="submit" value="Add This Product" class="button" />

</fieldset>

</form>

What I want to achieve is this;

When a record is being inserted, a user will make a selection from the dropdown box with a list of directories. Then, a user will upload an image. When a image is uploaded and a directory is chosen, I want the image to be assigned to a specific directory from the list so when the record is inserted, that image will be placed in the specific directory. How do I achieve this please?

Problem Setting Directory

Similar Tutorials

Hello everyone

I'm working on my first website with a image uploader. I am having problems setting the directory that includes 2 folders.

My code is as follows
Code: [Select]
$upload_location = "uploads/".$user."/".$fileName;
$moveResult = move_uploaded_file($fileTmpLoc, $upload_location);
It works when I change the code to ...
Code: [Select]
$upload_location = "uploads/".$user."_".$fileName;
$moveResult = move_uploaded_file($fileTmpLoc, $upload_location);
How can I get it to work with a second folder?

Problem With Getting Directory Listings

Similar Tutorials

I'm using the latest version of XAMPP on Windows and can't figure out why I'm not seeing the correct directory listing when using the scandir() function. The first time i opened the web page I got the correct listing of what was in the directory. After moving and adding files, I opened the web page again and got the same listing I had before i moved and added files. Is this the correct spot to ask this or should I use the XAMPP support forums?

I tried

$path= 'C:\\xampp\\htdocs\\website\\img\';
$listing = scandir($path);
print_r($listing);

I had 5 files in the 'img' directory the first time I opened the website and got the correct listings. I then added 10 new files and moved 2 files out and refreshed the page and got the same listings of the original 5 files. I closed and reopened the browser and tired again and got the original 5 files again.

Searching Through And Listing A Remote Directory (directory Listings Enabled)

Similar Tutorials

Hi guys,

I've been working on a script for a while now,
and I'm sure it doesn't look great and all, and it's probably really messed up..
But right now I've finally got it working!
There's only 1 thing I'd really like to add..
Searching through & listing of remote directories!
The directories I'm trying to list have directory listings enabled,
and I think it *should* be possible.
I just have no clue how.

Here's my current code in a beautiful mix of HTML and PHP:

<?
$border_size = "0";

function returner($what) {
$what=explode("/",$what);
$tps=count($what);
$what=$what[$tps-1];
return $what;
}

$page_url= "";
$home_url=returner(__FILE__);
if(isset($_GET['q'])) {
$qtext=$_GET['q'];
} else {
$qtext="";
}
function getdirsize($directory, $format=FALSE) {
$size = 0;
if(substr($directory,-1) == '/') {
$directory = substr($directory,0,-1);
}
if(!file_exists($directory) || !is_dir($directory) || !is_readable($directory)) {
return -1;
}
if($handle = opendir($directory)) {
while(($file = readdir($handle)) !== false) {
$path = $directory.'/'.$file;
if($file != '.' && $file != '..') {
if(is_file($path)) {
$size += filesize($path);
}
elseif(is_dir($path)) {
$handlesize = getdirsize($path);
if($handlesize >= 0) {
$size += $handlesize;
} else {
return -1;
}
}
}
}
closedir($handle);
}
if($format == TRUE) {
if($size / 1048576 > 1) {
return round($size / 1048576, 1).' MB';
}
elseif($size / 1024 > 1) {
return round($size / 1024, 1).' KB';
} else {
return round($size, 1).' bytes';
}
} else {
return $size;
}
}

if(isset($_GET['type'])){
  $type=$_GET['type'];
} else {
  $type="new";
}

$textures=0;
$models=0;
$avatars=0;
$seqs=0;
$sounds=0;

foreach (glob("textures/*.jpg") as $texture){
$textures++;
}
foreach (glob("models/*.zip") as $model){
$models++;
}
foreach (glob("avatars/*.zip") as $avatar){
$avatars++;
}
foreach (glob("seqs/*.zip") as $seq){
$seqs++;
}
foreach (glob("sounds/*.zip") as $sound){
$sounds++;
}
?>
<!DOCTYPE html>
<html>
<head>
<title>ObjectPath Search</title>
<style type="text/css">
#wrapper {
width: 850px;
margin: 30px auto 30px auto;
padding: 10px;
}

body
{
color:#C6C6C6;
background:#1E1E1E;
/* margin:0; padding:0; */
overflow-x:hidden;
}

#tabs {
font: 85% "Trebuchet MS", sans-serif;
}

.left {
float: left;
}

.right {
float: right;
}

a:link, a:visited, a:active {
color: #3DB015;
text-decoration: none;
}

a:hover {
color: #00E0FF;
}

h2 {
color: #3DB015;
padding-bottom: 0.2em;
font-size: 110%;
}
ul#icon {margin: 0; padding: 0;}
ul#icon li {margin: 1px; position: relative; padding: 1px 0; cursor: pointer; float: left;  list-style: none;}
ul#icon span.ui-icon {float: left; margin: 0 1px;}
</style>
<link type="text/css" href="http://objects.jk-hosting.com/search/css/black-tie/jquery-ui-1.8.2.custom.css" rel="stylesheet" />
<script type="text/javascript" src="http://objects.jk-hosting.com/search/js/jquery-1.4.2.min.js"></script>
<script type="text/javascript" src="http://objects.jk-hosting.com/search/js/jquery-ui-1.8.2.custom.min.js"></script>
<script type="text/javascript">
function formHandler(form){
var URL = document.form.site.options[document.form.site.selectedIndex].value;
window.location.href = URL;
};

$(function(){
// Tabs
$('#tabs').tabs();
});
</script>
</head>
<body>
<div id="wrapper">
<div id="tabs"> 
<ul>
<li><a href="#tab-search">Search</a></li>
<li><a href="#tab-list">List Objects</a></li>
<li><a href="#tab-info">OP info</a></li>
</ul>

<div id="tab-search">
Please enter a string to search for, and choose a folder to search in. <br /><br />
<form name="Search">
<input type='hidden' value='search' name='type'>
<input value='<? print $qtext; ?>' type='text' name='q'>
<select name='map'>
<option selected='selected' value='models'>Models</option>
<option value='avatars'>Avatars</option>
<option value='textures'>Textures</option>
<option value='seqs'>Seqs</option>
<option value='sounds'>Sounds</option></select> <input type='submit' value='Search'>
</form>
</div> 

<div id="tab-list">
Please pick a folder to browse. <br /><br />
<form name="form">
<select name="site" onChange="javascript:formHandler()">
<option value="#">Look in folder...</option>
<option value="<? print $page_url; ?>?type=list&map=models">Models</option>
<option value="<? print $page_url; ?>?type=list&map=avatars">Avatars</option>
<option value="<? print $page_url; ?>?type=list&map=textures">Textures</option>
<option value="<? print $page_url; ?>?type=list&map=seqs">Seqs</option>
<option value="<? print $page_url; ?>?type=list&map=sounds">Sounds</option>
</select>
</form>
</div> 

<div id="tab-info">
The OP currently contains: <br /><br />
<table>
<tr><td><b><? echo $models; ?></b></td> <td>Models</td></tr>
<tr><td><b><? echo $avatars; ?></b></td> <td>Avatars</td></tr>
<tr><td><b><? echo $textures; ?></b></td> <td>Textures</td></tr>
<tr><td><b><? echo $seqs; ?></b></td> <td>Seqs</td></tr>
<tr><td><b><? echo $sounds; ?></b></td> <td>Sounds</td></tr>
</table>
</div> 
</div> 
</div>



<?
if($type=="search" || $type=="list") {
$M=$_GET['map'];
if($type=="search") {
$Q=$_GET['q'];
$empty="Nothing found with <b>\"" . $Q . "\"</b> in it's name.<br />\nPlease make a more general search query, or try a different folder.\n\n";
} else {
$Q="";
$empty='This folder is empty';
}
if($M=="textures") {
$ext="jpg";
} else {
$ext="zip";
}
$i=0;
print "<hr>\n";
$endfile=array();
$endsize=array();
$endsize2=array();
    foreach (glob($M."/*".$Q."*.".$ext) as $filename) {
$filename = explode(".", $filename);
$filename=$filename[0];
$filename = explode("/", $filename);
$filename=$filename[1];
$i++;
$endfile[$i]=$filename;
if($ext=="jpg") {
$endfile[$i]="<a name='".$endfile[$i]."' href='".$pageurl."?type=view&name=".$endfile[$i]."&folder=".$M."&from=".$type."&addon=".$Q."'>".$endfile[$i]."</a>";
}
$endsize[$i]=$size;
$endsize2[$i]=$size2;
}
if($i != 1) {
print "<b>".$i."</b> items were found.\n<hr>\n";
} else {
print "<b>".$i."</b> item was found.\n<hr>\n";
}
    echo("<table width='100%' border='" . $border_size . "' cellspacing='0' cellpadding='0' >\n");
if($i!=0) {
for ($t = 1; $t < $i; $t++) {
$thumbfile = $M."/".$endfile[$t].'.jpg';
if(file_exists($thumbfile)) {
$thumbnail = "<a name='".$endfile[$t]."' href='".$page_url."?type=view&name=".$endfile[$t]."&folder=".$M."&from=".$type."&addon=".$Q."'><ul id='icon'><li class='ui-state-default ui-corner-all' title='".$endfile[$t]."'><span class='ui-icon ui-icon-image'></span></li></ul></a>";
} else {
$thumbnail = "";
}
if($t=="1") {
echo("<tr><td width='10%'>Number</td><td width='3%'><ul id='icon'><li class='ui-state-default ui-corner-all' title='".$endfile[$t]."'><span class='ui-icon ui-icon-image'></span></li></ul></td><td width='60%'>Name</td></tr>\n");
}
echo("<tr><td>" . $t . "</td><td>".$thumbnail."</td><td>" . $endfile[$t] . "</td></tr>\n");
flush();
}
$thumbfile = $M."/".$endfile[$t].'.jpg';
if(file_exists($thumbfile)) {
$thumbnail = "<a name='".$endfile[$t]."' href='".$page_url."?type=view&name=".$endfile[$t]."&folder=".$M."&from=".$type."&addon=".$Q."'><ul id='icon'><li class='ui-state-default ui-corner-all' title='".$endfile[$t]."'><span class='ui-icon ui-icon-image'></span></li></ul></a>";
} else {
$thumbnail = "";
}
echo("<tr><td>" . $t . "</td><td>".$thumbnail."</td><td>" . $endfile[$t] . "</td></tr>\n");
}
print "</table>\n";
if($i=="0") {
print $empty;
}
} elseif($type=="view") {
$filename=$_GET['name'];
$folder=$_GET['folder'];

if($_GET['from']=="list"){
$addon="?type=list&map=".$folder."#".$filename;
}

if($_GET['from']=="search"){
$addon="?type=search&q=".$filename."&map=".$folder."#".$filename;
}
print"<center><a href='".$home_url."'>Home</a></center>";
print "<hr>\n<center><img src='".$folder."/".$filename.".jpg'></img></center>\n<hr>\n<br />\n<a href='".$page_url."".$addon."'>Previous Page</a>\n";
}
$htmlshow="";
if($_GET['type']=="returnOPfile") {
if(isset($_GET['split'])) {
$splitter=$_GET['split'];
} else {
$splitter=" | ";
}
if(isset($_GET['html'])) {
$htmlshow="<br />";
}
foreach (glob("textures/*.jpg") as $texture){
if(isset($_GET['size'])) {
$size=$splitter.filesize($texture);
}
    $texture = explode("/", $texture);
$texture=$texture[1];
print "textures".$splitter.$texture.$size."\n".$htmlshow;
}

foreach (glob("models/*.zip") as $model){
if(isset($_GET['size'])) {
$size=$splitter.filesize($model);
}
    $model = explode("/", $model);
$model=$model[1];
print "models".$splitter.$model.$size."\n".$htmlshow;
}

foreach (glob("avatars/*.zip") as $avatar){
if(isset($_GET['size'])) {
$size=$splitter.filesize($avatar);
}
    $avatar = explode("/", $avatar);
$avatar=$avatar[1];
print "avatars".$splitter.$avatar.$size."\n".$htmlshow;
}

foreach (glob("seqs/*.zip") as $seq){
if(isset($_GET['size'])) {
$size=$splitter.filesize($seq);
}
    $seq = explode("/", $seq);
$seq=$seq[1];
print "seqs".$splitter.$seq.$size."\n".$htmlshow;
}
    foreach (glob("sounds/*.zip") as $sound){
if(isset($_GET['size'])) {
$size=$splitter.filesize($sound);
}
      $sound = explode("/", $sound);
$sound=$sound[1];
print "sounds".$splitter.$sound.$size."\n".$htmlshow;
}
}
?>



</body>
</html>

So right now my question to you PHP freaks is,
can you please help me edit my script so I can search through a remote directory?

*This* is one of the directories I wish to be able to search through & list..

Thanks in advance.

Edit;
It might help if you know what the site currently looks like.
*Click*

Directory Scan Snippet Problem

Similar Tutorials

Hi hi,

CAn anyone tell me why this piece of code doesn't work?

Code: [Select]
<?php
function readDirs($main){
$dirHandle = opendir($main);
while($file = readdir($dirHandle)){
if(is_dir($file) && $file != '.' && $file != '..'){
readDirs($file);
}
else{
echo $file . '<br/>';
}
}
}

$dir = '../../lib';

readDirs($dir);
?>
It must show all the files in the directory, but only shows:
Code: [Select]
.
..
technical

Delete Files From Directory / Sub-directory

Similar Tutorials

i have made an delete files script which works for only one directory but not sub directory so i want to delete files of same extention from directory and subdirectory.

My current code is

Code: [Select]

<?

$dir = 'hmm/';

function scanr($dir){

$arr = glob($dir.'/*.jpg');
foreach($arr as $vv){

//check if $vv is a file
if(is_file($vv)){

//if file, get the filename
$vx=explode('/',$vv);
$file=$vx[count($vx)-1];

// if no extension delete the file
unlink($vv);
// print the deletion message
echo $vv." deleted!<br>";}else{
// if $vv is a dir then scan it again for files
scanr($vv);
}}
}

scanr($dir);
?>

Dropdown Problem

Similar Tutorials

Hi Guys,
I've been pulling my hair out regarding this peoblem. Hope you can help.

On my webpage I have 4 html dropdowns and 2 html textboxs.

What I need to do is populate the 2nd dropdown from the results of the first, populate the 3rd dropdown from the results of the 2nd and finally populate the 2 textboxs from the results of the 4th dropdown.
So far I have been using the $_POST variable to send back to some PHP functions to populate the dropdowns.
To make the dropdowns remember the last selection i've been using 'echo $_POST[' ']' just to show what the user choose before.

My question is; is there a more simple way of doing this because its getting pretty messy.
I've been looking at AJAX but i really dont wanna go there just yet.

Hope you help
TIM

Problem With Dropdown Filter

Similar Tutorials

I have set up a dynamic dropdown to filter records on a page but it is not working and I feel it is down to the way I am using the GET. My guess is that you cannot use dates as a filter in this way but I cannot find any evidence of that through searching, mainly as I do not know what to search for!
The url generated is 'games.php?date=2005-09-03&submit=Filter' so it is passing the data from the dropdown correctly but I am clearly missing something as it just returns that no records have been found.
I am probably missing something simple and am sure that someone on here will spot it within seconds but I am lost. The actual testing page for this, in case you want to have a look at it not working, is http://www.margate-fc.com/content/test/games.php.

As always, any advice would be greatly appreciated!
Steve
The Query Part
// The 'WHERE' bit
if (isset($_GET['date'])) {
    if ($_GET['date'] == "")
    {
        $filter = "";
    }
    else
    {
        $filter = "WHERE date = {$_GET['date']}";
    }
}

// Main Query
$limit = 5;
$all_games = mysql_query("SELECT *, HT.team_name as HomeTeam, VT.team_name as AwayTeam, COMP.comp_short_name as CP
FROM all_games
JOIN teams as HT ON all_games.home_team = HT.team_id
JOIN teams as VT ON all_games.away_team = VT.team_id
JOIN competitions as COMP ON all_games.comp = COMP.comp_id
$filter ORDER BY all_games_id ASC
");
if (!$all_games) {
    die("Query to show fields from table failed");
}

// Filter query
$dates = mysql_query("SELECT DISTINCT date FROM all_games
ORDER BY date ASC
");
The form
Code: [Select]

<form method='get' enctype='text/plain'>
<select size='1' name='date'>
<?php while ($row_dates = mysql_fetch_assoc($dates)){

echo "<option value='".$row_dates['date']."'>".$row_dates['date']."</a></option>";
       }
    ?>

</select>
<input type='submit' name='submit' value='Filter'>
</form>
The table part (excluding header row)
Code: [Select]
<?php if(!mysql_num_rows($all_games)) {
  echo "<tr><td style=\"text-align:left\" COLSPAN=\"8\">No records returned</td></tr>";
} else {
while ($row_all_games = mysql_fetch_assoc($all_games)){

echo '<tr>
   <td style="text-align:left" width="10PX">'.$row_all_games['all_games_id'].'</td>';
if ($row_all_games['date']=="")
echo  '<td>TBA</td>';
  else
echo '<td style="text-align:left" width="100PX">'.date('d M y',strtotime($row_all_games['date'])).'</td>
   <td style="text-align:left">'.$row_all_games['CP'].'</td>
   <td style="text-align:left"> '.$row_all_games['HomeTeam'].'</td>
   <td style="text-align:left"> '.$row_all_games['home_goals']. '</td>
   <td style="text-align:left"> '.$row_all_games['AwayTeam']. '</td>
   <td style="text-align:left"> '.$row_all_games['away_goals']. '</td>
   <td style="text-align:left"> '.$row_all_games['attendance']. '</td>
                  </tr>';
       }}
    ?>

Looping Through Dropdown List Problem

Similar Tutorials

how come the lines:
PHP Code:
echo $form['catcher_id'];

$catcher_names = $form['catcher_id']
foreach($catcher_names as $val)
{
echo "testing loop";
}
produce nothing?? its not doing the foreach.
$form['catcher_id']; is a dropdown list containing catcher names
please help?
thanks

Mysql Form Dropdown Box Problem

Similar Tutorials

Hello, I have been trying to figure this for a while now and reading the tutorials are not helping, I think I'm a little over my head on this one and was hoping someone could help me out with this issue. I am making a User Edit page and would like to have the access level part of the form show the users access current access level thats set in the database when the page loads, and if it needs to be changed you can press the dropdown box and select a new access level. I can't figure out how to show the current access level as default and populate the drop down box with the other access levels in my table. My Tables look like this Users table (users): --------------------------------------------------------------------------------------------------- | id | username | password | flag | realfirst | reallast | dept | --------------------------------------------------------------------------------------------------- 1 loderd 9 test guy Service Auth Table (auth): -------------------------------------------- | id | auth_level | descrip | -------------------------------------------- 1 1 Service Tech 2 2 Office Staff 3 9 Super Admin My SQL Query looks like this

$users = $db->fetch_all_array("SELECT users.id, users.username, users.password, users.realfirst, users.reallast, users.dept, users.flag, auth.auth_level, auth.descrip, auth.id 
							   FROM users LEFT JOIN auth
							   ON users.flag = auth.auth_level
							   WHERE users.id = '".$_GET['id']."'");

I can't seem to figure out how I can do this for the Access Level dropdown box.

                <tr>
                    <td width="19%" align="right" valign="top">Access Level :</td>
                    <td width="1%" align="left">&nbsp;</td>
                    <td width="80%" align="left" valign="top">
						  <?php 
						  echo "<select name='flag' id='flag'>";
						  foreach ($users as $row){
						  if($row[auth_level]==$row[auth_level]){
						  echo "<option value=$row[auth_level] selected>$row[auth_level] - $row[descrip]</option>"; 
						  }else{
						  echo "<option value=$row[auth_level]>$row[auth_level] - $row[descrip]</option>"; 
						  }
						  }
						  echo "</select>";                          ?>
                    </td>
				</tr>

Any help would be greatly appreciated

What Day Is It? Buried Dropdown List Option Problem

Similar Tutorials

Hi, I'll try and keep this brief but it really is a case of searching for needle in a haystack... I've just started working for a UK charity whose main activity is supported by a massive website. Stacks of information sheets, 3 distinct forums (each about the size of Freaks here), numerous blogs, events pages, webinars etc. etc. Essentially, it is an on-line free community that serves the needs of a very sizeable percentage of man and womankind. Like many charities it relies on gratis contributions from those with time or money to spare. I don't have either, but I do believe in what they are doing. The problem is that that the site itself has grown or rather mutated to become a huge data repository, built from a number of contributors with different skills sets and ways of doing things. At the back of it lurks a CMS which staff (a limited number) use to update site content. 95% of the site is in PHP, with a host of other ingredients thrown into the pot (Tiny-MCE, Perl, Ajax, Fancybox, html5, flash, blah and blah). The problem is in the CMS when someone tries to enter a date beyond 2014 there is no option to do so - -.i.e. that's as far as the dropdown goes. I can see the problem but can't find the offending script/files. Anywhere. Here's a snippet from the viewable source for those with keener eyesight:

<form action="index.php?content=data_universal_new&table=events" method="post" ENCTYPE="multipart/form-data" >
<input type="hidden" name="change" value="">
<table summary="" border="0">
<tr>
<td valign="top">Title</td>
<td><input type="text" name="titlex" size="30" maxlength="256" value=""></td>
</tr> <tr>
<td valign="top">Microsite</td>
<td>
<select name="micrositex">
<option value="INF UK" > INF UK</option>
<option value="MTL" > MTL</option>
<option value="ACE BABES" > ACE BABES</option>
</select>
</td>



</tr> <tr>
<td valign="top">Short description</td>
<td><textarea name="short_descriptionx" cols="40" rows="5" ></textarea></td>
</tr> <tr>
<td valign="top">Thumbnail</td>
<td>
<input type="file" name="graphic[thumbnailx]"> <input type="checkbox" name="deletepic[thumbnail]" value="yes"> Delete?
</td>
</tr> <tr>
<td valign="top">Main page</td>
<td>
<div id="tm"><textarea id="elm1" name="main_pagex" style=" height: 400px;width:460px;" class="mceEditor"></textarea></div>
<p>
<script type="text/javascript">


function toggleEditor(id) {
if (!tinyMCE.getInstanceById(id))
tinyMCE.execCommand('mceAddControl', false, id);
else
tinyMCE.execCommand('mceRemoveControl', false, id);
}
</script>
<div><a href="javascript:toggleEditor('elm1');">[Add/Remove editor]</a></div>
<a href="upload.php" title="Upload Documents" class="iframe">Upload Documents</a>
<span class="tooltip" title="Click here to start the document uploader,The documents will be available to link to in the link list drop-down">
<img src="../images/help.png" border="0" width="15" height="15" alt="" align="top" >
</span>
</p>
</td>
</tr> <tr>
<td valign="top">Date</td>
<td>
<select name="date[4]">
<option >1</option>
<option >2</option>
<option >3</option>
<option >4</option>
<option >5</option>
<option >6</option>
<option >7</option>
<option >8</option>
<option >9</option>
<option >10</option>
<option >11</option>
<option >12</option>
<option >13</option>
<option >14</option>
<option >15</option>
<option >16</option>
<option >17</option>
<option >18</option>
<option >19</option>
<option >20</option>
<option >21</option>
<option >22</option>
<option >23</option>
<option >24</option>
<option selected>25</option>
<option >26</option>
<option >27</option>
<option >28</option>
<option >29</option>
<option >30</option>
<option >31</option>
</select>
<select name="date[3]">
<option value="1" >Jan</option>
<option value="2" >Feb</option>
<option value="3" >Mar</option>
<option value="4" >Apr</option>
<option value="5" >May</option>
<option value="6" >Jun</option>
<option value="7" >Jul</option>
<option value="8" >Aug</option>
<option value="9" >Sep</option>
<option value="10" >Oct</option>
<option value="11" selected>Nov</option>
<option value="12" >Dec</option>
</select>
<select name="date[5]">
<option value="2002" >2002</option>
<option value="2003" >2003</option>
<option value="2004" >2004</option>
<option value="2005" >2005</option>
<option value="2006" >2006</option>
<option value="2007" >2007</option>
<option value="2008" >2008</option>
<option value="2009" >2009</option>
<option value="2010" >2010</option>
<option value="2011" >2011</option>
<option value="2012" >2012</option>
<option value="2013" >2013</option>
<option value="2014" selected >2014</option>
</select>
</td></tr> <tr>
<td>&nbsp;</td>
<td><input type="submit" value="Submit"></td>
</tr>
</table>
</form>
</div>
　
　
<div id="man_div">
<p><a href="index.php?content=data_universal_new&add=yes&table=events">Add event</a></p>

Hmm. Any thoughts would be greatly appreciated.
Edited by Ch0cu3r, 25 November 2014 - 07:15 AM.

Foreach To Create Dropdown List Problem

Similar Tutorials

I have the following code which works (thanks to PHP Freaks members)

    foreach ($swap["sims"] as $swap) 
    		{
                    echo $swap['voice'] . "</br>";
			}

But I can't figure out why the following doesn't work

<select name="sim_for_swap[]">
<?php
    foreach ($swap["sims"] as $swap)  
    		{
?>
<option value="<?php echo $swap['voice'];?>"><?php echo $swap['voice'];?></option>
<?php
}
?>

Echo $form['catcher_id'] Dropdown List Problem

Similar Tutorials

the line : echo $form['catcher_id'] gives me a dropdown list

when i choose another item from the dropdown i want to do a few things but my code not working:

$selected_catcher = $form['catcher_id'];
foreach($selected_catcher as $val)
{
$catcher_name = $val->getName();
echo $catcher_name." ".$val->getId();

if ($catcher_name = "zed-catcher")
{
echo $form['service_code']->renderLabel();
echo $form['service_code']->renderError();
echo $form['service_code'];

}
}

please help?
thanks

Echo Directory And Sub Directory's

Similar Tutorials

I'm trying to echo the directory and sub directory only. I am not looking to show the files contained - only folders.

Dynamic Dropdown Question, Submit 2 Values From Dropdown To A Form??

Similar Tutorials

Populate Dropdown On The Basis Of Another Dropdown Value In Php Using Jquery Ajax

Similar Tutorials

I have a form with dropdown list that is populated with values from Sql Server table. Now i would like to use this selected item in SQL query. The results of this query should be shown in label or text field. So when a user selects item from dropdown menu, results from SQL query are shown at the same time.

I have two dropdown list at the moment in my form. First one gets all values from a column in table in SQL Server. And the second one should get a value from the same table based on a selection in first dropdown list.

When i load ajax.php i get 2 error mesages:
Notice: Undefined index: machinery in C:\wamp64\www\gecko\ajaxfile.php on line *8*
Warning: sqlsrv_fetch_array() expects parameter 1 to be resource, boolean given in C:\wamp64\www\site\ajaxfile.php on line *16*

This is my code so far. I have tried to do it with this Ajax script. But i can only get first dropdown to work. The second dropdown(sub_machinery) does not show values, when first dropdown item is selected. The second dropdown should show values from databse table with this query( *$machineryID* is first dropdown selected item): SELECT MachineID FROM T013 WHERE Machinery=".$machineryID.

Index.php

    <!doctype html>
      <?PHP
    $server = "server";
    $options = array(  "UID" => "user",  "PWD" => "pass",  "Database" => 
    "database");
    $conn2 = sqlsrv_connect($server, $options);
    if ($conn2 === false) die("<pre>".print_r(sqlsrv_errors(), true));
    echo " ";
    ?>
    <html>
    <head>
    <meta charset="utf-8">
    <title>Untitled Document</title>
    </head>
    
    <body>
                <section id="formaT2" class="formaT2 formContent">
                <div class="row">
                    <div class="col-md-2 col-3 row-color remove-mob"></div>
                    <div class="col-md-5 col-9 bg-img" style="padding-left: 0; 
    padding-right: 0;">
                        <h1>Form</h1>
                        <div class="rest-text">
                           <div class="contactFrm">
                              <p class="statusMsg <?php echo 
    !empty($msgClass)?$msgClass:''; ?>"><?php echo $statusMsg; ?></p>
                               
                                <form action="connection.php" method="post">
                                    <div>machinery</div>     
    <select id="machinery">
       <option value="0">--Please Select Machinery--</option>
       <?php 
       // Fetch Department
       $sql = "SELECT Machinery FROM T013";
       $machanery_data = sqlsrv_query($conn2,$sql);
       while($row = sqlsrv_fetch_array($machanery_data) ){
          $id = $row['Id'];
          $machinery = $row['Machinery'];
          
          // Option
          echo "<option value='".$id."' >".$machinery."</option>";
       }
       ?>
    </select>
    <div class="clear"></div>
                                    <div>Sub Machinery</div>
    <select id="sub_machinery">
       <option value="0">- Select -</option>
    </select>
                                    
                                    <input type="submit" name="submit" 
    id="submit" class="strelka-send" value="Insert">
                                    <div class="clear"> </div>
                                </form>
                             </div> 
                         </div>
                    </div>
                </div> 
            </section>
             </script>
          <script type="text/javascript">
          $(document).ready(function(){

        $("#machinery").change(function(){
            var machinery_id = $(this).val();
    
            $.ajax({
                url:'ajaxfile.php',
                type: 'post',
                data: {machinery:machinery_id},
                dataType: 'json',
                success:function(response){
    
                    var len = response.length;
     
                    $("#sub_machinery").empty();
                    for( var i = 0; i<len; i++){
                        var machinery_id = response[i]['machinery_id'];
                        var machinery = response[i]['machinery'];
                        
                        $("#sub_machinery").append("<option 
    value='"+machinery_id+"'>"+machinery+"</option>");
    
                    }
                }
            });
        });
    
    });
          </script>
    </body>
    </html>

Ajaxfile.php

<?php
    $server = "server";
    $options = array(  "UID" => "user",  "PWD" => "pass",  
    "Database" => "database");
    $conn2 = sqlsrv_connect($server, $options);
    if ($conn2 === false) die("<pre>".print_r(sqlsrv_errors(), true));
    echo " ";

    $machineryID = $_POST['machinery'];   // department id

    $sql = "SELECT MachineID FROM T013 WHERE Machinery=".$machineryID;
    
    $result = sqlsrv_query($conn2,$sql);
    
    $machinery_arr = array();
    
    while( $row = sqlsrv_fetch_array($result) ){
        $machinery_id = $row['ID'];
        $machinery = $row['MachineID'];
    
        $machinery_arr[] = array("ID" => $machinery_id, "MachineID" => 
    $machinery);
    }
    
    // encoding array to json format
    echo json_encode($machinery_arr);
    ?>

Edited May 6, 2019 by davidd

Fetching Selected Value From One Dropdown To Populate Another Dropdown

Similar Tutorials

Hi freaks,

I'm new to php first of all. I'm dynamically binding a dropdownlist with mysql database . After the user selects an item from it , I want to match that item with another table so as to populate another database.

The code I'm using to populate dropdown:
Code: [Select]
<?php
$con = mysql_connect("localhost","root","");
if(!$con)
{
  die ('Can not connect to : '.mysql_error());
}
mysql_select_db("ims",$con);
$result=mysql_query("select cat_id,cat_name from category");
echo "<select name=cat>";
while($nt=mysql_fetch_array($result))
{
echo "<option value=$nt[cat_id]> $nt[cat_name] </option>";
}
echo "</select>";
        mysql_close($con);
  ?>

Now after the user selects any one of the item , I want to bind another dropdown on the same page using such query like
   $result=mysql_query("select subcategory.sc_id,subactegory.sc_name from subcategory,category where subcategory.sc_id=$nt[cat_id]");

Please anyone tell me the logic and code to do it. Also tell me do I need an intermediate page to post the 1st dropdown value and then continue with 2nd dropdown. I couldn't figure out the concept anyhow.
Help on this will be highly appreiable .
(Tell me if I'm not clear with my question)

Problem With "sort By" Dropdown Menu?

Similar Tutorials

Ok i'm trying to make a dropdown menu to sort content on my site.

The dropdown looks like this:
Code: [Select]
<select>
<option selected="selected">Date</option>
<option>Clicks</option>
<option>Ratings</option>
<option>Comments</option>
</select>
The content that the dropdown needs to sort are taken from my MySQL database and put on the site using these lines of code: (there is alot more code to do other stuff aswell, but that isn't importand for my problem)
$sql = "SELECT * FROM links LIMIT $offset, $rowsperpage";
$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);

$dyn_table = '<table class="main_table">';

while ($row = mysql_fetch_assoc($result)) {
etc...

The dropdown and the php script that inserts the content on the page are (and needs to be) in two seperate files. So how can i make so that when a user selects "Sort by: Clicks" for example, the page refresh and maybe inserts "ORDER BY clicks ASC" into "$sql = "SELECT * FROM links LIMIT $offset, $rowsperpage";"or something?? I'm really open for ideas here, Javascript and jQuery is also welcome if it needs to be used!

Dropdown Populating From Another Dropdown

Similar Tutorials

I am not a developer but I can modify code to work for me. The following code works on my test machine (Windows 10, IIS, PHP 7.4) but doesn't work on my website (cPanel, Some version of Linux, PHP 7.4). The two dropdowns are for State and City. You are supposed to be able to select the state and then select a city from that state then bring up a report for craft breweries in the city. When selecting State from the first dropdown, the page refreshes, the URL is correct with the reports.php?cat=<STATE> so $cat is being set, but the first dropdown no longer has the state selected and the second dropdown is populated with All cities and not just one ones from the selected state. Any ides why this is working fine on one machine and not the other?

Selected code from reports.php

<?php
$cat=$_REQUEST['cat'];

?>
<SCRIPT language=JavaScript>
   <!--
   function reload(form)
   {
       var val=form.cat.options[form.cat.options.selectedIndex].value;
       self.location='reports.php?cat=' + val ;
   }

</script>

<?Php
   ///////// Getting the State from Mysql table for first list box//////////
   $Cyquer2="SELECT DISTINCT breweries.State, states.state FROM breweries INNER JOIN states ON breweries.State=states.abbr ORDER BY states.state";
   $Cyresult2 = mysqli_query($con, $Cyquer2);

   /////// for second drop down list we will check if State is selected else we will display all the cities/////
   if(isset($cat) and strlen($cat) > 0)
   {
       $Cyquer="SELECT DISTINCT City FROM breweries where State='" . $cat . "' order by City";
   }
   else
   {
       $Cyquer="SELECT DISTINCT City FROM breweries order by City";
   }

   $Cyresult1 = $con->query($Cyquer);

   echo "<form method=post action='brewerylistbycity.php'>";
       ////////// Starting of first drop downlist ///////// -->
       echo "<select name='cat' onchange=\"reload(this.form)\"><option value=''>Select State</option>";
           while($Cynoticia2 = mysqli_fetch_array($Cyresult2))
           {
               if($Cynoticia2['State']==@$cat)
               {
                   echo "<option selected value='$Cynoticia2[State]'>$Cynoticia2[state]</option>"."<BR>";

               }
               else
               {
                   echo "<option value='$Cynoticia2[State]'>$Cynoticia2[state]</option>";

               }
           }
       echo "</select>";
       echo "</br>";

       ////////// Starting of second drop downlist /////////
       echo "</br>";
       echo "<select name='subcat' selected=''><option value=''>Select City</option>";
           while($Cynoticia = $Cyresult1->fetch_assoc())
           {
               echo "<option value='$Cynoticia[City]'>$Cynoticia[City]</option>";
           }
       echo "</select></br>";

       //// End Form /////
       echo "<input type=submit value=Submit>";
   echo "</form>";
?>

Php Directory

Similar Tutorials

Hello, can someone please help me make this. I want a simple php directory script that lists files and folders. If a folder is clicked on then open that directory and if a file is clicked on it will download or if its a .txt or picture it will open in the browser. BUT I NEED IT TO LOOK EXACTLY LIKE THIS: http://test512.x10.mx/ which would be the default cpanel indexing but i use godaddy and i dont like there indexing page.

Please help and whoever make it i will provide a subdomain on my website for you to host your stuff.