How to show the available time on the day which i select??

52 New Member

Hi ,
I stuck in my project as i face a problem
How to show the available time of the venue when i select the day??
Need to connect to the database to find out the available time of the venue on that day i select???

The selection the day

Expand|Select|Wrap|Line Numbers

 
?>

<select name="p_day" id="p_day">

  <option <?php if(isset($_COOKIE['Day']) && $_COOKIE['Day']=="Monday") echo "selected"; ?> value="Monday">Monday</option>

  <option <?php if(isset($_COOKIE['Day']) && $_COOKIE['Day']=="Tuesday") echo "selected"; ?> value="Tuesday">Tuesday</option>

  <option <?php if(isset($_COOKIE['Day']) && $_COOKIE['Day']=="Wednesday") echo "selected"; ?> value="Wednesday">Wednesday</option>

  <option <?php if(isset($_COOKIE['Day']) && $_COOKIE['Day']=="Thursday") echo "selected"; ?> value="Thursday">Thursday</option>

  <option <?php if(isset($_COOKIE['Day']) && $_COOKIE['Day']=="Friday") echo "selected"; ?> value="Friday">Friday</option>

  <option <?php if(isset($_COOKIE['Day']) && $_COOKIE['Day']=="Saturday") echo "selected"; ?> value="Saturday">Saturday</option>

</select>

This is the selection of the time which i think need to change all the code here!

Expand|Select|Wrap|Line Numbers

 
?>

<select name="p_time" id="select7">

  <option <?php if(isset($_COOKIE['Time']) && $_COOKIE['Time']=="0800") echo "selected"; ?> value="0800">0800</option>

  <option <?php if(isset($_COOKIE['Time']) && $_COOKIE['Time']=="0900") echo "selected"; ?> value="0900">0900</option>

  <option <?php if(isset($_COOKIE['Time']) && $_COOKIE['Time']=="1010") echo "selected"; ?> value="1010">1010</option>

  <option <?php if(isset($_COOKIE['Time']) && $_COOKIE['Time']=="1110") echo "selected"; ?> value="1110">1110</option>

  <option <?php if(isset($_COOKIE['Time']) && $_COOKIE['Time']=="1205") echo "selected"; ?> value="1205">1205</option>

  <option <?php if(isset($_COOKIE['Time']) && $_COOKIE['Time']=="1300") echo "selected"; ?> value="1300">1300</option>

  <option <?php if(isset($_COOKIE['Time']) && $_COOKIE['Time']=="1400") echo "selected"; ?> value="1400">1400</option>

  <option <?php if(isset($_COOKIE['Time']) && $_COOKIE['Time']=="1510") echo "selected"; ?> value="1510">1510</option>

  <option <?php if(isset($_COOKIE['Time']) && $_COOKIE['Time']=="1610") echo "selected"; ?> value="1610">1610</option>

  <option <?php if(isset($_COOKIE['Time']) && $_COOKIE['Time']=="1710") echo "selected"; ?> value="1710">1710</option>

</select>

This is the selection of the venue

Expand|Select|Wrap|Line Numbers

 
?>

<select name="p_venue">

<?php

do {  

?>

  <option 

  <?php if(isset($_COOKIE['Venue']) && $_COOKIE['Venue']==$row_VenueRS['venue']) echo "selected"; ?>

    value="<?php echo $row_VenueRS['venue']?>"><?php echo $row_VenueRS['venue']?>

  </option>

<?php

} while ($row_VenueRS = mysql_fetch_assoc($VenueRS));

  $rows = mysql_num_rows($VenueRS);

  if($rows > 0) {

  mysql_data_seek($VenueRS, 0);

  $row_VenueRS = mysql_fetch_assoc($VenueRS);

}

?>

</select>

Jun 27 '07 #1

Subscribe Reply

1794

chaos

New Member

As i doing timetable system whereby ppl can book the venue and it will update the system

this code might help u all understand how i check the check button work
[PHP]<input type="button" name="Button" value="Check" onClick="checkf acility(change_ timetable.p_tim e.value,change_ timetable.p_day .value,change_t imetable.p_venu e.value,change_ timetable.p_dur ation.value,'us er')">[/PHP]

This is checkfacility.p hp

Expand|Select|Wrap|Line Numbers

 
<body>

<?php $day= $_GET['day']; ?>

<?php $duration= $_GET['duration']; ?>

<?php $venue= $_GET['venue']; ?>

<?php $time= $_GET['time']; ?>

<?php $rights= $_GET['rights']; ?>
 
<?php     setcookie("Venue",$venue);

    setcookie("Day",$day);

    setcookie("Time",$time);

    setcookie("Duration",$duration);

?>
 
<?php
 
switch($time)

