Temat: [PHP] mysqli_connect
<?php
$link = mysqli_connect('localhost', 'root', '');
//----
if (!$link) { die('Nie można się połaczyć: '.mysqli_error()); }
else
{
$db_selected = mysqli_select_db($link, 'test123');
//----
if (!$db_selected) { die ('Nie można ustawić bazy: '.mysqli_error()); }
//----
$result = mysqli_query($link, 'select * from tabela');
//----
if (@mysqli_num_rows($result)==0) { echo "Brak danych."; }
else
{
while ($row = mysqli_fetch_assoc($result))
{
echo $row["id"];
echo "<br />";
echo $row["pelna_nazwa"];
echo "<br />";
echo $row["ile_lat"];
echo "<hr />";
}
}
//----
@mysqli_free_result($result);
//----
mysqli_close($link);
}
?>