How can number_format be used to format an input in a way that it is stored in a MySQL DB as 2.59 when entered as 2,59 in the input field?

When dealing with numbers in different formats, such as using commas instead of periods for decimal points, you can use the PHP number_format function to format the input before storing it in a MySQL database. This function allows you to specify the number of decimal places and the thousands separator, making it easy to convert the input into the desired format. By using number_format to format the input as 2.59 before inserting it into the database, you can ensure consistency in the data stored.

$input = "2,59";
$number = str_replace(',', '.', $input); // Replace comma with period
$formatted_number = number_format($number, 2, '.', ''); // Format number with 2 decimal places and no thousands separator

// Insert $formatted_number into MySQL database
// Example query: INSERT INTO table_name (column_name) VALUES ('$formatted_number');