\u0628\u0627 \u0633\u0644\u0627\u0645 \u0648 \u0627\u062d\u062a\u0631\u0627\u0645 \u062e\u062f\u0645\u062a \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0632\u0631\u062f\u06cc\u0633
\n\u0628\u0631\u0627\u06cc \u06af\u0631\u0641\u062a\u0646 \u0628\u06a9\u0627\u067e \u0627\u0632 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 php \u06a9\u0627\u0641\u06cc\u0633\u062a \u0627\u0632 \u06a9\u062f \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f.<\/p>\n
\r\n?php\r\n$connection = mysqli_connect('localhost','user','pass','quiz');\r\n$tables = array();\r\n$result = mysqli_query($connection,"SHOW TABLES");\r\nwhile($row = mysqli_fetch_row($result)){\r\n $tables[] = $row[0];\r\n}\r\n$return = '';\r\nforeach($tables as $table){\r\n $result = mysqli_query($connection,"SELECT * FROM ".$table);\r\n $num_fields = mysqli_num_fields($result);\r\n \r\n $return .= 'DROP TABLE '.$table.';';\r\n $row2 = mysqli_fetch_row(mysqli_query($connection,"SHOW CREATE TABLE ".$table));\r\n $return .= "\\n\\n".$row2[1].";\\n\\n";\r\n \r\n for($i=0;$i<$num_fields;$i++){\r\n while($row = mysqli_fetch_row($result)){\r\n $return .= "INSERT INTO ".$table." VALUES(";\r\n for($j=0;$j<$num_fields;$j++){\r\n $row[$j] = addslashes($row[$j]);\r\n if(isset($row[$j])){ $return .= '"'.$row[$j].'"';}\r\n else{ $return .= '""';}\r\n if($j<$num_fields-1){ $return .= ',';}\r\n }\r\n $return .= ");\\n";\r\n }\r\n }\r\n $return .= "\\n\\n\\n";\r\n}\r\n\/\/save file\r\n$handle = fopen("backup.sql","w+");\r\nfwrite($handle,$return);\r\nfclose($handle);\r\necho "Successfully backed up";\r\n?>\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"\u0628\u0627 \u0633\u0644\u0627\u0645 \u0648 \u0627\u062d\u062a\u0631\u0627\u0645 \u062e\u062f\u0645\u062a \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0632\u0631\u062f\u06cc\u0633 \u0628\u0631\u0627\u06cc \u06af\u0631\u0641\u062a\u0646 \u0628\u06a9\u0627\u067e \u0627\u0632 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 php \u06a9\u0627\u0641\u06cc\u0633\u062a \u0627\u0632 \u06a9\u062f \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f. ?php $connection = mysqli_connect(‘localhost’,’user’,’pass’,’quiz’); $tables = array(); $result = mysqli_query($connection,"SHOW TABLES"); while($row = mysqli_fetch_row($result)){ $tables[] = $row[\u06f0]; } $return = ”; foreach($tables as $table){ $result = mysqli_query($connection,"SELECT * FROM ".$table); $num_fields = mysqli_num_fields($result); […]<\/p>\n","protected":false},"author":15,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":"","_members_access_role":[],"_members_access_error":""},"categories":[3188,3082],"tags":[],"class_list":["post-43349","post","type-post","status-publish","format-standard","hentry","category-sql","category-php"],"acf":[],"_links":{"self":[{"href":"https:\/\/zardis.net\/news\/wp-json\/wp\/v2\/posts\/43349","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/zardis.net\/news\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zardis.net\/news\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zardis.net\/news\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/zardis.net\/news\/wp-json\/wp\/v2\/comments?post=43349"}],"version-history":[{"count":0,"href":"https:\/\/zardis.net\/news\/wp-json\/wp\/v2\/posts\/43349\/revisions"}],"wp:attachment":[{"href":"https:\/\/zardis.net\/news\/wp-json\/wp\/v2\/media?parent=43349"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zardis.net\/news\/wp-json\/wp\/v2\/categories?post=43349"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zardis.net\/news\/wp-json\/wp\/v2\/tags?post=43349"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}