Flere sider i php.

Du kan prøve at kigge lidt på koden her: http://www.eksperten.dk/spm/828868

Forstår det stadig ikke :/

Hvordan får vi dig til at forstå det så ? :o)

Prøv dette:

<?php

$page_name = $PHP_SELF;
$start = $_GET['start'];

if (!($start > 0))
{
    $start = 0;
}
$limit = 5;
$this = $start; // + $limit;
$next = $this + $limit;
$back = $this - $limit;

$query = "SELECT * FROM spil";
$result = mysql_query($query) or die("SQL Query failed ...");
$number_rows = mysql_num_rows($result);

$query = "SELECT * FROM spil ORDER BY id DESC LIMIT $start, $limit";
$result = mysql_query($query) or die("SQL Query failed ...");

while($rows = mysql_fetch_array($result))
{
    /* Her skal der stå det fra MySQL db'en */
}
if ($back >= 0)
{
    echo '<br><a href="'.$page_name.'?start='.$back.'">Prev.</a>&nbsp;';
}
$i = 0;
$page_number = 1;

for($i = 0; $i < $number_rows; $i = $i + $limit)
{
    if ($i <> $start)
    {
        echo '<a href="'.$page_name.'?start='.$i.'">'.$page_number.'</a>&nbsp;';
    }
    else
    {
        echo $page_number."&nbsp;";
    }
    $page_number = $page_number + 1; // $page_number++
}

if ($next < $number_rows)
{
    echo '<a href="'.$page_name.'?start='.$next.'">Next&nbsp;</a>';
}

?>

/ep

Variablen $limit indeholder tallet på hvor mange resultater der skal vises per side.

Der hvor der står /* Her skal der stå det fra MySQL db'en */
Er det ikke bare
include "connect.php";
jeg skal ligge ind der?

Nej, men connect.php skal selvfølig inkluderes.
Men der hvor der står /* Her skal der stå det fra MySQL db'en */ skal der stå det du vil hente ud fra MySQL db'en atså i dit tilfælde:

    <td width="100" rowspan="3" height="1"><a target="_blank" href="play.php?id=<?=$row[id]?>"><img src="grafik/spil/<?=$row[kategori]?>/<?=$row[gfx]?>" width="100" height="100" border="0" style="filter:alpha(opacity=70)"/></a></td>
    <td height="1"><a target="_blank" href="play.php?id=<?=$row[id]?>"><strong><?=$row[navn]?></strong></a></td>
    <td height="1"><div align="right"><font color="#000000"> <?=$row[klik]?> hits</font></div></td>
  </tr>
  <tr>
    <td height="43" colspan="2"><a target="_blank" href="play.php?id=<?=$row[id]?>"><?=$row[beskrivelse]?></a></td>
  </tr>
  <tr>
    <td width="283" height="1"><a target="_blank" href="play.php?id=<?=$row[id]?>"><font color="#CCCCCC"><?=$row[link]?></font></a></td>
    <td width="95" height="1">&nbsp;</td>
  </tr>
  <tr>
    <td height="1"><hr color="#EAEAEA" size="1"/></td>
    <td height="1"><hr color="#EAEAEA" size="1"/></td>
    <td height="1"><hr color="#EAEAEA" size="1"/></td>
  </tr>

http://www.bloddue.dk/test1.php

Den siger fejl?..

Hos mig står der slet ikke noget ?

Hvordan deler jeg den kode du gav mig.?..
Så der kommer plads hvor jeg kan ligge hele min egen kode ind..
Forstår du hvad jeg mener?.

Koden skulle gerne se sådan ud:

<?php
include("connect.php");

$page_name = $PHP_SELF;
$start = $_GET['start'];

if (!($start > 0))
{
    $start = 0;
}
$limit = 5;
$this = $start; // + $limit;
$next = $this + $limit;
$back = $this - $limit;

$query = "SELECT * FROM spil";
$result = mysql_query($query) or die("SQL Query failed ...");
$number_rows = mysql_num_rows($result);

$query = "SELECT * FROM spil ORDER BY id DESC LIMIT $start, $limit";
$result = mysql_query($query) or die("SQL Query failed ...");

while($rows = mysql_fetch_array($result))
{
    $id = '$_GET[id]';
?>
    <td width="100" rowspan="3" height="1"><a target="_blank" href="play.php?id=<?=$row[id]?>"><img src="grafik/spil/<?=$row[kategori]?>/<?=$row[gfx]?>" width="100" height="100" border="0" style="filter:alpha(opacity=70)"/></a></td>
    <td height="1"><a target="_blank" href="play.php?id=<?=$row[id]?>"><strong><?=$row[navn]?></strong></a></td>
    <td height="1"><div align="right"><font color="#000000"> <?=$row[klik]?> hits</font></div></td>
    </tr>
    <tr>
    <td height="43" colspan="2"><a target="_blank" href="play.php?id=<?=$row[id]?>"><?=$row[beskrivelse]?></a></td>
    </tr>
    <tr>
    <td width="283" height="1"><a target="_blank" href="play.php?id=<?=$row[id]?>"><font color="#CCCCCC"><?=$row[link]?></font></a></td>
    <td width="95" height="1">&nbsp;</td>
    </tr>
    <tr>
    <td height="1"><hr color="#EAEAEA" size="1"/></td>
    <td height="1"><hr color="#EAEAEA" size="1"/></td>
    <td height="1"><hr color="#EAEAEA" size="1"/></td>
    </tr>
<?php
}
if ($back >= 0)
{
    echo '<br><a href="'.$page_name.'?start='.$back.'">Prev.</a>&nbsp;';
}
$i = 0;
$page_number = 1;

for($i = 0; $i < $number_rows; $i = $i + $limit)
{
    if ($i <> $start)
    {
        echo '<a href="'.$page_name.'?start='.$i.'">'.$page_number.'</a>&nbsp;';
    }
    else
    {
        echo $page_number."&nbsp;";
    }
    $page_number = $page_number + 1; // $page_number++
}

if ($next < $number_rows)
{
    echo '<a href="'.$page_name.'?start='.$next.'">Next&nbsp;</a>';
}

?>

Forstår ikke hvorfor den ikke gider :S

Kan du se fejlen?

Nej, er der mere kode end det du har skrevet ?

<script language="JavaScript">
function popop ()
{
iwin = window.open("anbefal.php", "iwin", "status=no, toolbar=no, location=no,menu=no,width=340,height=290");
}
</script>
<body link="#FFFFFF" vlink="#FFFFFF" alink="#FFFFFF">
<div align="center"><font color="#03679B" size="2" face="Verdana"> <a href="?side=spil&valg=nyeste">10 Nyeste</a> | <a href="?side=spil&valg=popular">10 Popul&aelig;re</a></font></div>
<hr color="#006699" size="1"/>
<div align="center"><a href="#" onClick="popop();"><img src="gfx/tilfojspil.gif" width="69" height="23" /></a></div>
<hr color="#006699" size="1"/>
<table border="0" width="495" height="56">
<tr>
<?
if($_GET["valg"] == "nyeste")
{
echo("");
?>
<table border="0" width="495" height="56">
  <tr>
    <?
include "connect.php";

$sql = mysql_query("select * from spil ORDER BY id DESC LIMIT 0,10");
while($row = mysql_fetch_array($sql)){
$id = '$_GET[id]';
?>
    <td width="100" rowspan="3" height="1"><a target="_blank" href="play.php?id=<?=$row[id]?>"><img src="grafik/spil/<?=$row[kategori]?>/<?=$row[gfx]?>" width="100" height="100" border="0" style="filter:alpha(opacity=70)"/></a></td>
    <td height="1"><a target="_blank" href="play.php?id=<?=$row[id]?>"><strong><?=$row[navn]?></strong></a></td>
    <td height="1"><div align="right"><font color="#000000"> <?=$row[klik]?> hits</font></div></td>
  </tr>
  <tr>
    <td height="43" colspan="2"><a target="_blank" href="play.php?id=<?=$row[id]?>"><?=$row[beskrivelse]?></a></td>
  </tr>
  <tr>
    <td width="283" height="1"><a target="_blank" href="play.php?id=<?=$row[id]?>"><font color="#CCCCCC"><?=$row[link]?></font></a></td>
    <td width="95" height="1">&nbsp;</td>
  </tr>
  <tr>
    <td height="1"><hr color="#EAEAEA" size="1"/></td>
    <td height="1"><hr color="#EAEAEA" size="1"/></td>
    <td height="1"><hr color="#EAEAEA" size="1"/></td>
  </tr>
  <?

  }
?>
<?
}
?>
<?
if($_GET["valg"] == "popular")
{
echo("");
?>
<table border="0" width="495" height="56">
  <tr>
    <?
include "connect.php";

$sql = mysql_query("select * from spil ORDER BY klik DESC LIMIT 0,10");
while($row = mysql_fetch_array($sql)){
$id = '$_GET[id]';
?>
    <td width="100" rowspan="3" height="1"><a target="_blank" href="play.php?id=<?=$row[id]?>"><img src="grafik/spil/<?=$row[kategori]?>/<?=$row[gfx]?>" width="100" height="100" border="0" style="filter:alpha(opacity=70)"/></a></td>
    <td height="1"><a target="_blank" href="play.php?id=<?=$row[id]?>"><strong><?=$row[navn]?></strong></a></td>
    <td height="1"><div align="right"><font color="#000000"> <?=$row[klik]?> hits</font></div></td>
  </tr>
  <tr>
    <td height="43" colspan="2"><a target="_blank" href="play.php?id=<?=$row[id]?>"><?=$row[beskrivelse]?></a></td>
  </tr>
  <tr>
    <td width="283" height="1"><a target="_blank" href="play.php?id=<?=$row[id]?>"><font color="#CCCCCC"><?=$row[link]?></font></a></td>
    <td width="95" height="1">&nbsp;</td>
  </tr>
  <tr>
    <td height="1"><hr color="#EAEAEA" size="1"/></td>
    <td height="1"><hr color="#EAEAEA" size="1"/></td>
    <td height="1"><hr color="#EAEAEA" size="1"/></td>
  </tr>
  <?

  }
?>
<?
}
?>
</table>

