Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- ob_start();
- session_start();
- $isLoggedIn = isset($_SESSION['user']);
- $con = mysqli_connect("localhost", "st2014", "progress", "st2014");
- if (!$con) {
- die('Could not connect: ' . mysqli_connect_error());
- }
- ?>
- <!doctype html>
- <html>
- <head>
- <meta charset = 'UTF-8'>
- <meta name="viewport" content="width=device-width, initial-scale=1.0">
- <title>Reddit</title>
- <link rel="stylesheet" type = "text/css" href = "main.css">
- <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0-beta.2/css/bootstrap.min.css" integrity="sha384-PsH8R72JQ3SOdhVi3uxftmaW6Vc51MKb0q5P2rRUpPvrszuE4W1povHYgTpBfshb" crossorigin="anonymous">
- </head>
- <body>
- <!--- KUI ON SISSE LOGITUD --->
- <?php if ($isLoggedIn): ?>
- <div class="row">
- <div class="col-sm-2"></div>
- <div class="col-sm-6">
- <!--Uudise sisestamine-->
- <form method="post">
- <div class="form-group">
- <label for="newsinput">Uudise sisestamine:</label>
- <textarea id="newsinput" class="form-control" name="news" rows="5" placeholder="Postita uudis."></textarea>
- </div>
- <button class="btn btn-primary">Postita uudis</button>
- <hr>
- </form>
- <?php
- $error = '';
- if (empty($_POST['news'])) {
- $error = "Tühja uudist ei saa sisestada";
- } else {
- $txt = htmlspecialchars($_POST['news']);
- $adder = $_SESSION['user'];
- $query = mysqli_query($con,
- "insert into t155531_news (adder, txt)
- values('$adder','$txt')");
- }
- ?>
- <!-- TEISED UUDISED -->
- <h3 style="text-align:left">Viimased uudised:</h3>
- <?php
- $user = $_SESSION['user'];
- // päring uute uudiste lisamiseks
- $news = mysqli_query($con, "select adder, txt, added, id from t155531_news order by added desc limit 10");
- if (mysqli_num_rows($news) > 0) {
- while($row = mysqli_fetch_assoc($news)) {
- echo "
- <div class='card'>
- <div class='card-block''>
- <h4 class='card-title'>".$row['adder']."</h4>
- <h6 class='card-subtitle mb-2 text-muted'>".$row['added']."</h6>
- <p class='card-text'>".$row['txt']."</p>";
- $newsId = $row['id'];
- // uudise skoor
- $scores = mysqli_query($con, "select score from t155531_votes where news_id = '$newsId'");
- $newsScore = 0;
- while($row = mysqli_fetch_assoc($scores)) {
- $newsScore += $row['score'];
- }
- echo "Uudise skoor: ", $newsScore;
- echo
- "
- <form method='post' action='addScore.php'>
- <input type ='submit' name='buttonValue' value='+1' class='btn btn-sm btn-success'/>
- <input type ='submit' name='buttonValue' value='-1' class='btn btn-sm btn-danger'/>
- <input type='hidden' name='newsId' value='$newsId'/>
- </form>
- </div>
- </div>";
- ?>
- <!--- Kommenteerimine -->
- <form method="post" action = "comments.php">
- <div class="form-group">
- <label for="commentinput">Kommenteeri:</label>
- <textarea id="commentinput" class="form-control" name="comment" rows="5" placeholder="Kommentaar"></textarea>
- </div>
- <?php echo"<input type='hidden' name='newsId' value='$newsId'/>" ?>
- <button class="btn btn-primary">Postita kommentaar</button>
- <br/>
- <p>Kommentaarid:</p>
- </form>
- <div class="card">
- <?php
- $comments = mysqli_query($con, "select comment, news_id, username from t155531_comments where news_id = '$newsId'");
- if (mysqli_num_rows($comments) > 0) {
- while($row = mysqli_fetch_assoc($comments)) {
- echo "<div class='card-header'>".$row['username']."</div>
- <div class='card-block'>
- <blockquote class='card-blockquote'>
- <p>".$row['comment']."</p>
- </blockquote>
- </div>";
- }
- } else {
- echo "Kommentaarid puuduvad";
- }
- echo "</div>
- <hr>
- <br/>";
- }
- } else {
- echo "Pole ühtegi uudist";
- }
- ?>
- </div>
- <div class="col-sm-4">
- <p>Tere, <b><?=$_SESSION['user']?></b>!</p>
- <a href="logout.php"><button class="btn btn-danger">Logi välja</button></a>
- </div>
- </div>
- <!-- Vaade külalisena -->
- <?php else: ?>
- <div class="row">
- <div class="col-sm-2"></div>
- <div class="col-sm-6">
- <!-- Uudiste kuvamine -->
- <h3 style="text-align:left">Viimased uudised:</h3>
- <?php
- $news = mysqli_query($con, "select adder, txt, added, id from t155531_news as n left join t155531_votes as v on n.id = v.news_id order by added desc limit 10");
- if (mysqli_num_rows($news) > 0) {
- while($row = mysqli_fetch_assoc($news)) {
- echo "<div class='card'>
- <div class='card-block'>
- <h4 class='card-title'>".$row['adder']."</h4>
- <h6 class='card-subtitle mb-2 text-muted'>".$row['added']."</h6>
- <p class='card-text'>".$row['txt']."</p>";
- $newsId = $row['id'];
- // skoori kuvamine
- $scores = mysqli_query($con, "select score from t155531_votes where news_id = '$newsId'");
- $newsScore = 0;
- while($row = mysqli_fetch_assoc($scores)) {
- $newsScore += $row['score'];
- }
- echo "Skoor: ", $newsScore;
- // kysi andmebaasist skoori ja prindi välja
- // nuppudega liida või lahuta
- echo "
- </div>
- </div>";
- }
- } else {
- echo "Pole ühtegi uudist";
- }
- ?>
- </div>
- <div class="col-sm-4">
- <?php
- $error = '';
- if (empty($_POST['user']) || empty($_POST['pass'])) {
- $error = 'Mõlemad väljad peavad olema täidetud!';
- } else {
- $user = mysqli_real_escape_string($con,$_POST['user']);
- $pass = mysqli_real_escape_string($con,$_POST['pass']);
- $query = mysqli_query($con, "select * from t155531_users where username='$user'and password='$pass'");
- if (mysqli_num_rows($query) == 1) {
- $_SESSION['user'] = $user;
- header('Location: index.php');
- exit;
- } else {
- $error = 'Kasutajanimi või parool vale!';
- }
- }
- ob_end_flush();
- ?>
- <h3>Logi sisse</h3>
- <p style="color:red"><?=$error?></p>
- <form method="post">
- <div class="form-group">
- <input name="user" class="form-control" placeholder="Kasutajanimi">
- </div>
- <div class="form-group">
- <input name="pass" class="form-control" placeholder="Parool" type='password'>
- </div>
- <button class="btn btn-primary">Logi sisse</button>
- </form>
- <a href=register.php><button class="btn btn-primary">Registreeru</button></a>
- </div>
- </div>
- <?php endif; ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement