-
Notifications
You must be signed in to change notification settings - Fork 0
/
Voter account.php
84 lines (67 loc) · 1.94 KB
/
Voter account.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
<?php
// query for user has upload or not the img
$sql = "SELECT * FROM file WHERE username = ?" ;
$stmt = mysqli_prepare ($connect ,$sql);
mysqli_stmt_bind_pram ($stmt , "i" , $_SESSION ['username']);
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);
$userImage = mysqli_fetch_assoc($result);
mysqli_stmt_close($stmt);
$userImage = $_POSt['file'];
if ($userImage ['is_set'] == 0){
echo '<img src = "profile_pics/default-profile-pic.png"/>';
}
else{
echo '<img src = "'.$userImage ['image_dir'].'"/>';
}
if (isset($_POST['reset'])) {
if (isset($_POST['fname']) && isset($_POST['lname']) &&
isset($_POST['uname'])
{
$fname = $_POST['fname'];
$lname = $_POST['lname'];
$uname = $_POST['uname'];
$eml = $_POST['eml'];
include "config.php";
if($conn->connect_error){
die('Could not connect to the database.');
}
else{
$SELECT = "SELECT uname FROM voter where uname = ? Limit 1";
$INSERT = "INSERT into voter(fname, lname, uname, eml) values (?,?,?,?)";
$stmt = $conn->prepare($SELECT);
$stmt ->bind_param("s", $uname);
$stmt->execute();
$stmt->bind_result($resultuname);
$stmt->store_result();
$stmt->fetch();
$rnum = $stmt->num_rows;
if ($rnum == 0) {
$stmt->close();
$stmt = $conn->prepare($INSERT);
$stmt->bind_param("ssss", $fname, $lname, $uname, $eml);
if ($stmt->execute()) {
// echo "Account updated Sucessfully.";
echo "<script>alert('Account Created Sucessfully.');location.href = 'home.php'</script>";
}
else {
echo $stmt->error;
}
}
else {
echo "<script>alert('Someone already registers using this username.');location.href = 'Voter acc.html'</script>";
}
$stmt->close();
$conn->close();
}
}
else{
echo "All field are required";
die();
}
}
else{
echo "Update button is not set";
}
?>
?>