Webpage with authentication Mysql query . ajax.

已关闭 已发布的 6 年前 货到付款
已关闭 货到付款

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脚本

项目ID: #16758358

关于项目

12个方案 远程项目 活跃的5 年前

有12名威客正在参与此工作的竞标,均价$172/小时

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 更多

$222 USD 在2天内
(1014条评论)
8.7
WebInfoSolutions

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

$222 USD 在3天内
(227条评论)
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, 更多

$200 USD 在5天内
(158条评论)
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 在3天内
(134条评论)
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 更多

$180 USD 在4天内
(137条评论)
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 更多

$250 USD 在11天内
(64条评论)
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 在2天内
(32条评论)
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 更多

$250 USD 在3天内
(0条评论)
0.0
john130

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

$250 USD 在4天内
(0条评论)
0.0