users zoek fout - Forum

E

Eris -

08-04-2006 17:03

bron code

D

David

08-04-2006 17:07

wat moet ik dan veranderen?

D

David

08-04-2006 17:08

<?php
$db = mysql_connect("localhost","myzite","2pac%%") or mysql_die("Unable to connect");
mysql_select_db("myzite_db",$db);

function mysql_die($error = "unknown")
{
echo "<H1>Error:". $error."</H1>";
exit;
}

if ($sitenaam == ""){
print('

<HTML><HEAD>
<META content="text/html; charset=windows-1252" http-equiv=Content-Type>

<TABLE width="100%" height="100%"><TR><TD valign="midle" align="midle"><center>
<META content="MSHTML 5.00.2614.3500" name=GENERATOR></HEAD>
<BODY bgcolor="1E90FF" TEXT="000000">
<CENTER>

<TABLE border=1 width=413>
<TBODY>
<TR>
<TD colspan="3" align=middle valign=top bgcolor="00bfff" height="12"><font color="#000000">
My Runescape Profielen
</TD>
</TR>
<TR>
<TD colspan="3" align=middle valign=top width=409 colspan="2">

<center>Voer het de profiel naam in die je wilt bekijken<br><form action="index.php3" method="POST"><input type="tekst" NAME="sitenaam"><br><input type="submit" value="GO!!"></form><br><br>');

$db = mysql_connect("localhost","myzite","2pac%%") or mysql_die("Unable to connect");
mysql_select_db("myzite_db",$db);
$db_query ="SELECT * FROM mysite WHERE sitenaam='placetobe'";

function recordsetNav($db,$db_query,$page_url,$offset=0,$limit=10,$tablewidth='100%',$verbiage=1)
{
# EXAMPLE USAGE: recordsetNav($db,$users_query,$PHP_SELF,$offset,$limit,'75%',0); #

# &$db_connect is the MySQL connection passed by reference #
# $db_query is your entire query string including WHERE criteria and ORDER BY - without the LIMIT statement! #
# $page_url will probably always be $PHP_SELF #
# $tablewidth determines the width of the $navstring table #
# $verbiage, by default set to 'true', prints out "page:$pagenumber/$totalpages total records:$totalrecords" #

$db_result = @mysql_query($db_query,$db);
$totalrecords = @mysql_num_rows($db_result);
$pagenumber = ($offset + $limit) / $limit;
$totalpages = intval($totalrecords/$limit);
if ($totalrecords%$limit > 0) $totalpages++;

// start building navigation string
$navstring = "<table width=\"$tablewidth\" cellspacing=\"0\" cellpadding=\"1\" border=\"0\">";

if ($totalrecords > $limit) // only show <<PREV NEXT>> row if $totalrecords is greater than $limit
{
$navstring .= "<tr>";
if ($offset != 0)
{
$navstring .= "<td valign='middle' width='25%' nowrap><a class='small' href='".$page_url."?offset=".($offset-$limit)."'><b><< PREV</a></b></td>";
} else {
$navstring .= "<td width='25%' nowrap> </td>";
}

$navstring .= "<td align='center' width='50%' class='BG7'>";
for ($i=1;$i<=$totalpages;$i++)
{
if ($i == $pagenumber)
{
$navstring .= "<span class='ATTENTIONsmall'>$i</span> ";
} else {
$nextoffset = $limit * ($i-1);
$navstring .= "<a class='small' href='".$page_url."?offset=".$nextoffset."'>$i</a> ";
}
}
$navstring .= "</td>";

if($totalrecords-$offset <= $limit)
{
$navstring .= "<td width='25%' nowrap> </td>";
} else {
$navstring .= "<td align='right' valign='middle' width='25%' nowrap><a class='small' href='".$page_url."?offset=".($offset+$limit)."'><b>NEXT >></b></a></td>";
}
$navstring .= "</tr>";
}

if ($verbiage)
{
$navstring .= "<tr><td colspan='3' align='center' nowrap>";
$navstring .= "<span class='RGBsmall'>page: <b>".$pagenumber."</b>/<b>".$totalpages."</b>";
$navstring .= "   total records: <b>".$totalrecords."</b></span>";
$navstring .= "</td></tr>";
}
$navstring .= "</table>";

echo $navstring;
}

print('


<head>
<title>MySQL/PHP Recordset Navigation</title>
<style>
body,p {
font-family: Verdana, Geneva, Arial, Helvetica, sans-serif;
font-size: 11px;
color: #000000;
background: #1e90ff;
}
table,th,td {
font-family: Verdana, Geneva, Arial, Helvetica, sans-serif;
font-size: 11px;
}
.RGBsmall {
font-size: 10px;
color: #000000;
background: transparent;
}
.BG7 {
color: #000000;
background: #1e90ff;
}
.ATTENTION {
color: #000000;
font-weight: bold;
background : transparent;
}
.ATTENTIONsmall {
font-size: 10px;
color: #000000;
font-weight: bold;
background : transparent;
}
a {
font-family: Verdana, Geneva, Arial, Helvetica, sans-serif;
font-size: 11px;
color: #000000;
text-decoration: none;
background : transparent;
}
a:active {
font-family: Verdana,Geneva,Arial,Helvetica, sans-serif;
text-decoration: underline;
}
a:hover {
font-family: Verdana,Geneva,Arial,Helvetica, sans-serif;
color: #000000;
text-decoration: underline;
}
a.small {
font-size: 10px;
}
</style>
</head>

<body>
');

if (!isset($offset)) $offset = 0;
$limit = 10; // this detemines max records per page

$users_query = "SELECT * FROM mysite ORDER BY id ASC";
$users_limit = " LIMIT " . $offset . "," . $limit;
$users_display = @mysql_query($users_query.$users_limit) or die ("ERROR: The query failed.");

// table header
echo "<table align='center' width='400' cellspacing='0' cellpadding='1' border='1'>";
echo "<thead>";
echo "<tr><th nowrap bgcolor='00bfff'><font color='000000'>Sitenaam</th><th nowrap bgcolor='00bfff'><font color='000000'>Email</th></tr>";
echo "</thead>";

// table body
echo "<tbody>";
while ($row = @mysql_fetch_array($users_display))
{

$FNAME = $row["sitenaam"];

$USERNAME = $row["name"];
$EMAIL = $row["email"];

echo "<tr><td bgcolor='1e90ff'><font color='000000'> $FNAME</td><td bgcolor='1E90FF'><font color='000000'> $EMAIL</td></tr>";
}
echo "<tr><td height='100%' colspan='5'> </td></tr>";
echo "</tbody>";

// table footer
echo "<tfoot>";
echo "<tr><td align=\"center\" colspan=\"5\">";
recordsetNav($db,$users_query,$PHP_SELF,$offset,$limit,'100%',1);
echo "</td></tr></tfoot></table>";

@mysql_close($db);

print('
</body>
</html>
</center></td></TR></table></TD></TR></TABLE>');
}else {
$requete = "SELECT * FROM mysite WHERE sitenaam='$sitenaam'";
$result = mysql_query ($requete,$db) or mysql_die("Dit profiel bestaat niet meer of heeft nooit bestaan");
$article =mysql_fetch_object($result);
mysql_free_result($result);
if($article->bron ==""){
print('<h2>Dit profiel bestaat niet (meer). Of er is nog niks aan het profiel gedaan.<BR><BR>Probeer het later nog eens!</font></body></h2>');
}else{
print($article->bron);
}
}
?>