Výpis z databázy
PHP
<?php
$result = mysql_query("SELECT meno, priezvisko FROM pouzivatelia");
while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
echo "Meno a priezvisko: " . $row["meno"] . " " . $row["priezvisko"];
}
mysql_free_result($result);
?>
Perl
$query = $db->prepare("SELECT meno, priezvisko FROM pouzivatelia");
$query->execute;
while(@row = $query->fetchrow_array() )
{
print "Meno a priezvisko: " . $row[0] . " " . $row[1];
}
Python
conn = MySQLdb.connect (host='localhost', user='user', passwd='heslo', db='meno_databazy')
cursor = conn.cursor()
cursor.execute("SELECT meno, priezvisko FROM pouzivatelia a_regs")
while (1):
row = cursor.fetchone()
if row == None:
break
print row[0], row[1],
cursor.close()
conn.close