PHP - How Do I Embed Index.php Into My Url

hi all

is there anyway embedding excel or .csv files to the webpage other than the folowing two options

. saving it as a webpage
. using google docs

i used the following code, iam getting the .csv file in the page, but it would be good to have the color formatting, bold, italics... also in the webpage.

is it possible?

Code: [Select]
<?php 
      $cnx = fopen("example.csv", "r"); //open example.csv 
      echo("<table style='border:1px solid #ddd;'>"); // echo the table 
      while (!feof ($cnx)) { // while not end of file 
      $buffer = fgets($cnx); // get contents of file (name) as variable 
      $values = explode(",", $buffer); //explode "," between the values within the  contents 
      echo "<tr>"; 
      for ( $j = 0; $j < count($values); $j++ ) {  // 
      echo("<td style='border:1px solid #ddd;'>$values[$j]</td>"); 
      } 
      echo"</tr>"; 
      }; 
      echo("</table>"); 
      fclose($cnx); //close filename variable 
      ?>

I tried searching google and phpclasses.org for something of this nature, but can't seem to come across anything. (or possibly using the wrong keywords).

Basically I am looking for a class that I can instantiate with a URL (or similar), and in turn it will provide me with the appropriate embed code for that video along with a thumbnail. (Thumbnail optional)
I currently having something im using, but its restricted purely to YouTube, and wish to expand it to all video providers.

Does anyone know of any code available (class) that can provide me with what I mentioned above.

Thanks

i know you get embed code from youtube videos.  How do i put the code into my website.  Do i store the code in mysql? and how do i get php to display it?

hey guys,
what i have done so far is got the link to a bbc video feed
so when you go to my site the php code will retrive the latest video from bbc and get the link.
so i now have $url as having the value of the video
but i now need to insert it into the html embed video code.
so how can i make this.
Code: [Select]
<object width="416" height="374" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" id="ep"><param name="allowfullscreen" value="true" /><param name="allowscriptaccess" value="always" /><param name="wmode" value="transparent" /><param name="movie" value="http://i.cdn.turner.com/cnn/.element/apps/cvp/3.0/swf/cnn_416x234_embed.swf?context=embed_edition&videoId=world/2009/06/28/penhaul.lok.honduras.cnn" /><param name="bgcolor" value="#000000" /><embed src="http://i.cdn.turner.com/cnn/.element/apps/cvp/3.0/swf/cnn_416x234_embed.swf?context=embed_edition&videoId=world/2009/06/28/penhaul.lok.honduras.cnn" type="application/x-shockwave-flash" bgcolor="#000000" allowfullscreen="true" allowscriptaccess="always" width="416" wmode="transparent" height="374"></embed></object>

I have an excel file that I want to show in PHP page. I dont want this to first download and then view. I want it something like gmail where you just click on the file name and it opens up. Can you please give me an idea as how to do this.

Regards,

Faisa

Hey all -

Below is my code.  I'm uncertain how to move correctly code (syntax) what I'm looking to do..

When the user clicks "Next" or "Previous," the following youtube clip will load into the div tag.  (With the corresponding description tag).   Where do I incorporate the str_replace?  And how do I make sure both the youtube clip with the correct description is loaded?

Any advice is appreciated!

<?php
   $youtubeIds = array("rHNtuaVHenM","zIAdbIMNq9g","QQ4TlJLa-n4","JccPOA12ELI","JccPOA12ELI", "TWhhXVqVB7E");
   $embedCode = '<object width="853" height="505"><param name="movie" value="http://www.youtube.com/v/__YOUTUBE_ID__?fs=1&amp;hl=en_US"></param><param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><embed src="http://www.youtube.com/v/__YOUTUBE_ID__?fs=1&amp;hl=en_US" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="853" height="505"></embed></object>';

   
   
   if(isset($_GET['youtubeclip']))
   {
   if(is_numeric($_GET['youtubeclip']))
      {
         if($_GET['youtubeclip'] >= 0 && $_GET['youtubeclip'] <= 5)
         {
            $youtubeclip = $_GET['youtubeclip'];
         }
         
         else
         {
            $youtubeclip = 0;
         }      
      }
   else
   {
      $youtubeclip = 0;
   }
   
   $prevyoutubeclip = $youtubeclip-1;
   if($prevyoutubeclip < 0)
   {
      $prevyoutubeclip = 5;
   }
   
   $nextyoutubeclip = $youtubeclip+1;
   if($nextyoutubeclip > 5)
   {
      $nextyoutubeclib = 0;
   }
   
   $clip_names= array('Episode #1', 'Episode #2', 'Episode #3', 'Episode #4', 'Episode #5', 'Episode #6');
   }



?>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
   "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
   <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>

   <title>Billy Green</title>
   
   <link rel="stylesheet" type="text/css" media="screen" href="episode_style.css">
   
</head>

