Lawn Care Business Forum Lawn Care Business Book Lawn Care Business Blog Lawn Care Software
Home Forum Contract & Flyer Templates Blog Software Videos Podcast Calculators / Estimators Store Mower Review Design It Yourself Lawn Business School

Go Back   GopherHaul Landscaping & Lawn Care Business Marketing Forum

» GopherHaul Lawn Care Business Marketing Podcasts
"; //Include our login information include_once('./uploaded-files/pages/estimator_db_login.php'); include_once('./uploaded-files/pages/ditech_utils.php'); // include_once('./uploaded-files/pages/ditech_utils.php'); // sets to show dollars in u.s. version setlocale(LC_MONETARY, 'en_US'); // set max image size height $MaxImageSize = 100; $connection = mysql_connect($db_host, $db_username, $db_password); if (!$connection) { die ("Could not connect to the database:
". mysql_error()); } // Select the database $db_select = mysql_select_db($db_database); if (!$db_select){ die ("Could not select the database:
". mysql_error( )); } function imageResize($width, $height, $target) { //takes the larger size of the width and height and applies the formula accordingly...this is so this script will work dynamically with any size image if ($width > $height) { $percentage = ($target / $width); } else { $percentage = ($target / $height); } //gets the new value and applies the percentage, then rounds the value $width = round($width * $percentage); $height = round($height * $percentage); //returns the new sizes in html image tag format...this is so you can plug this function inside an image tag and just get the return "width=\"$width\" height=\"$height\""; } // ******************************************************************* if (isset($_GET['Page'])) { $Page = mysqlclean($_GET,"Page",100,$connection); } else { $Page = 1; } echo "

GopherHaul Lawn Care Business Marketing Podcasts

"; // ******************************************************************* if (isset($_POST['Listen'])) { $UniqueID = mysqlclean($_POST,"UniqueID",100,$connection); echo ""; echo "
"; $query = "SELECT * FROM GopherHaulPodcasts Where UniqueID='$UniqueID'"; if (!(@mysql_query($query,$connection))) showerror; $result=mysql_query($query); $num=mysql_numrows($result); $i=0; while ($i < $num) { $PodcastTitle=mysql_result($result,$i,"PodcastTitle"); $PodcastTalkshoeID=mysql_result($result,$i,"PodcastTalkshoeID"); $DateCreated=mysql_result($result,$i,"DateCreated"); echo ""; echo ""; $i++; } echo "

$PodcastTitle

"; echo " "; echo "
"; } // ******************************************************************* //else // ******************************************************************* { $TotalCountOfVideosToShowPerPage = 12; $MaxVideosInRow = 4; $CurrentVideoInRowCounter = 1; echo "
"; echo "
Page - $Page "; $query = "SELECT * FROM GopherHaulPodcasts Order by DateCreated DESC"; if (!(@mysql_query($query,$connection))) showerror; $result=mysql_query($query); $num=mysql_numrows($result); $i=0; // while ($i < $num) //calculate total pages of videos to show $TotalPagesOfVideos = ($num / $TotalCountOfVideosToShowPerPage); //now round it up. $TotalPagesOfVideos = ceil($TotalPagesOfVideos); //Figure out where to start count $i = (($Page * $TotalCountOfVideosToShowPerPage) - $TotalCountOfVideosToShowPerPage); // make sure you don't show more videos per page than asked. if ($num > ($TotalCountOfVideosToShowPerPage * $Page )) { $num = ($TotalCountOfVideosToShowPerPage * $Page ); } while ($i < $num) { $UniqueID=mysql_result($result,$i,"UniqueID"); $PodcastTitle=mysql_result($result,$i,"PodcastTitle"); $PodcastTalkshoeID=mysql_result($result,$i,"PodcastTalkshoeID"); $DateCreated=mysql_result($result,$i,"DateCreated"); // is this the first video in the row? if ($CurrentVideoInRowCounter == 1) { echo ""; $CurrentVideoInRowCounter++; } //is this video somewhere in the middle of the row? elseif (($CurrentVideoInRowCounter > 1) and ($CurrentVideoInRowCounter < $MaxVideosInRow)) { echo ""; $CurrentVideoInRowCounter++; } //is this video somewhere in the middle of the row? elseif ($CurrentVideoInRowCounter == $MaxVideosInRow) { echo ""; $CurrentVideoInRowCounter = 1; } // echo ""; $i++; } echo "
$DateCreated

$PodcastTitle
"; echo '
'; echo "

$DateCreated

$PodcastTitle
"; echo '
'; echo "

$DateCreated

$PodcastTitle
"; echo '
'; echo "

$VideoTitle
Page - "; $i=1; while ($i <= $TotalPagesOfVideos) { echo "$i,"; $i++; } echo "
"; } echo ""; ?>
Powered by vBadvanced CMPS v3.1.0

All times are GMT -5. The time now is 02:38 PM.


(C) 2011 Riggs Publications - Terms of use & Privacy Policy

All times are GMT -5. The time now is 02:38 PM.

(C) 2011 Riggs Publications - Terms of use & Privacy Policy