gistfile1.php

<?php
	public function insert_booking_date_match(Array $dates, $rule_id)
	{
		$sql = "-- insert_booking_date_match

		BEGIN;
		DELETE FROM
			rule_booking_date_match
		WHERE
			rule_id = ".$rule_id."
		;
		";
		foreach ( $dates as $date )
		{
			if( $date != null )
			{
				$sql .= "
				INSERT INTO
					rule_booking_date_match(rule_id,date_from,date_to)
				VALUES(
				".$rule_id."
				,
				'".date('Y-m-d',$date['from'])."'
				,
				'".date('Y-m-d',$date['to'])."'
				);";
			}
		}
		$sql .= "COMMIT;";
		$result = $this->db->query($sql);
	}