<body>
   
   <div class="wrapper">
      <?php include 'header.php'?>
      
      <div id="episode_content">
      
         
         <div class="youtube_box">
         <?php
      
         echo $embedCode;
         
         ?>
         
         </div>
      
         
         <h2 class="clip-description">"<?php echo $clip_names[$youtubeclip]; ?>" </h2>
         <div class="youtube_control">
         <a href="episodes.php?youtubeclip=<?php echo $prevyoutubeclip; ?>"> Previous Clip </a>
         <a href="episodes.php?youtubeclip=<?php echo $nextyoutubeclip; ?>"> Next Clip </a>
         </div>

         
      </div>   
      <div class="clearIt"> </div>   
   
      <?php include 'footer.php'?>
   </div>
   
   




</body>
</html>

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=332275.0

Ok I have a unique issue I have a decent sized database for a fix up and modify project I just landed. My problem is my client has a table with plain html, flash, javascript it in. Which generally speaking isn't to much a problem if I we're going the straight php route to get the data from the database. However I'm not so lucky. These people wish to have the element being built by me to use AJAX to give the site a "2.0" feel, which again to a point fine. So all this said and done, I am going using jQuery as my frame for the javascript. The landing page for the script is PHP it handles any potential user input checks before it works its way into the javascript variables to then use JSON through the javascript to another php file which in turn double checks the inputs just incase someone wants to go in to the source find the way to the file its gathering the data from an all else. Then based on the data forms its output. Which I don't know why Ive wasted my time explaining that, we all know how JSON works in concept at least.

My issue with this all is, a single column or 2 but ill stick with just the one for now... with these people having stored plain html, javascript, and object tags for flash in the column without any htmlspecialchars or stripslash's or really any security per say in mind. In other words I can go into any column and just copy and paste the code and have it work in an HTML file as if it were typed out for use in HTML alone. So with that, my JSON requests are failing due to the extra quotes, double quotes, slashes, and all else. What I am trying to figure out is, what is my best method to phrase the output of the DB so its friendly for for the JSON request yet can be repieced back together via javascript/jquery.

Any takers on that idea?

Hi guys,

In an application I'm working on, I'm looking to embed a youtube video with [YOUTUBE][/YOUTUBE].

Code: [Select]
echo preg_replace('#(?:<\>]+href=\")?(?:http://)?((?:[a-zA-Z]{1,4}\.)?youtube.com/(?:watch)?\?v=(.{11}?))[^"]*(?:\"[^\<\>]*>)?([^\<\>]*)(?:)?#', '<object width="425" height="350"><param name="movie" value="http://www.youtube.com/v/'.$matches[2].'"></param><param name="wmode" value="transparent"></param><embed src="http://www.youtube.com/v/'.$matches[2].'" type="application/x-shockwave-flash" wmode="transparent" width="425" height="350"></embed></object>', $ENTIREPAGE?);
The problem is that the video appears with a slider control at the bottom.

How do I get rid of the Youtube slider control at the bottom?

Thanks.

http://ahy4life.com/test2/press.php

I am following the tutorial below:

http://www.adambate.com/how-to-add-a-flickr-based-photo-gallery-to-your-website-phpflickr-lightbox/
 

I am encountering errors when I introduce the code below.  Not sure what is causing it. The flickr photo set is named 'AHY' .

 

php and js

<CODE>

<script type="text/javascript" src="photos/lightbox2.05/js/prototype.js"></script>

<script type="text/javascript"

          src="photos/lightbox2.05/js/scriptaculous.js?load=effects,builder"></ script>

<script type="text/javascript" src="photos/lightbox2.05/js/lightbox.js"></script>

 

<?php

require_once("photos/phpFlickr-3.1/phpFlickr.php");

$f = new phpFlickr("b16911dd0ec59f16ed66e80711edbdaf"); // API

$user = "ahy4l@yahoo.com";

$ph_sets = $f->photosets_getList($user);

?>

</CODE>

 

<CODE>

<!-- Photo Gallery -->

<div id="gallery">

<?php foreach ($ph_sets['AHY'] as $ph_set): ?>

  <div class="photosets">

  <p><h2><?php print $ph_set['title']; ?></h2></p>

  <?php $photoset_id = $ph_set['id'];

  $photos = $f->photosets_getPhotos($photoset_id);

  foreach ($photos['AHY']['photo'] as $photo): ?>

  <div class="photos">

   <a rel="lightbox[]"

     href="<?= $f->buildPhotoURL($photo, 'medium') ?>"

     title="<?= $photo['title'] ?>">

   <img src="<?= $f->buildPhotoURL($photo, 'square') ?>"

     alt="<?= $photo['title'] ?>" title="<?= $photo['title'] ?>" />

   </a>

  </div>

  <?php endforeach; ?>

  </div>

<?php endforeach; ?>

</div>

 

The CSS I use for this is:

 

