I'm trying to give my users to update their profile. but something is wrong... it says that users successfuly update profile but in mysql won't change it
i hope you guys could help me
here is my HTML:
<div class="panel-body"><form method="POST" action=''>
<br>
<div class="form-group input-group">
<span class="input-group-addon"><b>Uporabnisko ime:</b></span>
<fieldset disabled>
<label for="disabledSelect"></label>
<B><input type="text" id="disabledInput" class="form-control" placeholder='<?php echo $userRow['username']; ?>' > </b>
</fieldset>
</div><Br>
<div class="form-group input-group">
<span class="input-group-addon"><b>Vzdevek:</b></span>
<input type="text" id='novvzdevek' name='vzdevek' class="form-control" placeholder="<?php echo $userRow['vzdevek']; ?>">
</div>
<br><span> <div class="form-group input-group">
<span class="input-group-addon"><b>Ime:</b></span>
<input type="text" name='ime' class="form-control" placeholder="Ime (neobvezno)">
</div>
<br>
<div class="form-group input-group">
<span class="input-group-addon"><b>Email:</b></span>
<input type="email" id='email' name='email' class="form-control" placeholder="<?php echo $userRow['email']; ?>">
</div>
<br><br>
<label>Izberi spol</label>
<select class="form-control" id='spol' name='spol'>
<option></option>
<option>Moski</option>
<option>Zenska</option>
</select></center><br><br><br>
<br>
<br>
<br><input type='submit' value='Posodobi izkaznico' name='btn-edit' data-toggle="modal" data-target="#myModal">
<br>
</form></div>
and here is my php:
<?php
include_once 'dbconnect.php';
if(isset($_POST['btn-edit']))
{
$vzdevek = mysql_real_escape_string($_POST['vzdevek']);
$ime = mysql_real_escape_string($_POST['ime']);
$spol = mysql_real_escape_string($_POST['spol']);
if(!empty($vzdevek))
{
mysql_query("UPDATE users SET vzdevek='$vzdevek' WHERE vzdevek='$vzdevek'") or die(mysql_error());
echo("You have successfully updated your Name");
}
if(!empty($ime))
{
mysql_query("UPDATE users SET ime='$ime' WHERE ime='$ime'") or die(mysql_error());
echo("You have successfully updated your Password");
}
if(!empty($spol))
{
mysql_query("UPDATE users SET spol='$spol' WHERE spol='$spol'") or die(mysql_error());
echo("You have successfully updated your SPOL");
}
mysql_close();
}
?>