$produse['ro']=array('De la','produkt');
$produse['de']=array('Von','produkt');
if(!isset($_GET['page']))$_GET['page']=1;
$line_number=10;
$begin=($_GET['page'] * $line_number)-$line_number;
$stmt = $mysqli->prepare("SELECT nume_ro,re_nume_ro,id from firme where re_nume_ro=?");
$stmt->bind_param("s", $_GET['nume_firm']);
$stmt->execute();
$pResult = $stmt->get_result();
$array = $pResult->fetch_array(MYSQLI_ASSOC);
$link_dom="/".$array['re_nume_ro'];
$id_dom=$array['id'];
$descrp=$array['descr_ro'];
$dom=$array['nume_ro'];
$h1=$dom;
$stmt = $mysqli->prepare("SELECT id,cod, nume_ro, poza,pret, reducere, descr_ro,ord,stare,re_nume_ro,prezentare,id_firm,bumbac,short_text,aktion,poza_redimens from produse where aktion='on' and activ=0 order by ord limit $begin, $line_number");
$stmt->bind_param("ii", $begin, $line_number);
$stmt->execute();
$pResult = $stmt->get_result();
$pResult1 = $mysqli->query("SELECT id,cod, nume_ro, poza,pret, reducere, descr_ro,ord,stare,re_nume_ro,id_firm from produse where aktion='on' and activ=0 order by ord,id");
$k=0;
?>
Sie sind hier: Aktions preis
echo "
Aktions preis
";
//if($descrp<>"")
echo "
".$descrp."
";
/*
if($pdf<>"")
echo '
Descarcă
PDF';
*/
/*---posibila galerie domeniu
$pResult4 = $mysqli->query("select * from poze_subdom where id_poza='".$array['id']."'");
$row4 = $pResult4->num_rows;
if($row4>0)
{
echo '
';
while ($array4 = $pResult4->fetch_assoc())
{
echo '

';
}
echo '
';
}
-----------------*/
?>
Empfehlungen
$i=0;
$row1 = $pResult1->num_rows;
$row = $pResult->num_rows;
while ($array = $pResult->fetch_assoc())
{
$i++;
$len = 5;
$base="abcdefghjkmnpqrstwxyzabcdefghjkmnpqrstwxyzabcdefghjkmnpqrstwxyz123456789";
$max=strlen($base)-1;
$activatecode='';
mt_srand((double)microtime()*1000000);
while (strlen($activatecode)<$len+1)
$activatecode.=$base{mt_rand(0,$max)};
$pret=pret($array['pret'],$array['reducere']);
if($array['poza']=="")
$src="/assets/farapoza.jpg";
else
$src="/poze_prod_max/".$array['poza_redimens']; //$src="/poze_prod_m/max_".$array['poza'];
$array['descr_ro']=str_replace("( "," (",$array['descr_ro']);
$sigla='';
//*****************************************firma
$stmt = $mysqli->prepare("SELECT nume_ro,poza from firme where id=?");
$stmt->bind_param("i", $array['id_firm']);
$stmt->execute();
$pResF = $stmt->get_result();
$arrF = $pResF->fetch_array();
if($arrF['poza']<>'')
$sigla='

';
//*****************************************firma
echo '
';
if($array['bumbac']=="on")
echo '
';
if($array['aktion']=="on")
echo '
';
echo '
'.$produse[$lb][0].' CHF '.$array['pret'].' (inkl. MwSt)
'.$sigla.'
';
/*
echo '
';
if($array['bumbac']=="on")
echo '
';
if($array['aktion']=="on")
echo '
';
echo '
'.$produse[$lb][0].': '.$array['pret'].' EUR
'.$sigla.'
';
*/
//
//if($i%2==0)
//echo '
';
}
$_SESSION['LAST_REF']=$_SERVER["REQUEST_URI"];
$_SESSION['LAST_ID']=$id_dom;
$address="/aktions-preis";
if($row1>9)
{
echo '
';
include "next.php";
}
echo '
';
?>