Virker det her:?

<?php
include("connect.php");

$page_name = $PHP_SELF;
$start = $_GET['start'];

if (!($start > 0))
{
    $start = 0;
}
$limit = 10;
$this = $start;
$next = $this + $limit;
$back = $this - $limit;

$query = "SELECT * FROM spil;
$result = mysql_query($query) or die("SQL Query failed ...");
$number_rows = mysql_num_rows($result);

$query = "SELECT * FROM spil ORDER BY id DESC LIMIT $start, $limit";
$result = mysql_query($query) or die("SQL Query failed ...");

while($rows = mysql_fetch_array($result))
{
    $id = '$_GET[id]';
    ?>
    <td width="100" rowspan="3" height="1"><a target="_blank" href="play.php?id=<?=$row[id]?>"><img src="grafik/spil/<?=$row[kategori]?>/<?=$row[gfx]?>" width="100" height="100" border="0" style="filter:alpha(opacity=70)"/></a></td>
    <td height="1"><a target="_blank" href="play.php?id=<?=$row[id]?>"><strong><?=$row[navn]?></strong></a></td>
    <td height="1"><div align="right"><font color="#000000"> <?=$row[klik]?> hits</font></div></td>
    </tr>
    <tr>
    <td height="43" colspan="2"><a target="_blank" href="play.php?id=<?=$row[id]?>"><?=$row[beskrivelse]?></a></td>
    </tr>
    <tr>
    <td width="283" height="1"><a target="_blank" href="play.php?id=<?=$row[id]?>"><font color="#CCCCCC"><?=$row[link]?></font></a></td>
    <td width="95" height="1">&nbsp;</td>
    </tr>
    <tr>
    <td height="1"><hr color="#EAEAEA" size="1"/></td>
    <td height="1"><hr color="#EAEAEA" size="1"/></td>
    <td height="1"><hr color="#EAEAEA" size="1"/></td>
    </tr>
<?php
}
if ($back >= 0)
{
    echo '<br><a href="'.$page_name.'?start='.$back.'">Prev.</a>&nbsp;';
}
$i = 0;
$page_number = 1;

for($i = 0; $i < $number_rows; $i = $i + $limit)
{
    if ($i <> $start)
    {
        echo '<a href="'.$page_name.'?start='.$i.'">'.$page_number.'</a>&nbsp;';
    }
    else
    {
        echo $page_number."&nbsp;";
    }
    $page_number = $page_number + 1;
}

if ($next < $number_rows)
{
    echo '<a href="'.$page_name.'?start='.$next.'">Next&nbsp;</a>';
}

?>

Melder fucking fejl igen :S:S:S

Nogen der kan hjælpe ?

Hvad med denne kode:

<?
include "connect.php";

$offset = (isset($_GET['offset']) && is_numeric($_GET['offset']) && $_GET['offset'] >= 0) ? intval($_GET['offset']) : 0;
$antal = mysql_result(mysql_query("select COUNT(id) from spil"),0);
$page  = 5;

