d3.js - how to visualize data from mysql database in force layout of d3 tool -



d3.js - how to visualize data from mysql database in force layout of d3 tool -

i need help d3 , mysql. below question:

i using d3 forcefulness directed layout visualize info stored in mysql. want visualize using d3. far knowledge of d3 goes, requires json file input contain nodes , links. question is: how access mysql database d3 script in specified format? want kind of input d3 tool. please help me.

{"nodes":[{"name":"myriel","group":1}, {"name":"mlle.baptistine","group":1}, {"name":"mme.hucheloup","group":1}], "links":[{"source":1,"target":0,"value":1}, {"source":2,"target":0,"value":8}, {"source":3,"target":0,"value":10}]}

there blog post here on using mysql database d3 http://www.d3noob.org/2013/02/using-mysql-database-as-source-of-data.html.

the key have phone call info in d3 phone call php script returns info in format d3 expects.

for instance line;...

d3.json("php/data2.php", function(error, data) {

... is telling d3 info in json format, it's calling php script doing querying of database , returning info in json format;

here's script (data2.php) calling;

<?php $username = "homedbuser"; $password = "homedbuser"; $host = "localhost"; $database="homedb"; $server = mysql_connect($host, $username, $password); $connection = mysql_select_db($database, $server); $myquery = " select `date`, `close` `data2` "; $query = mysql_query($myquery); if ( ! $myquery ) { echo mysql_error(); die; } $data = array(); ($x = 0; $x < mysql_num_rows($query); $x++) { $data[] = mysql_fetch_assoc($query); } echo json_encode($data); mysql_close($server); ?>

d3.js force-layout

Comments

Post a Comment

Popular posts from this blog

javascript - mongodb won't find my schema method in nested container -

javascript - mongodb won't find my schema method in nested container - i trying access method of schema stored within mixed container. here situation : have cases model can many different things, have schema each of these things stored in "casecontent" mixed property. var caseschema = mongoose.schema({ casecontent : {}, object : {type:string, default : "null"}, collision : {type : boolean, default : false} }); the casecontent property filled model of 1 of schemas, 1 exemple : var treeschema = new mongoose.schema({ applecount : {type : number, default : 3} }); treeschema.methods.dostuff = function (data) { console.log('hey, listen'); homecoming true; }; then, want utilize method of schema original container : caseschema.methods.dostuff = function (data) { if (this.casecontent.dostuff !== undefined) { this.casecontent.dostuff(); console.log('it worked'); } else { ...
Read more

How do you set up a perforce server to work over the internet? -

How do you set up a perforce server to work over the internet? - i setting perforce server , noticed options localhosts , such. i'm trying setup server on desktop machine @ 1 household, , able connect using p4v client access files on net form household. no i'll have forwards ports , stuff set files need this? can find info servers beingness run on same network @ business or nil on internet. i've set team speak server go connect , type in ip address , port , connect server dosn't have options that, i've seen anyway. done on windows 7 64 bit machines. server on desktop , clients on desktops , laptops. help appreciated , i'll posting updates on i'm doing others can follow if needed. the server accepts tcp/ip connections, can client machine has tcp/ip connectivity. perforce server configuration telling ip address , port number hear @ p4port setting: http://www.perforce.com/perforce/r12.2/manuals/cmdref/env.p4port.html since you're on windo...
Read more

ios - Lagging ScrollView with UIWebview inside -

ios - Lagging ScrollView with UIWebview inside - i have uiwebview within uiscrollview lot of content. when content loaded uiwebview big, starts lag. does know how solve issue? maintain in mind lags when uiwebview's height becomes considerably big. thank in advance! if read documentation on uiwebview , states not embed uiwebview uitableview or uiscrollview . doing leads unexpected behaviour, , think experiencing first hand. sorry bearer of bad news. update - specific warning apple docs: the documentation addresses issue specifically. important: should not embed uiwebview or uitableview objects in uiscrollview objects. if so, unexpected behavior can result because touch events 2 objects can mixed , wrongly handled. apple reference on uiwebview . update 2: after doing few searches (search link, same posted in comments), came across this answer, may provide insight. monitors content offset in both uiscrollview , uiwebview via delegates, , cle...
Read more