#gallery {

    position: relative;

    float: left;

    width: 600px;

    padding: 0px 15px 10px 15px;

}

 

.photos {

    position: relative;

    float: left;

    display: block;

    padding-bottom: 10px;

}

.photosets {

    clear: both;

    padding-top: 1px;

}

.photosets h2 {

    color: #000;

}

</CODE>

Hi friends i have latest rss news feed im my php site, i would like to share latest 5 rss feed so some of our partners can publish in thier site . How to do it ?

I am looking for a code where I can get a video URL from Youtube, Vimeo, Facebook and convert it to an embedded video to be shown on my site. I found a script that does that. It works fine.

The only errors I get are in the inspect element window in the browser. Errors such as this. 

Failed to load resource: net::ERR_BLOCKED_BY_CLIENT   googleads.g.doubleclick.net/pagead/id:1 
Failed to load resource: net::ERR_BLOCKED_BY_CLIENT   static.doubleclick.net/instream/ad_status.js:1 

 

This is the function to generate the embedded videos. Do the above errors matter if the videos show up and play fine?

function generateVideoEmbedUrl($url){
    //This is a general function for generating an embed link of an FB/Vimeo/Youtube Video.
    $finalUrl = '';
    if(strpos($url, 'facebook.com/') !== false) {
        //it is FB video
        $finalUrl.='https://www.facebook.com/plugins/video.php?href='.rawurlencode($url).'&show_text=1&width=200';
    }else if(strpos($url, 'vimeo.com/') !== false) {
        //it is Vimeo video
        $videoId = explode("vimeo.com/",$url)[1];
        if(strpos($videoId, '&') !== false){
            $videoId = explode("&",$videoId)[0];
        }
        $finalUrl.='https://player.vimeo.com/video/'.$videoId;
    }else if(strpos($url, 'youtube.com/') !== false) {
        //it is Youtube video
        $videoId = explode("v=",$url)[1];
        if(strpos($videoId, '&') !== false){
            $videoId = explode("&",$videoId)[0];
        }
        $finalUrl.='https://www.youtube.com/embed/'.$videoId;
    }else if(strpos($url, 'youtu.be/') !== false){
        //it is Youtube video
        $videoId = explode("youtu.be/",$url)[1];
        if(strpos($videoId, '&') !== false){
            $videoId = explode("&",$videoId)[0];
        }
        $finalUrl.='https://www.youtube.com/embed/'.$videoId;
    }else{
        //Enter valid video URL
    }
    return $finalUrl;
}

 

This is a section of my code that goes and gets videos from any video site. What I’m having issues with is having it post a random title, that are all in a text file called titles.txt. What I’m wanting to accomplish is have my script go pull the video embed code, the duration, the tags, etc. Which all works fine until I get to the title part where it pulls locally from the server from the text file. I'm not an advance programmer so not sure if I am even approaching this correct way. Here is the code I have that is responsible for putting the title in. I appreciate your help.

$video = array(
‘user_id’ => $this->user_id,
‘status’ => $this->status,
‘site’ => ‘my site’,
‘id’ => ‘’,
‘embeddable’ => true,
‘url’ => ‘’,
‘titles’ => ‘’,
‘title’ => ‘’,
‘description’ => ‘’,
‘tags’ => ‘’,
‘category’ => ‘’,
‘thumbs’ => array(),
‘duration’ => 0,
‘embed’ => ‘’
);

function random_title ()
{
$titles = file (“titles.txt”, FILE_IGNORE_NEW_LINES);
$num = rand (0, intval (count ($titles) / 3)) * 3;
return ucwords($titles[$num]);
}

//Title
if(preg_match(’/title="(.*?)"/’, $match, $matches_title)) {
$video[‘title’] = random_title(). ’ - My site name’;
} else {
$this->errors[] = ‘Failed to get video title for ‘.$video[‘url’].’!’;
if (!$this->debug) continue;
else $debug_e[] = ‘TITLE’;
}

 

i'm running code on what i only want to be the HOME page, but the current site it built using GET variables with index.php

needless to say, the home page is accessed either as domain.com/ or domain.com/index.php - i'm hoping someone can show me how to check for this condition, that it is only index.php without anything further

I'm only slightly familiar with $_SERVER['uri'], etc... So i don't know just what to ask.

thanks for anyone's help.

Glenn

So I've searched for a few hours already, and decided to give in to asking on a forums.

On the site I'm working on, I want the navigation to look like www.website.com/index.php?id=2 instead of www.website.com/contacts.htm

Also, the way I did it before, I renamed my main home page as 'main.php' and when you go to the site, index.php will display what's on main.php, but will still show www.website.com/index.php?id=1.

I've done it before a few years ago, but I lost the site and forgot how to do it. I'm pretty sure there's a if/else if statement that comes into play, but I don't remember. I hope this all makes sense.

Thanks