<!-- Slide number: 1 -->
fetch ()
Préparé par : Ouali Mohamed
2015/2016
<!-- Slide number: 2 -->
| NCIN | NOM | PRENOM | AGE |
| --- | --- | --- | --- |
| 44444444 | Abidi | Nizar | 40 |
| 11111111 | Cheick | Hafedh | 45 |
| 88888888 | Dhaouedi | Nebil | 28 |
Table
personne
$ result = $bdd->query('SELECT NCIN,NOM,PRENOM, AGE from personne ');
| NCIN | NOM | PRENOM | AGE |
| --- | --- | --- | --- |
| 44444444 | Abidi | Nizar | 40 |
| 11111111 | Cheick | Hafedh | 45 |
| 88888888 | Dhaouedi | Nebil | 28 |
Publicité
$result
<!-- Slide number: 3 -->
| NCIN | NOM | PRENOM | AGE |
| --- | --- | --- | --- |
| 44444444 | Abidi | Nizar | 40 |
| 11111111 | Cheick | Hafedh | 45 |
| 88888888 | Dhaouedi | Nebil | 28 |
Table
personne
$ result = $bdd->query("SELECT NCIN from personne");
| NCIN |
| --- |
| 44444444 |
| 11111111 |
| 88888888 |
$result
<!-- Slide number: 4 -->
| NCIN | NOM | PRENOM | AGE |
Publicité
| --- | --- | --- | --- |
| 44444444 | Abidi | Nizar | 40 |
| 11111111 | Cheick | Hafedh | 45 |
| 88888888 | Dhaouedi | Nebil | 28 |
Table
personne
$ result = $bdd->query("SELECT NCIN,NOM,PRENOM from personne");
| NCIN | NOM | PRENOM |
| --- | --- | --- |
| 44444444 | Abidi | Nizar |
| 11111111 | Cheick | Hafedh |
| 88888888 | Dhaouedi | Nebil |
$result
<!-- Slide number: 5 -->
| NCIN | NOM | PRENOM | AGE |
| --- | --- | --- | --- |
| 44444444 | Abidi | Nizar | 40 |
| 11111111 | Cheick | Hafedh | 45 |
Publicité
| 88888888 | Dhaouedi | Nebil | 28 |
Table
personne
$ result = $bdd->query("SELECT NCIN,NOM,PRENOM from personne Where AGE >=40");
| NCIN | NOM | PRENOM |
| --- | --- | --- |
| 44444444 | Abidi | Nizar |
| 11111111 | Cheick | Hafedh |
$result
<!-- Slide number: 6 -->
| NCIN | NOM | PRENOM | AGE |
| --- | --- | --- | --- |
| 44444444 | Abidi | Nizar | 40 |
| 11111111 | Cheick | Hafedh | 45 |
| 88888888 | Dhaouedi | Nebil | 28 |
$result
while ($ligne = $reponse->fetch())
{
Publicité
echo $ligne[‘NCIN’].' : '.$ligne[‘NOM’].' '.$ligne[‘PRENOM’].‘ ($ligne[‘AGE]’) <br>';}
| NCIN | NOM | PRENOM | AGE |
| --- | --- | --- | --- |
| 88888888 | Dhaouedi | Nebil | 28 |
| NCIN | NOM | PRENOM | AGE |
| --- | --- | --- | --- |
| 11111111 | Cheick | Hafedh | 45 |
| NCIN | NOM | PRENOM | AGE |
| --- | --- | --- | --- |
| 44444444 | Abidi | Nizar | 40 |
$ligne
44444444 : Abidi Nizar (40)
11111111 : Cheick Hafedh (45)
88888888 : Dhaouedi Nebil (28)