Issue with triggering query on a clickable date

hiphop · April 22, 2010

Hi All,

I am new to Php/mysql and was working on a calendar time slot application. So far I have done calender & table (MYSQL DB) creation.

I would really appreciate if someone could help on solving issue below:

------when I click a date it will trigger a query, pull some data from db and display it on the same page.-----

Thank you in advance for your help!

//Clickable Calendar Code

html>

<head>

<title>Reservation Request</title>

</head>

<body>

<?php

$monthNames = Array("January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December");

?>

<?php

if (!isset($_REQUEST["month"])) $_REQUEST["month"] = date("n");

if (!isset($_REQUEST["year"])) $_REQUEST["year"] = date("Y");

?>

<?php

$cMonth = $_REQUEST["month"];

$cYear = $_REQUEST["year"];

$prev_year = $cYear;

$next_year = $cYear;

$prev_month = $cMonth-1;

$next_month = $cMonth+1;

if ($prev_month == 0 ) {

$prev_month = 12;

$prev_year = $cYear - 1;

}

if ($next_month == 13 ) {

$next_month = 1;

$next_year = $cYear + 1;

}

?>

<tr>

<td width="50%" align="left"> <a href="<?php echo $_SERVER["PHP_SELF"] . "?month=". $prev_month . "&year=" . $prev_year; ?>" style="color:#FFFFFF">Previous</a></td>

<td width="50%" align="right"><a href="<?php echo $_SERVER["PHP_SELF"] . "?month=". $next_month . "&year=" . $next_year; ?>" style="color:#FFFFFF">Next</a> </td>

</tr>

</table>

</td>

</tr>

<tr>

</tr>

<tr>

</tr>

<?php

$timestamp = mktime(0,0,0,$cMonth,1,$cYear);

$maxday = date("t",$timestamp);

$thismonth = getdate ($timestamp);

$startday = $thismonth['wday'];

$newdate = date('Y-m-j',$timestamp);

$newdate = strtotime ( '-1 day' , strtotime ( $newdate ) ) ;

$newdate = date('Y-m-j',$newdate);

for ($i=0; $i<($maxday+$startday); $i++) {

if(($i % 7) == 0 ) echo "<tr>\n";

if($i < $startday) echo "<td></td>\n";

else {

$newdate = strtotime ( '+1 day' , strtotime ( $newdate ) ) ;

$newdate = date ( 'Y-m-j' , $newdate );

echo "<td align='center' valign='middle' style='height:20px'>";

//I need to update the line below when a date get selected it will run a query in db and post the aviable time slots

//for that day on this (Reservation Request) page

echo "<a href='".$newdate."'>".($i - $startday + 1) ."</a>";

echo "</td>\n";

}

if(($i % 7) == 6 ) echo "</tr>\n";

}

?>

</table>

</td>

</tr>

</table>

</body>

</html>

//db code

//DB related code

$db = mysql_connect("mysql", "Test", "test") or die(mysql_error());

//echo "Connected to mysqlL

";

mysql_select_db("Test" ) or die(mysql_error());

/*

//echo "Connected to Database";

$login = mysql_query("select * from tbuser) or die(mysql_error());

$login1 = mysql_fetch_array( $login );

// Print out the contents of the entry

while($login1 = mysql_fetch_array($login1)){

echo $login1['username']. " - ". $login1['password'];

echo "

";

}

//line that I think need to be udated

echo "<a href='".$newdate."'>".($i - $startday + 1) ."</a>";

ChemicalBliss · April 22, 2010

What query is it?

Because the functionality you want would require either reloading the page, or using Javascript to communicate in real-time with php (AJAX).

Maybe you can call the query and save the information in a hidden div, then when a user clicks the date the div is shown. (I assume you want to pull the current events for the clicked date).

Either pull all the events, and hide them all in divs, or if it gets to the point where your page is taking too long to load you'll have to go AJAX.

-cb-

hiphop · April 22, 2010

The query is just an sample showing that I am able to connect to the db.

Is there any sample code that I can use which will trigger query and get data when click on a date?

Thanks!

Sign In

Issue with triggering query on a clickable date

Recommended Posts

hiphop

Link to comment

Share on other sites

ChemicalBliss

Link to comment

Share on other sites

hiphop

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information