aangemelde website presenteren per pagina
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
<?
require_once('config.php');
$db_conn = mysql_connect($host,$db_user,$db_pass);
if(!$db_conn) {echo "connection failed"; exit;}
mysql_select_db($database,$db_conn);
$thisNr = 0;
if (isset($_GET['function']) && $_GET['function']== 'show')
{
if (isset($_GET['id'])){$thisNr = $_GET['id'];}
}
$sql = "SELECT * FROM gelderse_achterhoekpages";
$result = mysql_query($sql);
$nr = 0;
while ($rij = mysql_fetch_assoc($result))
{
$page[$nr] = array('id'=>$rij['id'], 'url'=>$rij['url'],'title'=>$rij['title'],'description'=>$rij['description'],'keywords'=>$rij['keywords'], 'accepted'=>$rij['accepted']);
$nr++;
}
//Informatie op 'nr' aanroepen.
echo " <tr><td><p><b>".$page[$thisNr]['title']."</b></p></td>
<td><p>".$page[$thisNr]['description']."</p></td></tr>
<td><p>".$page[$thisNr]['keywords']."</p></td></tr>
<td><p>".$page[$thisNr]['url']."</p></td></tr>";
echo "<tr><td><a href='index3.php?function=show&id=".($thisNr-1)."'>terug</a> ";
echo "<a href='index3.php?function=show&id=".($thisNr+1)."'>verder</a></td></tr>";
?>
require_once('config.php');
$db_conn = mysql_connect($host,$db_user,$db_pass);
if(!$db_conn) {echo "connection failed"; exit;}
mysql_select_db($database,$db_conn);
$thisNr = 0;
if (isset($_GET['function']) && $_GET['function']== 'show')
{
if (isset($_GET['id'])){$thisNr = $_GET['id'];}
}
$sql = "SELECT * FROM gelderse_achterhoekpages";
$result = mysql_query($sql);
$nr = 0;
while ($rij = mysql_fetch_assoc($result))
{
$page[$nr] = array('id'=>$rij['id'], 'url'=>$rij['url'],'title'=>$rij['title'],'description'=>$rij['description'],'keywords'=>$rij['keywords'], 'accepted'=>$rij['accepted']);
$nr++;
}
//Informatie op 'nr' aanroepen.
echo " <tr><td><p><b>".$page[$thisNr]['title']."</b></p></td>
<td><p>".$page[$thisNr]['description']."</p></td></tr>
<td><p>".$page[$thisNr]['keywords']."</p></td></tr>
<td><p>".$page[$thisNr]['url']."</p></td></tr>";
echo "<tr><td><a href='index3.php?function=show&id=".($thisNr-1)."'>terug</a> ";
echo "<a href='index3.php?function=show&id=".($thisNr+1)."'>verder</a></td></tr>";
?>
stap 2 is:
titel is <A herf= url
stap 3 is:
title, description, keywords in de meta tag
dus bijna klaar
als iemand nog sugesties heeft zijn ze welkom.
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
<?
require_once('config.php');
$db_conn = mysql_connect($host,$db_user,$db_pass);
if(!$db_conn) {echo "connection failed"; exit;}
mysql_select_db($database,$db_conn);
$thisNr = 0;
if (isset($_GET['function']) && $_GET['function']== 'show')
{
if (isset($_GET['id'])){$thisNr = $_GET['id'];}
}
$sql = "SELECT * FROM gelderse_achterhoekpages";
$result = mysql_query($sql);
$nr = 0;
while ($rij = mysql_fetch_assoc($result))
{
$page[$nr] = array('id'=>$rij['id'], 'url'=>$rij['url'],'title'=>$rij['title'],'description'=>$rij['description'],'keywords'=>$rij['keywords'], 'accepted'=>$rij['accepted']);
$nr++;
}
//Informatie op 'nr' aanroepen.
echo " <tr><td><p><b>".$page[$thisNr]['title']."</b></p></td>
<td><p>".$page[$thisNr]['description']."</p></td></tr>
<td><p>".$page[$thisNr]['keywords']."</p></td></tr>
<td><p>".$page[$thisNr]['url']."</p></td></tr>";
echo "<tr><td><a href='index3.php?function=show&id=".($thisNr-1)."'>terug</a> ";
echo "<a href='index3.php?function=show&id=".($thisNr+1)."'>verder</a></td></tr>";
?>
require_once('config.php');
$db_conn = mysql_connect($host,$db_user,$db_pass);
if(!$db_conn) {echo "connection failed"; exit;}
mysql_select_db($database,$db_conn);
$thisNr = 0;
if (isset($_GET['function']) && $_GET['function']== 'show')
{
if (isset($_GET['id'])){$thisNr = $_GET['id'];}
}
$sql = "SELECT * FROM gelderse_achterhoekpages";
$result = mysql_query($sql);
$nr = 0;
while ($rij = mysql_fetch_assoc($result))
{
$page[$nr] = array('id'=>$rij['id'], 'url'=>$rij['url'],'title'=>$rij['title'],'description'=>$rij['description'],'keywords'=>$rij['keywords'], 'accepted'=>$rij['accepted']);
$nr++;
}
//Informatie op 'nr' aanroepen.
echo " <tr><td><p><b>".$page[$thisNr]['title']."</b></p></td>
<td><p>".$page[$thisNr]['description']."</p></td></tr>
<td><p>".$page[$thisNr]['keywords']."</p></td></tr>
<td><p>".$page[$thisNr]['url']."</p></td></tr>";
echo "<tr><td><a href='index3.php?function=show&id=".($thisNr-1)."'>terug</a> ";
echo "<a href='index3.php?function=show&id=".($thisNr+1)."'>verder</a></td></tr>";
?>
Nu nog de title, description, keywords in de meta tags
en in de title moet de url nog geplaatst worden.
Sugesties zijn welkom