{

    case '0800': $hourset = 0; break;

    case '0900': $hourset = 1; break;

    case '1010': $hourset = 2; break;

    case '1110': $hourset = 3; break;

    case '1205': $hourset = 4; break;

    case '1300': $hourset = 5; break;

    case '1400': $hourset = 6; break;

    case '1510': $hourset = 7; break;

    case '1610': $hourset = 8; break;

    case '1710': $hourset = 9; break;

}
 
switch($day)

{

    case 'Monday':        //timeslot is from 0 to 9

                        switch($hourset)

                        {

                            case 0:    $slot=0; break;

                            case 1: $slot=1; break;

                            case 2: $slot=2; break;

                            case 3: $slot=3; break;

                            case 4: $slot=4; break;

                            case 5: $slot=5; break;

                            case 6: $slot=6; break;

                            case 7: $slot=7; break;

                            case 8: $slot=8; break;

                            case 9: $slot=9; break;

                        }

                        break;
 
    case 'Tuesday':        //time slot is from 10-19

                        switch($hourset)

                        {

                            case 0:    $slot=10; break;

                            case 1: $slot=11; break;

                            case 2: $slot=12; break;

                            case 3: $slot=13; break;

                            case 4: $slot=14; break;

                            case 5: $slot=15; break;

                            case 6: $slot=16; break;

                            case 7: $slot=17; break;

                            case 8: $slot=18; break;

                            case 9: $slot=19; break;

                        }

                        break;
 
    case 'Wednesday':    //time slot is from 20-29

                        switch($hourset)

                        {

                            case 0:    $slot=20; break;

                            case 1: $slot=21; break;

                            case 2: $slot=22; break;

                            case 3: $slot=23; break;

                            case 4: $slot=24; break;

                            case 5: $slot=25; break;

                            case 6: $slot=26; break;

                            case 7: $slot=27; break;

                            case 8: $slot=28; break;

                            case 9: $slot=29; break;

                        }

                        break;    
 
    case 'Thursday':    // time slot is 30-39

                        switch($hourset)

                        {

                            case 0:    $slot=30; break;

                            case 1: $slot=31; break;

                            case 2: $slot=32; break;

                            case 3: $slot=33; break;

                            case 4: $slot=34; break;

                            case 5: $slot=35; break;

                            case 6: $slot=36; break;

                            case 7: $slot=37; break;

                            case 8: $slot=38; break;

                            case 9: $slot=39; break;

                        }

                        break;
 
    case 'Friday':        // time slot is 40-49

                        switch($hourset)

                        {

                            case 0:    $slot=40; break;

                            case 1: $slot=41; break;

                            case 2: $slot=42; break;

                            case 3: $slot=43; break;

                            case 4: $slot=44; break;

                            case 5: $slot=45; break;

                            case 6: $slot=46; break;

                            case 7: $slot=47; break;

                            case 8: $slot=48; break;

                            case 9: $slot=49; break;

                        }

                        break;
 
    case 'Saturday':    // time slot is 50-54

                        switch($hourset)

                        {

                            case 0:    $slot=50; break;

                            case 1: $slot=51; break;

                            case 2: $slot=52; break;

                            case 3: $slot=53; break;

                            case 4: $slot=54; break;

                            case 5: $slot=55; break;

                            case 6: $slot=56; break;

                            case 7: $slot=57; break;

                            case 8: $slot=58; break;

                            case 9: $slot=59; break;

                        }

                        break;

}

?>
 
<?php

echo $time;

echo "<BR>Time slot is ".$slot."<BR>";
 
mysql_select_db($database_conn, $conn);

$query_Recordset2 = "SELECT * FROM facilities WHERE venue='$venue'";

$Recordset2 = mysql_query($query_Recordset2, $conn) or die(mysql_error());

$row_Recordset2 = mysql_fetch_assoc($Recordset2);

$totalRows_Recordset2 = mysql_num_rows($Recordset2);
 
$query_RS3 = "SELECT * FROM staff WHERE staff_1 ='".$_SESSION['MM_Username']."'";

echo $query_RS3;

$RS3 = mysql_query($query_RS3, $conn) or die(mysql_error());

$row_RS3= mysql_fetch_assoc($RS3);

$totalRows_RS3 = mysql_num_rows($RS3);
 
$canBook=true;
 
for($i=0;$i<$duration;$i++)

{

$facilityAvailable =$row_Recordset2["_".($slot+$i)];

echo "_".($slot+$i)."=".$facilityAvailable."<BR>";
 
if($facilityAvailable!=0)

    $canBook=false;

    for($i=0;$i<$duration;$i++)

    {

        $ModuleAtProposedSlot=$row_RS3["_".($slot+$i)];
 
        if($ModuleAtProposedSlot!=0)

            $canBook=false;

    }

}
 
    if($canBook)

    {

        if ($rights =="admin")

        {

            echo "<script>alert('Change Request OK. Proceed to Approve')

        window.opener.location=window.opener.location+'&&showSubmit=true'

            </script>";

        }

        else

        {

            echo "<script>alert('Available for booking')

        window.opener.location=window.opener.location+'&&showSubmit=true'

            </script>";

        }    

    }

    else

    {    

        if ($rights =="admin")

        {    

            echo "<script>alert('Facility not available!')

                window.opener.location=window.opener.location+'&&showSubmit=false'

            </script>";

        }
 
        else

        {    

            echo "<script>alert('This timeslot is not available!')

                window.opener.location=window.opener.location+'&&showSubmit=false'

            </script>";

        }
 
        unset($_COOKIE['Venue']);

    }

    echo "<script>window.close()</script>";

