ZingChart how to load latest data after some interval and update chart

ZingChart how to load latest data after some interval and update chart

I am using ZingChart . At loading of the page the chart successfully loads the data from MySql database . But after some interval when the database is updated how to load the latest data ? Please help … Read the rest “ZingChart how to load latest data after some interval and update chart”

PHP Grouping an Array with Multiple Dimensions from database results

PHP Grouping an Array with Multiple Dimensions from database results

I have an array as a result of a database query. Lines include two dimensions and some metrics.
Metrics must be summed by dimension groups.
Here is an example raw data array in table view:

Here is the exact array:… Read the rest “PHP Grouping an Array with Multiple Dimensions from database results”

Cannot properly insert greek characters in mysql database

Cannot properly insert greek characters in mysql database

Our mysql database shows Î Î¿Î»Ï Î³Î»Ï…ÎºÏŒÏ in place of greek characters while sending data from an emulator to a mysql database. Other characters are left ok.
screenshot from phpMyAdmin:

UPDATE:
After using
@Félix Gagnon-Grenier answer in my code it gives me … Read the rest “Cannot properly insert greek characters in mysql database”

How big MySQL table should be before breaking it down to multiple tables?

How big MySQL table should be before breaking it down to multiple tables?

Problem: We have a very big table, and growing. Most of its entries (say 80%) are historical data (with “DATE” field past current date) that are seldom queried, while small part of it (say 20%) are current … Read the rest “How big MySQL table should be before breaking it down to multiple tables?”

how to deal with accents and strange characters in a database?

how to deal with accents and strange characters in a database?

im trying to safe spanish words with accent in my database but it won’t work, i have already tried:
1) changing conllation from tables and rows to utf8_spanish_ci and utf_unicode_ci.
2)adding a header tag with

3)adding
header(“Content-Type: text/html;charset=utf-8”);

in … Read the rest “how to deal with accents and strange characters in a database?”

How to connect mysql in a rails application with docker?

How to connect mysql in a rails application with docker?

I created a rails app use mysql database.
Now want to put them into docker container.
I am using docker, docker-machine, docker-compose.
My docker-compose.yml
db:
image: mysql
environment:
MYSQL_ROOT_PASSWORD: < %= ENV['MYSQL_ROOT_PASSWORD'] %>
ports:
– “3306:3306”

web:
build: .
command: bundle exec rails s … Read the rest “How to connect mysql in a rails application with docker?”