Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $db = mysqli_connect("localhost", "root", "", "photos");
- $sql = "SELECT * FROM images ORDER BY id DESC";
- $result = mysqli_query($db, $sql);
- while ($row = mysqli_fetch_array($result)) {
- echo "<a href='uploads/".$row['image']."' data-caption='".$row['text']."' data-fancybox='quote'> ";
- echo "<img id='img_div' title='".$row['image']."' alt='".$row['image']."' src='uploads/".$row['image']."'/>";
- //echo "<p id='img_div'>".$row['desc']."</p>";
- echo "</a>";
- echo'';
- echo "<a href='http://www.facebook.com/sharer/sharer.php?u=www.quotin.co/uploads/".$row['image']."'>
- <i id='share_div' class='fa fa-facebook fa-lg' aria-hidden='true'></i></a>";
- //echo "<a id='tweet_div' href='http://www.twitter.com/share?text=Check out this quote from "Quotin"!&url=http://www.quotin.co/uploads/".$row['image']."&via=_Quotin_'><i class='fa fa-twitter fa-lg' aria-hidden='true'></i></a>";
- }
- ?>
- ID int(11)
- image varchar(200)
- text text
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement