Ditutup

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

Columns:

- 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

Columns:

- 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

11 pekerja bebas membida secara purata $23 untuk pekerjaan ini

rajeshsonisl

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
(898 Ulasan)
8.4
evgendob

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
(459 Ulasan)
7.8
langtukqs

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
(166 Ulasan)
6.5
amutinda

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
(81 Ulasan)
5.8
omniscient04

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
(8 Ulasan)
4.4
bjrupani

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
(17 Ulasan)
3.6
mayankinnovative

A proposal has not yet been provided

$15 USD dalam sehari
(33 Ulasan)
3.3
nicrosoft

Your requirements should be fulfilled and guarantee work should be provided to you according to your desire with in decided time duration because your requirements are my highest priority. Actually right now money is n Lagi

$12 USD dalam sehari
(2 Ulasan)
1.6
ankitkumar890

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
(2 Ulasan)
1.6
Sindustrus

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

$15 USD dalam sehari
(0 Ulasan)
0.0
$10 USD dalam sehari
(0 Ulasan)
0.0