CREATE TABLE Accounts (
account_sid INT AUTO_INCREMENT PRIMARY KEY,
account_name VARCHAR(255) NOT NULL,
account_address VARCHAR(255),
account_city VARCHAR(100),
account_state VARCHAR(50),
account_zip VARCHAR(20)
);
-- Insert some example values
INSERT INTO Accounts (account_name, account_address, account_city, account_state, account_zip)
VALUES
('John Doe', '123 Main St', 'Springfield', 'IL', '62701'),
('Jane Smith', '456 Elm St', 'Springfield', 'IL', '62702'),
('Bob Johnson', '789 Oak St', 'Chicago', 'IL', '60601');
<?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);