if($offset > 0){
    $prev = $offset - $page;
    echo '<a href="?offset='.$prev.'">Forrige</a>
}else{
    echo 'Forrige';
}

echo ' - ';

if(($offset+$page) < $antal){
    $next = $offset + $page;
    echo '<a href="?offset='.$next.'">N&aelig;ste</a>
}else{
    echo 'N&aelig;ste';
}

echo '<hr />';

$sql = mysql_query("select * from spil ORDER BY id DESC LIMIT $offset,$page");
while($row = mysql_fetch_array($sql)){
?>
        <td width="100" rowspan="3" height="1"><a target="_blank" href="play.php?id=<?=$row[id]?>"><img src="grafik/spil/<?=$row[kategori]?>/<?=$row[gfx]?>" width="100" height="100" border="0" style="filter:alpha(opacity=70)"/></a></td>
        <td height="1"><a target="_blank" href="play.php?id=<?=$row[id]?>"><strong><?=$row[navn]?></strong></a></td>
        <td height="1"><div align="right"><font color="#000000"> <?=$row[klik]?> hits</font></div></td>
  </tr>
  <tr>
    <td height="43" colspan="2"><a target="_blank" href="play.php?id=<?=$row[id]?>"><?=$row[beskrivelse]?></a></td>
  </tr>
  <tr>
    <td width="283" height="1"><a target="_blank" href="play.php?id=<?=$row[id]?>"><font color="#CCCCCC"><?=$row[link]?></font></a></td>
    <td width="95" height="1">&nbsp;</td>
  </tr>
  <tr>
    <td height="1"><hr color="#EAEAEA" size="1"/></td>
    <td height="1"><hr color="#EAEAEA" size="1"/></td>
    <td height="1"><hr color="#EAEAEA" size="1"/></td>
  </tr>
  <?
}
?>

Virker heller ikke :S ved sku ikke hvad der er galt

Havde glemt '; bagefter begge </a>

Fuld kode med rettelser:

<?
//http://www.eksperten.dk/spm/830684
include "connect.php";

$offset = (isset($_GET['offset']) && is_numeric($_GET['offset']) && $_GET['offset'] >= 0) ? intval($_GET['offset']) : 0;
$antal = mysql_result(mysql_query("select COUNT(id) from spil"),0);
$page  = 5;

if($offset > 0){
    $prev = $offset - $page;
    echo '<a href="?offset='.$prev.'">Forrige</a>';
}else{
    echo 'Forrige';
}

echo ' - ';

if(($offset+$page) < $antal){
    $next = $offset + $page;
    echo '<a href="?offset='.$next.'">N&aelig;ste</a>';
}else{
    echo 'N&aelig;ste';
}

echo '<hr />';

$sql = mysql_query("select * from spil ORDER BY id DESC LIMIT $offset,$page");
while($row = mysql_fetch_array($sql)){
?>
        <td width="100" rowspan="3" height="1"><a target="_blank" href="play.php?id=<?=$row[id]?>"><img src="grafik/spil/<?=$row[kategori]?>/<?=$row[gfx]?>" width="100" height="100" border="0" style="filter:alpha(opacity=70)"/></a></td>
        <td height="1"><a target="_blank" href="play.php?id=<?=$row[id]?>"><strong><?=$row[navn]?></strong></a></td>
        <td height="1"><div align="right"><font color="#000000"> <?=$row[klik]?> hits</font></div></td>
  </tr>
  <tr>
    <td height="43" colspan="2"><a target="_blank" href="play.php?id=<?=$row[id]?>"><?=$row[beskrivelse]?></a></td>
  </tr>
  <tr>
    <td width="283" height="1"><a target="_blank" href="play.php?id=<?=$row[id]?>"><font color="#CCCCCC"><?=$row[link]?></font></a></td>
    <td width="95" height="1">&nbsp;</td>
  </tr>
  <tr>
    <td height="1"><hr color="#EAEAEA" size="1"/></td>
    <td height="1"><hr color="#EAEAEA" size="1"/></td>
    <td height="1"><hr color="#EAEAEA" size="1"/></td>
  </tr>
  <?
}
?>

Virker fint nu, men det ikke sådan at man kan vælge siderne på en drop down boks?
1
2
3
4
5
f.eks

Jo, det kan man godt! :o)

Smid svar.
Er der noget du kan hjælpe med?

Et svar og ja, jeg vil gerne prøve.
Det bliver dog senere.

Tak :) skal jeg oprette nyt spg.?

Ja, det må du nok hellere! :o)