:
1. .
2. .
3. .
4. .
5. .
6. .
7. .
8. .
9. .
. .
, ( 17), . , .
17 -
SQL- :
INSERT INTO Polzovatel (Login, Password, Familia, Imya, Otchestvo, Data_rojdenia, Telephone, E-mail, Uroven_dostupa) VALUES ($login, $password, $familia, $imya, $otchestvo, $data_rojdenia, $telephone, $e-mail, $uroven_dostupa)
-, . 18 . , .
18 - " ": - ; -
, , SQL- .
:
<form id="newsletter" class="divider" name="newsletter" method="post" action="">
<fieldset>
<table>
<tr>
<td></td>
<td></td>
<td></td>
<td> </td>
<td></td>
<td>E-mail</td>
</tr>
<tr>
<td><input type="text" id=familia name=familia></td>
<td><input type="text" id=imya name=imya></td>
<td><input type="text" id=otchestvo name=otchestvo></td>
<td><input type="text" id=data_rojdenia name=data_rojdenia></td>
<td><input type="text" id=telephone name=telephone></td>
<td><input type="text" id=e-mail name=e-mail></td>
</tr>
</table>
</fieldset>
</form>
SQL- :
SELECT Familia, Imya, Otchestvo, Data_rojdenia, Telephone, E-mail FROM Polzovatel WHERE (Login like $login) and (Password like $password) and (Familia like $familia) and (Imya like $imya) and (Otchestvo like $otchestvo) and (Data_rojdenia like $data_rojdenia) and (Telephone like $telephone) and (E-mail like, $e-mail) ORDER BY Familia, Imya, Otchestvo
19 - " "
, . , .
|
|
|
, , ( 20). , .
20 -
SQL- SQL- , .. LIKE, . :
Data_vileta>=data_vileta and Data_prileta>=data_prileta
. , 21, , , . , , , 22. , .
21 - .
22 -
, , . 23.
23 - " "
- , 24.
24 -
3 , , .
, , , , , 25.
25 -
