This script will loop though all fields in a database and output the name and create a form field with appropriate record value.<\/p>\n
This is useful if you don’t want to manually code the form, or don’t know all of the field names<\/p>\n
\r\n\/\/ Assumes you have your database connected here using variable $conn\r\n\r\n\/\/ Set a flag to determin if you're editing here by checking $_GET for example\r\n$editing = true;\r\n\r\nif ($editing) {\r\n \/\/ Fetch the record to edit\r\n $result = $conn->query(\"SELECT * FROM `$table` WHERE ID = $id\");\r\n $row = $result->fetch_assoc();\r\n}\r\n\r\n\/\/ Grab the column names for your table\r\n$result = $conn->query(\"SHOW COLUMNS FROM `$table`\");\r\n$columns = $result->fetch_all(MYSQLI_ASSOC);\r\n\r\n\/\/ Loop through each column and work out its name and type\r\n\/\/ Then output the appropriate form field for the data type\r\nforeach ($columns as $column): ?>\r\n <?php\r\n $fieldName = $column['Field'];\r\n $fieldType = $column['Type'];\r\n \/\/ Skip auto-increment fields (like 'id')\r\n if ($fieldName == 'WebsiteID') continue;\r\n $value = $editing && isset($row[$fieldName]) ? htmlspecialchars($row[$fieldName]) : '';\r\n ?>\r\n <div class=\"WebsiteField\">\r\n <label for=\"<?php echo $fieldName; ?>\">\r\n <?php echo ucfirst(str_replace('_', ' ', $fieldName)); ?>\r\n <\/label>\r\n <?php if (strpos($fieldType, 'enum') !== false): ?>\r\n <!-- Handle ENUM fields as dropdowns -->\r\n <?php\r\n preg_match(\"\/^enum\\('(.*)'\\)$\/\", $fieldType, $matches);\r\n $enumValues = explode(\"','\", $matches[1]);\r\n ?>\r\n <select name=\"<?php echo $fieldName; ?>\" id=\"<?php echo $fieldName; ?>\">\r\n <?php foreach ($enumValues as $enumValue): ?>\r\n <option value=\"<?php echo $enumValue; ?>\" <?php echo ($value == $enumValue) ? 'selected' : ''; ?>>\r\n <?php echo $enumValue; ?>\r\n <\/option>\r\n <?php endforeach; ?>\r\n <\/select>\r\n <?php elseif (strpos($fieldType, 'text') !== false): ?> \r\n <textarea><\/textarea><br>\r\n <?php else: ?>\r\n <!-- Default to text input -->\r\n <input type=\"text\" name=\"<?php echo $fieldName; ?>\" id=\"<?php echo $fieldName; ?>\" value=\"<?php echo $value; ?>\">\r\n <?php endif; ?>\r\n <div class=\"ClearFix\"><\/div>\r\n <\/div>\r\n \r\n <?php\r\n endforeach; \r\n \/\/ Tidy Up The Connection\r\n $conn->close();\r\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"This script will loop though all fields in a database and output the name and create a form field with appropriate record value. This is […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[29,4],"tags":[31,66,24,9],"class_list":["post-258","post","type-post","status-publish","format-standard","hentry","category-mysql","category-php","tag-database","tag-forms","tag-mysql","tag-php"],"_links":{"self":[{"href":"https:\/\/www.kwwd.co.uk\/blog\/wp-json\/wp\/v2\/posts\/258","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.kwwd.co.uk\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.kwwd.co.uk\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.kwwd.co.uk\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.kwwd.co.uk\/blog\/wp-json\/wp\/v2\/comments?post=258"}],"version-history":[{"count":0,"href":"https:\/\/www.kwwd.co.uk\/blog\/wp-json\/wp\/v2\/posts\/258\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.kwwd.co.uk\/blog\/wp-json\/wp\/v2\/media?parent=258"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.kwwd.co.uk\/blog\/wp-json\/wp\/v2\/categories?post=258"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.kwwd.co.uk\/blog\/wp-json\/wp\/v2\/tags?post=258"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}