Database/account.php at main · RickyMarin/Database · GitHub

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
85
86
87
<html>
<head>
    <title>Order Status</title>
    <meta charset="utf-8"/>
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    <link rel="stylesheet" href="assets/css/main.css"/>
    <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css" integrity="sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhcWr7x9JvoRxT2MZw1T" crossorigin="anonymous">
</head>

<body class="is-preload">
<?php
include("library.php");
session_start();
if(!isset($_SESSION['logged_in'])){
    header("Location:SignUp.php");
}
$stmt = $db->prepare("SELECT * FROM Users WHERE uemail = ?");
$stmt->execute([$_SESSION['email']]);
$user = $stmt->fetch();
$mobile = "Mobile";
$home = "Home";
$Phonestmt = $db->prepare("SELECT * FROM UsersPhone WHERE uemail = ? AND numtype = ?");
$Phonestmt->execute([$_SESSION['email'],$mobile]);
$Phoneuser = $Phonestmt->fetch();
$Homestmt = $db->prepare("SELECT * FROM UsersPhone WHERE uemail = ? AND numtype = ?");
$Homestmt->execute([$_SESSION['email'],$home]);
$Homeuser = $Homestmt->fetch();
?>

<?php include("LoggedInHeader.php"); ?>
<div class="container-fluid">
    <form method="post" enctype="multipart/form-data">

        <fieldset class="form-group">
            <div class="border border-light p-3 mb-4">
                <div class="row">
                    <div class="col-md-3">
                        <div container="container-fluid" style="background-color:#F46036; padding: 1rem;">
                            <div class="text-center">

                                <h3 class="text-light">
                                </h3>

                            </div>
                            <div class="text-center">
                                <p><p>
                                    <a class="btn btn-info btn-lg" href="updateinfo.php/">Update Info</a>
                                </p></p>
                            </div>
                        </div>
                        <hr>
                        <div container="container-fluid" style="background-color:#122C34; padding: 1rem;">

                        </div>

                    </div>

                    <div class="col-md-8">
                        <div container="container-fluid" style="background-color:whitesmoke; padding: 1rem;">
                            <h2 class="text-light" style="background-color:#122C34; padding: 1rem;">
                                Your Profile
                            </h2>
                            <h5 class="text-secondary" style="padding: 0.5rem;"> <b>Name:</b> <?php echo $user['uname']; ?></h5>
                            <h5 class="text-secondary" style="padding: 0.5rem;"> <b>Email:</b> <?php echo $user['uemail']; ?></h5>
                            <h5 class="text-secondary" style="padding: 0.5rem;"> <b>Phone Number:</b> <?php echo $Phoneuser['uphone']; ?></h5>
                            <h5 class="text-secondary" style="padding: 0.5rem;"> <b>Home Phone Number:</b> <?php echo $Homeuser['uphone']; ?></h5>
                            <h5 class="text-secondary" style="padding: 0.5rem;"> <b>Address:</b> <?php echo $user['uaddrstr']; ?></h5>
                            <h5 class="text-secondary" style="padding: 0.5rem;"> <b>City:</b> <?php echo $user['uaddrcity']; ?></h5>
                            <h5 class="text-secondary" style="padding: 0.5rem;"> <b>State:</b> <?php echo $user['uaddrstate']; ?></h5>
                            <h5 class="text-secondary" style="padding: 0.5rem;"> <b>Zip Code:</b> <?php echo $user['uaddrzip']; ?></h5>
                            <h5 class="text-secondary" style="padding: 0.5rem;"> <b><a href='export.php'>Get Data?</a></b></h5>


                        </div>
                    </div>
                </div>
        </fieldset>
    </form>
</div>


<?php include("footer.php"); ?>
</body>
</html>