Gammel ver. php til ny
Efter flytning fra webhotellets side til ny ver af php finder databasen kun nogle gamle sider hvis man søger på et søgeord har det noget med denne fil at gøre??? og hvad skal ændres?<?
/*/////////////////////////////////////////////////
Web-Developer
*//////////////////////////////////////////////////
require("config.inc");
?>
<?
#################### Søge funktion ###########################
################################################
if($sogeord){
$arg = split(" ", $sogeord);
require("config.inc");
if (strtoupper($regel) == "ALLE") {
$joiner = "OR";
} elseif (strtoupper($regel) == "NOGEN") {
$joiner = "AND";
}
if (strtoupper($regel) != "PRAECIS") {
for($i=0; $i<count($arg); $i++) {
if($i==0) {
// Change column names ;)
$cond = "((Soge_Ord LIKE '%$arg[$i]%') OR ".
"(Beskrivelse LIKE '%$arg[$i]%') OR ".
"(Sogeord1 LIKE '%$arg[$i]%') OR ".###TEST
"(Titel LIKE '%$arg[$i]%'))";
} else {
$cond = "$cond $joiner ((Soge_Ord LIKE '%$arg[$i]%') OR ".
"(Beskrivelse LIKE '%$arg[$i]%') OR ".
"(Sogeord1 LIKE '%$arg[$i]%') OR ".###TEST
"(Titel LIKE '%$arg[$i]%'))";
}
}
} elseif (strtoupper($regel) == "PRAECIS") {
$cond = "((Soge_Ord LIKE '%$sogeord%') OR".
" (Beskrivelse LIKE '%$sogeord%') OR".
" (Sogeord1 LIKE '%$sogeord%') OR".###TEST
" (Titel LIKE '%$sogeord%'))";
}
################# Stop Søge Funktion ##########################
################################################
$numresults = mysql_query("SELECT DISTINCT * FROM $link WHERE $cond ORDER BY Titel", $db);
$totalrows = mysql_num_rows($numresults);
$count= $totalrows;
$step=10;
$start=$pos;
$finish=($pos+$step);
$begin =($pos+1);
$end = ($begin+($step-1));
if ($end > $totalrows) {
$end = $totalrows;
}
if (!$totalrows) {
echo "<div class=\"normal\">Ingen links matchede søgning efter <b>".$sogeord."</b>.</div>";
} else {
########### Count Næste/Forrige
if($count>$step){
echo "\n\n<table width=\"100%\" cellpadding=\"2\" cellspacing=\"3\" border=\"0\">";
if($pos>=$step){
#echo "\n<tr>\n<td width=\"0\">\n<font face=Verdana size=\"2\" color=\"#000000\">[ <a class=\"menulink\" href=\"sog_html.php?Kat2ID=$Kat2ID","&pos=".($pos-$step)."\"><< Forrige</a> ] \n</font></td>\n</tr>";
#echo "\n<tr>\n<td width=\"0\" align=\"right\">\n<a href=\"sog_html.php?sogeord=".$sogeord."®el=".$regel."&pos=".($pos-$step)."\"><img border=\"0\" src=\"/image/minus.gif\" align=\"absmiddle\" width=\"23\" height=\"18\"></a><font face=\"Arial\" size=\"1\" color=\"#FF000\">Forrige 10</font>";
if(isset($kat)){
echo "\n<tr>\n<td width=\"0\" align=\"right\">\n<a href=\"sog_html.php?sogeord=".$sogeord."®el=".$regel."&pos=".($pos-$step)."\"><img border=\"0\" src=\"/image/minus.gif\" align=\"absmiddle\" width=\"23\" height=\"18\"></a><font face=\"Arial\" size=\"1\" color=\"#FF000\">Forrige 10</font>";
} else {
echo "\n<tr>\n<td width=\"0\" align=\"right\">\n<a href=\"sog_html.php?sogeord=".$sogeord."®el=".$regel."&pos=".($pos-$step)."\"><img border=\"0\" src=\"/image/minus.gif\" align=\"absmiddle\" width=\"23\" height=\"18\"></a><font face=\"Arial\" size=\"1\" color=\"#FF000\">Forrige 10</font>";
}
}
if(($pos+$step)<=$count){
#echo "\n<tr>\n<td width=\"0\" align=\"left\">\n<font face=Verdana size=\"2\" color=\"#000000\">[ <b><a href=\"sog_html.php?Kat2ID=$Kat2ID","&pos=".($pos+$step)."\"> Vis Næste 10 Links >></a></b> ] </font>\n</td>";
#echo "\n<tr>\n<td width=\"0\" align=\"right\">\n<a href=\"sog_html.php?Kat2ID=$Kat2ID","&pos=".($pos+$step)."\"><img border=\"0\" src=\"/image/plus.gif\" align=\"absmiddle\" width=\"23\" height=\"18\"></a><font face=\"Arial\" size=\"1\">Næste 10</font> \n</td>";
if(isset($kat)){
echo "\n<tr>\n<td width=\"0\" align=\"right\">\n<a href=\"sog_html.php?sogeord=".$sogeord."®el=".$regel."&pos=".($pos+$step)."\"><img border=\"0\" src=\"/image/plus.gif\" align=\"absmiddle\" width=\"23\" height=\"18\"></a><font face=\"Arial\" size=\"1\">Næste 10</font> \n</td>";
} else {
echo "\n<tr>\n<td width=\"0\" align=\"right\">\n<a href=\"sog_html.php?sogeord=".$sogeord."®el=".$regel."&pos=".($pos+$step)."\"><img border=\"0\" src=\"/image/plus.gif\" align=\"absmiddle\" width=\"23\" height=\"18\"></a><font face=\"Arial\" size=\"1\">Næste 10</font> \n</td>";
}
}
echo "\n</tr>\n</table>\n\n";
}
if(!$pos){
$pos=0;
}
########### Slut Count Næste/Forrige
?>
<div align="left">
<table border="0" width="98%" cellspacing="1" cellpadding="3">
<tr>
<td align="left">
<?
echo "<div><font face=Verdana size=\"1\" color=\"#000000\">Søgeord:<b> $sogeord </b>- \n";
echo "Gav følgende Resultat <b>$totalrows</b> Links blev fundet.</font><br>\n";
echo "<font face=Verdana size=\"1\" color=\"#000000\">Viser links <font color=\"#FF0000\"><b>$begin</b></font> til <font color=\"#FF0000\"><b>$end</b></font>.</font><br></div>\n";
echo "<br><br>\n";
?>
</td>
</tr>
</table>
</div>
<?
########################### Henter data i sql databasen ############################
################################################
$query = "SELECT DISTINCT * FROM $link WHERE $cond ORDER BY Sogeord1 DESC LIMIT $pos,10";
$result = mysql_query($query, $db);
while($data = mysql_fetch_array($result)) {
$print_kat=mysql_query("SELECT * FROM $kategori_tb WHERE ID='$data[Kategori]'",$db);
$print_kat2=mysql_fetch_array($print_kat);
$kat_print=eregi_replace("_"," ",$print_kat2[Kategori]);
$timestamp = $data["Dato"];
require("time.class.php");
#############
###TEST 7-11-01
if($data[Sogeord1] == "$sogeord"){
require("id/top_id_sog.php");
}else{
require("id/id_sog.php");
}
###########
}
}
}
#mysql_close($query);
########### Count Næste/Forrige
if($count>$step){
echo "\n\n<table width=\"100%\" cellpadding=\"2\" cellspacing=\"3\" border=\"0\">";
if($pos>=$step){
#echo "\n<tr>\n<td width=\"0\">\n<font face=Verdana size=\"2\" color=\"#000000\">[ <a class=\"menulink\" href=\"sog_html.php?Kat2ID=$Kat2ID","&pos=".($pos-$step)."\"><< Forrige</a> ] \n</font></td>\n</tr>";
#echo "\n<tr>\n<td width=\"0\" align=\"right\">\n<a href=\"sog_html.php?sogeord=".$sogeord."®el=".$regel."&pos=".($pos-$step)."\"><img border=\"0\" src=\"/image/minus.gif\" align=\"absmiddle\" width=\"23\" height=\"18\"></a><font face=\"Arial\" size=\"1\" color=\"#FF000\">Forrige 10</font>";
if(isset($kat)){
echo "\n<tr>\n<td width=\"0\" align=\"right\">\n<a href=\"sog_html.php?sogeord=".$sogeord."®el=".$regel."&pos=".($pos-$step)."\"><img border=\"0\" src=\"/image/minus.gif\" align=\"absmiddle\" width=\"23\" height=\"18\"></a><font face=\"Arial\" size=\"1\" color=\"#FF000\">Forrige 10</font>";
} else {
echo "\n<tr>\n<td width=\"0\" align=\"right\">\n<a href=\"sog_html.php?sogeord=".$sogeord."®el=".$regel."&pos=".($pos-$step)."\"><img border=\"0\" src=\"/image/minus.gif\" align=\"absmiddle\" width=\"23\" height=\"18\"></a><font face=\"Arial\" size=\"1\" color=\"#FF000\">Forrige 10</font>";
}
}
if(($pos+$step)<=$count){
#echo "\n<tr>\n<td width=\"0\" align=\"left\">\n<font face=Verdana size=\"2\" color=\"#000000\">[ <b><a href=\"sog_html.php?Kat2ID=$Kat2ID","&pos=".($pos+$step)."\"> Vis Næste 10 Links >></a></b> ] </font>\n</td>";
#echo "\n<tr>\n<td width=\"0\" align=\"right\">\n<a href=\"sog_html.php?Kat2ID=$Kat2ID","&pos=".($pos+$step)."\"><img border=\"0\" src=\"/image/plus.gif\" align=\"absmiddle\" width=\"23\" height=\"18\"></a><font face=\"Arial\" size=\"1\">Næste 10</font> \n</td>";
if(isset($kat)){
echo "\n<tr>\n<td width=\"0\" align=\"right\">\n<a href=\"sog_html.php?sogeord=".$sogeord."®el=".$regel."&pos=".($pos+$step)."\"><img border=\"0\" src=\"/image/plus.gif\" align=\"absmiddle\" width=\"23\" height=\"18\"></a><font face=\"Arial\" size=\"1\">Næste 10</font> \n</td>";
} else {
echo "\n<tr>\n<td width=\"0\" align=\"right\">\n<a href=\"sog_html.php?sogeord=".$sogeord."®el=".$regel."&pos=".($pos+$step)."\"><img border=\"0\" src=\"/image/plus.gif\" align=\"absmiddle\" width=\"23\" height=\"18\"></a><font face=\"Arial\" size=\"1\">Næste 10</font> \n</td>";
}
}
echo "\n</tr>\n</table>\n\n";
}
if(!$pos){
$pos=0;
}
########### Slut Count Næste/Forrige
?>
<form action="sog_html.php" method="POST">
<div align="center">
<table border="0" width="100%" cellspacing="1" cellpadding="3">
<tr>
<td class="normal"><b>Find Det du mangler:</b></td>
</tr>
<tr>
<td>
<input class="formsog" type=text name=sogeord maxlength=50 size=20 value="<? echo $sogeord ?>"> <input class="formsubmit" type=submit name=submit value="Søg!">
</td>
</tr>
<tr>
<td align="left" class="normal">
<input type="radio" name="regel" value="PRAECIS" checked>Præcis Match
<input type="radio" name="regel" value="NOGEN">Et af ordene
<input type="radio" name="regel" value="ALLE">Alle Ord
</td>
</tr>
<tr>
<td align="center"></td>
</tr>
</table>
</div>
</form>
