PHP สร้างคำสั่ง SQL INSERT ให้มีระเบียบสวยงามด้วยฟังก์ชั่น implode()

<form method="POST" action="<?php echo $_SERVER['PHP_SELF'];?>">
	<table border="0">
		<tr>
			<td align="right">payment_id</td>
			<td><input name="payment_id" value="AAAAAA"></td>
		</tr>
		<tr>
			<td align="right">payment_customer_id</td>
			<td><input name="payment_customer_id" value="BBBBBBB"></td>
		</tr>
		<tr>
			<td align="right">payment_date</td>
			<td><input name="payment_date" value="CCCCCCC"></td>
		</tr>
		<tr>
			<td align="right">payment_amount</td>
			<td><input name="payment_amount" value="DDDDDDD"></td>
		</tr>
		<tr>
			<td align="right"></td>
			<td><input type="submit" name="send" value="Save"></td>
		</tr>
	</table>
</form>

<?php
if(isset($_POST['send'])){
	$data = array(
		'payment_id' => $_POST['payment_id'], 
		'payment_customer_id' => $_POST['payment_customer_id'], 
		'payment_date' => $_POST['payment_date'], 
		'payment_amount' => $_POST['payment_amount'], 
	);

	$field_name = implode(", ", array_keys($data));
	$field_value = implode("', '", array_values($data));
	$sql = "INSERT INTO myTable ($field_name) VALUES ('$field_value')";
	echo $sql;
}
?>

INSERT INTO myTable (payment_id, payment_customer_id, payment_date, payment_amount) VALUES ('AAAAAA', 'BBBBBBB', 'CCCCCCC', 'DDDDDDD')

	$field_name = implode(", ", array_keys($data));
	$field_value = implode("', '", array_values($data));
	$sql = "INSERT INTO myTable ($field_name) VALUES ('$field_value')";

function sqlInsert($tablename, $arr){
	$field_name = implode(", ", array_keys($arr));
	$field_value = implode("', '", array_values($arr));
	return "INSERT INTO $tablename($field_name) VALUES ('$field_value')";
}

$data = array(
		'payment_id' => $_POST['payment_id'], 
		'payment_customer_id' => $_POST['payment_customer_id'], 
		'payment_date' => $_POST['payment_date'], 
		'payment_amount' => $_POST['payment_amount'], 
	);

$sql = sqlInsert("tb_payment", $data);