Predmet:Imena i osobine polja u tabeli-fetch_fields
PreuzmiIzvorni kôd (Text):<?php
$con = mysqli_connect("localhost","korisnicko_ime","sifra","ime_baze");
if (mysqli_connect_errno())
{
echo "Nije uspjela konekcija" . mysqli_connect_error();
exit();
}
$sql = "SELECT * FROM ime_tabele";
if ($result = mysqli_query($con , $sql))
{
$fieldinfo = mysqli_fetch_fields($result);
$i=TRUE;
foreach ($fieldinfo as $val)
{
if ($i==TRUE)
{
echo "Tabela:". $val->table . "<br>";
echo "=========================<br>";
$i=FALSE;
}
echo "Ime polja:". $val->name . "<br>";
echo "Duzina:$val->max_length ";
echo "Tip polja:$val->type ";
echo "Flag:$val->flags <br>";
echo "------------------------------------------<br>";
}
mysqli_free_result($result);
}
else
{
echo "Greška u Query-u";
}
mysqli_close($con);
?>
Podrska samo putem foruma, jer samo tako i ostali imaju koristi od toga.