mark103 Posted April 25, 2013 Share Posted April 25, 2013 Hi guys,I am working on my tv guide website that I output the data to my php from mysql database. I want to know how i can work it out the tv time for per programme how long they would last for, e.g 30 mins, 1 hour...etc <html> <body> <style type="text/css"> #channel1 { position:absolute; font-family:Arial; font-size:29px; font-style:normal; font-weight:bold; color:f5fdfd; text-decoration:none; text-transform:none; visibility:visible; overflow:hidden; left:35px; top:245px; width:176px; height:50px; z-index:1; } #programme1 { position:absolute; font-family:Arial; font-size:29px; font-style:normal; font-weight:bold; color:f5fdfd; text-decoration:none; text-transform:none; visibility:visible; overflow:hidden; left:427px; top:245px; width:176px; height:50px; z-index:1; } #programme2 { position:absolute; font-family:Arial; font-size:29px; font-style:normal; font-weight:bold; color:f5fdfd; text-decoration:none; text-transform:none; visibility:visible; overflow:hidden; left:765px; top:245px; width:176px; height:50px; z-index:1; } #programme3 { position:absolute; font-family:Arial; font-size:29px; font-style:normal; font-weight:bold; color:f5fdfd; text-decoration:none; text-transform:none; visibility:visible; overflow:hidden; left:1110px; top:245px; width:176px; height:50px; z-index:1; } #day { font-family:Arial; font-size:29px; font-style:normal; font-weight:bold; color:f5fdfd; text-decoration:none; text-transform:none; position:absolute; visibility:visible; overflow:hidden; left:294px; top:180px; width:176px; height:50px; z-index:0; } #time1 { font-family:Arial; font-size:29px; font-style:normal; font-weight:bold; color:f5fdfd; text-decoration:none; text-transform:none; position:absolute; visibility:visible; overflow:hidden; left:424px; top:180px; width:176px; height:50px; z-index:0; } #time2 { font-family:Arial; font-size:29px; font-style:normal; font-weight:bold; color:f5fdfd; text-decoration:none; text-transform:none; position:absolute; visibility:visible; overflow:hidden; left:754px; top:180px; width:176px; height:50px; z-index:0; } #time3 { font-family:Arial; font-size:29px; font-style:normal; font-weight:bold; color:f5fdfd; text-decoration:none; text-transform:none; position:absolute; visibility:visible; overflow:hidden; left:1104px; top:180px; width:176px; height:50px; z-index:0; } <?php include("get-listing.php"); ?> <div id="image1" style="position:absolute; overflow:hidden; visibility:visible; left:21px; top:245px; width:374px; height:40px; z-index:0"><img src="/images/row1_yellow.jpg" alt="" title="" border=0 width=374 height=50></div> <div id="image2" style="position:absolute; overflow:hidden; visibility:visible; left:21px; top:295px; width:374px; height:40px; z-index:0"><img src="/images/row1.jpg" alt="" title="" border=0 width=374 height=50></div> <div id="image3" style="position:absolute; overflow:hidden; visibility:visible; left:21px; top:345px; width:374px; height:40px; z-index:0"><img src="/images/row1.jpg" alt="" title="" border=0 width=374 height=50></div> </body> </html> I am using the row1 as per image to resize it for per programme, but i have no idea how i can compare with each timing for per programme before resizing on per image.here is what my php displaying: <span id='time1'>1:00 PM</span> - <span id='title1'>SportsCenter</span><br></br><span id='time2'>2:00 PM</span> - <span id='title2'>SportsCenter</span><br></br><span id='time3'>3:00 PM</span> - <span id='title3'>SportsCenter Special: On the Clock</span><br></br><span id='time4'>4:00 PM</span> - <span id='title4'>NFL Live</span><br></br> I want to know how to work it out on per timing how long the programme will last for, e.g I want to work it out between time1 and time2 to find out how long it will last which it make 60 mins.Does anyone know how i can compare with each timing on per programme before resizing on per image?Any advice would be much appreicated.Thanks in advance Link to comment https://forums.phpfreaks.com/topic/277311-create-row-on-per-timing/ Share on other sites More sharing options...
Barand Posted April 25, 2013 Share Posted April 25, 2013 Based on what you have told us, and the code you have shown us, I would say you probably need to change "get-listing.php". Link to comment https://forums.phpfreaks.com/topic/277311-create-row-on-per-timing/#findComment-1426581 Share on other sites More sharing options...
mark103 Posted April 25, 2013 Author Share Posted April 25, 2013 Sorry I have forgotten to include the code for get-listing.php. Here it is: <html> <body> <script> function ajaxpage(str) { if (window.XMLHttpRequest) { // code for IE7+, Firefox, Chrome, Opera, Safari xmlhttp=new XMLHttpRequest(); } else {// code for IE6, IE5 xmlhttp=new ActiveXObject("Microsoft.XMLHTTP") } xmlhttp.onreadystatechange=function() { if (xmlhttp.readyState==4 && xmlhttp.status==200) { } } xmlhttp.open("GET",".php?q="+str,true); xmlhttp.send(); } </script> <?php define('DB_HOST', 'localhost'); define('DB_USER', 'myusername'); define('DB_PASSWORD', 'mypassword'); define('DB_DATABASE', 'mydbname_tvguide'); $errmsg_arr = array(); $errflag = false; $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD); if(!$link) { die('Failed to connect to server: ' . mysql_error()); } $db = mysql_select_db(DB_DATABASE); if(!$db) { die("Unable to select database"); } if($errflag) { $_SESSION['ERRMSG_ARR'] = $errmsg_arr; echo implode('<br />',$errmsg_arr); } else { $qrytable1="SELECT id, channels FROM tvguide"; $result1=mysql_query($qrytable1) or die('Error:<br />' . $qry . '<br />' . mysql_error()); while ($row = mysql_fetch_array($result1)) { echo "</br>"; echo "<td>".$row['channels']."</td>"; echo "</br>"; } } mysql_close($link); ?> </body> </html> I want to know how i can resizing the images for per programme in my php when I want to comare the timing for per programme how long the programme will last for, e.g 30 mins, 60 mins...etc do you know how i can compare the timing for per programme using with this tags? <span id='time1'>1:00 PM</span><span id='time2'>2:00 PM</span><span id='time3'>4:00 PM</span><span id='time4'>5:00 PM</span> Link to comment https://forums.phpfreaks.com/topic/277311-create-row-on-per-timing/#findComment-1426590 Share on other sites More sharing options...
mark103 Posted April 26, 2013 Author Share Posted April 26, 2013 can someone help me please?????????? Link to comment https://forums.phpfreaks.com/topic/277311-create-row-on-per-timing/#findComment-1426720 Share on other sites More sharing options...
Barand Posted April 26, 2013 Share Posted April 26, 2013 I recall that helping you is just rewarded by insults for our efforts. http://forums.phpfreaks.com/topic/276583-how-to-print-data-in-html-from-php/?do=findComment&comment=1423190 Link to comment https://forums.phpfreaks.com/topic/277311-create-row-on-per-timing/#findComment-1426723 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.