Closed

Create a double AJAX/PHP/HTML/MySQL query

I want someone to give me a simple template HTML (including the JavaScript/AJAX) file, a PHP file and the SQL query that will create test tables in MySQL that does the following:

I have a MySQL database that I access using PHP. Basically, I want to have a "switch" in the MySQL database which turns on or off based on a simple SELECT query (e.g. a value in a field in a table). Depending on the value returned (e.g. ON or OFF in a value somewhere in the database), there needs to be some dynamic HTML shown (an HTML form created from a different PHP/MySQL query). If the SELECT gets an "ON" value, then it will show the HTML form including dynamically created values from PHP. If it's "OFF", then the HTML form disappears, and the HTML page is blank. This "switch" needs be checked every two seconds (so the form appears or disappears quickly), but when the switch is "ON", I don't want the actual HTML form (from the second PHP/MySQL query) refreshing every two seconds.

It's like I need two PHP/MySQL queries working together - one every two seconds checking the switch, and the other running a different query which generates the HTML form itself that is shown when the switch is on.

This is what should happen:

1. When the HTML page first loads, the switch should be checked. If the switch is ON, run the PHP SELECT query once that selects some other data from another table in the database and spits out some HTML containing this dynamic data.

2. Keep checking the switch every two seconds, but do not refresh the dynamic HTML form while the switch is still on. I don't want the form flashing or refreshing while someone is trying to use it. Hold the form steady, but keep checking the switch.

3. Continue checking the switch every two seconds.

4. When the switch is finally OFF, make the HTML form disappear so the HTML page goes blank. It is fine if the person hasn't filled in the form - it should disappear anyway.

If you could give me files that show me how to do this using AJAX, I'd be most appreciative.

If you have more questions, just ask.

Kĩ năng: AJAX, Javascript, MySQL, PHP

Xem nhiều hơn: create quiz ajax php mysql, create report using php html mysql, php html mysql ajax, php, html, javascript, psd to html, jquery / prototype, ajax css, create upload ajax php, php sanitize mysql query, php html mysql select form, php tabs mysql query, php select form query database, ajax php display mysql, php protect mysql query, php xml mysql saving database, ajax php select mysql, ajax php login mysql, ajax php tree mysql

Về Bên Thuê:
( 7 nhận xét ) Balmain, Australia

ID dự án: #15011379

35 freelancer đang chào giá trung bình $28 cho công việc này

$54 AUD trong 1 ngày
(954 Nhận xét)
8.6
minhhoangduc

Hello, I'm a PHP/Drupal/WordPress/Codeigniter/Laravel/Slim/Joomla Framework CERTIFIED EXPERT coder. And have a lot of experience with System admin + Html + Javascript + CSS + API integration Relevant Skills and Experi Thêm

$55 AUD trong 1 ngày
(569 Nhận xét)
8.1
maxsmith8

Hello there, I am interested and ready to start, lets discuss with details. Relevant Skills and Experience we have 10+ year experience in WEB DESIGNING AND DEVELOPMENT. Please visit our profile [login to view URL] Thêm

$30 AUD trong 1 ngày
(184 Nhận xét)
8.0
sismaster

Hello sir, It will be nice if we have one time discuss to me. BEST THAT I TRY ALWAYS PLEASE HAVE A LOOK https://www.freelancer.in/u/sismaster.html Thanks, Poonam Relevant Skills and Experience HTML, CSS, Bootstrap, Thêm

$35 AUD trong 1 ngày
(451 Nhận xét)
7.5
webdesign786

[login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] Proposed Milestones $29 AUD - After Co Thêm

$29 AUD trong 1 ngày
(101 Nhận xét)
6.9
jayshreeganeshha

hello,software developer here having experience of more than 5 years and i would like to work on your project .you can see my reviews and discuss with me.I hope you would like to hire [login to view URL] Relevant Skills and Exp Thêm

$25 AUD trong 1 ngày
(74 Nhận xét)
6.1
$30 AUD trong 0 ngày
(133 Nhận xét)
6.1
Dckumawat

Dear Client, I've gone through your project description, as per given description we can do this work and we'll fix all your issues. Relevant Skills and Experience We are expertise in php, core php, CMS, HTML5, CSS3, Thêm

$50 AUD trong 2 ngày
(51 Nhận xét)
5.5
alif8

Hello, Great to see your job. I have 8+ year of experience. Services that we provide: App, Web Design & Dev., Graphic Design, Content Writing, SEO, hosting. Please contact for more details. Sandhya. Relevant Skills Thêm

$25 AUD trong 1 ngày
(69 Nhận xét)
6.0
imagicaworld

Hello Relevant Skills and Experience please have a look at our portfolio link:- [login to view URL] Proposed Milestones $50 AUD - S

$50 AUD trong 1 ngày
(39 Nhận xét)
5.5
$25 AUD trong 1 ngày
(30 Nhận xét)
5.4
darkerbg

A proposal has not yet been provided

$30 AUD trong 1 ngày
(22 Nhận xét)
5.1
khemrajfreelance

I have more than 9 years of experience in web/mobile development. I have completed many mobile/web applications. We can discuss in detail further. Thanks Stay tuned, I'm still working on this proposal.

$25 AUD trong 1 ngày
(32 Nhận xét)
5.1
$25 AUD trong 1 ngày
(5 Nhận xét)
4.5
kaleshwarchand83

Hi, I have gone through the requirements and I can give you the html/ajax and php files which can do this easily using settimeout and json ready to start thanks Relevant Skills and Experience worked extensively with Thêm

$10 AUD trong 1 ngày
(40 Nhận xét)
4.2
mirzayas

hi sir can i help you?? Relevant Skills and Experience hi sir can i help you?? Proposed Milestones $25 AUD - hi sir can i help you?? hi sir can i help you??

$25 AUD trong 1 ngày
(9 Nhận xét)
4.6
oliviainfotech

Hi greetings of the day I am a Experienced PHP Developer based out in Chennai,India. My experience revolves around development of web and mobile applications,Ecommerce websites. Relevant Skills and Experience I believ Thêm

$50 AUD trong 1 ngày
(43 Nhận xét)
4.7
$15 AUD trong 1 ngày
(16 Nhận xét)
4.4
nikunjv9

Hello sir, - I have a good experience in PHP, photoshop,bootstrap 3, CSS3 and HTML5. Relevant Skills and Experience Our Work [login to view URL] [login to view URL] [login to view URL] http://fla Thêm

$25 AUD trong 1 ngày
(12 Nhận xét)
3.4
WCTech

To submit this offer please use the word "MINGHIE" in the title of your message. Hello, I am Neha, I am Business Analyst, have an amazing Team of around 5 Designers and 15 Developers Relevant Skills and Experience T Thêm

$25 AUD trong 1 ngày
(13 Nhận xét)
2.9