Siemens HMI
global $rand; global $helprand; $rand = 0; $helprand = 1; $Keyword = $_GET["Keyword"]; $OrderNumber = $_GET["OrderNumber"]; $Keyword = $OrderNumber; //if ($Keyword==""){$PicEn=false;}else{$PicEn=true;} if ($Keyword==""){$Keyword="6AV"; $OrderNumber="6AV";} if ($Keyword==""){$PicEn=false;}else{$PicEn=true;} //echo" Keyword: $Keyword // Order:$OrderNumber"; $i=0; if ($Sort ==''){$Sort = 'OrderNumber';} //$abfrage = "SELECT * FROM `N_Siemens` order by $Sort "; $abfrage = "SELECT * FROM `N_Siemens` WHERE (`OrderNumber` LIKE '%$OrderNumber%' or `Keyword` LIKE '%$Keyword%' or `Name` LIKE '%$Keyword%' or `Description` LIKE '%$Keyword%') order by $Sort limit 0,150"; $conUserId = mysqli_connect( 'localhost', 'nessies1_root', 'neumi', 'nessies1_SPS' ) or die( 'Verbindungsfehler!' ); $ergebnis = mysqli_query ($conUserId, $abfrage); while ($row =mysqli_fetch_object ($ergebnis)) { include 'AddText.php'; $helprand++; $rand++; //if ($helprand >2){$helprand = 1;$rand++;$addText='';} $i++; $Img = $row->OrderNumber.'.png'; $name = $row->Name; $description = $row->Description; $StLen = strlen($description); //while ($StLen <= 170){$description = $description.'_'; $StLen = strlen($description);} $price = $row->VK; $OrderNumber = $row->OrderNumber; $ItemId = $row->id; if ($row->Stock>0){$av = "available in Perth WA";}else{$av=" ships in 1-3 days*";} echo "* Conditions apply
$addText
