How to parse image sizes?

Question

PHP

There is a task to automatically go through the site and calculate the computed size of the images. In principle, the GTmetrix tool does what is needed, but requests for its api are limited.

How can you do it yourself?

Answer 1

PhantomJS + your script for working with the document.

Answer 2

as I understand it, the problem is to calculate the size given by css, the real one can be obtained from getimagesize () for example, with the size on the site, you can use some selenium thread and javascript that will display all image sizes in a separate element. Then it remains to parse this element and that's it.

Answer 3

Alternatively https://regex101.com/r/TYgj87/1

Answer 4

It is not clear what you are trying to output in the statement IF((SELECT disposition FROM cdr WHERE uniqueid = uniqueid)='NO ANSWER','NO ANSWER' ,
'ANSWERED') as disposition
work like this:

SELECT calldate,
src,
dst,
dcontext,
channel,
dstchannel,
lastapp,
lastdata,
duration,
billsec,
MIN(uniqueid) as uniqueid1,
amaflags,
accountcode,
userfield
FROM cdr WHERE src='81113331110'
GROUP BY calldate,
src,
dst,
dcontext,
channel,
dstchannel,
lastapp,
lastdata,
duration,
billsec,
amaflags,
accountcode,
userfield
ORDER BY  (MIN(uniqueid)) DESC

Answer 5

The problem here is
ORDER BY uniqueid DESC
You can't order anything that is defined as an alias.
Try
ORDER BY (MIN(uniqueid)) DESC

Answer 6

I suspect that because of MIN(uniqueid)... ORDER BY uniqueid
Try to remove sorting, or sort by uniqueid1. If this is really the case, you can wrap the query in another SELECT and sort it already.