Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $smt=$conn->prepare('SELECT * FROM post');
- $smt->execute();
- <?php while($gdata=$smt->fetch(PDO::FETCH_OBJ)):?>
- <a href="#" class="media-left col-md-4 clearfix"><img src="posts/<?php echo $gdata->Post_Path; ?>" alt="image" class="post-image"/></a>
- <div class="media-body col-md-8 post-image-space pull-left">
- <div class="post-overview">
- <ul>
- <li class="post-category"><?php echo $gdata->Category;?></li>
- <li class="post-timestemp">Post on <?php echo $gdata->Post_Date;?></li>
- </ul>
- <a href="post-description.php?id=<?php echo $gdata->Id?>"><h4 class="media-heading h4"><?php echo $gdata->Title;?></h4></a>
- <p class="post-text"><?php echo $gdata->Post;?></p>
- </div>
- </div>
- <?php endwhile;?>
- <?php
- include 'conn.php';
- $smt=$conn->prepare('SELECT * FROM post');
- $smt->execute();
- $row=$smt->fetch(PDO::FETCH_OBJ);
- $row->Post_Path;
- $ext=pathinfo($row,PATHINFO_EXTENSION);
- ?>
- <?php if($ext=='mp4')
- {?>
- <?php while($gdata=$smt->fetch(PDO::FETCH_OBJ)):?>
- <a href="#" class="media-left col-md-4 clearfix"><video class="post-image" controls>
- <source src="posts/<?php echo $gdata->$ext;?>" type="video/mp4">
- </video></a>
- <div class="media-body col-md-8 post-image-space pull-left">
- <div class="post-overview">
- <ul>
- <li class="post-category"><?php echo $gdata->Category;?></li>
- <li class="post-timestemp">Post on <?php echo $gdata->Post_Date;?></li>
- </ul>
- <a href="post-description.php?id=<?php echo $gdata->Id?>"><h4 class="media-heading h4"><?php echo $gdata->Title;?></h4></a>
- <p class="post-text"><?php echo $gdata->Post;?></p>
- </div>
- </div>
- <?php endwhile;
- }
- elseif($ext=='jpg||jpeg||png')
- {
- ?>
- <?php while ($gdata = $smt->fetch(PDO::FETCH_OBJ)): ?>
- <a href="#" class="media-left col-md-4 clearfix"><img src="posts/<?php echo $gdata->Post_Path; ?>" alt="image"
- class="post-image"/></a>
- <div class="media-body col-md-8 post-image-space pull-left">
- <div class="post-overview">
- <ul>
- <li class="post-category"><?php echo $gdata->Category; ?></li>
- <li class="post-timestemp">Post on <?php echo $gdata->Post_Date; ?></li>
- </ul>
- <a href="post-description.php?id=<?php echo $gdata->Id ?>"><h4
- class="media-heading h4"><?php echo $gdata->Title; ?></h4></a>
- <p class="post-text"><?php echo $gdata->Post; ?></p>
- </div>
- </div>
- <?php endwhile;
- }?>
- $info = new SplFileInfo('testing.jpg');
- var_dump($info->getExtension());
- $smt=$conn->prepare('SELECT * FROM post');
- $smt->execute();
- <?php while($gdata=$smt->fetch(PDO::FETCH_OBJ)):
- $mime = mime_content_type($gdata->Post_Path);
- if(strstr($mime, "video/")){
- // this code for video
- $file='';
- }else if(strstr($mime, "image/")){
- // this code for image
- $file='<img src="posts/'.$gdata->Post_Path.'" alt="image" class="post-image"/>';
- }
- ?>
- <a href="#" class="media-left col-md-4 clearfix"><?php echo $file?></a>
- <div class="media-body col-md-8 post-image-space pull-left">
- <div class="post-overview">
- <ul>
- <li class="post-category"><?php echo $gdata->Category;?></li>
- <li class="post-timestemp">Post on <?php echo $gdata->Post_Date;?></li>
- </ul>
- <a href="post-description.php?id=<?php echo $gdata->Id?>"><h4 class="media-heading h4"><?php echo $gdata->Title;?></h4></a>
- <p class="post-text"><?php echo $gdata->Post;?></p>
- </div>
- </div>
- <?php endwhile;?>
- $fileInfo = pathinfo($gdata->Post_Path);
- if($fileInfo['extension'] == 'png')
- {
- echo "It's an PNG";
- }
- elseif($fileInfo['extension'] == 'mp4')
- {
- echo "It's an MP4";
- }
- $file_parts = pathinfo($filename);
- switch($file_parts['extension'])
- {
- case "jpg":
- break;
- case "exe":
- break;
- case "": // Handle file extension for files ending in '.'
- case NULL: // Handle no file extension
- break;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement