PHPize Online / SQLize Online  /  SQLtest Online

<?php function getSql($post, $table, $db) { $result = $db->query("DESCRIBE $table"); $rows = $result->fetch_all(MYSQLI_ASSOC); $fields = array_column($rows, "Field"); mysqli_free_result($result); if (!is_array($post)) { return ""; } $sqlParts = []; foreach ($post as $key => $val) { if (in_array($key, $fields)) { $sqlParts[] = "$key = '" . addslashes("$val") . "'"; } } return implode(', ', $sqlParts); } $post = array( 'account_sid' => 123, 'account_name' => "John Doe", 'account_address' => "123 Main's St", 'non_existent_field' => "This should be ignored" ); // echo getSql($post, "Accounts", $mysqli); $query = "DESCRIBE Accounts;"; $result = $mysqli->query($query); $rows = $result->fetch_all(MYSQLI_ASSOC); $fields = array_column($rows, 'Field'); $line = "'" . implode("','", $fields) . "'"; print_r($rows);