How to extract MySQL data monthwise and daywise to populate table to draw graph using PHP libchart? -

-

I have a table that has call_id, timestamp, date, firstname, last_name, status and so on. < / P>

What do I need to do to draw the graph by data, filtered according to their dates. This is for month-to-date graphs, I need to position = accept the number of rows that are approved for each day of the month according to the current date.

And, for the year-to-date article

My idea of ​​doing this is -

For months-to-to-time, Date: 

  $ temp = date ("Ym-"); While ($ i & lt; = Date ("D")) {$ query = "Main WHERE Status =" Approved "and Call = '". $ Temp $ I. Select from "" "call_id; $ result = mysql_query ($ query, $ link) or die (" ", mysql_error ()); $ count [i] = mysql_num_rows ($ result);}    
 And then I was thinking of pursuing these meanings in the array in the other temporary tables (YTD for one and one for MTD) by a "floating" loop and then Drawing articles from those tables using PHP Libertarch  
 Is there a better way to do this? Or is this the only way?   
 
 
 You can make it very easy to get rid of it using mysql and lots of your Php loops such as for the month date:  
  $ query = "Select COUNT (call_id) as 'num_records', from the main WHERE state, date = 'approved' and concrete (year) , Date (date)) = CONCAT (year (now ()), date by date (now ()) group   
 This query will show a row that date and total records on that day For every day For Heine.

Comments

Post a Comment

Popular posts from this blog

mysql - BLOB/TEXT column 'value' used in key specification without a key length -

-
I have developed an extension which works up to 1.6 on Magren (I'm trying Enterprise Edition, And I think the community is the same problem, because it is the same code). In my install script, I see the $ installer-> gt; CreateEntityTables ($ this- & gt; getTable ('alphanum / info')); The installation is done until it is not in the _text unit table. It crashed there! It turns out that when I log in to SQL and run it via PHPmyadmin, then this error is: Blob / Text column 'value' is used without the key 'key' . I saw the code there, and this is what is trying to create an index on the value column: -> addIndex ($ this- & gt; getIdxName ($ eavTableName, array ( 'attribute_id array (' attribute_id ',' value ')) - & gt; addIndex ($ this- & gt; getIdxName ($ eavTableName, array (' entity_type_id ' , 'Value')), array ('entity_type_id', 'value')) If there is no if statement is n...
Read more

memcached - Django cache performance -

-
We are now using Redis for in-memory cache for our Django application (we used the first memcatch The difference in performance is no big, and we're using Redis because the disc dump feature). The problem is that Django cache's performance in my view - terrible, we have a view with 102 cache hits (no miss), and it has 81 ms (only the cash part, which is with the DJBugBug toolbar Is measured). In my opinion - this is a very long time, I know, asking for a question for DB can be 10x more (or 100x) time, but that is also not good with cash performance of that fact. We are running radis (and the first memacatch) on different hosts, connected to the local network with other servers. Is there a way to maximize cache performance in Django? Instead of displaying problem cache, there is a possibility of the number of items to be received for each page 102 Cash calls mean long time lost due to network latency. With full control of the code, you may be able to fix it with m...
Read more