Beiträge von Maaax

Produktbeschreibung von 48603 erfolgreich aktualisiert
stdClass Object
(
    [id] => 48603
    [name] => Quarantine
    [slug] => quarantine
    [permalink] => https://4-gamers-shop.de/produkt/quarantine/
    [date_created] => 2019-04-08T20:23:08
    [date_created_gmt] => 2019-04-08T18:23:08
    [date_modified] => 2019-04-11T19:41:09
    [date_modified_gmt] => 2019-04-11T17:41:09
    [type] => simple
    [status] => publish
    [featured] =>
    [catalog_visibility] => visible
    [description] =>
    [short_description] =>
    [sku] => 0728ffdd-038c-4711-8ec8-de1ead8d3218
    [price] => 9.99
    [regular_price] => 9.99
    [sale_price] =>
    [date_on_sale_from] =>
    [date_on_sale_from_gmt] =>
    [date_on_sale_to] =>
    [date_on_sale_to_gmt] =>
    [price_html] => <span class="woocommerce-Price-amount amount"><span class="woocommerce-Price-currencySymbol">&euro;</span>9,99</span>
    [on_sale] =>
    [purchasable] => 1
    [total_sales] => 0
    [virtual] => 1
    [downloadable] =>
    [downloads] => Array
        (
        )


    [download_limit] => -1
    [download_expiry] => -1
    [external_url] =>
    [button_text] =>
    [tax_status] => taxable
    [tax_class] =>
    [manage_stock] => 1
    [stock_quantity] => 50
    [stock_status] => instock
    [backorders] => no
    [backorders_allowed] =>
    [backordered] =>
    [sold_individually] =>
    [weight] =>
    [dimensions] => stdClass Object
        (
            [length] =>
            [width] =>
            [height] =>
        )


    [shipping_required] =>
    [shipping_taxable] =>
    [shipping_class] =>
    [shipping_class_id] => 0
    [reviews_allowed] => 1
    [average_rating] => 0
    [rating_count] => 0
    [related_ids] => Array
        (
            [0] => 51781
            [1] => 51831
            [2] => 51533
            [3] => 51729
            [4] => 51459
        )


    [upsell_ids] => Array
        (
        )


    [cross_sell_ids] => Array
        (
        )


    [parent_id] => 0
    [purchase_note] =>
    [categories] => Array
        (
            [0] => stdClass Object
                (
                    [id] => 1436
                    [name] => RPG
                    [slug] => rpg
                )


            [1] => stdClass Object
                (
                    [id] => 1427
                    [name] => Simulation
                    [slug] => simulation
                )


            [2] => stdClass Object
                (
                    [id] => 1432
                    [name] => Strategy
                    [slug] => strategy
                )


        )


    [tags] => Array
        (
        )


    [images] => Array
        (
            [0] => stdClass Object
                (
                    [id] => 48604
                    [date_created] => 2019-04-08T22:23:08
                    [date_created_gmt] => 2019-04-08T18:23:08
                    [date_modified] => 2019-04-08T22:23:08
                    [date_modified_gmt] => 2019-04-08T18:23:08
                    [src] => https://4-gamers-shop.de/wp-content/uploads/2019/04/cover-214.jpg
                    [name] =>
                    [alt] =>
                )


        )


    [attributes] => Array
        (
            [0] => stdClass Object
                (
                    [id] => 5
                    [name] => Language
                    [position] => 0
                    [visible] => 1
                    [variation] =>
                    [options] => Array
                        (
                            [0] => Multilanguage
                        )


                )


            [1] => stdClass Object
                (
                    [id] => 3
                    [name] => Platform
                    [position] => 0
                    [visible] => 1
                    [variation] =>
                    [options] => Array
                        (
                            [0] => Steam
                        )


                )


            [2] => stdClass Object
                (
                    [id] => 4
                    [name] => Region
                    [position] => 0
                    [visible] => 1
                    [variation] =>
                    [options] => Array
                        (
                            [0] => EU
                        )


                )


            [3] => stdClass Object
                (
                    [id] => 8
                    [name] => Altersfreigabe
                    [position] => 0
                    [visible] => 1
                    [variation] =>
                    [options] => Array
                        (
                            [0] => 6
                        )


                )


        )


    [default_attributes] => Array
        (
        )


    [variations] => Array
        (
        )


    [grouped_products] => Array
        (
        )


    [menu_order] => 0
    [meta_data] => Array
        (
            [0] => stdClass Object
                (
                    [id] => 700703
                    [key] => _max_variation_sale_price
                    [value] =>
                )


            [1] => stdClass Object
                (
                    [id] => 700704
                    [key] => _min_variation_sale_price
                    [value] =>
                )


            [2] => stdClass Object
                (
                    [id] => 700705
                    [key] => _max_variation_regular_price
                    [value] =>
                )


            [3] => stdClass Object
                (
                    [id] => 700706
                    [key] => _min_variation_regular_price
                    [value] =>
                )


            [4] => stdClass Object
                (
                    [id] => 700707
                    [key] => _max_variation_price
                    [value] =>
                )


            [5] => stdClass Object
                (
                    [id] => 700708
                    [key] => _min_variation_price
                    [value] =>
                )


        )


    [_links] => stdClass Object
        (
            [self] => Array
                (
                    [0] => stdClass Object
                        (
                            [href] => https://4-gamers-shop.de/wp-json/wc/v3/products/48603
                        )


                )


            [collection] => Array
                (
                    [0] => stdClass Object
                        (
                            [href] => https://4-gamers-shop.de/wp-json/wc/v3/products
                        )


                )


        )


)

