{"id":12773,"date":"2022-10-01T21:01:17","date_gmt":"2022-10-01T15:31:17","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-pdo-table-inside-table-using-json\/"},"modified":"2022-10-01T21:01:17","modified_gmt":"2022-10-01T15:31:17","slug":"solved-pdo-table-inside-table-using-json","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-pdo-table-inside-table-using-json\/","title":{"rendered":"[Solved] PDO table inside table using json"},"content":{"rendered":"

[ad_1]
\n<\/p>\n

\n
\n
<\/div>\n
\n
\n

Start by returning objects from PDO as that is what you want.<\/p>\n

Then only select from the table the columns that you actually need<\/p>\n

Then build the data structure that you believe you want from the returned data<\/p>\n

$stmt1 = $db->prepare(\"SELECT title,description FROM data WHERE id='1'\");\n$stmt1->execute();\n$data = $stmt1->fetch(PDO::FETCH_OBJ);\n\n$stmt2 = $db->prepare(\"SELECT id,title FROM weeks WHERE id='2'\");\n$stmt2->execute();\n$data->weeks[] = $stmt2->fetch(PDO::FETCH_OBJ);\n\n$stmt3 = $db->prepare(\"SELECT id,name FROM user WHERE id='1'\");\n$stmt3->execute();\n$data->user[] = $stmt3->fetch(PDO::FETCH_OBJ);\n\n$response = new stdClass();\n$response->data[] = $data;\n\nprint_r($response);\necho json_encode($response);\n<\/code><\/pre>\n
RESULT:<\/p>\n
stdClass Object\n(\n    [data] => Array\n        (\n            [0] => stdClass Object\n                (\n                    PDO table inside table using json => name of module2\n                    PDO table inside table using json => description of module2\n                    [weeks] => Array\n                        (\n                            [0] => stdClass Object\n                                (\n                                    [id] => 2\n                                    PDO table inside table using json => Week 02\n                                )\n\n                        )\n\n                    [user] => Array\n                        (\n                            [0] => stdClass Object\n                                (\n                                    [id] => 2\n                                    [name] => john\n                                )\n\n                        )\n\n                )\n\n        )\n\n)\n<\/code><\/pre>\n
Giving a JSON String of <\/p>\n
{\"data\":[{\"title\":\"name of module2\",\n          \"description\":\"description of module2\",\n          \"weeks\":[{\"id\":2,\"title\":\"Week 02\"}],\n          \"user\":[{\"id\":2,\"name\":\"john\"}]\n        }]\n}\n<\/code><\/pre>\n<\/p><\/div>\n
<\/div>\n<\/div>\n
            8<\/span> <\/p><\/div>\n<\/div>\n
[ad_2]<\/p>\n
solved PDO table inside table using json <\/p>\n","protected":false},"excerpt":{"rendered":"
[ad_1] Start by returning objects from PDO as that is what you want. Then only select from the table the columns that you actually need Then build the data structure that you believe you want from the returned data $stmt1 = $db->prepare(“SELECT title,description FROM data WHERE id=’1′”); $stmt1->execute(); $data = $stmt1->fetch(PDO::FETCH_OBJ); $stmt2 = $db->prepare(“SELECT id,title … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[356,855,339],"class_list":["post-12773","post","type-post","status-publish","format-standard","hentry","category-solved","tag-json","tag-pdo","tag-php"],"yoast_head":"\n[Solved] PDO table inside table using json - JassWeb<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jassweb.com\/solved\/solved-pdo-table-inside-table-using-json\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] PDO table inside table using json - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] Start by returning objects from PDO as that is what you want. Then only select from the table the columns that you actually need Then build the data structure that you believe you want from the returned data $stmt1 = $db->prepare("SELECT title,description FROM data WHERE id='1'"); $stmt1->execute(); $data = $stmt1->fetch(PDO::FETCH_OBJ); $stmt2 = $db->prepare("SELECT id,title ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-pdo-table-inside-table-using-json\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-01T15:31:17+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-pdo-table-inside-table-using-json\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-pdo-table-inside-table-using-json\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] PDO table inside table using json\",\"datePublished\":\"2022-10-01T15:31:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-pdo-table-inside-table-using-json\/\"},\"wordCount\":60,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"json\",\"pdo\",\"php\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-pdo-table-inside-table-using-json\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-pdo-table-inside-table-using-json\/\",\"name\":\"[Solved] PDO table inside table using json - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-10-01T15:31:17+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-pdo-table-inside-table-using-json\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-pdo-table-inside-table-using-json\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-pdo-table-inside-table-using-json\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] PDO table inside table using json\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] PDO table inside table using json - JassWeb","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/jassweb.com\/solved\/solved-pdo-table-inside-table-using-json\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] PDO table inside table using json - JassWeb","og_description":"[ad_1] Start by returning objects from PDO as that is what you want. Then only select from the table the columns that you actually need Then build the data structure that you believe you want from the returned data $stmt1 = $db->prepare(\"SELECT title,description FROM data WHERE id='1'\"); $stmt1->execute(); $data = $stmt1->fetch(PDO::FETCH_OBJ); $stmt2 = $db->prepare(\"SELECT id,title ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-pdo-table-inside-table-using-json\/","og_site_name":"JassWeb","article_published_time":"2022-10-01T15:31:17+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-pdo-table-inside-table-using-json\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-pdo-table-inside-table-using-json\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] PDO table inside table using json","datePublished":"2022-10-01T15:31:17+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-pdo-table-inside-table-using-json\/"},"wordCount":60,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["json","pdo","php"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-pdo-table-inside-table-using-json\/","url":"https:\/\/jassweb.com\/solved\/solved-pdo-table-inside-table-using-json\/","name":"[Solved] PDO table inside table using json - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-10-01T15:31:17+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-pdo-table-inside-table-using-json\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-pdo-table-inside-table-using-json\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-pdo-table-inside-table-using-json\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] PDO table inside table using json"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/12773","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=12773"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/12773\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=12773"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=12773"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=12773"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}