Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $servername = "localhost";
- $username = "";
- $password = "";
- $database = "";
- // Create connection
- $conn = new mysqli($servername, $username, $password, $database);
- // Check connection
- if ($conn->connect_error) {
- die("Connection failed: " . $conn->connect_error);
- }
- //echo "Connected successfully";
- //completed orders
- //$completed_orders = $conn->query("SELECT ID from wp_z5x343_posts WHERE post_type = 'shop_order' AND post_status = 'wc-completed'");
- //while($row = $completed_orders->fetch_array()) {
- // print $row[ID].',';
- //}
- //customers
- //$customers = $conn->query("SELECT meta_value FROM wp_z5x343_postmeta WHERE post_id IN (2022,2036,2040,2044,2045,2078,2079,2080,2081,2083,2088,2089,2090,2092,2093,2094,2100,2108,2110,2111,2109,2112,2113,2114,2115,2121,2122,2125,2127,2131,2135,2136,2137,2138,2139,2140,2141,2142,2143,2144,2145,2146,2147,2148,2149,2150,2151,2152,2153,2154,2155,2156,2157,2158,2159,2160,2161,2162,2163,2164,2166,2167,2168,2169,2170,2171,2172,2173,2174,2176,2177,2178,2179,2180,2186,2187,2188,2195,2196,2208,2209,2210,2213,2214,2215,2217,2218,2220,2221,2222,2223,2224,2225,2226,2227,2228,2229,2230,2231,2232,2233,2234,2238,2239,2240,2241,2242,2243,2244,2247,2248,2249,2254,2256,2257,2258,2259,2260,2264,2266,2270,2276,2277,2278,2286,2287,2290,2292,2295,2296,2301,2302,2303,2304,2305,2308,2311,2312,2313,2314,2315,2316,2317,2319,2321,2322,2323,2324,2325,2327,2328,2329,2330,2331,2332,2333,2334,2338,2341,2342,2343,2344,2346,2347,2348,2349,2350,2351,2353,2354,2355,2356,2358,2361,2364,2366,2367,2368,2369,2371,2373,2374,2375,2378,2379,2380,2381,2382,2383,2384,2385,2386,2387,2388,2389,2390,2391,2392,2393,2394,2395,2396,2397,2398,2399,2400,2401,2402,2403,2404,2405,2406,2407,2408,2409,2410,2411,2412,2414,2415,2417,2418,2423,2449,2452,2453,2456,2457,2458,2459,2460,2462,2470,2485,2486,2487,2488,2491,2496,2497,2500,2501,2502,2503,2506,2514,2516,2520,2525,2526,2527,2529,2531,2532,2533,2534,2536,2537,2541,2542,2543,2547,2548,2550,2555,2557,2558,2560,2561,2563,2564,2566,2567,2580,2581,2582,2583,2584,2585,2586,2587,2588,2589,2590,2591,2595,2596,2597,2598,2599,2600,2601,2602,2603,2604,2605,2606,2619,2620,2621,2623,2624,2627,2628,2629,2639,2643,2648,2655,2656,2661,2662,2663,2664,2665,2666,2670,2682,2684,2699,2700,2701,2706,2707,2708,2709,2712,2713,2714,2715,2717,2718,2719,2721,2722,2723,2724,2725,2728,2738,2741,2756,2763,2764,2765,2770,2772,2775,2777,2778,2779,2780,2789,2795,2798,2799,2800,2801,2802,2804,2805,2806,2810,2812,2814,2815,2816,2817,2818,2819,2820,2821,2822,2823,2824,2827,2830,2838,2841,2842,2843,2844,2845,2846,2849,2850,2851,2852,2853,2860,2861,2867,2868,2869,2870,2871,2882,2889,2890,2891,2892,2893,2894,2896,2897,2898,2899,2900,2905,2906,2908,2909,2910,2911,2912,2913,2915,2920,2921,2922,2926,2927,2929,2930,2933,2934,2936,2937,2944,2948,2949,2954,2955,2956,2957,2961,2965,2982,3003,3004,3005,3025,3034,3041,3042,3045,3055,3056,3059,3062,3064,3065,3075,3077,3078,3082,3084,3092,3097,3102,3103,3107,3112,3114,3115,3117,3153,3154,3350,3351) AND meta_key = ''");
- //while($row = $customers->fetch_array()) {
- // print $row[_customer_user].',';
- //}
- //ordered items
- //$ordered_items = $conn->query("SELECT order_item_name FROM wp_z5x343_woocommerce_order_items where order_id IN (2022,2036,2040,2044,2045,2078,2079,2080,2081,2083,2088,2089,2090,2092,2093,2094,2100,2108,2110,2111,2109,2112,2113,2114,2115,2121,2122,2125,2127,2131,2135,2136,2137,2138,2139,2140,2141,2142,2143,2144,2145,2146,2147,2148,2149,2150,2151,2152,2153,2154,2155,2156,2157,2158,2159,2160,2161,2162,2163,2164,2166,2167,2168,2169,2170,2171,2172,2173,2174,2176,2177,2178,2179,2180,2186,2187,2188,2195,2196,2208,2209,2210,2213,2214,2215,2217,2218,2220,2221,2222,2223,2224,2225,2226,2227,2228,2229,2230,2231,2232,2233,2234,2238,2239,2240,2241,2242,2243,2244,2247,2248,2249,2254,2256,2257,2258,2259,2260,2264,2266,2270,2276,2277,2278,2286,2287,2290,2292,2295,2296,2301,2302,2303,2304,2305,2308,2311,2312,2313,2314,2315,2316,2317,2319,2321,2322,2323,2324,2325,2327,2328,2329,2330,2331,2332,2333,2334,2338,2341,2342,2343,2344,2346,2347,2348,2349,2350,2351,2353,2354,2355,2356,2358,2361,2364,2366,2367,2368,2369,2371,2373,2374,2375,2378,2379,2380,2381,2382,2383,2384,2385,2386,2387,2388,2389,2390,2391,2392,2393,2394,2395,2396,2397,2398,2399,2400,2401,2402,2403,2404,2405,2406,2407,2408,2409,2410,2411,2412,2414,2415,2417,2418,2423,2449,2452,2453,2456,2457,2458,2459,2460,2462,2470,2485,2486,2487,2488,2491,2496,2497,2500,2501,2502,2503,2506,2514,2516,2520,2525,2526,2527,2529,2531,2532,2533,2534,2536,2537,2541,2542,2543,2547,2548,2550,2555,2557,2558,2560,2561,2563,2564,2566,2567,2580,2581,2582,2583,2584,2585,2586,2587,2588,2589,2590,2591,2595,2596,2597,2598,2599,2600,2601,2602,2603,2604,2605,2606,2619,2620,2621,2623,2624,2627,2628,2629,2639,2643,2648,2655,2656,2661,2662,2663,2664,2665,2666,2670,2682,2684,2699,2700,2701,2706,2707,2708,2709,2712,2713,2714,2715,2717,2718,2719,2721,2722,2723,2724,2725,2728,2738,2741,2756,2763,2764,2765,2770,2772,2775,2777,2778,2779,2780,2789,2795,2798,2799,2800,2801,2802,2804,2805,2806,2810,2812,2814,2815,2816,2817,2818,2819,2820,2821,2822,2823,2824,2827,2830,2838,2841,2842,2843,2844,2845,2846,2849,2850,2851,2852,2853,2860,2861,2867,2868,2869,2870,2871,2882,2889,2890,2891,2892,2893,2894,2896,2897,2898,2899,2900,2905,2906,2908,2909,2910,2911,2912,2913,2915,2920,2921,2922,2926,2927,2929,2930,2933,2934,2936,2937,2944,2948,2949,2954,2955,2956,2957,2961,2965,2982,3003,3004,3005,3025,3034,3041,3042,3045,3055,3056,3059,3062,3064,3065,3075,3077,3078,3082,3084,3092,3097,3102,3103,3107,3112,3114,3115,3117,3153,3154,3350,3351)");
- //while($row = $ordered_items->fetch_array()) {
- // print $row[order_item_name].',';
- //}
- //
- $first_sunday = $conn->query("SELECT wp_z5x343_woocommerce_order_items.order_item_name, wp_z5x343_woocommerce_order_items.order_id, wp_z5x343_postmeta.meta_key, wp_z5x343_postmeta.meta_value FROM wp_z5x343_woocommerce_order_items INNER JOIN wp_z5x343_postmeta ON wp_z5x343_woocommerce_order_items.order_id = wp_z5x343_postmeta.post_id WHERE order_id IN (2022,2036,2040,2044,2045,2078,2079,2080,2081,2083,2088,2089,2090,2092,2093,2094,2100,2108,2110,2111,2109,2112,2113,2114,2115,2121,2122,2125,2127,2131,2135,2136,2137,2138,2139,2140,2141,2142,2143,2144,2145,2146,2147,2148,2149,2150,2151,2152,2153,2154,2155,2156,2157,2158,2159,2160,2161,2162,2163,2164,2166,2167,2168,2169,2170,2171,2172,2173,2174,2176,2177,2178,2179,2180,2186,2187,2188,2195,2196,2208,2209,2210,2213,2214,2215,2217,2218,2220,2221,2222,2223,2224,2225,2226,2227,2228,2229,2230,2231,2232,2233,2234,2238,2239,2240,2241,2242,2243,2244,2247,2248,2249,2254,2256,2257,2258,2259,2260,2264,2266,2270,2276,2277,2278,2286,2287,2290,2292,2295,2296,2301,2302,2303,2304,2305,2308,2311,2312,2313,2314,2315,2316,2317,2319,2321,2322,2323,2324,2325,2327,2328,2329,2330,2331,2332,2333,2334,2338,2341,2342,2343,2344,2346,2347,2348,2349,2350,2351,2353,2354,2355,2356,2358,2361,2364,2366,2367,2368,2369,2371,2373,2374,2375,2378,2379,2380,2381,2382,2383,2384,2385,2386,2387,2388,2389,2390,2391,2392,2393,2394,2395,2396,2397,2398,2399,2400,2401,2402,2403,2404,2405,2406,2407,2408,2409,2410,2411,2412,2414,2415,2417,2418,2423,2449,2452,2453,2456,2457,2458,2459,2460,2462,2470,2485,2486,2487,2488,2491,2496,2497,2500,2501,2502,2503,2506,2514,2516,2520,2525,2526,2527,2529,2531,2532,2533,2534,2536,2537,2541,2542,2543,2547,2548,2550,2555,2557,2558,2560,2561,2563,2564,2566,2567,2580,2581,2582,2583,2584,2585,2586,2587,2588,2589,2590,2591,2595,2596,2597,2598,2599,2600,2601,2602,2603,2604,2605,2606,2619,2620,2621,2623,2624,2627,2628,2629,2639,2643,2648,2655,2656,2661,2662,2663,2664,2665,2666,2670,2682,2684,2699,2700,2701,2706,2707,2708,2709,2712,2713,2714,2715,2717,2718,2719,2721,2722,2723,2724,2725,2728,2738,2741,2756,2763,2764,2765,2770,2772,2775,2777,2778,2779,2780,2789,2795,2798,2799,2800,2801,2802,2804,2805,2806,2810,2812,2814,2815,2816,2817,2818,2819,2820,2821,2822,2823,2824,2827,2830,2838,2841,2842,2843,2844,2845,2846,2849,2850,2851,2852,2853,2860,2861,2867,2868,2869,2870,2871,2882,2889,2890,2891,2892,2893,2894,2896,2897,2898,2899,2900,2905,2906,2908,2909,2910,2911,2912,2913,2915,2920,2921,2922,2926,2927,2929,2930,2933,2934,2936,2937,2944,2948,2949,2954,2955,2956,2957,2961,2965,2982,3003,3004,3005,3025,3034,3041,3042,3045,3055,3056,3059,3062,3064,3065,3075,3077,3078,3082,3084,3092,3097,3102,3103,3107,3112,3114,3115,3117,3153,3154,3350,3351) AND order_item_name = 'Max Value HUD'");
- $x=0;
- while($row = $first_sunday->fetch_array()) {
- if($row["meta_key"] === '_customer_user')
- //print $row["meta_value"].',';
- $x++;
- }
- print $x;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement