Webpage with authentication Mysql query . ajax.

Closed Posted 5 years ago Paid on delivery
Closed Paid on delivery

DO NOT bid if you will not be personally working on this project.

You must be well versed with linux and be comfortable with calling scripts from cli

Webpage will be password protected. I prefer entire directory to be password protected as I will want to move some other webpages there.

Top of webpage there will be 3 variables.

1. IP

2. Row

3 Collumn

If ip =[login to view URL]

channel=32

sim=16

Create a grid that is 32x16

in this grid we will write down phone numbers which are up to 12 digits long

to get phone number for channel 13 sim 4. select phone_number,bal,st,updated_at from device_status where channel = '13' and sim='4'

result will be like

+--------------+---------+------+---------------------+

| phone_number | bal | st | updated_at |

+--------------+---------+------+---------------------+

| 661024816 | 5390.00 | UN-R | 2018-04-22 09:26:24 |

+--------------+---------+------+---------------------+

We display phone number and balance in a cell

The color of the cell writing will vary based on st value

hovering my mouse over the cell or touching it on mobile shows me the updated at value and gives me some new menus

Menu

1. an arrow up, when i click this, it changes the background color of the cell and remembers the bal value. This background color gets reset if the bal value changes.

This will also issue the following command

php [login to view URL] --ussd --gw [login to view URL] --ports 13.4 --ussd-code *223#

ip is from the variable above, 13 and 4 are from the mysql query and *223# is a variable which we call balance written on the top of the page in the code

2. a refresh sign. when I click this. I issue the follwing php commands ont he local box

php [login to view URL] --ussd --gw [login to view URL] --ports 13.4 --ussd-code *123#

values should be checked against db every 60 sec

create 2 more buttons for future use

keep a log file for the clicks

I want ability to add multiple grid on same page

JavaScript Linux MySQL PHP Shell Script

Project ID: #16758358

About the project

12 proposals Remote project Active 5 years ago

12 freelancers are bidding on average $172 for this job

rajeshsonisl

Hi there, By 3 Variables, do you mean 3 input boxes where the user would enter the input OR would the variable input be populated from other sources? I'll need Cpanel access to your server to get started. I have More

$222 USD in 2 days
(1014 Reviews)
8.7
WebInfoSolutions

Do u want password protected web pages with options to add grids?................................................

$222 USD in 3 days
(227 Reviews)
7.9
tranngocanh1702

Hi, I am Anna with more than 6 years experience in web and cross-platform app development including Hybrid, PHP, Laravel framework, Slim, CodeIgniter, MySQL, PostgreSQL, HTML, CSS, Javascript, jQuery, Vuejs, Ajax, More

$200 USD in 5 days
(158 Reviews)
7.8
asifchaudhry2015

Hi There, I am Full Stack PHP Developer. I can call the scripts form cli. I can add multiple grid on same page. I am ready start to your work right now. Would you like to start chat with me? Thanks

$155 USD in 3 days
(134 Reviews)
7.3
PhpWebD

I'm a developer with extensive experience in building high quality sites and apps. I have an experience in (Ionic framework/React Native/NativeScript/PHP/Javascript/UI design). I know how to do apps in native IOS More

$180 USD in 4 days
(137 Reviews)
6.3
adicoman

Hi , l am very intrested to work on your project. I have more than 15+ years of experience in Web Development and around 1000 projects finished with success and some of them can be seen on freelancing websites Pleas More

$250 USD in 11 days
(64 Reviews)
5.9
dineshchand73

Hi, I have experience with php, php-cli, mysql, ajax and more and I can easily create the script as described in the post. if you have any questions please ask. thanks Dinesh Chand

$30 USD in 2 days
(32 Reviews)
3.3
tipsgarg07

I have developed & delivered Web database applications for enterprises & companies, using open source language PHP, MySQL, HTML 5, CSS3, AJAX, JSON, XML, etc. Coding, project and team management is my passion. My exper More

$250 USD in 3 days
(0 Reviews)
0.0
john130

I have done many projects like yours, I think I can do that.

$250 USD in 4 days
(0 Reviews)
0.0