note 81277 deleted from function.mysqli-free-result by betz
| From: | betz@php.net | Date: | Thu, 21 Feb 2008 12:01:40 +0000 |
| Subject: | note 81277 deleted from function.mysqli-free-result by betz | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-136352@lists.php.net to get a copy of this message | ||
Note Submitter: alexander dot t dot dejong at NOSPAM dot live dot nl
----
<?php
$mysqli = new mysqli('host', 'user', 'password',
'database');
if(mysqli_connect_errno())
{
trigger_error('Fout bij verbinding: '.$mysqli->error);
}
$sql = "SELECT naam FROM tabel";
if(!$result = $mysqli->query($sql))
{
trigger_error('Fout in query: '.$mysqli->error);
}
else
{
echo 'Aantal records: '.$result->num_rows;
while($row = $result->fetch_assoc())
{
echo $row['naam'].'<br>';
}
}
$mysqli->free_result();
$mysqli->close();
?>