Da ich Google Friendly URLs installiert habe, habe ich die who.php so abgewandelt:
<?
// Settings
///////////////////////////////////////////
$url = "http://www.meineseite.de";
$table = "4images_users"; //do not edit if you have not changed table prefix
// Code
///////////////////////////////////////////
include "config.php";
$a_url = $_SERVER["REQUEST_URI"];
$i = explode("/", $a_url);
$b = count($i);
$b = $b-1;
$i = str_replace(array("%20"), " ", $i[$b]);
if (($i != "") and ($i != "guest"))
{
$db = mysql_connect("$db_host", "$db_user", "$db_password") or die ("Error");
@mysql_select_db("$db_name", $db) or die ("DB not found");
$result = mysql_query("SELECT user_id FROM `$table` WHERE user_name='$i'");
$row = mysql_fetch_array($result);
$id = $row['user_id'];
header("Location: ".$url."/profile".$id.".htm");
}
else
{
header("Location: ".$url."");
}
?>Das klappt wunderbar. Jetzt wollte ich eine weitere Datei erstellen, namens Image:
image.php<?
// Settings
///////////////////////////////////////////
$url = "http://www.meineseite.de";
$table = "4images_images"; //do not edit if you have not changed table prefix
// Code
///////////////////////////////////////////
include "config.php";
$a_url = $_SERVER["REQUEST_URI"];
$i = explode("/", $a_url);
$b = count($i);
$b = $b-1;
$i = str_replace(array("%20"), " ", $i[$b]);
if (($i != "") and ($i != "guest"))
{
$db = mysql_connect("$db_host", "$db_user", "$db_password") or die ("Error");
@mysql_select_db("$db_name", $db) or die ("DB not found");
$result = mysql_query("SELECT image_id FROM `$table` WHERE image_name='$i'");
$row = mysql_fetch_array($result);
$id = $row['image_id'];
header("Location: ".$url."/video".$id.".htm");
}
else
{
header("Location: ".$url."");
}
?>Die URL zu dem Bild sieht so aus:
image-fggf-3.htmAber wie mache ich das, dass er die Image_id und den image_name ausgibt?
Ich habe das so versucht:
<?
// Settings
///////////////////////////////////////////
$url = "http://www.anitube.de";
$table = "4images_images"; //do not edit if you have not changed table prefix
// Code
///////////////////////////////////////////
include "config.php";
$a_url = $_SERVER["REQUEST_URI"];
$i = explode("/", $a_url);
$b = count($i);
$b = $b-1;
$i = str_replace(array("%20"), " ", $i[$b]);
if (($i != "") and ($i != "guest"))
{
$db = mysql_connect("$db_host", "$db_user", "$db_password") or die ("Error");
@mysql_select_db("$db_name", $db) or die ("DB not found");
$result = mysql_query("SELECT image_id FROM `$table` WHERE image_name='$i'");
$resultname = mysql_query("SELECT image_name FROM `$table` WHERE image_id='$i'");
$row = mysql_fetch_array($result);
$id = $row['image_id'];
$name = $row['image_name'];
header("Location: ".$url."/video-".$name."-".$id.".htm");
}
else
{
header("Location: ".$url."");
}
?>Das scheint aber nicht richtig zu sein, da es dann nun so aufgerufen wird:
image--3.htmDer name zwischen - und - fehlt, dennoch wird es aufgerufen, aber wie klappt das richtig?