{"id":1132,"date":"2025-10-16T05:52:00","date_gmt":"2025-10-15T20:52:00","guid":{"rendered":"https:\/\/touhyo.com\/blog\/?p=1132"},"modified":"2025-11-01T14:20:20","modified_gmt":"2025-11-01T05:20:20","slug":"phpliteadmin-error","status":"publish","type":"post","link":"https:\/\/touhyo.com\/blog\/en\/phpliteadmin-error\/","title":{"rendered":"phpLiteAdmin error"},"content":{"rendered":"\n<p>The following error was output in the database management tool.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><pre class=\"shiki monokai\" style=\"background-color: #272822\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F8F8F2\">PHP Deprecated:  Function get_magic_quotes_gpc() is deprecated in \/phpliteadmin.php<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>The relevant section is below.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:flex;align-items:center;padding:10px 0px 10px 16px;margin-bottom:-2px;width:100%;text-align:left;background-color:#34362e;color:#efefe1\">PHP<\/span><pre class=\"shiki monokai\" style=\"background-color: #272822\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F92672\">if<\/span><span style=\"color: #F8F8F2\"> (<\/span><span style=\"color: #66D9EF\">get_magic_quotes_gpc<\/span><span style=\"color: #F8F8F2\">()) {<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">\t$process <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #66D9EF\">array<\/span><span style=\"color: #F8F8F2\">(<\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\">$_GET, <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\">$_POST, <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\">$_COOKIE, <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\">$_REQUEST);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">\t<\/span><span style=\"color: #F92672\">while<\/span><span style=\"color: #F8F8F2\"> (<\/span><span style=\"color: #66D9EF\">list<\/span><span style=\"color: #F8F8F2\">($key, $val) <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #66D9EF\">each<\/span><span style=\"color: #F8F8F2\">($process)) {<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">\t\t<\/span><span style=\"color: #F92672\">foreach<\/span><span style=\"color: #F8F8F2\"> ($val <\/span><span style=\"color: #F92672\">as<\/span><span style=\"color: #F8F8F2\"> $k <\/span><span style=\"color: #F92672\">=&gt;<\/span><span style=\"color: #F8F8F2\"> $v) {<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">\t\t\t<\/span><span style=\"color: #66D9EF\">unset<\/span><span style=\"color: #F8F8F2\">($process[$key][$k]);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">\t\t\t<\/span><span style=\"color: #F92672\">if<\/span><span style=\"color: #F8F8F2\"> (<\/span><span style=\"color: #66D9EF\">is_array<\/span><span style=\"color: #F8F8F2\">($v)) {<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">\t\t\t\t$process[$key][<\/span><span style=\"color: #66D9EF\">stripslashes<\/span><span style=\"color: #F8F8F2\">($k)] <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> $v;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">\t\t\t\t$process[] <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\">$process[$key][<\/span><span style=\"color: #66D9EF\">stripslashes<\/span><span style=\"color: #F8F8F2\">($k)];<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">\t\t\t} <\/span><span style=\"color: #F92672\">else<\/span><span style=\"color: #F8F8F2\"> {<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">\t\t\t\t$process[$key][<\/span><span style=\"color: #66D9EF\">stripslashes<\/span><span style=\"color: #F8F8F2\">($k)] <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #66D9EF\">stripslashes<\/span><span style=\"color: #F8F8F2\">($v);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">\t\t\t}<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">\t\t}<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">\t}<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">\t<\/span><span style=\"color: #66D9EF\">unset<\/span><span style=\"color: #F8F8F2\">($process);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">}<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>Warning: Avoid using <code>get_magic_quotes_gpc()<\/code> as it will be removed in PHP 7.4 and later. The tool remains functional, but error logs were being generated.<\/p>\n\n\n\n<p>The code after the fix is below. The above can be commented out.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:flex;align-items:center;padding:10px 0px 10px 16px;margin-bottom:-2px;width:100%;text-align:left;background-color:#34362e;color:#efefe1\">PHP<\/span><pre class=\"shiki monokai\" style=\"background-color: #272822\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F8F8F2\">$process <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> [<\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\">$_GET, <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\">$_POST, <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\">$_COOKIE, <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\">$_REQUEST];<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F92672\">foreach<\/span><span style=\"color: #F8F8F2\"> ($process <\/span><span style=\"color: #F92672\">as<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\">$global) {<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">\t<\/span><span style=\"color: #F92672\">foreach<\/span><span style=\"color: #F8F8F2\"> ($global <\/span><span style=\"color: #F92672\">as<\/span><span style=\"color: #F8F8F2\"> $key <\/span><span style=\"color: #F92672\">=&gt;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\">$value) {<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">\t\t$newKey <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #66D9EF\">stripslashes<\/span><span style=\"color: #F8F8F2\">($key);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">\t\t<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">\t\t<\/span><span style=\"color: #F92672\">if<\/span><span style=\"color: #F8F8F2\"> (<\/span><span style=\"color: #66D9EF\">is_array<\/span><span style=\"color: #F8F8F2\">($value)) {<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">\t\t\t<\/span><span style=\"color: #66D9EF\">array_walk_recursive<\/span><span style=\"color: #F8F8F2\">($value, <\/span><span style=\"color: #66D9EF; font-style: italic\">function<\/span><span style=\"color: #F8F8F2\">(<\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\">$item) {<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">\t\t\t\t$item <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #66D9EF\">stripslashes<\/span><span style=\"color: #F8F8F2\">($item);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">\t\t\t});<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">\t\t} <\/span><span style=\"color: #F92672\">else<\/span><span style=\"color: #F8F8F2\"> {<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">\t\t\t$value <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #66D9EF\">stripslashes<\/span><span style=\"color: #F8F8F2\">($value);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">\t\t}<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">\t\t<\/span><span style=\"color: #F92672\">if<\/span><span style=\"color: #F8F8F2\"> ($newKey <\/span><span style=\"color: #F92672\">!==<\/span><span style=\"color: #F8F8F2\"> $key) {<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">\t\t\t$global[$newKey] <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> $value;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">\t\t\t<\/span><span style=\"color: #66D9EF\">unset<\/span><span style=\"color: #F8F8F2\">($global[$key]);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">\t\t}<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">\t}<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">}<\/span><\/span>\n<span class=\"line\"><span style=\"color: #66D9EF\">unset<\/span><span style=\"color: #F8F8F2\">($process);<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>If you modify the code after applying the countermeasure, you can maintain security while removing backslashes without generating error logs in PHP 7.4 and later.<\/p>\n\n\n\n<p>To briefly explain the process: Even with Magic Quotes disabled, it executes the processing, applies <code>stripslashes()<\/code> to the array keys and values to remove backslashes. It then recursively processes nested arrays, removes backslashes from their keys, and reassigns them with new keys. Finally, it deletes the original keys using <code>unset()<\/code> to replicate the behavior of the original code.<\/p>\n\n\n\n<p>In summary, you can remove backslashes without relying on Magic Quotes.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The following error was output in the database management tool. The relevant section is below. Warning: Avoid using get_magic_quotes_gpc() as it will be removed in PHP 7.4 and later. The tool remains functional, but error logs were being generated. The code after the fix is below. The above can be commented out. If you modify [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_locale":"en_US","_original_post":"https:\/\/touhyo.com\/blog\/?p=1125","footnotes":""},"categories":[1],"tags":[],"class_list":["post-1132","post","type-post","status-publish","format-standard","hentry","category-memo","en-US"],"_links":{"self":[{"href":"https:\/\/touhyo.com\/blog\/wp-json\/wp\/v2\/posts\/1132","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/touhyo.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/touhyo.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/touhyo.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/touhyo.com\/blog\/wp-json\/wp\/v2\/comments?post=1132"}],"version-history":[{"count":2,"href":"https:\/\/touhyo.com\/blog\/wp-json\/wp\/v2\/posts\/1132\/revisions"}],"predecessor-version":[{"id":1253,"href":"https:\/\/touhyo.com\/blog\/wp-json\/wp\/v2\/posts\/1132\/revisions\/1253"}],"wp:attachment":[{"href":"https:\/\/touhyo.com\/blog\/wp-json\/wp\/v2\/media?parent=1132"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/touhyo.com\/blog\/wp-json\/wp\/v2\/categories?post=1132"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/touhyo.com\/blog\/wp-json\/wp\/v2\/tags?post=1132"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}