s_kaiba
Legacy Member
Ik heb dus weer een probleempje en hoop dus op wat hulp.
Dus ik ben begonnen met een site te maken van mijn games collectie, maar alles wat ik kan of doe heb ik geleerd via een boek zoals eerder eens vermeld.
Dus nu is mijn probleem dat ik bezig ben met mijn databanken aan te maken en zolang ik het in internet explorer test is er geen enkel probleem.
Zodra ik het in firefox bekijk is re dus wel een probleem.
Ineens staat er niets zoals het zou moeten staan en is alles eigelijk een beetje zoals het niet zou moeten zijn.
De linken staan anders en mijn tabbelen zijn volledig verplaatst.
Dus wie kan mij helpen??
Hier zijn alvast de codes.
<?php require_once('../Connections/retro_fan.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
$currentPage = $_SERVER["PHP_SELF"];
$maxRows_Recordset1 = 10;
$pageNum_Recordset1 = 0;
if (isset($_GET['pageNum_Recordset1'])) {
$pageNum_Recordset1 = $_GET['pageNum_Recordset1'];
}
$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;
mysql_select_db($database_retro_fan, $retro_fan);
$query_Recordset1 = "SELECT * FROM `playstation1.a`";
$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);
$Recordset1 = mysql_query($query_limit_Recordset1, $retro_fan) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
if (isset($_GET['totalRows_Recordset1'])) {
$totalRows_Recordset1 = $_GET['totalRows_Recordset1'];
} else {
$all_Recordset1 = mysql_query($query_Recordset1);
$totalRows_Recordset1 = mysql_num_rows($all_Recordset1);
}
$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;
$queryString_Recordset1 = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_Recordset1") == false &&
stristr($param, "totalRows_Recordset1") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_Recordset1 = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_Recordset1 = sprintf("&totalRows_Recordset1=%d%s", $totalRows_Recordset1, $queryString_Recordset1);
?><!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=utf-8" />
<title>Playstation</title>
<link href="cssretro.css" rel="stylesheet" type="text/css" />
<link href="file:///E|/Documents and Settings/andy/Bureaublad/school/Retro_fan/cssretro.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div id="container">Hier wordt de inhoud voor id "container" weergegeven
<div class="alfabet" id="voet">0 A <strong> </strong>B C D E F G H I J K L M N O P Q R S T U V W X Y Z</div>
<div id="header"><img src="../images/banner.jpg" width="700" height="50" /></div>
<div id="Menu">
<p class="menu1"> </p>
<p class="menu1"><a href="../index.html">Home</a></p>
<p class="menu1"><a href="../playstation.html">playstation</a></p>
<p class="extra_link"><a href="../playstation1.html">Psx</a></p>
<p class="extra_link"><a href="../playstation2.html">Ps2</a></p>
<p class="extra_link"><a href="../playstation3.html">Ps3</a></p>
<p class="extra_link"><a href="../psp.html">Psp</a></p>
<p class="menu1"> </p>
<p> </p>
</div>
<div id="site">
<table width="166" border="1">
<tr>
<td width="66"><a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, max(0, $pageNum_Recordset1 - 1), $queryString_Recordset1); ?>">Vorige</a></td>
<td width="418"><a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, min($totalPages_Recordset1, $pageNum_Recordset1 + 1), $queryString_Recordset1); ?>">Volgende</a></td>
</tr>
</table>
<p> </p>
<table width="520" border="1">
<tr>
<td class="lijst">Titel</td>
<td class="lijst">CD</td>
<td class="lijst">Back</td>
<td class="lijst">Front</td>
<td class="lijst">Book</td>
<td class="lijst">Information</td>
</tr>
<?php do { ?>
<tr>
<td class="lijst"><?php echo $row_Recordset1['Titel']; ?></td>
<td class="lijst"><?php echo $row_Recordset1['CD']; ?></td>
<td class="lijst"><?php echo $row_Recordset1['Back']; ?></td>
<td class="lijst"><?php echo $row_Recordset1['Front']; ?></td>
<td class="lijst"><?php echo $row_Recordset1['Book']; ?></td>
<td class="lijst"><?php echo $row_Recordset1['Information']; ?></td>
<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
</tr>
<tr>
<td colspan="6"></td>
</tr>
</table>
<p> </p>
<div align="center"></div>
<p> </p>
<p> </p>
<p class="welcome"> </p>
<p> </p>
<p> </p>
<p class="welcome"> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
</div>
</div>
</body>
</html>
<?php
mysql_free_result($Recordset1);
?>
Dus ik ben begonnen met een site te maken van mijn games collectie, maar alles wat ik kan of doe heb ik geleerd via een boek zoals eerder eens vermeld.
Dus nu is mijn probleem dat ik bezig ben met mijn databanken aan te maken en zolang ik het in internet explorer test is er geen enkel probleem.
Zodra ik het in firefox bekijk is re dus wel een probleem.
Ineens staat er niets zoals het zou moeten staan en is alles eigelijk een beetje zoals het niet zou moeten zijn.
De linken staan anders en mijn tabbelen zijn volledig verplaatst.
Dus wie kan mij helpen??
Hier zijn alvast de codes.
<?php require_once('../Connections/retro_fan.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
$currentPage = $_SERVER["PHP_SELF"];
$maxRows_Recordset1 = 10;
$pageNum_Recordset1 = 0;
if (isset($_GET['pageNum_Recordset1'])) {
$pageNum_Recordset1 = $_GET['pageNum_Recordset1'];
}
$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;
mysql_select_db($database_retro_fan, $retro_fan);
$query_Recordset1 = "SELECT * FROM `playstation1.a`";
$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);
$Recordset1 = mysql_query($query_limit_Recordset1, $retro_fan) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
if (isset($_GET['totalRows_Recordset1'])) {
$totalRows_Recordset1 = $_GET['totalRows_Recordset1'];
} else {
$all_Recordset1 = mysql_query($query_Recordset1);
$totalRows_Recordset1 = mysql_num_rows($all_Recordset1);
}
$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;
$queryString_Recordset1 = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_Recordset1") == false &&
stristr($param, "totalRows_Recordset1") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_Recordset1 = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_Recordset1 = sprintf("&totalRows_Recordset1=%d%s", $totalRows_Recordset1, $queryString_Recordset1);
?><!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=utf-8" />
<title>Playstation</title>
<link href="cssretro.css" rel="stylesheet" type="text/css" />
<link href="file:///E|/Documents and Settings/andy/Bureaublad/school/Retro_fan/cssretro.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div id="container">Hier wordt de inhoud voor id "container" weergegeven
<div class="alfabet" id="voet">0 A <strong> </strong>B C D E F G H I J K L M N O P Q R S T U V W X Y Z</div>
<div id="header"><img src="../images/banner.jpg" width="700" height="50" /></div>
<div id="Menu">
<p class="menu1"> </p>
<p class="menu1"><a href="../index.html">Home</a></p>
<p class="menu1"><a href="../playstation.html">playstation</a></p>
<p class="extra_link"><a href="../playstation1.html">Psx</a></p>
<p class="extra_link"><a href="../playstation2.html">Ps2</a></p>
<p class="extra_link"><a href="../playstation3.html">Ps3</a></p>
<p class="extra_link"><a href="../psp.html">Psp</a></p>
<p class="menu1"> </p>
<p> </p>
</div>
<div id="site">
<table width="166" border="1">
<tr>
<td width="66"><a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, max(0, $pageNum_Recordset1 - 1), $queryString_Recordset1); ?>">Vorige</a></td>
<td width="418"><a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, min($totalPages_Recordset1, $pageNum_Recordset1 + 1), $queryString_Recordset1); ?>">Volgende</a></td>
</tr>
</table>
<p> </p>
<table width="520" border="1">
<tr>
<td class="lijst">Titel</td>
<td class="lijst">CD</td>
<td class="lijst">Back</td>
<td class="lijst">Front</td>
<td class="lijst">Book</td>
<td class="lijst">Information</td>
</tr>
<?php do { ?>
<tr>
<td class="lijst"><?php echo $row_Recordset1['Titel']; ?></td>
<td class="lijst"><?php echo $row_Recordset1['CD']; ?></td>
<td class="lijst"><?php echo $row_Recordset1['Back']; ?></td>
<td class="lijst"><?php echo $row_Recordset1['Front']; ?></td>
<td class="lijst"><?php echo $row_Recordset1['Book']; ?></td>
<td class="lijst"><?php echo $row_Recordset1['Information']; ?></td>
<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
</tr>
<tr>
<td colspan="6"></td>
</tr>
</table>
<p> </p>
<div align="center"></div>
<p> </p>
<p> </p>
<p class="welcome"> </p>
<p> </p>
<p> </p>
<p class="welcome"> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
</div>
</div>
</body>
</html>
<?php
mysql_free_result($Recordset1);
?>
.