How to get value from php to input using ajax request [duplicate]

Question

Hi My question is how can I get the value from php script using an ajax with a onclick event.

I have a text field and a button

<button type="button" class="btn btn-primary" onclick="getid(this)">Generate ID</button>
<input type="text" name="pin" class="form-control" readonly>

And here is my php script named getrowcount.php

include_once  'conx.php';

$query ="SELECT * FROM patientprofile";
$result = $DBcon->query($query);
$count = $result->num_rows;

if ($result) {
   if($count >= 0){
       $count_res = $count += 1;
       $idnum = $count_res;
       $test = str_pad($idnum, 5, "0", STR_PAD_LEFT);
    }
}

And now my problem is how can I get the value from $test and put it in the input text field using ajax.

The Codesee · Accepted Answer · 2017-01-31 18:20:54Z

1

You can use AJAX to display the output from the query in the input field.

Step 1: Add this line of code to the bottom of getrowcount.php:

echo $test;

Step 2: Amend your HTML so that it looks like this:

<form id="get">
   <input type="text" id="pin" name="pin" class="form-control" readonly>
   <input type="submit" class="btn btn-primary" value="Generate ID">
</form>

Step 3: Add this script to the bottom of the page.

<script>
$(document).ready(function(){
    $("form#get").submit(function(event) {
        event.preventDefault();
        var input = $("#pin");

        $.ajax({
            type: "POST",
            url: "getrowcount.php",
            success: function(data) { input.val(data); }
        });
    });
});
</script>

edited Jan 31, 2017 at 18:20

answered Jan 31, 2017 at 18:16

The Codesee

3,7937 gold badges44 silver badges80 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

The Codesee Over a year ago

I have made a small change to the jQuery code.

alex paolo Over a year ago

Hi @The Codesee what if i use the onclick event rather than the submit button so that the page wont reload when cliccking the button.

The Codesee Over a year ago

event.preventDefault(); should stop the page from refreshing when the submit button is pressed.

Narendra Singh · Accepted Answer · 2017-01-31 18:45:19Z

1

May be this will help you

Your PHP code :

<?php
    // Your database query and results store in $test
    echo $test;
?>

Your ajax call should be -

$.ajax("getrowcount.php").done(function(data) {
   $('.form-control').val(data);
})

answered Jan 31, 2017 at 18:45

Narendra Singh

351 silver badge6 bronze badges

Comments

Zakaria Acharki · Accepted Answer · 2017-01-31 19:02:56Z

1

You could use the jQuery method $.get() in your javascript script :

function getid(_this){
     $.get('php_script_url.php',{},function(response){
         alert(response);
         $("[name=pin]").val(response);
     })
}

Then in your PHP script you should add echo to the result you want to return :

echo $test;

Hope this helps.

edited Jan 31, 2017 at 19:02

answered Jan 31, 2017 at 18:13

Zakaria Acharki

67.5k15 gold badges79 silver badges106 bronze badges

Comments

Geoff · Accepted Answer · 2017-01-31 20:27:00Z

0

For this you'd run the ajax call on button press, load the php from the ajax, in the php do an echo with the variable you want to use, then in the ajax success section, you'd use the returned variable.

edited Jan 31, 2017 at 20:27

answered Jan 31, 2017 at 18:11

Geoff

5932 gold badges7 silver badges25 bronze badges

Collectives™ on Stack Overflow

How to get value from php to input using ajax request [duplicate]

4 Answers 4

3 Comments

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

Comments

Comments

Comments

Linked

Related