I put together a page and it gets its information from a mysql database.
This is the code:
Code:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>
<body>
<?php
$dbhost = 'localhost';
$dbuser = 'username';
$dbpass = 'password';
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die('Error connecting to mysql');
$dbname = 'database1';
$out = mysql_select_db($dbname,$conn) or die(mysql_error($conn));
$table = 'links';//Table name here
$limit = 10;//Limit of results here
$page = $_GET['page'];//Gets the page
$totalrows = mysql_num_rows(mysql_query("SELECT ModelName FROM $table"));//Get the total rows of the table
if(empty($page))//If the page is empty
{
$page = '1';//sets the page to 1
};
$start = ($page-1)*$limit;//set the start page
$start = round($start,0);//rounds it
$result = mysql_query("SELECT * FROM $table LIMIT $start, $limit");//makes the query, here you can add for example
//WHERE something='somethingelse'
while ($r = mysql_fetch_array($result))
{
echo "$r[ModelName]
";
echo "$r[ModelGroupUrl]
";
echo "$r[SiteStatus]
'";
echo"<img src=\"$ImageLocation\" width=150 height=150>
";
};
$totalpages = $totalrows / $limit;//Gets the totalpages
$totalpages = ceil($totalpages);//rounds them to the bigger number, so if the limit is 10 and there are 11 results it will show 2 paegs instead of 1 :)
if($page == 1)//if the page is 1
{
$actualpage = '[1]';//actial page 1
}
else
{
$actualpage = "[$page]";//else actualpage is the one we get using the $_GET
}
if($page < $totalpages)//if the page is smaller than totalpages
{
$nv = $page+1;//next page
$pv = $page-1;//prev page
$nextpage = "<a href=?page=$nv>></a>";//next page link
$prevpage = "<a href=?page=$pv><</a>";//preg page link
$firstpage = "<a href=\"?page=1\">«</a>";//first page
$finalpage = "<a href=\"?page=$totalpages\">»</a>";//last page
}
if($page == '1')//if the page is 1
{
$nv = $page+1;
$nextpage = "<a href=?page=$nv>> </a>";
$prevpage = "<";
$firstpage = "«";
$finalpage = "<a href=\"?page=$totalpages\">»</a>";
}elseif($page == $totalpages){//is the page is equal than the totalpages
$pv = $page-1;
$nextpage = ">";
$prevpage = "<a href=?page=$pv><</a>";
$firstpage = "<a href=\"?page=1\">«</a>";
$finalpage = "»";
}
if($totalpages == '1' || $totalpages == '0'){//if totalpages is 1 or 0
$nextpage = ">";
$prevpage = "<";
$firstpage = "«";
$finalpage = "»";
}
echo "$firstpage $prevpage $actualpage $nextpage $finalpage
Pages: $totalpages";//echoes the pages at the botton of the file
?>
</body>
</html>
The problem im having is, i want it to display a image. The url of the image is stored in the DB. I also want it to display links that are stored in the DB as links on the displayed page.
I tried several differnt things and nothing seems to work. Can i get some help
Displaying images
Linear Mode
