Ovako.. imam Registracija.php u kojem je ovaj kod:
<?php include "base.php"; ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>User Management System (Tom Cameron for NetTuts)</title>
<link rel="stylesheet" href="style.css" type="text/css" />
</head>
<body>
<div id="main">
<?php
if(!empty($_POST['username']) && !empty($_POST['password']))
{
$username = mysql_real_escape_string($_POST['username']);
$password = md5(mysql_real_escape_string($_POST['password']));
$email = mysql_real_escape_string($_POST['email']);
$checkusername = mysql_query("SELECT * FROM users WHERE Username = '".$username."'")
if(mysql_num_rows($checkusername) == 1)
{
echo "<h1>Error</h1>";
echo "<p>Sorry, that username is taken. Please go back and try again.</p>";
}
else
{
$registerquery = mysql_query("INSERT INTO users (Username, Password, EmailAddress) VALUES('".$username."', '".$password."', '".$email."')");
if($registerquery)
{
echo "<h1>Success</h1>";
echo "<p>Your account was successfully created. Please <a href=\"index.php\">click here to login</a>.</p>";
}
else
{
echo "<h1>Error</h1>";
echo "<p>Sorry, your registration failed. Please go back and try again.</p>";
}
}
}
else
{
?>
<h1>Registracije</h1>
<p>Unesite za nastavak.</p>
<form method="post" action="register.php" name="registerform" id="registerform">
<fieldset>
<p>
<label for="username">Ime:</label>
<input type="text" name="username" id="username" />
</p>
<p>
<label for="username2">Prezime:</label>
<input type="text" name="username2" id="username2" />
</p>
<p>
<label for="username3">Nadimak:</label>
<input type="text" name="username3" id="username3" />
<br />
<label for="password">Šifra:</label>
<input type="password" name="password" id="password" /><br />
<label for="email">Email Address:</label>
<input type="text" name="email" id="email" /><br />
<input type="submit" name="register" id="register" value="Register" />
</p>
</fieldset>
</form>
<?php
}
?>
</div>
</body>
</html>
U tom kodu ja sam samo dodao nekoliko "textbox-ova"... ime i prezime.. i napravio sam mySQL bazu i preko MyPHPadmin(tako nekako :D) tablicu users i na njoj (slika 1.0)
Što bih ja trebao izmjeniti gore u php kodu da mi doda ime i prezime isto u bazu?
(Slobodno mi se smijte zato što sam početnik :D)
e da i base.php datoteka me spaja s bazom.. tamo samo unosim te podatke za povezivanje i nista vise...
