merhaba sitemde tablomun users kısmında email password, ad, soyad, tecrube, ve pozisyon sütünları mevcut. giriş yaparken bu bilgileri kullanıcıdan istiyorum fakat database sadece mail ve şifreyi kaydediyor. Kodlarım aşağıdaki gibidir yardım eden olursa çok mutlu olurum.
Database kısmı kodu $password = encodeIt($_POST['password']);
$hash = md5(rand(0,1000));
$stmt = $mysqli->prepare("
INSERT INTO
users(
firstName,
lastName,
userEmail,
password,
tecrube,
pozisyon,
joinDate,
recEmails,
isActive,
hash,
lastUpdated
) VALUES (
?,
?,
?,
?,
?,
?,
NOW(),
1,
0,
?,
NOW()
)
");
$stmt->bind_param('sssssss',
$firstName,
$lastName,
$emailAddy,
$password,
$tecrube,
$pozisyon,
$hash
);
$stmt->execute();
$stmt->close();Form kısmı kodu <?php if($set['allowRegistrations'] == '1') { ?>
<div class="signup-form">
<form action="" method="post" class="mt-25">
<div class="form-group">
<input type="text" class="form-control" required="required" placeholder="Ad" name="firstName" value="" />
</div>
<div class="form-group">
<input type="text" class="form-control" required="required" placeholder="Soyad" name="lastName" value="" />
</div>
<div class="form-group">
<input type="email" class="form-control" required="required" placeholder="<?php echo $emailAddyField; ?>" name="emailAddy" value="<?php echo isset($_POST['emailAddy']) ? $_POST['emailAddy'] : ''; ?>" />
<span class="help-block"><?php echo $validEmailHelpText; ?></span>
</div>
<div class="row">
<div class="col-md-6">
<div class="form-group">
<input type="password" class="form-control" required="required" placeholder="<?php echo $passwordField; ?>" name="password" value="" />
<span class="help-block"><?php echo $passwordFieldHelp; ?></span>
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<input type="password" class="form-control" required="required" placeholder="<?php echo $repPasswordField; ?>" name="passwordr" value="" />
<span class="help-block"><?php echo $repPasswordFieldHelp; ?></span>
</div>
</div>
</div>
<div class="form-group">
<input type="text" class="form-control" required="required" placeholder="İş Tecrubeniz" name="tecrube" value="" />
</div>
<div class="form-group">
<input type="text" class="form-control" required="required" placeholder="Son Pozisyon" name="pozisyon" value="" />
</div>
<div class="row mb-10">
<div class="col-md-3">
<img src="includes/captcha.php" data-toggle="tooltip" data-placement="top" title="<?php echo $captchaCodeText; ?>" />
</div>
<div class="col-md-9">
<input type="text" class="form-control" required="required" placeholder="<?php echo $captchaCodeText; ?>" maxlength="6" name="captchaanswer" value="" />
</div>
</div>
<p class="text-center mt-20">
<input type="hidden" name="noAnswer" />
<button type="input" name="submit" value="signUp" class="btn btn-default btn-lg btn-block btn-icon"><i class="fa fa-check-square-o"></i> <?php echo $createAccBtn; ?></button>
</p>
</form>
</div>
<?php } ?>