Account Info List

<?php
/*
Pretpostavimo da će URL do account-a ići npr http://tvoja-stranica.hr/?username={username}
{} - unutar zagrada ide username, npr. kod mene je username lakotuts onda bi bila url:
http://tvoja-stranica.hr/?username=lakotuts
*/
//Uzimamo podatak username: ovo 'username' je od parametra nakon upitnika
$username = $_GET['username'];

$password1 = $_POST['pwd'];
$password2 = $_POST['pwd1'];
$surname = $_POST['surname'];
$lastname = $_POST['lastname'];
$dob = $_POST['dob'];
$email = $_POST['email'];
$tel = $_POST['tel'];
$address = $_POST['add'];
$ptc = $_POST['ptc'];


//sanitize username
$username = mysql_real_escape_string($username);

$query = "SELECT username, surname, lastname, dob, email, tel, add, ptc FROM member
        WHERE username = ".$username." LIMIT 1";

$result  = mysql_query($query);

//Uzimamo Rezultat
$row =  mysql_fetch_array($result);



mysql_close();

?>
<div id="container">
<h1><?php echo $row["username"]; ?></h1>
<h2><?php echo $row["surname"]. " " . $row["lastname"]; ?></h2>
<span class="godina">Dob: <?php echo $row["dob"]; ?></span>
<a href="javascript:mailto(<?php echo $row["email"]; ?>,'')"><?php echo $row["email"]; ?></a>
<span class="tel">Telefon: <?php echo $row["tel"]; ?></span>
<span class="add_ptc">Adresa i ZIP: <?php echo $row["add"].", ".$row["ptc"]; ?></span>
</div>