PHP - List File In Order

I'm looking to order my upload files in a specific order. I believe the default is a random upload order, but I would like to change this based on the file name, which I'm having difficulty with. The file names would be for example;

'01 smiley'
'02 dog'
'03 cat'

Currently I used a 'Drag & Drop' multiple file upload although this just uploads in any random order to my database table, I'd like to upload it by numeric order as above. Code so far (upload code works, just the order needs work)...

$count = count($_FILES['upload']['name']);
$in=0;

while($in<$count)
{
//upload here
$in++;
}

I think I need to sort()? before my while loop, but having difficulty getting this correct. How would I be able to sort each file into a correct order. Many thanks.
Edited by Veltu, 12 December 2014 - 05:46 AM.

Been looking on the web on and off for the past few days but can't seem to find a list of all file types that PHP (or is it Apache) appreciates.

Like when you go and upload file using a form and then it outputs:

Quote

Array
(
    [upload_file] => Array
        (
            [name] => discount_xcart_orders.csv
            [type] => text/comma-separated-values
            [tmp_name] => /tmp/phprAk2R6
            [error] => 0
            [size] => 674
        )

)



Is there an entire list of file types that this '[type] => text/comma-separated-values' falls under?

Just out of interest of course,
Jeremy.

Hello!

Hi everyone. I'm very new into self learning programming. Presently I'm trying to develop a simple basic Robot that would only Place a Market Order every seconds and it will cancel the Order every followed seconds. Using the following library:
https://docs.b2bx.exchange/en/_docs/api-reference.html#private-api

It would place Trade Order at a ( Price = ex.com api * Binance api Aggregate Trades Price)

I have already wrote the api to call for xe.com exchange rate with php 

<?php

$auth = base64_encode("username:password");
$context = stream_context_create([
    "http" => [
        "header" => "Authorization: Basic $auth"
    ]
]);
$homepage = file_get_contents("https://xecdapi.xe.com/v1/convert_from?to=NGN&amount=1.195", false, $context );
$json = json_decode($homepage, TRUE);
foreach ($json as $k=>$to){
    echo $k; // etc
};


?>

And also for the Binance Aggregate Price in JavaScript

 

<script>
var burl = "https://api3.binance.com";

var query = '/api/v3/aggTrades'; 

query += '?symbol=BTCUSDT';

var url = burl + query;

var ourRequest = new XMLHttpRequest();

ourRequest.open('GET',url,true);
ourRequest.onload = function(){
    console.log(ourRequest.responseText);
}
ourRequest.send();
</script>

  My problem  is how to handle these two api responds  and also the functions to use them to place a trade and cancel it.
Please help me out. Thanks in advance on any help.

Here is how I get categories for article listing. Article can be written in several categories at once. So I have this code:


Code: [Select]
$category = '1,5,23,46'; //Category IDs

$get_cats = explode("," , $category);
$cats = "";

for ($i = 0; $i<count($get_cats); $i++ ) {
$cat  = trim($get_cats[$i]);
$catSlug = get_value_of($cat, "inc/cat_ids.php");
$catName = str_replace("-"," ",$catSlug);
$cats .= "<a href=\"index.php?category=$catSlug\">".strtoupper($catName)."</a>, ";
}
$cats = substr($cats,0,-2);

As you can see there's get_value_of function that is used to read the category from the file. File is cat_ids.php and looks like this:
Quote

1='category-name-1';
2='category-name-2';
3='category name-3';
4='category-name-4';
5='category-name-5';
etc.



I want to improve this in order not to read the file at each step ("for" loop).
Means, one can load the file and then generate a list of (links) category compared to the numbers (Ids).
So if $category is "1,3,4" I want to get list like this (by reading cat_ids.php):
category-name-1, category name-3, category-name-4

With current function I read value for every ID from file in every step. So if article have 10 or more categories script load file 10 or more times. Looking for a solution to do this from a reading file only once.


Thanks.

I'm working on a file uploading project, and I want to let admins restrict the files uploaded to certain files only. Should this be saved in the database, or should I make a file that saves an array?

If I do it via the file method, how would I update an array, say allowed.php?

Example:

How could I change


<?php
$allowed = array('zip', 'png');
?>


To


<?php
$allowed = array('gif', 'png');
?>

I would like to go from a glob list, which is working great, to a download link kinda thing. So, The glob list is shown and each file has a link. The problem is that the download folder for PHP is apparently NOT within my website, but in another portion of the server. Also that when I modify the code to work within the website, it doesnt work. Probably because of the glob array. Anyone have an idea on how to fix this?

Code:
Code: [Select]
<?php
$dir = "/downloads/";
$files = glob($dir."*.zip", GLOB_NOSORT);
// echo'<select name="Files">';
foreach($files as $file){
// echo'<option value="'.$file.'">'.basename($file).'</option>';
echo '<p><a href="/downloads/'.basename($file).'">'.basename($file).'</a></p>';
};
// echo'</select>';
?>

