php - Dump data in json format from two tables from MySQL -


i have following scenario. have 2 tables follow table 1 id, name, desc, seo

table 2 id, table1_id, relation_table1_id

in table 1 have data need as:

----------------------------------- |id | name        |desc      |seo | ----------------------------------- | 1 | smith       |father    |f   | | 2 | jonh        |son       |j   | | 3 | margat      |mother    |m   | | 4 | bis3        |son       |b1  | | 5 | bis2        |son       |b2  | | 6 | bis1        |son       |b3  | | 7 | lanos       |brother   |l   | -----------------------------------

and have our table 2 follow

------------------------------------- |id | table1_id   |relation_table1_id| -------------------------------------- | 1 |     1       |         4        | | 2 |     1       |         5        | | 3 |     3       |         6        | | 4 |     3       |         2        | | 5 |     7       |         0        | --------------------------------------

so far have first table dump json() follow:

<?php include ('config.php'); $dump1 = mysql_query("select * table1 ") or die(mysql_error());   $getlist = array();  while ($row = mysql_fetch_assoc($dump1)) {      $getlist[] = $row; }   print json_encode($getlist);   exit; ?>

that code give me following:

[   {     "id":"1",     "name":"smith",     "desc":"father",     "seo":"f"   }, {     "id":"2",     "name":"jonh",     "desc":"son",     "seo":"j"   }, {     "id":"3",     "name":"margat",     "desc":"mother",     "seo":"m"   }... ... ... ]

what can't figure how following 

[   {     "id":"1",     "name":"smith",     "desc":"father",     "seo":"f",         "relations":[             {              "id":"4",              "name":"bis3",              "desc":"son",              "seo":"b1"             }           ]   },   {     "id":"3",     "name":"margat",     "desc":"father",     "seo":"f",         "relations":[             {              "id":"6",              "name":"bis2",              "desc":"son",              "seo":"b2"             },              {              "id":"2",              "name":"jonh",              "desc":"son",              "seo":"j"             }           ]   }... ... ...  ]

in plain text like

  id 1 smith   |   |_id 4 bis3   |      |_ id 3 margat       |_id 5 bis2       |_id 2 jonh

i'm learning how use json , got first part can see, lack of knowledge of sql , php wont let me want, please can 1 me achieve scenario please.

thank you.

you can loop through $getlist

then query

for($i = 0; $i <= count($getlist); $i++){     "select * table2 table1_id = $getlist[$i]['id']" // result way $getlist[$i]['something'] = $result; }

then take result of that, inside loop, , assign whichever key of getlist want example

hopefully thats specific enough. let me know if have problems that.


Comments

Post a Comment

Popular posts from this blog

c++ - End of file on pipe magic during open -

i have c++ application in starting process(wireshark) following. if (fp == null){ fp = popen(processpath, "r"); //processpath process want start if (!fp){ throw std::invalid_argument("cannot start process"); } fprintf(fp, d_msg);//d_msg input want provide process } else if(fp != null){ fprintf(fp, d_msg); } the problem when execute c++ application, start wireshark error end of file on pipe magic during open what should avoid that? also tried using mkfifo create named pipe , execute it. used this: if (fp == null){ system("mkfifo /tmp/mine.pcap"); fp = popen("wireshark -k -i /tmp/mine.pcap", "r"); if (!fp){ dout << "cannot start wireshark"<<std::endl; throw std::invalid_argument("cannot start wireshark"); } input = fopen("/tmp/mine.pcap", "wb"); fprintf(input , d_msg); fclose(input)...
Read more

basic authentication with http post params android -

i doing basic authentication passing username , password , using basicnamevaluepair sending post params response service. my method: public stringbuilder callservicehttppost(string username, string password, string type) { // create new httpclient , post header httpclient httpclient = new defaulthttpclient(); httppost httppost = new httppost(webservice + type); httpresponse response = null; stringbuilder total = new stringbuilder(); try { url url = new url(webservice + type); /*string base64encodedcredentials = base64.encodetostring((username + ":" + password).getbytes(), base64.url_safe | base64.no_wrap);*/ string base64encodedcredentials = "basic " + base64.encodetostring( (username + ":" + password).getbytes(), base64.no_wrap); httppost.setheader("auth...
Read more

data.table making a copy of table in R -

i doing this: myfun <- function(inputvar_vec){ # inputvar_vec input vector # # result = output vector return(result) } dt[, result := lapply(.sd, myfun), = byvar, .sdcols = inputvar] i getting following warning: warning message: `in `[.data.table`(df1, , `:=`(prop, lapply(.sd, propeventinlastk)), : invalid .internal.selfref detected , fixed taking copy of whole table, := can add new column reference. @ earlier point, data.table has been copied r (or been created manually using structure() or similar). (and more stuff) .... ` my guess because stacking result vectors (after operation), copy being made? can suggest method remove warning? have done using apply functions , thought should extendable here too. my other question is: can pass chunk of rows data frame (subsetted using statement), , call function myfun operate on that? adding example requested # generate data n = 10000 default=na value = 1 df = data.table(id = sample(1:5000, n, replace=true), ...
Read more