kako sad da postavim da kad korisnik unese mail koji već postoji u bazi da mu ispise "E-mail koji ste unijeli već postoji"
evo kako sam uradio
naredba za stvaranje tablice
CREATE TABLE `korisnici` (
`idkorisnici` int(11) NOT NULL AUTO_INCREMENT,
`ime` varchar(100) NOT NULL,
`prezime` varchar(200) NOT NULL,
`lozinka` varchar(30) NOT NULL,
`email` varchar(200) NOT NULL DEFAULT '',
`spol` varchar(100) NOT NULL,
`dan` decimal(10,0) NOT NULL default '0',
`mjesec` decimal(10,0) NOT NULL default '0',
`godina` decimal(10,0) NOT NULL default '0',
PRIMARY KEY (`idkorisnici`),
UNIQUE KEY `u_email` (`email`)
);
kod za upis
Code:
<?
if (!$_POST["SBunos"])
{
?>
<form method="post" action="">
<b>Ime: </b>
<input type="text" name="ime" size="50"><br />
<b>Prezime: </b>
<input type="text" name="prezime" size="50"><br />
<b>Lozinka: </b>
<input type="text" name="lozinka" size="50"><br />
<b>E-mail: </b>
<input type="text" name="email" size="50"><br />
<b>Odaberi spol: </b>
<select name="spol">
<option>muško</option>
<option>žensko</option>
</select><br />
<b>Datum rodjenja: </b>
<b>Dan: </b>
<select name="dan">
<option>01</option>
<option>03</option>
<option>04</option>
<option>05</option>
<option>06</option>
<option>07</option>
<option>08</option>
<option>09</option>
<option>10</option>
<option>11</option>
<option>12</option>
<option>13</option>
<option>14</option>
<option>15</option>
<option>16</option>
<option>17</option>
<option>18</option>
<option>19</option>
<option>20</option>
<option>21</option>
<option>22</option>
<option>23</option>
<option>24</option>
<option>25</option>
<option>26</option>
<option>27</option>
<option>28</option>
<option>29</option>
<option>30</option>
<option>31</option>
</select>
<b>Mjesec: </b>
<select name="mjesec">
<option>Januar</option>
<option>Februar</option>
<option>Mart</option>
<option>April</option>
<option>Maj</option>
<option>Juni</option>
<option>Juli</option>
<option>Avgust</option>
<option>Septembar</option>
<option>Oktobar</option>
<option>Novembar</option>
<option>Decembar</option>
</select>
<b>Godina: </b>
<select name="godina">
<option>1992</option>
<option>1991</option>
<option>1990</option>
<option>1989</option>
<option>1988</option>
<option>1987</option>
<option>1986</option>
<option>1985</option>
<option>1984</option>
<option>1983</option>
<option>1982</option>
<option>1981</option>
<option>1980</option>
<option>1979</option>
<option>1978</option>
<option>1977</option>
<option>1976</option>
<option>1975</option>
<option>1974</option>
<option>1973</option>
<option>1972</option>
<option>1971</option>
<option>1970</option>
</select><br />
<input type="submit" name="SBunos" value="Registriraj se" style="margin: 5px 0px 0px 0px;">
</form>
<?
} else {
include "Postavke.php";
$imebaze="INSERT INTO korisnici (ime, prezime, lozinka, email, spol, dan, mjesec, godina)
VALUES ('$_POST[ime]', '$_POST[prezime]', '$_POST[lozinka]', '$_POST[email]', '$_POST[spol]', '$_POST[dan]', '$_POST[mjesec]', '$_POST[godina]')";
if (mysql_query($imebaze))
{
if (empty($_POST[ime]))
{
echo "<center>Niste upisali <b>Ime</b>! </center>";
echo "<center><a href=\"javascript:history.back()\">Nazad</a></center>";
}
if (empty($_POST[prezime]))
{
echo "<center>Niste upisali <b>Prezime</b>! </center>";
echo "<center><a href=\"javascript:history.back()\">Nazad</a></center>";
}
if (empty($_POST[lozinka]))
{
echo "<center>Niste upisali <b>Lozinku</b>! </center>";
echo "<center><a href=\"javascript:history.back()\">Nazad</a></center>";
}
if (empty($_POST[email]))
{
echo "<center>Niste upisali <b>E-mail</b>! </center>";
echo "<center><a href=\"javascript:history.back()\">Nazad</a></center>";
}
else{
echo "Uspješno ste se registrirali!";
}
}
else{
echo "Nastala je greška pri registraciji!<br>" . mysql_error();
}
}
?>
i sta mislite dali je se to moglo kako jednostavnije uraditi. Hvala na pomoći