Help with Updating database from PHP?

Help with Updating database from PHP? - Printable Version

+- Sinisterly (https://sinister.ly)
+-- Forum: Coding (https://sinister.ly/Forum-Coding)
+--- Forum: PHP (https://sinister.ly/Forum-PHP)
+--- Thread: Help with Updating database from PHP? (/Thread-Help-with-Updating-database-from-PHP)

Pages: 1 2 3

RE: Help with Updating database from PHP? - Ex094 - 07-28-2016

(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

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

RE: Help with Updating database from PHP? - mudrig - 07-28-2016

I added it after body tags and tried it but the page still refreshes and goes to blank page with the results

RE: Help with Updating database from PHP? - Ex094 - 07-28-2016

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>

RE: Help with Updating database from PHP? - mudrig - 07-28-2016

It's working but still goes to blank page with results after it shows pop-up

RE: Help with Updating database from PHP? - Ex094 - 07-28-2016

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

RE: Help with Updating database from PHP? - mudrig - 07-28-2016

(07-28-2016, 01:36 PM)Ex094 Wrote: Typo detected 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?

RE: Help with Updating database from PHP? - Ex094 - 07-28-2016

(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);

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/

RE: Help with Updating database from PHP? - mudrig - 07-29-2016

(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?

RE: Help with Updating database from PHP? - Ex094 - 07-29-2016

I'm glad you are learning, Yes you can PM me any time you want Smile

RE: Help with Updating database from PHP? - mudrig - 07-29-2016

I've got the form and the result working just the way I want it now and styled just right now