Радость моя

<?php

$value = ... // значение из базы

?>


<input type="radio" name="rt1" value="1" <?php echo $value == 1 ? 'checked' : ''; ?>/>1
<input type="radio" name="rt1" value="2" <?php echo $value == 2 ? 'checked' : ''; ?>/>2
<input type="radio" name="rt1" value="3" <?php echo $value == 3 ? 'checked' : ''; ?>/>3

select * from mytable where myfield regexp '^.*([0-9]{2}.[0-9]{2}.[0-9]{4}).*$'

$period = new DatePeriod(
     new DateTime(date('Y-m-d', strtotime('now -30 days'))),
     new DateInterval('P1D'),
     new DateTime(date('Y-m-d'))
);

$visitorStats = [];

foreach($period as $date) { 
	$visitorStats[$date->format('Y-m-d')] = 0; 
}
// sql query ...
foreach($dbRows as $row) {
	$visitorStats[$row->date] = $row->count;
}