Login Register






Thread Rating:
  • 0 Vote(s) - 0 Average


Help with Updating database from PHP? filter_list
Author
Message
RE: Help with Updating database from PHP? #21
(07-28-2016, 05:52 AM)mudrig Wrote: That worked. Looks like I just had the parameters backwards on that.

Now one more question since you have been so helpful. How would I make this form after submitted go back to same page and Display above form the result from the action of the form submit.

Awww yeah Biggrin That's great...

In order to do that you'll have to submit the page via Ajax, I haven't tested the code but here it is according to your form
Code:
<script type="text/javascript">
$(document).ready(function() {
      $('form').submit(function(e){
       
           $.ajax({
                type: 'post',
                url: 'user_rank_change.php',
                data: $('form').serialize(),
                success: function(result) {
                       alert(result);
                }
           });
           e.preventdefault(); //Doesn't allow page to refresh
      });
});
</script>

Paste this code after your </body> tag and tell me if any error comes or it works
My Blog: http://www.procurity.wordpress.com
Donations: 1HLjiSbnWMpeQU46eUVCrYdbkrtduX7snG

Reply

RE: Help with Updating database from PHP? #22
I added it after body tags and tried it but the page still refreshes and goes to blank page with the results
“I am thankful for all of those who said NO to me. It’s because of them I’m doing it myself.” – Albert Einstein

Reply

RE: Help with Updating database from PHP? #23
Did you add the Jquery to your document?

Put this inside head tag
Code:
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.1.0/jquery.min.js"></script>
My Blog: http://www.procurity.wordpress.com
Donations: 1HLjiSbnWMpeQU46eUVCrYdbkrtduX7snG

Reply

RE: Help with Updating database from PHP? #24
It's working but still goes to blank page with results after it shows pop-up
“I am thankful for all of those who said NO to me. It’s because of them I’m doing it myself.” – Albert Einstein

Reply

RE: Help with Updating database from PHP? #25
Typo detected Tongue OMG I hate these mistakes

Replace this line in the Jquery code
Code:
e.preventdefault(); //Doesn't allow page to refresh

with this

Code:
e.preventDefault();

The d was to be uppercase D, Yikes
My Blog: http://www.procurity.wordpress.com
Donations: 1HLjiSbnWMpeQU46eUVCrYdbkrtduX7snG

Reply

RE: Help with Updating database from PHP? #26
(07-28-2016, 01:36 PM)Ex094 Wrote: Typo detected Tongue OMG I hate these mistakes

Replace this line in the Jquery code
Code:
e.preventdefault(); //Doesn't allow page to refresh

with this

Code:
e.preventDefault();

The d was to be uppercase D, Yikes

Thanks Bud, You have taught me a lot since I am new to PHP that helps more then you think. Is there a way to style the pop-up window? Or is that the only way it will show up?
“I am thankful for all of those who said NO to me. It’s because of them I’m doing it myself.” – Albert Einstein

Reply

RE: Help with Updating database from PHP? #27
(07-28-2016, 05:30 PM)mudrig Wrote: Thanks Bud, You have taught me a lot since I am new to PHP that helps more then you think. Is there a way to style the pop-up window? Or is that the only way it will show up?

That alert is Javascripts default prompt but you can make a custom popup using Jquery, HTML and CSS. Lemme show you a simple way to displaying that response on the HTML document via DOM (In simple words, It allows you to easily manipulate HTML components)

In your body tag, paste this any where:
Code:
<div id="response"></div>

Now edit the following line in your Jquery
Code:
alert(result);

By
Code:
$('#response').html("<b>" + result + "</b>")

Now your response from the PHP Script will be displayed on the HTML document inside the div tags, You won't see a popup. Now use CSS and more Jquery to give that div some eye candy factor.

There are plugins available for this task in case you wanna get some ideas:
http://dinbror.dk/bpopup/
My Blog: http://www.procurity.wordpress.com
Donations: 1HLjiSbnWMpeQU46eUVCrYdbkrtduX7snG

Reply

RE: Help with Updating database from PHP? #28
(07-28-2016, 05:56 PM)Ex094 Wrote:
(07-28-2016, 05:30 PM)mudrig Wrote: Thanks Bud, You have taught me a lot since I am new to PHP that helps more then you think. Is there a way to style the pop-up window? Or is that the only way it will show up?

That alert is Javascripts default prompt but you can make a custom popup using Jquery, HTML and CSS. Lemme show you a simple way to displaying that response on the HTML document via DOM (In simple words, It allows you to easily manipulate HTML components)

In your body tag, paste this any where:
Code:
<div id="response"></div>

Now edit the following line in your Jquery
Code:
alert(result);

By
Code:
$('#response').html("<b>" + result + "</b>")

Now your response from the PHP Script will be displayed on the HTML document inside the div tags, You won't see a popup. Now use CSS and more Jquery to give that div some eye candy factor.

There are plugins available for this task in case you wanna get some ideas:
http://dinbror.dk/bpopup/

You have helped me once again thanks. If I run into anymore questions I cant figure out do you mind if I PM you on here?
“I am thankful for all of those who said NO to me. It’s because of them I’m doing it myself.” – Albert Einstein

Reply

RE: Help with Updating database from PHP? #29
I'm glad you are learning, Yes you can PM me any time you want Smile
My Blog: http://www.procurity.wordpress.com
Donations: 1HLjiSbnWMpeQU46eUVCrYdbkrtduX7snG

Reply

RE: Help with Updating database from PHP? #30
I've got the form and the result working just the way I want it now and styled just right now
“I am thankful for all of those who said NO to me. It’s because of them I’m doing it myself.” – Albert Einstein

[+] 1 user Likes mudrig's post
Reply







Users browsing this thread: 2 Guest(s)