TravelBlog/author.php at master · wildfireone/TravelBlog · 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
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
<?php
session_start();
include('./conn.php');


?>
<!DOCTYPE html>
<html lang="en">

<head>

    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <meta name="description" content="">
    <meta name="author" content="">

    <title>Travel Blog</title>

    <!-- Bootstrap Core CSS -->
    <link href="./css/bootstrap.min.css" rel="stylesheet">

    <!-- Custom CSS -->
    <link href="./css/full-width-pics.css" rel="stylesheet">

    <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
    <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
    <!--[if lt IE 9]>
        <script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script>
        <script src="https://oss.maxcdn.com/libs/respond.js/1.4.2/respond.min.js"></script>
    <![endif]-->
<style>

.center form {
    display:inline-block;
}

</style>
</head>

<body>

    <!-- Navigation -->
    <?php include('outer_header.php');?>

    <!-- Full Width Image Header with Logo -->
    <!-- Image backgrounds are set within the full-width-pics.css file. -->
 <!--   <header class="image-bg-fluid-height">
        <img class="img-responsive img-center" src="images/grand-canyon-1083745_1920.jpg" alt="">
    </header>-->

    <!-- Content Section -->
    <section>
        <div class="container ">
        <div class="row">
           		<div class="col-lg-12" >
              <section class="panel">
                              <header class="panel-heading">
                                  <strong>Author</strong><span class="pull-right"></span>
                            </header>
            								<div class="panel-body table-responsive">
                                <table class="table table-hover">
                                  <thead>
                                    <tr>
                                                <th>Author Details</th>
                                      <th>Adventure Title</th>
                                    </tr>
                              		</thead>
                              		<tbody>
                                  <?php
																$sql = "SELECT
																	user.id,
`user`.`name` AS author_name,
country.`name` AS country_name
FROM
`user`
INNER JOIN country ON `user`.country = country.id
WHERE
user.id = $_GET[id]
";
																	$qry = mysqli_query($con,$sql);

																	while($row= mysqli_fetch_array($qry) ){
                                  ?>
                                  <tr>
                                  <td><?php echo $row['author_name']; ?><br><?php echo $row['country_name']; ?><br></td>
                                    <td>
                                     <table class="table table-hover">
                                     <?php
                                     $sql2 = "SELECT
adventure.title,
adventure.id
FROM
adventure

WHERE
`adventure`.by_id = $row[id]
";
																	$qry2 = mysqli_query($con,$sql2);

																	while($row2= mysqli_fetch_array($qry2) ){?>
																	<tr>
                                  <td><a href="./details.php?id=<?php echo $row2['id'];?>"><?php echo $row2['title']; ?></a></td>
                                  </tr>


																<?php	}

																		 ?>

                                     </table>
                                    </td>
                                  </tr>

																	<?php
																	}


																	?>

        													</tbody>
        												</table>
        											</div>
</section>
</div></div>

</div>
</section>

    <?php include('footer.php');?>

</body>

</html>