Rrestaurant delivery menu choices - how to handle?

Rrestaurant delivery menu choices - how to handle?

am 12.03.2006 10:07:27 von haggis

Our restaurant is developing a Delivery service and I'm wondering
how to handle the choices the customers will make on-line.
Stripped of the cosmetics, this is the display of the whole menu
(which is compiled from the output of several different menus -
"Starters", "Main Courses", "Salads", etc).

The restaurant is developing a Delivery service and I'm wondering
how to handle the choices the on-line customers will make.
This bare-bones display of the choices works fine -

$TableName="menus";
$Query="SELECT * FROM $TableName order by menu_id";
$Result=mysql_db_query ($DBName, $Query, $Link);
while ($Row=mysql_fetch_array ($Result))
{
$list_of_menus[]=$Row[menu_name];
}
$count=count($list_of_menus);
$count=$count-1;
$n="0";
while ($n<=$count)
{
print("

");
print("");
$TableName=$list_of_menus[$n];
$Query="SELECT * FROM $TableName order by dish_id";
$Result=mysql_db_query ($DBName, $Query, $Link);
while ($Row=mysql_fetch_array ($Result))
{
print("");
}
$++;
}



All that works just fine, unrolling the 80-odd dishes in our menu
down the screen, but... how do I handle the output? I'm guessing
it would be best to write each set of customer choices to a file,
its filename being composed of the customer surname, but how do I
handle the blank items? Are they, indeed, passed by the form?

(Guess who's never used check-boxes before? Go on, guess - you'll
never guess...)

TIA.

All that works just fine, unrolling the 80-odd dishes in our menu
down the screen, but... how do I handle the output? I'm guessing
it would be best to write each set of customer choices to a file,
with the filename being the customer name, but how do I handle the
blank items? Are they, indeed, passed by the form?
And how do I handle multiple items (several people ordering
different dishes from the "Main Courses", for instance)?

(Guess who's never used check-boxes before? Go on, guess - you'll
never guess...)

TIA.
Remove _your_teeth_ to reply.

Re: Rrestaurant delivery menu choices - how to handle?

am 13.03.2006 19:10:18 von Simon Bridgewater

Why not use an in memory table and with each choice placed in the table and
referenced via a session_id/user_id.

What do you mean by blanks?
simon
wrote in message
news:i3o712lf9h5ibm6e50i8tb8of3hm75n7j1@4ax.com...
> Our restaurant is developing a Delivery service and I'm wondering
> how to handle the choices the customers will make on-line.
> Stripped of the cosmetics, this is the display of the whole menu
> (which is compiled from the output of several different menus -
> "Starters", "Main Courses", "Salads", etc).
>
> The restaurant is developing a Delivery service and I'm wondering
> how to handle the choices the on-line customers will make.
> This bare-bones display of the choices works fine -
>
> $TableName="menus";
> $Query="SELECT * FROM $TableName order by menu_id";
> $Result=mysql_db_query ($DBName, $Query, $Link);
> while ($Row=mysql_fetch_array ($Result))
> {
> $list_of_menus[]=$Row[menu_name];
> }
> $count=count($list_of_menus);
> $count=$count-1;
> $n="0";
> while ($n<=$count)
> {
> print("");
> print("

$Row[dish]$Row[cost] TYPE=\"checkbox\" NAME=\"$list_of_menus[$]\" VALUE=\"$Row[dish]\">
");
> $TableName=$list_of_menus[$n];
> $Query="SELECT * FROM $TableName order by dish_id";
> $Result=mysql_db_query ($DBName, $Query, $Link);
> while ($Row=mysql_fetch_array ($Result))
> {
> print("");
> }
> $++;
> }
>
>
>
> All that works just fine, unrolling the 80-odd dishes in our menu
> down the screen, but... how do I handle the output? I'm guessing
> it would be best to write each set of customer choices to a file,
> its filename being composed of the customer surname, but how do I
> handle the blank items? Are they, indeed, passed by the form?
>
> (Guess who's never used check-boxes before? Go on, guess - you'll
> never guess...)
>
> TIA.
>
> All that works just fine, unrolling the 80-odd dishes in our menu
> down the screen, but... how do I handle the output? I'm guessing
> it would be best to write each set of customer choices to a file,
> with the filename being the customer name, but how do I handle the
> blank items? Are they, indeed, passed by the form?
> And how do I handle multiple items (several people ordering
> different dishes from the "Main Courses", for instance)?
>
> (Guess who's never used check-boxes before? Go on, guess - you'll
> never guess...)
>
> TIA.
> Remove _your_teeth_ to reply.

Re: Rrestaurant delivery menu choices - how to handle?

am 13.03.2006 20:45:57 von haggis

On Mon, 13 Mar 2006 18:10:18 GMT, "Simon"
wrote:

>>> wrote in message
>>>news:i3o712lf9h5ibm6e50i8tb8of3hm75n7j1@4ax.com...
>>>> Our restaurant is developing a Delivery service and I'm wondering
>>>> how to handle the choices the customers will make on-line.
>>>> Stripped of the cosmetics, this is the display of the whole menu
>>>> (which is compiled from the output of several different menus -
>>>> "Starters", "Main Courses", "Salads", etc).
>>>>
>>>> The restaurant is developing a Delivery service and I'm wondering
>>>> how to handle the choices the on-line customers will make.
>>>> This bare-bones display of the choices works fine -
>>>>
>>>> $TableName="menus";
>>>> $Query="SELECT * FROM $TableName order by menu_id";
>>>> $Result=mysql_db_query ($DBName, $Query, $Link);
>>>> while ($Row=mysql_fetch_array ($Result))
>>>> {
>>>> $list_of_menus[]=$Row[menu_name];
>>>> }
>>>> $count=count($list_of_menus);
>>>> $count=$count-1;
>>>> $n="0";
>>>> while ($n<=$count)
>>>> {
>>>> print("");
>>>> print("

$Row[dish]$Row[cost] > TYPE=\"checkbox\" NAME=\"$list_of_menus[$]\" VALUE=\"$Row[dish]\">
>
");
>>>> $TableName=$list_of_menus[$n];
>>>> $Query="SELECT * FROM $TableName order by dish_id";
>>>> $Result=mysql_db_query ($DBName, $Query, $Link);
>>>> while ($Row=mysql_fetch_array ($Result))
>>>> {
>>>> print("");
>>>> }
>>>> $++;
>>>> }
>>>>
>>>>
>>>>
>>>> All that works just fine, unrolling the 80-odd dishes in our menu
>>>> down the screen, but... how do I handle the output? I'm guessing
>>>> it would be best to write each set of customer choices to a file,
>>>> its filename being composed of the customer surname, but how do I
>>>> handle the blank items? Are they, indeed, passed by the form?
>>>>
>>>> (Guess who's never used check-boxes before? Go on, guess - you'll
>>>> never guess...)
>>>>
>>>> TIA.
>>>>
>>>> All that works just fine, unrolling the 80-odd dishes in our menu
>>>> down the screen, but... how do I handle the output? I'm guessing
>>>> it would be best to write each set of customer choices to a file,
>>>> with the filename being the customer name, but how do I handle the
>>>> blank items? Are they, indeed, passed by the form?
>>>> And how do I handle multiple items (several people ordering
>>>> different dishes from the "Main Courses", for instance)?
>>>>
>>>> (Guess who's never used check-boxes before? Go on, guess - you'll
>>>> never guess...)
>>>>
>>>> TIA.
>>>> Remove _your_teeth_ to reply.
>>>
>>>Why not use an in memory table and with each choice placed in the table and
>>>referenced via a session_id/user_id.
Sorry, I'm not very good at this - I don't understand what you
mean.
>>>
>>>What do you mean by blanks?
>>>simon

The input fields which are not used becos the visitor has chosen
something else from that menu.
Remove _your_teeth_ to reply.

$Row[dish]$Row[cost] >>>> TYPE=\"checkbox\" NAME=\"$list_of_menus[$]\" VALUE=\"$Row[dish]\">
>>>>