Php mysqli query
mysqli, query, fetch, close
connect
include 'connect.php';
$mysqli = new mysqli($myhost, $myuser, $mypasswd, $mydb);
$errno = mysqli_connect_errno();
if ($errno) {
printf("Connect failed: %s\n", mysqli_connect_error());
}
$mysqli = new mysqli($myhost, $myuser, $mypasswd, $mydb);
$errno = mysqli_connect_errno();
if ($errno) {
printf("Connect failed: %s\n", mysqli_connect_error());
}
query
$result = $mysqli->query("select count(*) from mytable");
process results
$fields = $result->fetch_fields();
echo '<pre>';
foreach ($fields as $col)
{
printf("%s ", $col->name);
}
printf("\n");
while ($row = $result->fetch_row())
{
foreach ($row as $col)
{
printf("%s ", $col);
}
printf("\n");
}
echo '</pre>';
echo '<pre>';
foreach ($fields as $col)
{
printf("%s ", $col->name);
}
printf("\n");
while ($row = $result->fetch_row())
{
foreach ($row as $col)
{
printf("%s ", $col);
}
printf("\n");
}
echo '</pre>';
close
$result->close();
$mysqli->close();
$mysqli->close();
REFERRERS
PhpMySqlDatabases