<?php
//Datenbankverbindung ->
// WooCommerceverbindung ->




// Produktbeschreibungen aus der Datenbank selektieren


$selectOnline1 = "SELECT shop_product_ass.productId, default_description.dDescription, default_description.ter_id FROM shop_product_ass INNER JOIN default_description ON shop_product_ass.productId = default_description.productId WHERE default_description.ter_id = 19 GROUP BY shop_product_ass.productId";


$resultSelectOnline1 = $conn->query($selectOnline1);


use Automattic\WooCommerce\HttpClient\HttpClientException;




try {
   


$arrWoo = array(); // Array mit ProduktSKU && WooIds


// Schreibe ProduktSKUs && WooIds in ein Array
$maxPage = 20;


$page = 1;


$count = 0;


$perPage = 100;


for($loop = 0;$loop < $maxPage;$loop++){


    if($page == 20){
        $perPage = 20;
    }
    echo "Seite : ".$page."\n";


    sleep(1);
    $results = $woocommerce->get('products',array('per_page' => $perPage, 'page' => $page));


    foreach($results as $r){
        $arrWoo[$count][0] = $r->sku;
       $arrWoo[$count][1] = $r->id;
    $count++;
    }


    echo $arrWooLength = count($arrWoo);
    echo "\n";
    $page++;
}


// Schreibe ProduktSKUs && WooIds in ein Array Ende
       




    while($row = $resultSelectOnline1->fetch_assoc()) {
        // echo $row['productId']." aus dem Datenpool geholt \n";


        for($i = 0;$i < $arrWooLength;$i++){
            if($arrWoo[$i][0] == $row['productId']){
                $wooId = $arrWoo[$i][1];
                $desc = $row['dDescription'];


                // echo "Beschreibung aus dem Datenpool geholt \n";


                $desc = preg_replace('/<script\b[^>]*>(.*?)<\/script>/is', "", $desc); // Entferne Javascript


                $desc = str_replace(array("\r\n", "\r", "\n"), '', $desc); // Zeilenumbrüche entfernen
               
                // echo "Zeilenumbrüche entfernt \n";


                $desc = preg_replace("/<img[^>]+\>/i", "", $desc); // <img src=''> Tags entfernen


                // echo "Produktbeschreibung von ".$wooId." wird aktualisiert \n";
               


       //erstelle Array mit der Produktbeschreibung
                $data = [
                    'description' => $desc
                ];
           
                $wooProduct = 'products/'.$wooId;
           
                sleep(10); // warte 10 Sekunden, da sonst zu viele Anfragen geschickt werden & Script abbricht


       // Füge Produktbeschreibung bei WooCommerce ein


                if($woocommerce->put($wooProduct, $data)){
                    echo "Produktbeschreibung von ".$wooId." erfolgreich aktualisiert \n";
                }
                else{
                    echo "ERROR \n";
                }
            }
        }
    }




   
   




} catch (HttpClientException $e) { // Fehlermeldungen
    echo '<pre><code>' . print_r( $e->getMessage(), true ) . '</code><pre>'; // Error message.
    echo '<pre><code>' . print_r( $e->getRequest(), true ) . '</code><pre>'; // Last request data.
    echo '<pre><code>' . print_r( $e->getResponse(), true ) . '</code><pre>'; // Last response data.
}










?>