Retrieve the data from MySQL database and execute algorithm with PHP

It's a WordPress website, and here is the algorithm for PHP script that needs to be executed within particular .php file:

1. Check if WordPress user membership level is "dolphin":

<?php if(woocommerce_members_only(array("dolphin"))): ?>

...do the rest

<?php endif; ?>

2. Get user ID (X)

3. Get user membership start/end dates from:

Table 1: wp_usermeta


- user_id : X

- meta_key : _rpwcm_dolphin_expires (start date) AND _rpwcm_dolphin_since (end date)

- meta_value : 1516901635

4. Count number of rows where column "timestamp" is >= start date AND <= end date

Table 2: wp_ahm_download_stats


- user_id : X

- timestamp: 1514392796

5. Save the value (number) to variable and echo it.

That's it :)

Deadline: 2 days.

Kemahiran: MySQL, PHP, Wordpress

Lihat lagi: retrieve data mysql create reports using php, insert data mysql database using json php, upload data mysql database upload file php scriptonline website, php, laravel, retrieve data mysql database xml file, retrieve data mysql database javascript, retrieve data mysql database iphone app dev, retrieve data mysql database table scroll, actionscript php form send retrieve data mysql, appending data mysql database php forms, export data mysql database xls php, save xml data mysql database php, retrieve data mysql database flash using actionscript, php parse email data mysql database, send form data mysql database using php

Tentang Majikan:
( 3 ulasan ) Gospic, Croatia

ID Projek: #16026098

10 pekerja bebas membida secara purata $24 untuk pekerjaan ini


Hi there, Quick and easy. I can get started and complete in 2 hours. I'll need admin and FTP access. Thanks. Regards, Rajesh Soni

$25 USD dalam sehari
(987 Ulasan)

Hello. Wordpress development expert ready to help you with data retrieve. I have more 400 good reviews so all will be done on highest level. Price can be discussed to fit your budget More 7 years of WP full stack deve Lagi

$35 USD dalam sehari
(495 Ulasan)

Hello Sir, I have over 5 years experiences in web development. I checked all your requirements. As my skills and experiences about PHP/MySQL, Wordpress I believe that I can handle your task well and quickly. Plea Lagi

$35 USD dalam 2 hari
(176 Ulasan)

Hi there, I am a WordPress expert and I have worked with woocommerce for long and I can quickly get this done for you. Regards

$20 USD dalam sehari
(139 Ulasan)

Hello the hiring member there. Greetings ! I am Bhavika having 2+ years experience in PHP development. I have read your project details, And I can do this algorithm as you want and I will deliver the job today. I bel Lagi

$25 USD dalam 0 hari
(98 Ulasan)

A proposal has not yet been provided

$15 USD dalam sehari
(77 Ulasan)

Hello hope you are doing good I am a contemporary and excellent Website designer and developer with a focus on user-centered design while helping clients to achieve the desired result. Experience and expertise – Lagi

$30 USD dalam 2 hari
(18 Ulasan)

hi i am expert in algorithm and php i will do that task please consider

$15 USD dalam sehari
(4 Ulasan)
$10 USD dalam sehari
(2 Ulasan)

Hello there, I have gone through your job post and reviewed all your requirements. I can assist you in this job as i have 5 year experience in PHP, WordPress, MySQL. Please review my work:- [login to view URL] ( Lagi

$30 USD dalam 2 hari
(3 Ulasan)