using GET in tables

Beginners - Learning PHP
#1

Hi

im a very beginner at php. i have a lot of expierence in basic web designing and html but im learning from different tutorials. ive searched all over google and on these forums for help but cant find anything.

Im making a website and ive been getting help with a code to create a table that links to videos but we haven’t been able to get it finished and i really would prefer to get it done as im paying for a host service

so far i have it working on a local host with the tables set for showing each month and the videos playing, i just need it linked up to the server. i have got the videos working fine on the server (well i think its the right code) but cant get the tables to show.

this is in the header

[code]

<?php $val = ''; $videofilename = ''; $eTables = ''; $eRows = ''; $date = ''; $public = ''; $curmonth = ''; if(isset($_GET['video'])){ $video = $_GET['video']; } if(isset($_GET['date'])){ $bits = explode('-',$_GET['date']); if(!empty($bits[1])){ $date = date('F Y',strtotime("{$bits[0]} {$bits[1]}")); }else{ $date = $bits[0]; } $thead = ' '; $row = 1; if (($handle = fopen("e-stats.csv", "r")) !== FALSE) { while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { $num = count($data); $row++; if($row==1)continue; if(!empty($bits[1])){ $rowdate = date('F Y',strtotime($data[0])); }else{ $rowdate = date('Y',strtotime($data[0])); } //print "{$data[0]} $rowdate == $date
"; if($rowdate == $date){ $month = date('m',strtotime($data[0])); if (!empty($curmonth) && $curmonth != $month){ $eTables .= '
date Day clips

'.$thead.$eRows; unset($eRows); } $curmonth = $month; $eRows .= ''; for ($c=0; $c < $num; $c++) { if($c==3){ $filecount = $data[$c]; if(empty($filecount))$filecount=1; $filename = date('Y-m-d',strtotime($data[0])); $eRows .= ''; $fc = 1; while($fc <= $filecount){ if($fc>1){ $anchor = $fc; $val = '-'.strtolower($fc); }else{ $anchor = $fc; } $eRows .= ''.$anchor.", "; $fc = $fc + 1; } $val = ''; $eRows = rtrim($eRows,', '); $eRows .= "\n"; } else{ $erows.= ''.$data[$c]."\n"; } } $eRows .= ''; } } fclose($handle); } } ?>[/code]

this is the e-stats php file that needs editing for it to work (at least i think unless the above code needs editing too)


<header><center>
VIDEOS</center></header>

   <center>

    <?php if (!empty($video)): ?>
<video width="300" height="220" controls>

  <source src="video/<?=$video?>.mp4" type="video/mp4">

Your browser does not support the video tag.
</video>
<?php endif; ?>
</center></div>		
<br>

  <header><center>DETAILS     </header>      
<table style="width:70%">
                    <tr>

                        <td align="center" valign="middle"><b>date</b></td>
                        <td align="center" valign="middle"><b>Day</b></td>
                        <td align="center" valign="middle"><b>clips</b>			
<?php//include_once($_GET['date']..html");?>
		</td>
                    </tr>
                   
				
                    <?=$eTable;?>

</table>

                  <?php include_once("footer.php");?>
	</body>
</html>

i dont know if this is the right place but is there a simpler way to make the video work in all web browswrs instead of having to change each format of video? (and even that doesnt work)

if you need to explain anything please try to explain in simple form as i get very confused easy !! any help would be much appreciated :slight_smile:

sorry if this is in the wrong place i had a look but i wasnt sure

#2

Are the videos always mp4’s?

Sponsor our Newsletter | Privacy Policy | Terms of Service