I am getting following notice in code:
Notice:  Undefined offset:  2 in ...
Notice:  Undefined offset: 3 in etc..

I want to get all files from directory with pagination system. It is working, but how to remove this notice (when error_reportings is enabled). Here is code:

    $exts = array('w3g');
    $per_page = 10; // How many files per page
    
    $files = array();
    $dir = opendir($replayLocation);
    while( ($file = readdir($dir)) != false )
    {
        if( !is_dir($file) && !in_array($file,array('.','..')) && in_array(substr($file,strrpos($file,'.')+1),$exts) )
        {
            $files[] = array(
                    'path' => $file,
                    'filename' => pathinfo($file,PATHINFO_BASENAME),
                    'name' => pathinfo($file,PATHINFO_FILENAME)
                );
        }
    }
    closedir($dir);
    
    $file_count = count($files);
    $page_count = ceil( $file_count / $per_page );
    $page = ( isset($_GET['page']) && is_numeric($_GET['page']) ) ? (int) $_GET['page'] : 1;
    if( $page > $page_count )
    {
        $page = $page_count;
    }
    if( $page < 1 )
    {
        $page = 1;
    }

    $offset = ( ( $page - 1 ) * $per_page );
    
    
    for( $i = $offset; $i < ( $offset + $per_page ); $i++ )
    {
        //$files[$i]['path'];
        //$files[$i]['filename'];
       if (file_exists($replayLocation."/".$files[$i]['filename']))
        {
        $current_file = $files[$i]['filename'];
        echo "<a href='./$replayLocation/$current_file'>$current_file</a><br>";
        } 
    }
    
    echo '<br><table><tr><td style="padding-right:24px;" align="right" class="pagination">';
    if( $page > 1 )
    {
        echo ' <a href="./file.php?page=1">&lt;&lt;</a> <a href="./file.php?page=',( $page - 1 ),'">&lt;</a> ';
    }
    $range = 5;
    for( $x = ($page - $range); $x < ( ($page + $range) + 1); $x++ )
    {
        if( $x > 0 && $x <= $page_count )
        {
            if( $x == $page )
            {
                echo ' [ ',$x,' ] ';
            }
            else
            {
                echo ' <a href="./file.php?page=',$x,'">',$x,'</a> ';
            }
        }
    }
    if( $page != $page_count )
    {
        echo ' <a href="./file.php?page=',( $page + 1 ),'">&gt;</a> <a href="./file.php?page=',$page_count,'">&gt;&gt;</a> ';
    }
    echo '</td></tr></table>';

Hello again:

I would like to see if someone can either show me some code, or point me in the direction of a good article about uploading a file (meaning a photo, .JPG, .GIF, etc) via PHP. I have only done this with ASP.

My searches on GOOGLE are only showing me ways to upload a file INTO the database, and I don't believe that is the proper way to do it.

I have always stored the file (.JPG) in a folder called "uploads" and stored the file name (myPhoto.JPG) in the database.

So, if I want to make a Team bio list with a photo, a title, and a description what is the proper way to do that?

Meaning, I click "Add Player" and a form with title, description, and a photo upload field appear. The data is filled out, "Submit" is clicked, and the photo is uploaded to "uploads" and all other data is inserted into the database.

I had wanted to be able to modify, delete, or make inactive each player, and use a dropdown SELECT menu to choose what player to edit.

Any ideas how to accomplish this?

I would appreciate the help!

I am using the following php script to display all the files that are uploaded in a directory on a page. There are two files in the folder I do not want displayed: .htaccess & index.php.

Can someone help me out and provide a little guidance about what I need to do to print all the file names EXCEPT for those two. I imagine some sort of if statement.

CODE:

Top of page: Code: [Select]
<?php
$dirname = ".";
$dir = opendir($dirname);
?>
Body:
Code: [Select]
<?php
while(false != ($file = readdir($dir)))
{
if(($file != ".") and ($file != ".."))
{
echo("<a href='$dirname$file'>$file</a> <br />");
}
}
?>
Thanks so much!

I have some code where i input data and upload images to a database (working 100% correctly)

However I want to expand on it - what I want is when a user uploads an image of their choice, to assign it to a directory of their choosing.

Then, when input is successful, write the directory of where the image is stored (not just the image) to the database.

Here is the code;

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

// Move the file to its proper folder but add _tmp, just in case:
$dest =  "../db/images/$new_name";

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, 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, 'sssssi', $name, $desc, $_POST['cat'], $_POST['price'], $_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_product_errors['cat']; ?>
           
            Price<br /><?php create_form_input('price', 'text', $add_cat_errors); ?>
           
            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 />
