Prev: eBay-style drop down menu
Next: Why do this? <SCRIPT TYPE="text/javascript"
From: Mtek on 5 May 2008 15:11

Hi,

This is the content of my DIV now:

echo " <div class='innerb'>";
echo " <table class='tabletwo'>";
$select = mysql_query("SELECT row_id, name, address,
city, state, guests, seating, comments
FROM reservations
WHERE res_date =
STR_TO_DATE('$pdate','%m/%d/%Y')
ORDER BY row_id");
$x=0;
while ($row = mysql_fetch_array($select)) {
$x++;
echo " <tr>";
echo " <td class='td1' scope='row'>$x</td>";
echo " <td class='td2'>".$row['name']."</
td>";
echo " <td class='td3'>$address</td>";
echo " <td class='td4'>$city</td>";
echo " <td class='td5'>$state</td>";
echo " <td class='td6'>".$row['guests']."
Guests<br>".$row['seating']." in Section A <br>".$row['comments']."</
td>";
echo " </tr>";
}
echo " </table>";
echo "</div>";

We want to refresh the DIV (innerb) without refreshing the page, and
if we do not have to use ajax either.

So, the user selected the date ($pdate) from the combobox, it is used
to query the database, and the DIV is refreshed. I know this can be
done, but it is just a matter of finding the code or something
similar......

Thanks,

John
From: SAM on 5 May 2008 18:46
Mtek a �crit :
> Hi,
>
> This is the content of my DIV now:

no, that is the code given to the server
we need the code received by the browser

>
> echo " <div class='innerb'>";
(snip)
> echo "</div>";
>
> We want to refresh the DIV (innerb) without refreshing the page, and
> if we do not have to use ajax either.

you'll certainly need Ajax
or to send the form and get-it back

> So, the user selected the date ($pdate) from the combobox,

what is a "combobox" ?
where it is ?

> I know this can be
> done, but it is just a matter of finding the code or something
> similar......

<http://developer.mozilla.org/en/docs/AJAX>

--
sm
From: Mtek on 6 May 2008 00:37
On May 5, 5:46 pm, SAM <stephanemoriaux.NoAd...(a)wanadoo.fr.invalid>
wrote:
> Mtek a écrit :
>
> > Hi,
>
> > This is the content of my DIV now:
>
> no, that is the code given to the server
> we need the code received by the browser
>
>
>
>
>
> >               echo "      <div class='innerb'>";
> (snip)
> >               echo "</div>";
>
> > We want to refresh the DIV (innerb) without refreshing the page, and
> > if we do not have to use ajax either.
>
> you'll certainly need Ajax
> or to send the form and get-it back
>
> > So, the user selected the date ($pdate) from the combobox,
>
> what is a "combobox" ?
> where it is ?
>
> > I know this can be
> > done, but it is just a matter of finding the code or something
> > similar......
>
> <http://developer.mozilla.org/en/docs/AJAX>
>
> --
> sm


The combo box is in another part of the screen. The page is rather
large. It is not a form. It just has one combo box, and once the
user selects an item, I want the script to get the results from MySQL
and display them, without having to redraw the entire page.......

I know this can be done, I just do not know how.....

John.
From: Tom Cole on 6 May 2008 07:56
On May 6, 12:37 am, Mtek <m...(a)mtekusa.com> wrote:
> On May 5, 5:46 pm, SAM <stephanemoriaux.NoAd...(a)wanadoo.fr.invalid>
> wrote:
>
>
>
>
>
> > Mtek a écrit :
>
> > > Hi,
>
> > > This is the content of my DIV now:
>
> > no, that is the code given to the server
> > we need the code received by the browser
>
> > >               echo "      <div class='innerb'>";
> > (snip)
> > >               echo "</div>";
>
> > > We want to refresh the DIV (innerb) without refreshing the page, and
> > > if we do not have to use ajax either.
>
> > you'll certainly need Ajax
> > or to send the form and get-it back
>
> > > So, the user selected the date ($pdate) from the combobox,
>
> > what is a "combobox" ?
> > where it is ?
>
> > > I know this can be
> > > done, but it is just a matter of finding the code or something
> > > similar......
>
> > <http://developer.mozilla.org/en/docs/AJAX>
>
> > --
> > sm
>
> The combo box is in another part of the screen.  The page is rather
> large.  It is not a form.  It just has one combo box, and once the
> user selects an item, I want the script to get the results from MySQL
> and display them, without having to redraw the entire page.......
>
> I know this can be done, I just do not know how.....
>
> John.- Hide quoted text -
>
> - Show quoted text -

As mentioned in a previous post you have only two options if you do
not want a total page refresh...

1). To bring over not only the options, but also the results of each
option, and generate the entire page at once storing the results in a
series of hidden div elements. Then when they select an option make
that matching div visible. or...

