Want to prefetch values from the database

kedarp · 07-18-2013, 06:01 AM

Hello,

I am creating a web page where I need to get values from the database and fill the textboxes before submitting the form.
When I enter the employee ID, I should get the name of the employee when I click on a button "Get details".
What would help me to do this?

Snark1994 · 07-18-2013, 06:37 AM

Well, you could have PHP on the page that checks the POST data for an "employeeID" value: if it's not present (when you first load up the page) or invalid, then it just displays a blank page, but if it matches a record in your employee database (when someone's filled in the field and clicked 'Get details'), then it loads up their details and puts them into the fields as defaults. Just make sure your code doesn't fall foul of SQL injection if you use this approach.

If you need more specific help than this, please show us the code you've written so far.

Hope this helps,

kedarp · 07-18-2013, 08:25 AM

Thanks for the reply. Here is a sample code for page.
I want to get the employee name on the same page as this.

Code:

<form action="action.php" method="post">

    Employee ID: <input type="text" name="id">
    <input type="button" value="Get details">

    Employee Name: <input type="text" name="name">
    <br>
    <input type="submit" value="Submit">

</form>

The problem is if I click "Submit", it will navigate me to another page.
Do I need to look into AJAX or something?

dugan · 07-18-2013, 09:38 AM

Quote:

Originally Posted by kedarp

Do I need to look into AJAX or something?

Yes.

With jQuery, you'd use something like:

Code:

$('input[name="id"]).click(function {} {
    $.get('http://localhost/employees/' + this.val(), function (data) {
        $('input[name="name"].val(data['name']));
    })
});

And on the server side, you'd have an endpoint at http://localhost/employees/<id> (say, http://localhost/employees/2), which returns JSON in the following format:

Code:

{'id': 2, 'name': 'bob'}

kedarp · 08-03-2013, 12:45 AM

Uptil now, I have got success in getting values from the database on the same page by calling a php script.

Code:

<script type="text/javascript">
$(document).ready(function(){
    $("span").hide();
    $("#getname").click(function(){
        $.get("data.php?id=" + id.value,function(data){
	    if(data.length>1)
	    {
	    $("span").hide();
	    $("#name").val(data);
            }
	    else
            {
	    $("span").show();
	    }		    
        });
    });
});
</script>

Here is the html code.

Code:

    Employee ID: <input type="text" name="id" id="id">
    <button id="getname">Get name</button>

    Employee Name: <input type="text" name="name" id="name">
    <span>Name does not exist for this id</span>
    <br>

Now, the problem is that when I add the <form> tag to the html code, this code fails. The form gets submitted and
takes me to another page(action of form tag). I am working on it.

Regards.