{"id":6890,"date":"2022-09-05T18:02:18","date_gmt":"2022-09-05T12:32:18","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-php-mysql-json-data-saving-closed\/"},"modified":"2022-09-05T18:02:18","modified_gmt":"2022-09-05T12:32:18","slug":"solved-php-mysql-json-data-saving-closed","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-php-mysql-json-data-saving-closed\/","title":{"rendered":"[Solved] PHP MySQL Json data saving [closed]"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-71321607\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"71321607\" data-parentid=\"71320278\" data-score=\"0\" data-position-on-page=\"1\" data-highest-scored=\"1\" data-question-has-accepted-highest-score=\"1\" itemprop=\"acceptedAnswer\" itemscope itemtype=\"https:\/\/schema.org\/Answer\">\n<div class=\"post-layout\">\n<div class=\"votecell post-layout--left\"><\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"s-prose js-post-body\" itemprop=\"text\">\n<p>As ADyson said, you need to get the current state of that column, convert it to an array of objects, add the new object and then write that back to the database<\/p>\n<pre><code>\/\/ change the connection to use the MYSQLI extension, then you can freely update to PHP 8\n$vtbaglan = new mysqli('localhost', 'userid', 'password', 'database name');\n\n\/\/ get the current row from the DB\n$sorgum = $vtbaglan-&gt;query($vtbaglan, \"SELECT * FROM birlikler WHERE id = 1\");\n$sorgu  = $sorgum-&gt;fetch_assoc($sorgum);\n\n$uyesim = json_decode($sorgu['uyeler']);\n\nif(isset($_POST[\"verigir\"])){\n    $arr = [\n        'kullanici' =&gt; $_POST[\"kullaniciadi\"],\n        'rutbe' =&gt; _POST[\"rutbe\"],\n        'karakteradi' =&gt; $_POST[\"kadi\"]\n    ];\n\n    \/\/ add new data to the existing data\n    $uyesim[] = $arr;\n\n    \/\/ update it back to the database\n    $stmt = $vtbaglan-&gt;prepare(\"UPDATE birlikler SET uyeler = ? WHERE id = 1\");\n    $stmt-&gt;bind_param('s', json_encode($uyesim));\n    $stmt-&gt;execute();\n    \n}\n\n\/\/ this will now show the new data, if you have added it, as the add code\n\/\/ now happens before you re-present the page after the update\n\nforeach($uyesim as $bubirtest){\n    echo $bubirtest['kullanici'] . '&lt;br&gt;';\n}\necho $uyebilgileri.'\n\n&lt;form method=\"post\"&gt;\n    &lt;input type=\"text\" name=\"kullaniciadi\" placeholder=\"kullaniciadi\"s&gt;\n    &lt;input type=\"text\" name=\"rutbe\" placeholder=\"rutbe\"&gt;\n    &lt;input type=\"text\" name=\"kadi\" placeholder=\"karakteradi\"&gt;\n    &lt;button type=\"submit\" name=\"verigir\"&gt;verigir&lt;\/button&gt;\n&lt;\/form&gt;';\n\n<\/code><\/pre>\n<p>See there is nothing frightening about using the <code>mysqli_<\/code> OR <code>PDO<\/code> database access extension. These are also available in the old version of PHP you must be using, but now you can updgrade to newer version and this code should not need changing.<\/p>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\">1<\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved PHP MySQL Json data saving [closed] <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] As ADyson said, you need to get the current state of that column, convert it to an array of objects, add the new object and then write that back to the database \/\/ change the connection to use the MYSQLI extension, then you can freely update to PHP 8 $vtbaglan = new mysqli(&#8216;localhost&#8217;, &#8216;userid&#8217;, &#8230; <a title=\"[Solved] PHP MySQL Json data saving [closed]\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-php-mysql-json-data-saving-closed\/\" aria-label=\"More on [Solved] PHP MySQL Json data saving [closed]\">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,339],"class_list":["post-6890","post","type-post","status-publish","format-standard","hentry","category-solved","tag-json","tag-php"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] PHP MySQL Json data saving [closed] - 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-php-mysql-json-data-saving-closed\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] PHP MySQL Json data saving [closed] - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] As ADyson said, you need to get the current state of that column, convert it to an array of objects, add the new object and then write that back to the database \/\/ change the connection to use the MYSQLI extension, then you can freely update to PHP 8 $vtbaglan = new mysqli(&#039;localhost&#039;, &#039;userid&#039;, ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-php-mysql-json-data-saving-closed\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-05T12:32:18+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-php-mysql-json-data-saving-closed\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-php-mysql-json-data-saving-closed\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] PHP MySQL Json data saving [closed]\",\"datePublished\":\"2022-09-05T12:32:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-php-mysql-json-data-saving-closed\/\"},\"wordCount\":89,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"json\",\"php\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-php-mysql-json-data-saving-closed\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-php-mysql-json-data-saving-closed\/\",\"name\":\"[Solved] PHP MySQL Json data saving [closed] - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-09-05T12:32:18+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-php-mysql-json-data-saving-closed\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-php-mysql-json-data-saving-closed\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-php-mysql-json-data-saving-closed\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] PHP MySQL Json data saving [closed]\"}]},{\"@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=1775798750\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] PHP MySQL Json data saving [closed] - 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-php-mysql-json-data-saving-closed\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] PHP MySQL Json data saving [closed] - JassWeb","og_description":"[ad_1] As ADyson said, you need to get the current state of that column, convert it to an array of objects, add the new object and then write that back to the database \/\/ change the connection to use the MYSQLI extension, then you can freely update to PHP 8 $vtbaglan = new mysqli('localhost', 'userid', ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-php-mysql-json-data-saving-closed\/","og_site_name":"JassWeb","article_published_time":"2022-09-05T12:32:18+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-php-mysql-json-data-saving-closed\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-php-mysql-json-data-saving-closed\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] PHP MySQL Json data saving [closed]","datePublished":"2022-09-05T12:32:18+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-php-mysql-json-data-saving-closed\/"},"wordCount":89,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["json","php"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-php-mysql-json-data-saving-closed\/","url":"https:\/\/jassweb.com\/solved\/solved-php-mysql-json-data-saving-closed\/","name":"[Solved] PHP MySQL Json data saving [closed] - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-09-05T12:32:18+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-php-mysql-json-data-saving-closed\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-php-mysql-json-data-saving-closed\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-php-mysql-json-data-saving-closed\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] PHP MySQL Json data saving [closed]"}]},{"@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=1775798750","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","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\/6890","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=6890"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/6890\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=6890"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=6890"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=6890"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}