connect_error) {
die("Connection failed: " . $conn_m->connect_error);
}
$suche = $conn_m->real_escape_string($suche);
?>
" ;
$result_sql_orders = $conn_m->query($sql_orders);
//*********************************Artikelname*********************************
while($row_orders = $result_sql_orders->fetch_assoc()) {
$i = $i + 1 ;
//echo "1_".$row_orders["id"]."
" ;
$sql_orders_id= 'SELECT articleID, attr9 FROM s_articles_attributes WHERE articleID = \''.$row_orders["id"].'\' AND attr9 <>\'\' LIMIT 1 ';
//echo $sql_orders_id."
" ;
$result_sql_orders_id = $conn_m->query($sql_orders_id);
$ergebnis = mysqli_num_rows($result_sql_orders_id);
if ($ergebnis == 0) {
$keinergebnis = 1 ;
}
else {
$gefunden = 1 ;
}
while($row_orders_id = $result_sql_orders_id->fetch_assoc()) {
//echo "name_".$row_orders_id["articleID"]."
" ;
?>
".$sammler."
";
//*********************************Artikelnummer*********************************
$suche = str_replace("%", "", $suche);
$suche = $suche."%" ;
$sql_orders_nummer = 'SELECT articleID, ordernumber, ean FROM s_articles_details WHERE ordernumber LIKE \''.$suche.'\' OR ean LIKE \''.$suche.'\' ';
//echo $sql_orders_nummer."
" ;
$result_sql_orders_nummer = $conn_m->query($sql_orders_nummer);
$ergebnis = mysqli_num_rows($result_sql_orders_nummer);
//echo "A".$ergebnis."
";
if ($ergebnis != 0) {
while($row_orders_nummer = $result_sql_orders_nummer->fetch_assoc()) {
//echo "3_".$row_orders_nummer["articleID"]."
" ;
$sql_orders_id= 'SELECT articleID, attr9 FROM s_articles_attributes WHERE articleID = \''.$row_orders_nummer["articleID"].'\' AND attr9 <>\'\' LIMIT 1 ';
//echo $sql_orders_id."
" ;
$result_sql_orders_id = $conn_m->query($sql_orders_id);
$ergebnis = mysqli_num_rows($result_sql_orders_id);
if ($ergebnis == 0) {
$keinergebnis = 1 ;
} else {
$gefunden = 1 ;
}
$pos = strpos($sammler, $row_orders_nummer["articleID"]);
if ($pos === false) {
while($row_orders_id = $result_sql_orders_id->fetch_assoc()) {
$i = $i + 1 ;
$sql_orders_name= 'SELECT id, name FROM s_articles WHERE id = \''.$row_orders_id["articleID"].'\' ';
$result_sql_orders_name = $conn_m->query($sql_orders_name);
while($row_orders_name = $result_sql_orders_name->fetch_assoc()) {
//echo "nummer_".$row_orders_id["articleID"]."
" ;
?>