2). Query the server when an option is selected. If this is your
choice then you must either use XMLHttpRequest and process the results
in your callback handler or put your combo box in a form and set the
target of the form to a (i)Frame.

Unless you are dealing with a script that is being called from a
different domain I would use XMLHttpRequest as any modern browser that
can do one, can also do the other as they both require Javascript and
all modern browsers support XMLHttpRequest in one form or another.

If you choose method 2 (the (i)Frame method) your return code can
include javascript that calls javascript methods in the parent frame.

You're not going to be able to include PHP code inside your HTML and
have it magically generate results for you on the client side.

HTH.
From: Mtek on 6 May 2008 08:42
On May 6, 6:56 am, Tom Cole <tco...(a)gmail.com> wrote:
> On May 6, 12:37 am, Mtek <m...(a)mtekusa.com> wrote:
>
>
>
> > On May 5, 5:46 pm, SAM <stephanemoriaux.NoAd...(a)wanadoo.fr.invalid>
> > wrote:
>
> > > Mtek a écrit :
>
> > > > Hi,
>
> > > > This is the content of my DIV now:
>
> > > no, that is the code given to the server
> > > we need the code received by the browser
>
> > > > echo " <div class='innerb'>";
> > > (snip)
> > > > echo "</div>";
>
> > > > We want to refresh the DIV (innerb) without refreshing the page, and
> > > > if we do not have to use ajax either.
>
> > > you'll certainly need Ajax
> > > or to send the form and get-it back
>
> > > > So, the user selected the date ($pdate) from the combobox,
>
> > > what is a "combobox" ?
> > > where it is ?
>
> > > > I know this can be
> > > > done, but it is just a matter of finding the code or something
> > > > similar......
>
> > > <http://developer.mozilla.org/en/docs/AJAX>
>
> > > --
> > > sm
>
> > The combo box is in another part of the screen. The page is rather
> > large. It is not a form. It just has one combo box, and once the
> > user selects an item, I want the script to get the results from MySQL
> > and display them, without having to redraw the entire page.......
>
> > I know this can be done, I just do not know how.....
>
> > John.- Hide quoted text -
>
> > - Show quoted text -
>
> As mentioned in a previous post you have only two options if you do
> not want a total page refresh...
>
> 1). To bring over not only the options, but also the results of each
> option, and generate the entire page at once storing the results in a
> series of hidden div elements. Then when they select an option make
> that matching div visible. or...
>
> 2). Query the server when an option is selected. If this is your
> choice then you must either use XMLHttpRequest and process the results
> in your callback handler or put your combo box in a form and set the
> target of the form to a (i)Frame.
>
> Unless you are dealing with a script that is being called from a
> different domain I would use XMLHttpRequest as any modern browser that
> can do one, can also do the other as they both require Javascript and
> all modern browsers support XMLHttpRequest in one form or another.
>
> If you choose method 2 (the (i)Frame method) your return code can
> include javascript that calls javascript methods in the parent frame.
>
> You're not going to be able to include PHP code inside your HTML and
> have it magically generate results for you on the client side.
>
> HTH.

No, cannot include PHP on the client side, but how about calling a PHP
routine on the server and returning the results? I've seen simple
examples of this, though mine is a bit more complex......

John.
 |  Next  |  Last
Pages: 1 2
Prev: eBay-style drop down menu
Next: Why do this? <SCRIPT TYPE="text/javascript"