?>

[Please use CODE tags when posting source code. Thanks! --pbmods]

Jun 27 '07 #2

chaos

New Member

Someone Pls Help Me
THX

Jun 28 '07 #3

chaos

New Member

anyone know how to solve the problem

Jun 29 '07 #4

chaos

New Member

Help Help Help !!!
Anyone Pls Help Me!

Jul 1 '07 #5

kovik

1,044

Recognized Expert Top Contributor

No one will help you because:

1) You haven't asked much of a question other than "help me!"
2) You aren't even trying... I help those who help themselves.
3) You've posted too much code. No one wants to read it all, and most of it doesn't matter.
4) You're spamming the board with bumps.

Here's what you need to do:

1) Think logically about the problem.
2) Don't expect PHP to be magic.
3) Find out *exactly* where the problem is occurring
4) THEN ask questions.

Now, please stop spamming. I haven't read your code because it's obvious that you're hardly trying... Just looking for hand-outs.

Jul 1 '07 #6

Similar topics

3463

Slide show: this should be fairly straightforward - a what language to use question

by: Al Davis | last post by:

Note: I tried cross-posting this message to several newsgoups, including comp.lang.perl.misc, c.l.p.moderated, comp.infosystems.www.authoring.cgi, comp.lang.javascript and comp.lang.php. Nothing appeared on my news server, so I'm trying again - this time posting a separate copy of the message to each group. I'm thinking this should be...

PHP

9213

Show complete select box entry

by: Jens Riedel | last post by:

Hi, I use a select box with a fix width (via stylesheet). So some of the entries are cut on the right side if they're too long. Is there a way to display them complete like a tool tip on a mouseover? Thanks, Jens

Javascript

3855

Opera 7.23 doesn't show me inner tables

by: Mariusz Jedrzejewski | last post by:

Hi, I'll be very grateful if somebody can explain me why my Opera 7.23 (runing under linux) doesn't show me inner tables. Using below code I can see only "inner table 1". There is no problem with other browsers (I checked it under Konqueror). Thank you in advance for your help. Regards. /Mariusz <HTML>

HTML / CSS

1453

show details of first record

by: Bryan Harrington | last post by:

I have a list of requests that I'm displaying. The client wants to be able to display the details of the FIRST request as the page loads. Right now, as I loop through the recordset, I'm checking the querystring for "rid", and if rid = "" then I do a response.redirect to the page adding the rid value to the querystring from the recordset. ...

ASP / Active Server Pages

2749

show/hide used on checkboxes not working on IE6

by: sergio | last post by:

Hi all, I have created the following script that will show/hide a menu based on checkboxes. It works fine in Opera but not on IE6! Does anybody knows a workaround this problem? Thanks for your response. Sergio ------------------------------------------------ <script language="JavaScript" type="text/javascript">

Javascript

2562

show rows in table

by: WindAndWaves | last post by:

Hi Gurus I was wondering if you can send me in the right direction: I have a table with about 300 rows. I want to make all of them invisible and when a user enters a code in a form then make selected ones visible. At the moment, I am doing it as follows: www.corstorphinehouse.com/d/avail.html

Javascript

1443

show only last item per ID

by: psvhans | last post by:

Hi I have 3 colums: 'Task' , 'Case ID' and ' Time' And i would like to have an overwiew of the last task (the taks with de latest time) of every Case ID. Example Task Case ID Time A 1 12:00

Microsoft Access / VBA

2427

error in me.show()

by: ed | last post by:

Hi I can't seem to make the Me.Show() work My code is dim dlgresult as dialogresul dlgresult=me.show( The message is : "expression does not produce a value

Visual Basic .NET

130

6490

Why does 28.08 show up as 28.080000000000002 in DataGridView

by: Daniel Manes | last post by:

I'm baffled. I have a column in a SQL Server Express database called "Longitude," which is a float. When I view the table in a DataGridView, some of the numbers, which only have two decimal places in the database show up with *15* decimal places and are ever so slightly off (in the example in the subject line, by about 2E-15). I'm not doing...

.NET Framework

7915

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...

General

8339

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...

Online Marketing

7967

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...

Windows Server

8220

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...

General

6619

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...

Career Advice

3840

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...

Networking - Hardware / Configuration

3872

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2347

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1185

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

General