Linkleri seo yaptiktan sonra kategorilerdeki icerikler gözükmüyor.

function urlconvert($string) {
$replace_values = array(" ", "'", "\"", "\\", "/", "?", "|", "@", "ü", "~", "!", "£", "$", "%", "^", "&", "*", "(", ")", "[", "]", "{", "}", "+", "=", "-", ":", ";");
$string = str_replace($replace_values, "-", $string);
$string = str_replace("ü", "u", $string);
$string = str_replace("ş", "s", $string);
$string = str_replace("ı", "i", $string);
$string = str_replace(",", "", $string);
return strtolower($string);

Genişletmek için tıkla ...

function urlconvert($string) {
$string = strtolower($string);
$degis1 = array('İ','Ö','Ü','Ğ','Ç','Ş','ö','ü','ğ','ç','ş','ö','_',' ','--','---','ı');
$degis2 = array('i','o','u','g','c','s','o','u','g','c','s','o','-','-','-','-','i');
$string = str_replace($degis1,$degis2,$string);
$string = preg_replace("@[^A-Za-z0-9\-_öÖçÇüÜıİğĞşŞ]+@i","",$string);
return $string;
}

Genişletmek için tıkla ...

<?php

include_once("config.inc.php");
include_once("db_connect.php");

// get vars
$cat = $_REQUEST['cat'];

if($cat) {

$cat = str_replace("-", " ", $cat);
$start = $_REQUEST['start'];
if(!$start) $start = 0;
$page = $start + 50; $page = $page/50;

$ptitle = UCWords($cat)." Category - Page $page";
$meta_keys = "jokes, funny, laugher, joke, gag, laughing";
$meta_desc = UCWords($cat)." Category - Page $page";
$selected = "CATEGORIES";

include("header.php");

$temp3 = mysql_query("SELECT * FROM jokes WHERE category = '$cat'");
$temp = mysql_query("SELECT * FROM jokes WHERE category = '$cat' ORDER BY joke LIMIT $start, $perpage");
$total = mysql_numrows($temp3);

?>

<table width="100%" cellspacing="5" cellpadding="0">
<tr>
<td valign="top">
<?php
echo "<b>".UCWords($cat)." Category:</b><br><br>";
echo "All our jokes listing within the ".$cat." category are listed below. Click on any of the items to view the full joke.<br><br>";
?>
</td>
</tr>
</table>

<?php
if($total > 0) {
echo "<table width='100%' cellspacing='0' cellpadding='0'>";
$tracker = $start+1;
while($row = mysql_fetch_array($temp)) {
echo "<tr><td width='40' align='right'><b>".$tracker.".</b>   </td><td class='listingtitle'><b>Category:</b> ".$row[category]."  <img src='images/small-stars-".$row[votestartotal].".gif' width='52' height='8' alt='".$row[votestartotal]." stars'></td></tr>";
echo "<tr><td></td><td>".trim(substr(stripslashes($row[joke]), 0, 120))."... <a href='view-".$row[id]."-".trim(substr(urlconvert($row[joke]), 0, 50)).".html' class='morelink'>more</a><br><br></td></tr>";
$tracker++;
}
echo "</table>";
}
?>

<br><div align="center">
<?php
$start = $start + $perpage;
if($start > $perpage) {
$start2 = $start - ($perpage * 2);
if($start2 < 0) $start2 = 0;
echo "<a href=\"jokes_".str_replace(" ", "-", $cat)."_"."page-".$start2.".html\">< <b>Previous Page</b></a>  ";
}
if($start < $total) echo "  <a href=\"jokes_".str_replace(" ", "-", $cat)."_"."page-".$start.".html\"><b>Next Page</b> ></a>";
?></div><br><br>

<?php
}
else {

$ptitle = "Category Listing";
$meta_keys = "jokes, funny, laugher, joke, gag, laughing";
$meta_desc = "Category Listing";
$selected = "CATEGORIES";

include("header.php");

$cats = mysql_query("SELECT * FROM categories ORDER BY category");

?>

<table width="100%" cellspacing="5" cellpadding="0">
<tr>
<td valign="top">
<?php
echo "<b>Choose Category:</b><br><br>";
echo "Choose from the category listing below to being browsing our jokes by category.<br><br>";
?>
</td>
</tr>
</table>

<?php
echo "<table width='95%' cellspacing='3' cellpadding='0' align='center'>";
$tracker = 0;
while($row = mysql_fetch_array($cats)) {
// get total
$total = mysql_query("SELECT COUNT(id) AS total FROM jokes WHERE category = '".$row[category]."'");
$jokes_total = mysql_result($total, 0, total);
if($tracker == 0) echo "<tr>";
echo "<td width='50%'> - <a href='jokes_".urlconvert($row[category]).".html'>".$row[category]."</a> <font style='color:#999999;'>(".$jokes_total.")</font></td>";
if($tracker == 1) {
echo "</tr>";
$tracker = 0;
}
else $tracker++;
}
echo "</table><br>";
?>

<?php
}
?>

<?php
include("footer.php");
?>

Genişletmek için tıkla ...

<?php

/* Setup MySQL Access */

$DBhost = "localhost";
$DBuser = "aaaaa";
$DBpass = "aaa2halo";
$DBname = "bolum_test";
mysql_connect($DBhost, $DBuser, $DBpass) or die ("Cannot connect to database server");
mysql_select_db($DBname) or die ("Cannot select site database");
mysql_query("SET NAMES 'latin5'");
mysql_query("SET CHARACTER SET latin5");
mysql_query("SET COLLATION_CONNECTION = 'latin5_turkish_ci'");

?>

Genişletmek için tıkla ...

-- Tablo için tablo yapısı `categories`
--

CREATE TABLE IF NOT EXISTS `categories` (
`id` int(4) NOT lisanssız auto_increment,
`category` varchar(255) NOT lisanssız,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=110 ;

--
-- Tablo döküm verisi `categories`
--

INSERT INTO `categories` (`id`, `category`) VALUES
(1, 'süleyman+'),
(2, 'suluman, jokes'),
(3, 'Answer me this jokes'),
(4, 'Ant jokes');
;

Genişletmek için tıkla ...