| Publisher 98 | Microsoft |
| Corel Draw 6.0 FR | Corel |
Nombre de lignes affectées (SELECT): 2
<?php
print "<hr>";
$mysqli = new mysqli("serveur", "login", "passe", "base");
if (mysqli_connect_errno()) {
printf("Erreur de connexion : %s\n", mysqli_connect_error());
exit();
}
$nb=rand(1,10);
$result = $mysqli->query("SELECT * FROM logiciels limit $nb");
echo "<table border=2>";
while($row = $result->fetch_object())
printf("<tr>\n <td align=\"left\">%s</td><td>%s</td>\n</tr>\n", $row->nom, $row->editeur);
print "</table>";
printf("Nombre de lignes affectées (SELECT): %d\n", $mysqli->affected_rows);
$mysqli->close();
print "<hr>";
/*
Code procédural
<-php
$link = mysqli_connect('localhost', 'root', 'password', 'base');
echo mysql_get_server_info();
mysql_close($link);
->
Code orienté Objet
<-php
$mysqli = new mysqli('localhost', 'root', 'password', 'base');
echo $mysqli -> server_info;
$mysqli -> close();
->
*/
show_source("mysqlisrc.php");
?>