<?php
$mysqli = @new mysqli('localhost', 'root', 'root', 'user');
$result_set = $mysqli->query('SELECT * FROM civilman');
while ($row = $result_set->fetch_assoc()) {
foreach($row as $v=>$k) {
echo $v.': '.$k.'<br>';
}
}
$result_set->close();
$mysqli->close();
?>