<? try {
    $db = new PDO("mysql:host=$db_host;dbname=$db_name", $db_user, $db_pass);
    $db->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );
}

catch(PDOException $e) {
    print "Error connecting DB!";
    echo $e->getMessage();
    exit;
}

$q = $db->query('SELECT * FROM users');
$q->setFetchMode(PDO::FETCH_ASSOC);

?>

<table border="1">

    <tr>
        <td width="20%">Звуть</td>
        <td width="20%">Років</td>
        <td width="20%">Країна</td>
        <td width="20%">Місто</td>
        <td>Телефон</td>
    </tr>

<?
while ($row = $q->fetch()) {
    $year=date('Y') - $row[YEAR];
    print "
    <tr>
        <td>$row[NAME]</td>
        <td>$year</td>
        <td>$row[COUNTRY_ID]</td>
        <td>$row[CITY_ID]</td>
        <td>$row[PHONE]</td>
    </tr>";
}
?>
</table>

<?
print "
<form action='{$_SERVER['PHP_SELF']}' method='POST'>
<table>
    <tr>
        <td>Ім’я:</td>
        <td><input type='text' name='NAME' maxlength='15' value='$value'></td>
    </tr>

    <tr>
        <td>Рік народження:</td>
        <td>
            <select name='YEAR'>";
        for ($i = 1960; $i <= 2004; $i++)
            print "<option>$i</option>";
print "         </select></td>
    </tr>
    <tr>
        <td>Країна:</td>
        <td><select name='COUNTRY'>";

$q = $db->query('SELECT * FROM countries');
$q->setFetchMode(PDO::FETCH_ASSOC);

while ($countrie = $q->fetch()) {
    print "
    <option>
        $countrie[NAME_RU]
    </option>
    ";
}

print "</select>
</td>
    </tr>
    <tr>
        <td>Номер:</td>
        <td><input type='text' name='PHONE' maxlength='10' value='$value'></td>
    </tr>
</table>

<input type='submit' maxlength='15' value='Надіслати!'>

</form>

";



############# Обробка масиву POST ###############

print $db->lastInsertId();