aangemelde website presenteren per pagina
In de data base heb ik volgende tabellen staan van aangemelde site`s.
url
title
description
keywords
nu wil ik voor iedere aangemelde site een aparte pagina maken.
waarin de aanmelding gepresenteert wordt en title is title, description is description, keywords is de keywords van deze pagina.
Heeft iemand een voorbeeld scriptje?
maar bedoel je dan dat ze eerst op de titel moetten drukken en dat ze daarna naar de pagina gaan ?
en dan met de LIMIT werken (funtie van MySQL)
de bedoeling is dat
de pagina gevuld wordt met de info uit de database per aanmelding.
de inhoud van de site is dan
url
title
description
keywords
de mata tags nemen de title, descriptionen de keywords over.
en dan door tellen
maar moetten de gebruikers van de site eerst op een link drukken om de pagina met informatie te bezichtigen
of gaat dat zoals Jason zei ?
title = url
description
keywords
door op de title = url te klikken komen ze op de aangemelde site.
Code (php)
1
2
3
4
5
6
2
3
4
5
6
<?
$host = 'jou host';
$db_user= 'jou database gebruikersnaam';
$db_pass = 'jou database wachtwoord';
$database = 'jou database';
?>
$host = 'jou host';
$db_user= 'jou database gebruikersnaam';
$db_pass = 'jou database wachtwoord';
$database = 'jou database';
?>
code om de pagina's op te roepen
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
2
3
4
5
6
7
8
9
10
11
12
13
14
<?
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);
$query = "SELECT * FROM `tabel`"; if(!$query) {echo "query failed"; exit;}
$result = mysql_query($query) or die(mysql_error()); if(!$result) {echo "result failed"; exit;}
$num_results = mysql_num_rows($result);
for($i=0;$i<$num_results;$i++)
{
$title = $row['title'];
echo "<a href=\"joulink.php?link=".$title."\">".$title."</a>";
}
?>
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);
$query = "SELECT * FROM `tabel`"; if(!$query) {echo "query failed"; exit;}
$result = mysql_query($query) or die(mysql_error()); if(!$result) {echo "result failed"; exit;}
$num_results = mysql_num_rows($result);
for($i=0;$i<$num_results;$i++)
{
$title = $row['title'];
echo "<a href=\"joulink.php?link=".$title."\">".$title."</a>";
}
?>
om de gegevens op te halen kan je hetvolgende gebruiken.
kan je zelf in een leuk tabelletje gooien
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
<?
$title = $_GET['title'];
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);
$query = "SELECT * FROM `tabel` WHERE title='$title'"; if(!$query) {echo "query failed"; exit;}
$result = mysql_query($query) or die(mysql_error()); if(!$result) {echo "result failed"; exit;}
$num_results = mysql_num_rows($result);
for($i=0;$i<$num_results;$i++)
{
$row = mysql_fetch_array($result);
$url = $row['url'];
$titel = $row['title'];
$desc = $row['description'];
$keyword = $row['keywords'];
}
?>
$title = $_GET['title'];
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);
$query = "SELECT * FROM `tabel` WHERE title='$title'"; if(!$query) {echo "query failed"; exit;}
$result = mysql_query($query) or die(mysql_error()); if(!$result) {echo "result failed"; exit;}
$num_results = mysql_num_rows($result);
for($i=0;$i<$num_results;$i++)
{
$row = mysql_fetch_array($result);
$url = $row['url'];
$titel = $row['title'];
$desc = $row['description'];
$keyword = $row['keywords'];
}
?>
moet naar mijn weten werken
heb het zelf niet getest en een beetje snel in mekaar geflanst :P
vergeet niet de waardes te veranderen zodat ze kloppen ^^
Gewijzigd op 01/01/1970 01:00:00 door vincent -
echo "<a href=\"index3.php?link=".$title."\">".$title."</a>";
bovenstaan aangepast naar mij situatie
ik krijg nix te zien alleen in de broncode staat:
<a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a><a href="index3.php?link="></a>
mijn excuses
de juiste code is
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
<?
$title = $_GET['title'];
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);
$query = "SELECT * FROM `tabel` WHERE title='$title'"; if(!$query) {echo "query failed"; exit;}
$result = mysql_query($query) or die(mysql_error()); if(!$result) {echo "result failed"; exit;}
$num_results = mysql_num_rows($result);
for($i=0;$i<$num_results;$i++)
{
$row = mysql_fetch_array($result);
$url = $row['url'];
$title = $row['title'];
$desc = $row['description'];
$keyword = $row['keywords'];
}
?>
$title = $_GET['title'];
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);
$query = "SELECT * FROM `tabel` WHERE title='$title'"; if(!$query) {echo "query failed"; exit;}
$result = mysql_query($query) or die(mysql_error()); if(!$result) {echo "result failed"; exit;}
$num_results = mysql_num_rows($result);
for($i=0;$i<$num_results;$i++)
{
$row = mysql_fetch_array($result);
$url = $row['url'];
$title = $row['title'];
$desc = $row['description'];
$keyword = $row['keywords'];
}
?>
dit presenteert alles in de database wat goed gekeurd is:
Nu wil ik slechts 1 vermelding per pagina
het mag ook zo dat alles zichtbaar is dan is de wens dat url naar een nieuwe presentatie wijst waar dan de :
url
title
description
keywords
worden weergegeven en de url verwijst naar de site
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
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
<?
flush();
$bd = mysql_connect($mysql_hostname, $mysql_user, $mysql_password);
mysql_select_db($mysql_database, $bd);
$sql = mysql_query("SELECT {$prefix}pages.id, {$prefix}pages.url, {$prefix}pages.title, {$prefix}pages.description, {$prefix}pages.keywords, {$prefix}pages.accepted, {$prefix}pages.ip, {$prefix}pages.category, {$prefix}categories.name AS category_name FROM {$prefix}pages, {$prefix}categories WHERE {$prefix}categories.id = {$prefix}pages.category AND {$prefix}pages.accepted = 'y' ORDER BY {$prefix}pages.id");
$n_pages = mysql_num_rows($sql);
for ($x = 0; $x < $n_pages; $x++){
$pages[$x] = mysql_fetch_array($sql, MYSQL_ASSOC);
};
mysql_close();
if ($n_pages > 0){
echo ' <p style="margin-bottom: 0">
<B>Website`s in database:</B></p>
<p style="margin-bottom: 0">
<hr style="color: #dddddd; height: 1px; margin: 10px 0px" color="#dddddd" SIZE="1">'."\r\n";
for ($x = 0; $x < $n_pages; $x++){
echo '<P><A HREF="'.$pages[$x]["url"].'" TARGET="_blank"><B>'.$pages[$x]["title"].'</B></A>'."\r\n";
echo 'Rubriek: <A HREF="index.php?c='.$pages[$x]["category"].'">('.$pages[$x]["category_name"].')</A><BR>'."\r\n";
if ($pages[$x]["ip"]){
echo ''."\r\n";
};
echo '<BR>'.$pages[$x]["description"]."\r\n";
echo '<BR>Keywords: '.$pages[$x]["keywords"]."\r\n";
echo '<BR>'.$pages[$x]["url"]."\r\n";
};
};
?>
flush();
$bd = mysql_connect($mysql_hostname, $mysql_user, $mysql_password);
mysql_select_db($mysql_database, $bd);
$sql = mysql_query("SELECT {$prefix}pages.id, {$prefix}pages.url, {$prefix}pages.title, {$prefix}pages.description, {$prefix}pages.keywords, {$prefix}pages.accepted, {$prefix}pages.ip, {$prefix}pages.category, {$prefix}categories.name AS category_name FROM {$prefix}pages, {$prefix}categories WHERE {$prefix}categories.id = {$prefix}pages.category AND {$prefix}pages.accepted = 'y' ORDER BY {$prefix}pages.id");
$n_pages = mysql_num_rows($sql);
for ($x = 0; $x < $n_pages; $x++){
$pages[$x] = mysql_fetch_array($sql, MYSQL_ASSOC);
};
mysql_close();
if ($n_pages > 0){
echo ' <p style="margin-bottom: 0">
<B>Website`s in database:</B></p>
<p style="margin-bottom: 0">
<hr style="color: #dddddd; height: 1px; margin: 10px 0px" color="#dddddd" SIZE="1">'."\r\n";
for ($x = 0; $x < $n_pages; $x++){
echo '<P><A HREF="'.$pages[$x]["url"].'" TARGET="_blank"><B>'.$pages[$x]["title"].'</B></A>'."\r\n";
echo 'Rubriek: <A HREF="index.php?c='.$pages[$x]["category"].'">('.$pages[$x]["category_name"].')</A><BR>'."\r\n";
if ($pages[$x]["ip"]){
echo ''."\r\n";
};
echo '<BR>'.$pages[$x]["description"]."\r\n";
echo '<BR>Keywords: '.$pages[$x]["keywords"]."\r\n";
echo '<BR>'.$pages[$x]["url"]."\r\n";
};
};
?>
ik heb deze gevonden voor het tellen
Hoe knoop ik bijde werkend aan elkaar
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
36
37
38
39
40
41
42
43
44
45
46
47
48
49
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
36
37
38
39
40
41
42
43
44
45
46
47
48
49
<?
$page = isset($_GET['page']) ? $_GET['page'] : 1;
$totalPages = mysql_num_rows($sql);
$PAGE_LIMIT = 1;
echo 'Your viewing: Page '.$page.' <i><small>(total pages: '.$totalPages.')</small></i><br><br>';
function show_pagenumbers($start, $end, $page, $totalPages, $PAGE_LIMIT) {
$str = '';
for ($i = $start; $i <= $end; $i++) {
if ($page == $i) {
$str .= ' <b>[ '.$i.' ]</b> ';
}
else{
$str .= ' <a href="'.$_SERVER['PHP_SELF'].'?page='.$i.'&perpage='.$PAGE_LIMIT.'" title="Go to page '.$i.'">'.$i.'</a> ';
}
}
return $str;
}
if ($totalPages >= 1) {
if($totalPages > 7) {
$start = $page - 3;
$end = $page + 3;
while($start < 1) {
$start++;
$end++;
}
while($end > $totalPages) {
$start--;
$end--;
}
echo ( $page == 1 ) ? '<span style="color:#ccc;">« Eerste</span> ' : '<a href="'.$_SERVER['PHP_SELF'].'?page=1" title="Go to page 1">« Eerste</a> ';
echo ( $page > 4 ) ? '...' : '';
echo show_pagenumbers($start, $end, $page, $totalPages, $PAGE_LIMIT);
echo ( $page < $totalPages - 3 ) ? '... ' : ' ';
echo ( $page == $totalPages ) ? ' <span style="color:#ccc;">Laatste »</span> ' : ' <a href="'.$_SERVER['PHP_SELF'].'?page='.$totalPages.'" title="Go to page '.$totalPages.'">Laatste »</a>';
}
else {
echo show_pagenumbers(1, $totalPages, $page, $totalPages, $PAGE_LIMIT);
}
}
else {
echo 'no page numbers yet';
}
?>
$page = isset($_GET['page']) ? $_GET['page'] : 1;
$totalPages = mysql_num_rows($sql);
$PAGE_LIMIT = 1;
echo 'Your viewing: Page '.$page.' <i><small>(total pages: '.$totalPages.')</small></i><br><br>';
function show_pagenumbers($start, $end, $page, $totalPages, $PAGE_LIMIT) {
$str = '';
for ($i = $start; $i <= $end; $i++) {
if ($page == $i) {
$str .= ' <b>[ '.$i.' ]</b> ';
}
else{
$str .= ' <a href="'.$_SERVER['PHP_SELF'].'?page='.$i.'&perpage='.$PAGE_LIMIT.'" title="Go to page '.$i.'">'.$i.'</a> ';
}
}
return $str;
}
if ($totalPages >= 1) {
if($totalPages > 7) {
$start = $page - 3;
$end = $page + 3;
while($start < 1) {
$start++;
$end++;
}
while($end > $totalPages) {
$start--;
$end--;
}
echo ( $page == 1 ) ? '<span style="color:#ccc;">« Eerste</span> ' : '<a href="'.$_SERVER['PHP_SELF'].'?page=1" title="Go to page 1">« Eerste</a> ';
echo ( $page > 4 ) ? '...' : '';
echo show_pagenumbers($start, $end, $page, $totalPages, $PAGE_LIMIT);
echo ( $page < $totalPages - 3 ) ? '... ' : ' ';
echo ( $page == $totalPages ) ? ' <span style="color:#ccc;">Laatste »</span> ' : ' <a href="'.$_SERVER['PHP_SELF'].'?page='.$totalPages.'" title="Go to page '.$totalPages.'">Laatste »</a>';
}
else {
echo show_pagenumbers(1, $totalPages, $page, $totalPages, $PAGE_LIMIT);
}
}
else {
echo 'no page numbers yet';
}
?>
Alleen lukt het mij niet om bijde funties aan elkaar te knopen
Terence schreef op 20.11.2006 10:14:
title is volgens mij een gereserveerd woord.. je moet daar `backticks` omheen zetten of anders een andere naam van maken..
title word in html gebruikt.
ik heb er in php zelf nog nooit last van gehad dat het errors gaf
Terence schreef op 20.11.2006 10:14:
Backtics gebruiken? Wanneer je met droge ogen wilt beweren dat je over enige vorm van intelligentie beschikt, verzin dan een betere naam. Zo moeilijk kan dat toch niet zijn, of wel dan? Backtics, accolades, brackets, etc. horen gewoon niet thuis in een goede query. Einde discussie.title is volgens mij een gereserveerd woord.. je moet daar `backticks` omheen zetten of anders een andere naam van maken..
Zie verder http://dev.mysql.com/doc/refman/4.1/en/reserved-words.html voor de complete lijst met gereserveerde woorden.
Code (php)
1
2
3
4
5
6
7
2
3
4
5
6
7
<? if(!$a) $a=0;
$result = mysql_query("select * from act ORDER BY id DESC limit $a,15 ");
$result2 = mysql_query("select * from act");
$records=mysql_num_rows($result2);
if ($a>$numrows)
{?>
$result = mysql_query("select * from act ORDER BY id DESC limit $a,15 ");
$result2 = mysql_query("select * from act");
$records=mysql_num_rows($result2);
if ($a>$numrows)
{?>
<td align="left"><A HREF="
Code (php)
1
<? $php_self ?>
Code (php)
1
<? }?>
<td align="right"><A HREF="
Code (php)
1
<? $php_self?>
Code (php)
1
2
3
4
5
2
3
4
5
<?
}
dit werkt bij mij, ik weet niet of je er iets aan hebt...
}
dit werkt bij mij, ik weet niet of je er iets aan hebt...
Gewijzigd op 01/01/1970 01:00:00 door Tamara