MySql fronted TEST
\n"; $link = mysql_connect('dbs.spskladno.cz', 'ctenar2'); if (!$link) { die('Nelze pripojit: ' . mysql_error()); } echo 'Pripojeno'; echo '
Vypisuji tabulku Ucitel1.Test'; echo '
... vybiram databazi...'; mysql_select_db("ucitel1") or die ("nelze vybrat databazi"); echo '
... provadim dotaz...'; $result = mysql_query('SELECT * FROM test'); if (!$result) { die('Invalid query: ' . mysql_error()); } echo "
... kontrola: vysledek dotazu:\n "; var_dump ($result); echo "--------"; echo "
Vypisuji tabulku...\n"; echo "
"; echo "
id
jmeno
plat
\n"; while ($row = mysql_fetch_assoc($result)) { echo "
"; echo $row['id']; echo "
"; echo $row['jmeno']; echo "
"; echo $row['plat']; echo "
\n"; } echo "
\n"; echo "
Druha varianta se selectboxem...
\n"; echo "
\n"; $result = mysql_query('SELECT * FROM test'); while ($row = mysql_fetch_row($result)) { echo "
$row[1] ($row[2]) \n"; } echo "
\n"; echo "
... uzaviram spojeni...\n"; mysql_close($link); ?>