<select name="select">
<option value="full_heads">db/images/full_heads</option>
<option value="human_hair">db/images/human_hair</option>
</select>

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


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


</fieldset>

</form>

How do I achieve this?

I've got.

Hi,
In my mysql database i have a text input option, in the registration form and edit my details form i have a multiple select dropdown list, which user selects options to populate the text input box, which ultimately populates the text field in the mysql database.
All works perfectly.

The dropdownlist consists of 3 parts <optgroups> first is current selection (what is the usesr current selection)works fine, The second <optgroup> is existing words, what words we(the site) have given as options, and the third <optgroup> is the words that others have used. This is where im having a small problem.
Because its a text field when i call the data from the database, it calls the entire text box as a single option in my select list..

I want to break the words in the text field (at the comma) and have them listed each one as an option in the select list.


Example what i need:

Words in text box:(my input allows the "comma")
word1, word2, word3, word4, word5, word6,

How i want them called/displayed:
<option value=\"word1\">word1</option>
<option value=\"word2\">word2</option>
<option value=\"word3\">word3</option>
<option value=\"word4\">word4</option>
<option value=\"word5\">word5</option>
<option value=\"word6\">word6</option>

here's my code:
$query = "SELECT allwords FROM #__functions_experience WHERE  profile_id  = '".(int)$profileId."' LIMIT 1";
         $original_functionsexperience =doSelectSql($query,1);
         $query = "SELECT allwords FROM #__functions_experience WHERE  profile_id  = '".(int)$profileId."' LIMIT 1";
         $functionsexperiencelist=doSelectSql($query);
          $funcexpList ="<select multiple=\"multiple\" onchange=\"setFunctionsexperience(this.options)\">";   
         foreach ($functionsexperiencelist as $functionsexperienceal)
            {
            $selected="";
            if ($functionsexperienceals->allwords == $original_functionsexperience)
               $selected=' selected="selected"';
            $allwords=$functionsexperienceal->allwords;
            $funcexpList .= "<optgroup label=\"Current selection\">
            <option value=\"".$allwords."\" ".$selected." >".$allwords."</option>
            </optgroup>      
              <optgroup label=\"Existing Words\">
              <option value=\"existing1,\">existing1</option>
              <option value=\"existing2,\">existing2</option>
              <option value=\"existing3,\">existing3</option>
              <option value=\"existing4,\">existing4</option>
              <option value=\"existing5,\">existing5</option>
              <option value=\"existing6,\">existing6</option>
         </optgroup>
         <optgroup label=\"Others added\">    //heres problem
         <option value=\"".$allwordsgeneral."\">".$allwordsgeneral."</option>
         </optgroup>";
            }
         $funcexpList.="</select>";
         $output['FUNCEXPLIST']=$funcexpList;         
      
         
   The result im getting for optgroup others added:
   word1, word2, word3, word4, word5,

how can i get it like this:
<option value=\"word1\">word1</option>
<option value=\"word2\">word2</option>
<option value=\"word3\">word3</option>
<option value=\"word4\">word4</option>
<option value=\"word5\">word5</option>
<option value=\"word6\">word6</option>

Hi , I have one question .. Can I split showing of content of dynamic list in 2 parts , when I echo list in code ..

Code: [Select]
<?php 
// Run a select query to get my letest 8 items
// Connect to the MySQL database  
include "../connect_to_mysql.php"; 
$dynamicList = "";
$sql = mysql_query("SELECT * FROM products ORDER BY date_added DESC LIMIT 8");
$productCount = mysql_num_rows($sql); // count the output amount
if ($productCount > 0) {
while($row = mysql_fetch_array($sql)){ 
             $id = $row["id"];
 $product_name = $row["product_name"];
 $price = $row["price"];
 $date_added = strftime("%b %d, %Y", strtotime($row["date_added"]));
 $dynamicList .= '<table width="100%" border="2" cellspacing="2" cellpadding="2">
        <tr>
          <td width="17%" valign="top"><a href="product.php?id=' . $id . '"><img style="border:#666 1px solid;" src="inventory_images/' . $id . '.jpg" alt="' . $product_name . '" width="77" height="102" border="2" /></a></td>
          <td width="83%" valign="top">' . $product_name . '<br />
            $' . $price . '<br />
            <a href="product.php?id=' . $id . '">View Product Details</a></td>
        </tr>
      </table>';
    }
} else {
$dynamicList = "We have no products listed in our store yet";
}
mysql_close();
?>


Code: [Select]
<p><?php echo $dynamicList; ?><br />
</p>
It works ok, and putting my files, everything works, but when I put 8 pictures with price and other details, it just show one image with details and another image below with details, and the third image below and so on ..
Can I split dynamic list to show 4 images with details on the left side and 4 on the right side?

Thank you in advance for help , if is possible