Andre hovedside i photoalbum bygget i PHP/MySQL (radio og submit)
Er ny her samt ud i PHP/MySQL. Har med hjaelp faaet opbygget et online fotoalbum hvor besoegende paa hovedsiden under hver kategorie kan vaelge et underomraade. I den nuvaerende udgave benyttes 'submit' og 'radio' buttons - det er det jeg om muligt gerne vil ha aendret til rene tekst links (i stil med det normale <a href="">bla bla</a>)Nogen der kan hjaelpe mig?
Her er den kode jeg benytter:
Koden til main.php
<?php
include("functions_main.inc");
$n_per_page = 1;
if(isset($_POST['Country']))
{
if(!isset($_POST['interest']))
{
header("location: main.php");
exit();
}
else
{
if(isset($_POST['n_end']))
{
if($_POST['Country'] == "Previous")
{
$n_start = $_POST['n_end']-($n_per_page);
}
else
{
$n_start = $_POST['n_end'] + 1;
}
}
else
{
$n_start = 1;
}
$n_end = $n_start + $n_per_page -1;
$connect = connect_to_db("Vars.inc");
$query_photos = "SELECT * FROM photos WHERE
sub='$_POST[interest]' ORDER BY name";
$result = mysqli_query($connect,$query_photos)
or die ("query_photos: ".mysqli_error($connect));
$n=1;
while($row = mysqli_fetch_assoc($result))
{
foreach($row as $field => $value)
{
$country[$n][$field]=$value;
}
$n++;
}
$n_country = sizeof($country);
if($n_end > $n_country)
{
$n_end = $n_country;
}
include("fields_products_page.inc");
include("catalog_product_page.inc");
}
}
else
{
$cxn = connect_to_db("Vars.inc");
$query = "SELECT DISTINCT country,sub FROM photos
ORDER BY country,sub";
$result = mysqli_query($cxn,$query)
or die ("Couldn't execute query.
".mysqli_error($cxn));
while($row = mysqli_fetch_array($result))
{
$photo_categories[$row['country']][]=$row['sub'];
}
include("fields_index_page.inc");
include("catalog_index_page.inc");
}
?>
koden til catalog_index_page.inc:
<?php
echo "<form action='$_SERVER[PHP_SELF]' method='POST'>\n";
foreach($photo_categories as $key => $subarray)
{
echo "|$key|";
foreach($subarray as $type)
{
echo "<input type='radio' name='interest' value='$type'><b>$type</b>\n";
}
}
echo "<input type='submit' name='Country' value='view'>\n</form>\n";
?>
Koden til catalog_product_page.inc:
<?php
for ($i=$n_start; $i <= $n_end; $i++)
{
echo "<img src='images/{$country[$i]['pix']}'></td>";
echo "{$country[$i]['description']}";
}
echo "<form action='$_SERVER[PHP_SELF]' method='POST'>";
echo "<input type='hidden' name='n_end' value='$n_end'>";
echo "<input type='hidden' name='interest' value='$_POST[interest]'>";
echo "<input type='submit' value='to main page'>";
if($n_end > $n_per_page)
{
echo "<input type='submit' name='Country' value='Previous'>";
}
if($n_end < $n_country)
{
echo "<input type='submit' name='Country' value='Next'>";
}
echo "</form>";
?>
Paa forhaand mange tak
Magsie
(er ny her saa ved ikke om det er for faa/mange point der er udbudt?)
