{"action":"created","issue":{"url":"https://api.github.com/repos/andredumas/techan.js/issues/74","labels_url":"https://api.github.com/repos/andredumas/techan.js/issues/74/labels{/name}","comments_url":"https://api.github.com/repos/andredumas/techan.js/issues/74/comments","events_url":"https://api.github.com/repos/andredumas/techan.js/issues/74/events","html_url":"https://github.com/andredumas/techan.js/issues/74","id":90547503,"number":74,"title":"techan.js with mysql","user":{"login":"markkomar","id":11874106,"avatar_url":"https://avatars.githubusercontent.com/u/11874106?v=3","gravatar_id":"","url":"https://api.github.com/users/markkomar","html_url":"https://github.com/markkomar","followers_url":"https://api.github.com/users/markkomar/followers","following_url":"https://api.github.com/users/markkomar/following{/other_user}","gists_url":"https://api.github.com/users/markkomar/gists{/gist_id}","starred_url":"https://api.github.com/users/markkomar/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/markkomar/subscriptions","organizations_url":"https://api.github.com/users/markkomar/orgs","repos_url":"https://api.github.com/users/markkomar/repos","events_url":"https://api.github.com/users/markkomar/events{/privacy}","received_events_url":"https://api.github.com/users/markkomar/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/andredumas/techan.js/labels/question","name":"question","color":"cc317c"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-06-24T02:48:53Z","updated_at":"2015-11-08T06:13:39Z","closed_at":null,"body":"Hello, I am new to php and java script. How can I use techan.js with MySQL.? I created separate php file <?php\r\nrequire_once('Db.php');\r\n$db = new Db();\r\n$sql_query = 'select * from history limit 0,10';\r\n$rows = $db->select($sql_query);\r\n$a_json = array();\r\n$a_json_row = array();\r\nforeach ($rows as $row) {\r\n    $a_json_row[\"Date\"] = $row['businessDate'];\r\n    $a_json_row[\"Open\"] =  $row['open'];\r\n    $a_json_row[\"High\"] = $row['high'];\r\n    $a_json_row[\"Low\"] =  $row['low'];\r\n    $a_json_row[\"Close\"] = $row['close'];\r\n    $a_json_row[\"Volume\"] =  $row['volume'];\r\n    array_push($a_json, $a_json_row);\r\n}\r\necho json_encode($a_json);\r\nflush();\r\n?>\r\nthe result is [{\"Date\":\"2009-06-22\",\"Open\":\"18.76\",\"High\":\"18.86\",\"Low\":\"18.34\",\"Close\":\"18.4\",\"Volume\":\"4046000\"},{\"Date\":\"2009-06-22\",\"Open\":\"10.75\",\"High\":\"10.77\",\"Low\":\"10.02\",\"Close\":\"10.02\",\"Volume\":\"44660200\"},{\"Date\":\"2009-06-22\",\"Open\":\"2.57\",\"High\":\"2.57\",\"Low\":\"2.47\",\"Close\":\"2.47\",\"Volume\":\"3949300\"},{\"Date\":\"2009-06-22\",\"Open\":\"0.72\",\"High\":\"0.72\",\"Low\":\"0.72\",\"Close\":\"0.72\",\"Volume\":\"0\"},{\"Date\":\"2009-06-22\",\"Open\":\"25\",\"High\":\"25\",\"Low\":\"25\",\"Close\":\"25\",\"Volume\":\"0\"},{\"Date\":\"2009-06-22\",\"Open\":\"18.94\",\"High\":\"18.97\",\"Low\":\"18.6\",\"Close\":\"18.69\",\"Volume\":\"292200\"},{\"Date\":\"2009-06-22\",\"Open\":\"42.5\",\"High\":\"42.62\",\"Low\":\"41.48\",\"Close\":\"42.25\",\"Volume\":\"1576200\"},{\"Date\":\"2009-06-22\",\"Open\":\"140.67\",\"High\":\"141.56\",\"Low\":\"136.33\",\"Close\":\"137.37\",\"Volume\":\"158728000\"},{\"Date\":\"2009-06-22\",\"Open\":\"0.66\",\"High\":\"0.67\",\"Low\":\"0.62\",\"Close\":\"0.62\",\"Volume\":\"101000\"},{\"Date\":\"2009-06-22\",\"Open\":\"4.73\",\"High\":\"4.82\",\"Low\":\"4.39\",\"Close\":\"4.49\",\"Volume\":\"1480900\"}]\r\n\r\n\r\nI changed d3.csv(\"data.csv\", function(error, data) {\r\n        var accessor = candlestick.accessor(),\r\n            indicatorPreRoll = 33; \r\nto d3.json(\"livedata.php\", function(error, data) {\r\n        var accessor = candlestick.accessor(),\r\n            indicatorPreRoll = 33;  \r\nthe screen is empty :-(\r\nthank you very much in advance.\r\nMark"},"comment":{"url":"https://api.github.com/repos/andredumas/techan.js/issues/comments/154777659","html_url":"https://github.com/andredumas/techan.js/issues/74#issuecomment-154777659","issue_url":"https://api.github.com/repos/andredumas/techan.js/issues/74","id":154777659,"user":{"login":"andredumas","id":1518740,"avatar_url":"https://avatars.githubusercontent.com/u/1518740?v=3","gravatar_id":"","url":"https://api.github.com/users/andredumas","html_url":"https://github.com/andredumas","followers_url":"https://api.github.com/users/andredumas/followers","following_url":"https://api.github.com/users/andredumas/following{/other_user}","gists_url":"https://api.github.com/users/andredumas/gists{/gist_id}","starred_url":"https://api.github.com/users/andredumas/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/andredumas/subscriptions","organizations_url":"https://api.github.com/users/andredumas/orgs","repos_url":"https://api.github.com/users/andredumas/repos","events_url":"https://api.github.com/users/andredumas/events{/privacy}","received_events_url":"https://api.github.com/users/andredumas/received_events","type":"User","site_admin":false},"created_at":"2015-11-08T06:13:39Z","updated_at":"2015-11-08T06:13:39Z","body":"Closing due to no activity"}}