include_once("/home/chasing/pass/dogs.php");
?>
// Set Tuesday value of this week ---------------------------------------------
include("dvd_new/dvd_week.php");
$query = "SELECT * FROM dvds WHERE date='$tues'";
$result = mysqli_query($connection, $query);
$num = mysqli_num_rows($result);
// mysql_close();
$year = substr($tues, 0, 4); // returns 4 digit year
$month = substr($tues, 4, 2); // returns 2 digit month
$day = substr($tues, -2); // returns 2 digit day
$tues = date("F d, Y", mktime(0, 0, 0, $month, $day, $year));
$newtues = date("Ymd", mktime(0, 0, 0, $month, $day, $year)); //for more link
$mond = date("Ymd", mktime(0, 0, 0, $month, $day+6, $year)); // for more link
$featyear1 = $year; // Set for featured DVD in middle of page
?>
echo $tues . "
"; ?>
$i=0;
//echo "";
echo "";
while ($i < $num)
{
echo "";
$title = mysqli_result($result,$i,"title");
$title = stripslashes($title);
// Make sure entire title isn't longer than 122 characters, if so, cut at 122 and add "..."
if(strlen($title) > 122)
{
$title = substr($title, 0, 122);
$title = $title . "...";
}
// Travel through title string, putting a space after slashes that don't already have a space after them
if (stristr($title, "/"))
{
$title = str_replace("/", "/ ", $title);
}
// Make sure title doesn't have a word longer than 22 characters, if so, cut word
$words = explode(" ", $title);
$j=0;
foreach ($words as $value)
{
if(strlen($value) > 22)
{
$words[$j] = substr("$value", 0, 22);
}
$j++;
}
$title = implode(" ",$words);
$asin = mysqli_result($result,$i,"asin");
// Set featured DVD values for middle of page
if ($i == 1)
{
$featdvd1 = $asin;
$feattitle1 = $title;
}
echo "";
echo " ";
echo " ";
echo " | ";
echo "";
?>
echo $title." ";
?>
echo " | ";
echo " ";
$i++;
}
echo " ";
// echo " ";
?>
|
// Set values for release week 2 --------------------------------------------
include("dvd_new/dvd_week2.php");
$query = "SELECT * FROM dvds WHERE date='$tues'";
$result = mysqli_query($connection, $query);
$num = mysqli_num_rows($result);
$year = substr($tues, 0, 4); // returns 4 digit year
$month = substr($tues, 4, 2); // returns 2 digit month
$day = substr($tues, -2); // returns 2 digit day
$tues = date("F d, Y", mktime(0, 0, 0, $month, $day, $year));
$newtues = date("Ymd", mktime(0, 0, 0, $month, $day, $year)); //for more link
$mond = date("Ymd", mktime(0, 0, 0, $month, $day+6, $year)); // for more link
$featyear2 = $year; // Set for featured DVD in middle of page
?>
echo $tues . "
"; ?>
$i=0;
// echo "";
echo "";
while ($i < $num)
{
echo "";
$title = mysqli_result($result,$i,"title");
$title = stripslashes($title);
// Make sure entire title isn't longer than 122 characters, if so, cut at 122 and add "..."
if(strlen($title) > 122)
{
$title = substr($title, 0, 122);
$title = $title . "...";
}
// Travel through title string, putting a space after slashes that don't already have a space after them
if (stristr($title, "/"))
{
$title = str_replace("/", "/ ", $title);
}
// Make sure title doesn't have a word longer than 22 characters, if so, cut word
$words = explode(" ", $title);
$j=0;
foreach ($words as $value)
{
if(strlen($value) > 22)
{
$words[$j] = substr("$value", 0, 22);
}
$j++;
}
$title = implode(" ",$words);
$asin = mysqli_result($result,$i,"asin");
// Set featured DVD values for middle of page
if ($i == 1)
{
$featdvd2 = $asin;
$feattitle2 = $title;
}
echo "";
echo " ";
echo " ";
echo " | ";
echo "";
?>
echo $title . " ";
?>
echo " | ";
echo " ";
$i++;
}
echo " ";
echo " ";
// echo " ";
// Set values for release week 3 --------------------------------------------
include("dvd_new/dvd_week3.php");
$query = "SELECT * FROM dvds WHERE date='$tues'";
$result = mysqli_query($connection, $query);
$num = mysqli_num_rows($result);
$year = substr($tues, 0, 4); // returns 4 digit year
$month = substr($tues, 4, 2); // returns 2 digit month
$day = substr($tues, -2); // returns 2 digit day
$tues = date("F d, Y", mktime(0, 0, 0, $month, $day, $year));
$newtues = date("Ymd", mktime(0, 0, 0, $month, $day, $year)); //for more link
$mond = date("Ymd", mktime(0, 0, 0, $month, $day+6, $year)); // for more link
?>
echo " " . $tues . " "; ?>
$i=0;
echo "";
while ($i < $num)
{
$title = mysqli_result($result,$i,"title");
$title = stripslashes($title);
// Make sure entire title isn't longer than 122 characters, if so, cut at 122 and add "..."
if(strlen($title) > 122)
{
$title = substr($title, 0, 122);
$title = $title . "...";
}
// Travel through title string, putting a space after slashes that don't already have a space after them
if (stristr($title, "/"))
{
$title = str_replace("/", "/ ", $title);
}
// Make sure title doesn't have a word longer than 24 characters, if so, cut word
$words = explode(" ", $title);
$j=0;
foreach ($words as $value)
{
if(strlen($value) > 24)
{
$words[$j] = substr("$value", 0, 24);
}
$j++;
}
$title = implode(" ",$words);
$asin = mysqli_result($result,$i,"asin");
echo "- " . $title . "
";
$i++;
}
echo " ";
echo " ";
// Set values for release week 4 --------------------------------------------
include("dvd_new/dvd_week4.php");
$query = "SELECT * FROM dvds WHERE date='$tues'";
$result = mysqli_query($connection, $query);
$num = mysqli_num_rows($result);
$year = substr($tues, 0, 4); // returns 4 digit year
$month = substr($tues, 4, 2); // returns 2 digit month
$day = substr($tues, -2); // returns 2 digit day
$tues = date("F d, Y", mktime(0, 0, 0, $month, $day, $year));
$newtues = date("Ymd", mktime(0, 0, 0, $month, $day, $year)); //for more link
$mond = date("Ymd", mktime(0, 0, 0, $month, $day+6, $year)); // for more link
?>
echo " " . $tues . " "; ?>
$i=0;
echo "";
while ($i < $num)
{
$title = mysqli_result($result,$i,"title");
$title = stripslashes($title);
// Make sure entire title isn't longer than 122 characters, if so, cut at 122 and add "..."
if(strlen($title) > 122)
{
$title = substr($title, 0, 122);
$title = $title . "...";
}
// Travel through title string, putting a space after slashes that don't already have a space after them
if (stristr($title, "/"))
{
$title = str_replace("/", "/ ", $title);
}
// Make sure title doesn't have a word longer than 24 characters, if so, cut word
$words = explode(" ", $title);
$j=0;
foreach ($words as $value)
{
if(strlen($value) > 24)
{
$words[$j] = substr("$value", 0, 24);
}
$j++;
}
$title = implode(" ",$words);
$asin=mysqli_result($result,$i,"asin");
echo "- " . $title . "
";
$i++;
}
echo " ";
echo " ";
// Set values for release week 5 --------------------------------------------
include("dvd_new/dvd_week5.php");
$query = "SELECT * FROM dvds WHERE date='$tues'";
$result = mysqli_query($connection, $query);
$num = mysqli_num_rows($result);
$year = substr($tues, 0, 4); // returns 4 digit year
$month = substr($tues, 4, 2); // returns 2 digit month
$day = substr($tues, -2); // returns 2 digit day
$tues = date("F d, Y", mktime(0, 0, 0, $month, $day, $year));
$newtues = date("Ymd", mktime(0, 0, 0, $month, $day, $year)); //for more link
$mond = date("Ymd", mktime(0, 0, 0, $month, $day+6, $year)); // for more link
?>
echo " " . $tues . " "; ?>
$i=0;
echo "";
while ($i < $num)
{
$title = mysqli_result($result,$i,"title");
$title = stripslashes($title);
// Make sure entire title isn't longer than 122 characters, if so, cut at 122 and add "..."
if(strlen($title) > 122)
{
$title = substr($title, 0, 122);
$title = $title . "...";
}
// Travel through title string, putting a space after slashes that don't already have a space after them
if (stristr($title, "/"))
{
$title = str_replace("/", "/ ", $title);
}
// Make sure title doesn't have a word longer than 24 characters, if so, cut word
$words = explode(" ", $title);
$j=0;
foreach ($words as $value)
{
if(strlen($value) > 24)
{
$words[$j] = substr("$value", 0, 24);
}
$j++;
}
$title = implode(" ",$words);
$asin = mysqli_result($result,$i,"asin");
echo "- " . $title . "
";
$i++;
}
echo " ";
echo " ";
?>
|
|
|
New Release DVDs
|
|
// Set values for last week --------------------------------------------
include("dvd_new/dvd_weeklast.php");
$query = "SELECT * FROM dvds WHERE date='$tues'";
$result = mysqli_query($connection, $query);
$num = mysqli_num_rows($result);
$year = substr($tues, 0, 4); // returns 4 digit year
$month = substr($tues, 4, 2); // returns 2 digit month
$day = substr($tues, -2); // returns 2 digit day
$tues = date("F d, Y", mktime(0, 0, 0, $month, $day, $year));
$newtues = date("Ymd", mktime(0, 0, 0, $month, $day, $year)); //for more link
$mond = date("Ymd", mktime(0, 0, 0, $month, $day+6, $year)); // for more link
?>
// Get Image and Title for first dvd (#1 seller) of release list last week, then display
/* $asin = mysqli_result($result,0,"asin");
$title = mysqli_result($result,0,"title");
$title = stripslashes($title);
echo " ";
*/
?>
// echo $title . "
";
?>
echo " " . $tues . " "; ?>
$i=0;
echo "";
while ($i < $num)
{
$title=mysqli_result($result,$i,"title");
$title = stripslashes($title);
// Make sure entire title isn't longer than 122 characters, if so, cut at 122 and add "..."
if(strlen($title) > 122)
{
$title = substr($title, 0, 122);
$title = $title . "...";
}
// Travel through title string, putting a space after slashes that don't already have a space after them
if (stristr($title, "/"))
{
$title = str_replace("/", "/ ", $title);
}
// Make sure title doesn't have a word longer than 24 characters, if so, cut word
$words = explode(" ", $title);
$j=0;
foreach ($words as $value)
{
if(strlen($value) > 24)
{
$words[$j] = substr("$value", 0, 24);
}
$j++;
}
$title = implode(" ",$words);
$asin = mysqli_result($result,$i,"asin");
echo "- " . $title . "
";
$i++;
}
echo " ";
echo " ";
?> |
Put your DVD Collection online for free with our SPLYCED DVD Catalog Software. Edit your collection remotely and allow
others to view your DVD Catalog.
 New DVD Collections:

// Display new DVD collections
$i=0;
echo "";
?>
|
|