public function get_stat_by_id_loan()
    {

        $mysql_request = 'CALL get_data_by_id_loan(\'' . $_GET['id_loan'] . '\')';

        if ( !$result = mysqli_query ( $this->link_mysql, $mysql_request ) )
        {
            die ( 'can\'t CALL get_data_by_id_loan() <br />' . mysqli_error ($this->link_mysql) );
        }
        
        $arr_result = mysqli_fetch_array( $result, MYSQLI_ASSOC );
        
        

        echo '<table>
            <th colspan="4"> Данные по клиенту</th>
            <tr>
                <td>Имя</td>
                <td>' . $arr_result['first_name'] . '</td>
                <td>Зарегистрирован</td>
                <td>' . $arr_result['reg_time'] . '</td>
            </tr>
            <tr>
                <td>Фамилия</td>
                <td>' . $arr_result['second_name'] . '</td>
                <td>Кредитов всего</td>
                <td>' . $arr_result['@var_counted_loans'] . '</td>
            </tr>
        </table>

        <table>
            <th colspan="4"> Данные по кредиту</th>
            <tr>
                <td>Дата заявки</td>
                <td>' . $arr_result['request_time'] . '</td>
                <td>Период, дней</td>
                <td>' . $arr_result['period'] . '</td>
            </tr>
            <tr>
                <td>Дата выдачи</td>
                <td>' . $arr_result['takemoney_time'] . '</td>
                <td>Срок погашения</td>
                <td>' . $arr_result['payback_time'] . '</td>
            </tr>
            <tr>
                <td>Сумма кредита</td>
                <td>' . $arr_result['amount_money'] . '</td>
                <td>Осталось дней</td>
                <td>' . $arr_result['@var_count_left_days'] . '</td>
            </tr>
            <tr>
                <td>Размер интресса</td>
                <td>' . $arr_result['intress'] . '</td>
                <td>Статус кредита</td>
                <td>' . $arr_result['status'] . '</td>
            </tr>
        </table>';
        
        
        //prepare for next request to mysql.
        mysqli_free_result( $result );
        mysqli_next_result( $this -> link_mysql );
        
   }

        if ( preg_match('/^[a-zA-Z0-9_]*$/', $_POST['first_name']) == 0 || strlen( $_POST['first_name'] ) > 20 )
        {
            die ('Wrong letters for the first name or too big ! ( > 20 )<br />');
      }