hello everyone, hope u ppl r fine :)
well i am a beginner in php and my sql.. but i have no idea of javascript, i just wanted to use topup lightbox for my project.. i want to display the course material and the material is all media files like images,pdf, ppt,audios and videos..i have stored these media files (locally uploaded) and stored urls of media files from youtube,vimeo,picassa,flicke, slideshare in DB as well
this is my script and i've loaded all files as mentioned in the documentation and setup my it just pops up a gray window without any image of other media files.. please check my code and help me solving the problem :(
thanx in advnce :)
start-course.php
<!DOCTYPE HTML>
<html>
<head>
<script type="text/javascript">
TopUp.host = "http://localhost/project/";
TopUp.images_path = "../teacher/graphics/learningmaterial/";
</script>
<script type="text/javascript">
TopUp.host = "http://localhost/project/";
TopUp.players_path = "../players/";
</script>
<script type="text/javascript" src="../javascript/top_up.js"></script>
<script type="text/javascript" src="../javascript/top_up.js?libs=core+clip"></script>
<script type="text/javascript" src="../javascript/top_up.js?images_path=/foo"></script>
<?php include("../includes/pre-header.php");?>
<title>My Courses</title>
</head>
<body>
<div class="container">
<?php include("../includes/header.php"); ?>
<?php include("includes/nav.php"); ?>
<div id="maincontent">
<div class="span-24 last">
<div id="breadcrumbs" class="mycss">
<a href="index.php">Home</a> >
<a href="my-courses.php">My Courses</a> >
<a href="start-course.php"><?php echo $title; ?></a> >
Start Course
</div>
</div>
<?php include("includes/offered-courses-aside.php"); ?>
<br /> <br />
<div class="span-18 last">
<h2 class="alt"><?php echo $title ?></h2>
<?php
$con=mysql_connect($dbserver,$dbusername,$dbpassword);
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db($dbname, $con);
$result = mysql_query("SELECT * FROM learningmaterial WHERE (coursesid=".$cid.") ORDER BY sequence ASC");
echo "<table border='1' style='width:500px;'> <br />";
while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo " <h5>" . $row['title'] . "</h5>";
if ($row['type'] === 'youtube video')
{
echo "<img src='graphics/youtube-icon.png'/> <br />";
}
elseif ($row['type'] === 'vimeo video')
{
echo "<img src='graphics/vimeo-icon.png'/> <br />";
}
elseif ($row['type'] === 'youtube audio')
{
echo "<img src='graphics/youtube-icon.png'/> <br />";
}
elseif ($row['type'] === 'Flickr')
{
echo "<img src='graphics/flickr-icon.png'/> <br />";
}
elseif ($row['type'] === 'Picasa')
{
echo "<img src='graphics/picassa-icon.png'/> <br />";
}
elseif ($row['type'] === 'video')
{
echo "<img src='graphics/local-icon.png'/> <br />";
}
elseif ($row['type'] === 'audio')
{
echo "<img src='graphics/local.png'/> <br />";
}
elseif ($row['type'] === 'image')
{
echo "<img src='graphics/local.png'/> <br />";
}
elseif ($row['type'] === 'ppt')
{
echo "<img src='graphics/local.png'/> <br />";
}
elseif ($row['type'] === 'pdf')
{
echo "<img src='graphics/local.png'/> <br />";
}
else
{
echo " ";
}
"<br />";
echo " <p class='des'>" . $row['description'] . "</p> <br />";
if ($row['source']==='E')
{
echo "<a href='".$row['url']."' class='top_up' toptions='shaded = 1, overlayClose = 1 layout = quicklook, width = 1010, height = 600, type = auto, effect = fade'>CLICK TO VIEW!</a>";
}
elseif ($row['source']==='I' && $row['type']=='image')
{
echo "<a href='".$row['internalpath']."' class='top_up' toptions='shaded = 1, overlayClose = 1 layout = quicklook, width = 1010, height = 600, type = image,effect = fade'>CLICK TO VIEW!</a>";
echo "<img src='../teacher/".$row['internalpath']."'/>";
}
else{
echo "Nothing";
}
}
echo "</table>";
mysql_close($con);
?>