Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>A secondary approach would be to log processed filename to a log file and compare against directory listing to see if it has been processed.</p> <p>untested again:</p> <pre><code>&lt;?php // Open log file so we can read and put processed image name onto array $imageLogFilename = 'image.log'; $fh = fopen($imageLogFilename,'a+'); $processedFileNames = array(); $newProcessedFileNames = array(); // Read file line by line and add filename onto an array if($fh) { while (($line = fgets($fh)) !== false) { $processedFileNames[] = trim($line); } fclose($fh); } else { die('error - could not open log for reading'); } $imageDirectory = "/home/public_html/images/"; // Path to your images // Read all files in image directory. (You could put this in a function and call recursively if you have child directories.) $files = scandir($imageDirectory); foreach($files as $file) { if($file == '.' || $file == '..') { continue; } // check if this image is in the already processed image array if(in_array($file, $processedFileNames) === false) { // your resize code here if($resizeResult == false) { die('Image Resizing Failed'); } } // Store all images on new array $newProcessedFileNames[] = $file; } if(count($newProcessedFileNames) &gt; 0) { // open logfile again but this time truncate and update with latest image filenames, so its up to date for next run. $fh = fopen($imageLogFilename,'w'); if($fh) { foreach($newProcessedFileNames as $filename) { fwrite($fh,$filename . PHP_EOL); } fclose($fh); } else { die('error - could not write to log file'); } } fclose($fh); ?&gt; </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POIs it possible to run a cron job only on unprocessed files?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USSpringie
    1. USSpringie
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POIs it possible to run a cron job only on unprocessed files?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COOnce again, thank you. I just thought of something... Do you think this idea can work to save on system resources for large quantities: Since each file has a creation date, maybe the PHP script can look at the current day and process only current day images; and ignore all other dates.... However, I do like the 'log processed' solution too
      singulars
      1. PO
      1. USMichael Ryden
    2. COYes you could do that, you just have to think about which way will give you the best outcome. My thinking is checking the actual image dimensions has the least potential for any problems with files getting missed, but is the slowest. The log file way is quicker than reading each image but has a slight chance that if the log corrupts somehow then you will have to check the image dimensions to fix the log. The creation date can work if you can trust the date will never change. Just remember to call `clearstatcache();` if you check the creation time. Or do a mix of log and created time.
      singulars
      1. PO
      1. USSpringie
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload