Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I was able to come up with a time-consuming fix to this. Do the images being stored <em>need</em> to be stored with those black borders? It'd be much better if you could run every image with the black borders through the following script (using php to loop through every image in the directory) and let php override the old, black-bordered image with the new, borderless image.</p> <p>The approach I took was to create 4 loops:</p> <ol> <li>To look at black borders on the right (loop through x -> loop through y)</li> <li>To look at black borders on the left (loop through x -> loop through y)</li> <li>To look at black borders on the bottom (loop through y -> loop through x)</li> <li>To look at black borders on the top (loop through y -> loop through x)</li> </ol> <p>Now, each of these loops had another loop in them which would loop through the other coordinate (ie., x->y or y->x). If the inner loop found that one of the pixels lying on the outer loop's line wasn't black, it broke the whole look. If it didn't find that, it would increase one to the counter.</p> <p>At the end, we simply create a new image with the new dimensions and copy from the new to the old one.</p> <pre><code>&lt;?php $image_path = "jcMHt.jpg"; $jpg = imagecreatefromjpeg($image_path); $black = array("red" =&gt; 0, "green" =&gt; 0, "blue" =&gt; 0, "alpha" =&gt; 0); $removeLeft = 0; for($x = 0; $x &lt; imagesx($jpg); $x++) { for($y = 0; $y &lt; imagesy($jpg); $y++) { if(imagecolorsforindex($jpg, imagecolorat($jpg, $x, $y)) != $black){ break 2; } } $removeLeft += 1; } $removeRight = 0; for($x = imagesx($jpg)-1; $x &gt; 0; $x--) { for($y = 0; $y &lt; imagesy($jpg); $y++) { if(imagecolorsforindex($jpg, imagecolorat($jpg, $x, $y)) != $black){ break 2; } } $removeRight += 1; } $removeTop = 0; for($y = 0; $y &lt; imagesy($jpg); $y++) { for($x = 0; $x &lt; imagesx($jpg); $x++) { if(imagecolorsforindex($jpg, imagecolorat($jpg, $x, $y)) != $black){ break 2; } } $removeTop += 1; } $removeBottom = 0; for($y = imagesy($jpg)-1; $y &gt; 0; $y--) { for($x = 0; $x &lt; imagesx($jpg); $x++) { if(imagecolorsforindex($jpg, imagecolorat($jpg, $x, $y)) != $black){ break 2; } } $removeBottom += 1; } $cropped = imagecreatetruecolor(imagesx($jpg) - ($removeLeft + $removeRight), imagesy($jpg) - ($removeTop + $removeBottom)); imagecopy($cropped, $jpg, 0, 0, $removeLeft, $removeTop, imagesx($cropped), imagesy($cropped)); header("Content-type: image/jpeg"); imagejpeg($cropped); //change to `imagejpeg($cropped, $image_path);` to save imagedestroy($cropped); imagedestroy($jpg); </code></pre>
    singulars
    1. This table or related slice is empty.
    1. PORemove black edges from existing image using the GD library
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USjeremy
    1. USjeremy
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PORemove black edges from existing image using the GD library
      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
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COWow nice script! I notice when the script is done loading it shows the newly cropped image, but doesn't replace the old one. How can I replace the old image with the newly cropped image? Also, you were right about it being off by a pixel. The script appears to leave a very slight black border; it's very slight though. Check out the update to my question. I've uploaded an image I used the script on. You'll notice the very slight borders on the left and right. Also, the left side appears to have 1 more pixel than the right. Thanks Nile!
      singulars
      1. PO
      1. USGraham
    2. CONo, I've addressed the ±1px issue by using 8 loops instead of 4. The border you're seeing __is not__ black which is why my script does not crop it out. Check the comment in the script for how to make it save.
      singulars
      1. PO
      1. USjeremy
    3. COThat worked. I'll use it loop through a lot of images and modify the script to detect and work for all file extensions. The slight border left over must be a lighter shade of black or something as you suggested. Dude, nice script! Thanks!
      singulars
      1. PO
      1. USGraham
 

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