Viewing file:  courses.php (3.85 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0, shrink-to-fit=no">
<title>Untitled</title>
<link rel="stylesheet" href="courses/assets/bootstrap/css/bootstrap.min.css">
<link rel="stylesheet" href="courses/assets/fonts/fontawesome-all.min.css">
<link rel="stylesheet" href="courses/assets/fonts/font-awesome.min.css">
<link rel="stylesheet" href="courses/assets/fonts/fontawesome5-overrides.min.css">
<link rel="stylesheet" href="courses/assets/css/Customizable-Carousel-swipe-enabled.css">
<link rel="stylesheet" href="courses/assets/css/Lista-Productos-Canito.css">
<link rel="stylesheet" href="courses/assets/css/styles.css">
</head>
<body>
<link rel="stylesheet" href="divider/assets/bootstrap/css/bootstrap.min.css">
<link rel="stylesheet" href="divider/assets/css/divider-text-middle.css">
<link rel="stylesheet" href="divider/assets/css/styles.css">
<h2 class="text-white"></h2>
<div style="text-align:center;">
<h2 class="divider-style"><span>ERA COURSES</span></h2>
</div>
<script src="divider/assets/js/jquery.min.js"></script>
<script src="divide/rassets/bootstrap/js/bootstrap.min.js"></script>
<div id="Div_Promo_Carousel" class="carousel slide" data-ride="carousel">
<div>
</div>
<?php include '..connect.php';?>
<?php
// Get the search variable from URL
$var = 1;
$trimmed = trim($var); //trim whitespace from the stored variable
// rows to return
$limit=1000;
// check for an empty string and display a message.
if ($trimmed == "")
{
exit;
}
// check for a search parameter
if (!isset($var))
{
echo "<p>We dont seem to have a search parameter!</p>";
exit;
}
// Build SQL Query
$query = "select * from coureses
"; // EDIT HERE and specify your table and field names for the SQL query
$numresults=mysql_query($query);
$numrows=mysql_num_rows($numresults);
// If we have no results, offer a google search as an alternative
if ($numrows == 0)
{
}
// next determine if s has been passed to script, if not use 0
if (empty($s)) {
$s=0;
}
// get results
$query .= " limit $s,$limit";
$result = mysql_query($query) or die("Couldn't execute query");
$sr=0;
// begin to show results set
$count = 1 + $s ;
$amountss=0;
echo "<table id=\"example\" class=\"table table-striped table-bordered\" cellspacing=\"0\" width=\"100%\">\n";
echo " <thead>\n";
echo " <tr>\n";
echo " <th>Id</th>\n";
echo " <th>Course</th>\n";
echo " <th>Duration</th>\n";
echo " <th>Details</th>\n";
echo " </tr>\n";
echo " </thead>\n";
// now you can display the results returned
while ($row= mysql_fetch_array($result))
{
$sr=$sr+1;
echo " <tr>\n";
echo " <td>$sr</td>\n";
echo " <td>$row[coursename]</td>\n";
echo " <td>$row[duration]</td>\n";
echo " <td>$row[topics]</td>\n";
echo " </tr>\n";
$count++ ;
}
$currPage = (($s/$limit) + 1);
//break before paging
echo "";
// next we need to do the links to other results
if ($s>=1) { // bypass PREV link if s is 0
$prevs=($s-$limit);
print "<a href=\"$PHP_SELF?s=$prevs&q=$var\"><<
Prev 10</a> ";
}
// calculate number of pages needing links
$pages=intval($numrows/$limit);
// $pages now contains int of pages needed unless there is a remainder from division
?>
<tbody>
</tbody>
</table></div>
</div>
</div>
</div>
<script src="courses/assets/js/jquery.min.js"></script>
<script src="courses/assets/bootstrap/js/bootstrap.min.js"></script>
<script src="courses/assets/js/Customizable-Carousel-swipe-enabled.js"></script>
</body>
</html>
|