{"id":232814,"date":"2023-01-30T09:42:00","date_gmt":"2023-01-30T06:42:00","guid":{"rendered":"https:\/\/wordpress.mediadoma.com\/?p=232814"},"modified":"2023-02-06T11:18:47","modified_gmt":"2023-02-06T08:18:47","slug":"hur-man-skriver-ut-mysql-tabellsammanfattning-med-php","status":"publish","type":"post","link":"https:\/\/wordpress.mediadoma.com\/sv\/hur-man-skriver-ut-mysql-tabellsammanfattning-med-php\/","title":{"rendered":"Hur man skriver ut MySQL-tabellsammanfattning med PHP?"},"content":{"rendered":"

MySQL – tabellen har ett kommando Visa tabellstatus<\/strong> som<\/a> skriver ut en tabellsammanfattning, men den inneh\u00e5ller massor av information om alla tabeller i den aktuella databasen (f\u00f6r att \u00e4ndra databas, anv\u00e4nd ’anv\u00e4nd databasnamn’), vilket inte \u00e4r s\u00e5 anv\u00e4ndarv\u00e4nligt.<\/p>\n

Det vi vill veta \u00e4r storleken p\u00e5 data och storleken p\u00e5 indexet, du kan anv\u00e4nda f\u00f6ljande PHP-<\/a> skript f\u00f6r att skriva ut s\u00e5dan information.<\/p>\n

<?php\n\u00a0 require('conn.php'); \/\/ connect your database using e.g. $connection = mysqli_connect(...)\n\u00a0 $query = \"show table status\";\n\u00a0 $result = mysqli_query($connection, $query);\n\u00a0 $ds = 0;\n\u00a0 $is = 0;\n\u00a0 echo \"<table style='text-align:left;width:100%'>\";\n\u00a0 echo \"<tr \u00a0style='background:blue;color:yellow;'><th>Name<\/th><th>Data<\/th><th>Index<\/th><\/tr>\";\n\u00a0 function format($c) {\n\u00a0 \u00a0 return (round($c \/ 1024, 2)). 'KB';\n\u00a0 }\n\u00a0 while ($row = mysqli_fetch_assoc($result)) {\n\u00a0 \u00a0 echo \"<tr><th>\". ($row['Name']). '<\/th>';\n\u00a0 \u00a0 echo \"<th>\". format($row['Data_length']). \"<\/th>\";\n\u00a0 \u00a0 echo \"<th>\". format($row['Index_length']). \"<\/th>\";\n\u00a0 \u00a0 $ds += $row['Data_length'];\n\u00a0 \u00a0 $is += $row['Index_length'];\n\u00a0 \u00a0 echo \"<\/tr>\";\n\u00a0 }\n\u00a0 echo \"<tr style='background:lightblue;'>\";\n\u00a0 echo \"<th>\". format($ds + $is). \"<\/th><th>\". format($ds). \"<\/th><th>\". format($is). \"<\/th>\";\n\u00a0 echo \"<\/tr><\/table>\";<\/code><\/pre>\n
H\u00e4r \u00e4r ett exempel p\u00e5 anv\u00e4ndningen fr\u00e5n en typisk wordpress-<\/a> databas. Vi formaterar storleken med KB. P\u00e5 s\u00e5 s\u00e4tt kunde du h\u00e5lla koll p\u00e5 tabellanv\u00e4ndningen d\u00e5 och d\u00e5. Du kan ocks\u00e5 \u00e4ndra den snygga CSS i koden ovan f\u00f6r att formatera utdata.<\/p>\n
mysql-show-table-status-in-php-example<\/p>\n
Inspelningsk\u00e4lla:  helloacm.com<\/a><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"
Hur man skriver ut MySQL-tabellsammanfattning med PHP?<\/p>\n","protected":false},"author":1,"featured_media":224526,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_wp_rev_ctl_limit":""},"categories":[901,922,807,724],"tags":[1173],"class_list":["post-232814","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-koda","category-oevrig","category-php-9","category-utvecklaren","tag-affiai-sv"],"_links":{"self":[{"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/posts\/232814","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/comments?post=232814"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/posts\/232814\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/media\/224526"}],"wp:attachment":[{"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/media?parent=232814"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/categories?post=232814"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/tags?post=232814"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}