Displaying Last Record

zubinkasad

Hi everyone

I am working on stores management system where i have

1) one product "textbox" which on getting focus displays a combo box with the
list of products.
2) on selecting the product from the combo box the textbox will display the value
of the product selected in the combo box.

 Above part has been achieved using javascript but now what i want is

3) I need to display the last record of the product (whose name appears in
the textbox) that was ordered with all information.

4) I also need to display price, dealer name of that product automatically.

I dont want to refresh page.

Thanks

mjqtreble

If you don't want to refresh the page, then PHP is no good to you. You need to do it all with javascript.

Roger_Ramjet

Well, depends on how you want to do the thing. This is an ideal place to use an IFRAME on your page. The same piece of javascript that handles the amount display could also request the page for the iframe.
If you do not want any page requests then you are going to have to pass all the information along with the other data for the products and use javascript to display it again.


// to query for the last order data - and NOT assuming every product has an order

$sql = "SELECT p.product_id, 
           p.product,
           p.price,
           MAX(o.order_id),
           o.customer,
           o.orderdate,
           o.quantity,
           o.total
     FROM products AS p LEFT JOIN orders AS o USING(product_id)
     GROUP BY p.product_id, o.order_id";

Add additional tables as required for dealer data etc.

Only mysql lets you get away without listing all columns in the group by clause. It may even let you get away with using table.* along with aggregate functions (MAX) - I forget.

zubinkasad

Thanks to both of you.

Roger i know how to get last record from mysql , but what i want is to get this record once that textbox is updated with the value of product and on that product i will be running this query.

I am also looking into IFRAME, if you have more information into IFRAME please do provide me.

Thanks

Roger_Ramjet

iframe iframe Load the iframe with the data via your js event handler that already displays the value once a product is selected.

You can also do it without sending another page request.

If you include the data for the last order for every product when you send the page, then you can use CSS to display it when a specific product is selected. Pure CSS Popups

You can also do this with javascript: include the data for each product in an array and code a javascript function to show it. This may be preferable as you already have js to update the value when an option is selected. Just add code to select from the array and another document write to display the addditional data on the page.

But I think the CSS is slicker.

zubinkasad

I still cant get it.

i have a php file, can i put iframe inside it and than display the database results inside that iframe, based on the products i enter in the textbox

Roger_Ramjet

To explain.

Create the php script that will query the database and display the order data for a requested product. This will be the page loaded into the iframe.

In the original page:
Include an iframe.
Embed the product select box in a form that submits to the above script and sets the iframe as the target. Code this in the select


<select name="prod" onChange="submit();">

Or add the load request to a javascript event handler instead of using a form.

Every time the product is changed, the iframe will reload with the corresponding order data.

thorpe

another and IMO better option would be to use ajax. here is a simple tutorial written by the guy who originaly wrote php.

Roger_Ramjet

Cool link to great code, Thorpie.

I agree that the HttpRequest method is the best way to go, and this is the best implementation of it that I have seen. (my own link on the subject - here)

Iframe is much the simpler remote-scripting option though, and easier for novices to get their head around. remote scripting

zubinkasad

Thanks i was able to solve the problem i had, but adding another problem

as there are lots of product textboxes for example to enter 10 orders on a page, u need 10 textboxes so what i want is

How to find out which was the textbox from which i have got the product name. Because on basis of that product the query will get last record.

For eg.

first textbox is having 'laptop'; (i got the last record of this textbox as it is the only one)
second textbox is having 'desktop' ( i want to get the last record of second box as by default it takes the first one).