Learn VBA & Macros in 1 Week!

PHP - Calendar Changing

Full Excel VBA Course - Beginner to Expert

Calendar Changing	View Content

hello guys

i have a project with Georgian calendar but when i contact to the developer they tell me we not support any other calendar so you must do this alone or get help from local developer. as manager i need to have basic knowledge from what is under my control. so please guide me to how change Georgian to Persian (jalali) calendar. i done translating from en to per but the most problem is the calendar.

project address: https://drive.google.com/open?id=1eKestInuUiUJHotYltNuVsqRGnq4ujNN

thank you for your attention and your kind

best regards

Full Excel VBA Course - Beginner to Expert

Calendar Help!

Similar Tutorials

View Content

Hello there!

I've been at this for too long! I've got a normal calendar at the side of my website that works fine, however i would like one that shows the next 7 days starting at today. I have an image here that kind of shows what i want...

So it will show the next 7 days starting with today, and going into the next month if todays date is the 30th etc.

Could anybody please help me? :\

Calendar

Similar Tutorials

View Content

hi,

i have implemented a calendar in php and added contols to display the previous and next months. How will I enhance my code to add links to display the previous and next year calendars?

My code is as follows:
Code: [Select]
<?php
session_start();
$_SESSION['username'];
$_SESSION['unique_id'];
$username = $_SESSION['username'];
$unique_id = $_SESSION['unique_id'];
?>

<?php
    $host = "localhost";
    $user="";
    $password="";
    $db_name="";
    $tbl_name="";

    $con = mysql_connect("localhost","","");
    if (!$con)
      {
          die('Could not connect: ' . mysql_error());
      }
    mysql_select_db("$db_name", $con);

    // Now we need to define "A DAY", which will be used later in the script:
    define("ADAY", (60*60*24));

    // The rest of the script will stay the same until about line 82

    if ((!isset($_GET['month'])) || (!isset($_GET['year']))) {
        $nowArray = getdate();
        $month = $nowArray['mon'];  //mon - Numeric representation of a month
    $year = $nowArray['year'];
    } else {
        $month = $_GET['month'];
    $year = $_GET['year'];
    }
    $start = mktime(12,0,0,$month,1,$year);
    $firstDayArray = getdate($start);
    ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title><?php echo "Calendar: ".$firstDayArray['month']."" . $firstDayArray['year']; ?></title>
<link type="text/css" href="css/style_inner.css" rel="stylesheet" />
</head>

<body>
<form method="get" action="<?php echo $_SERVER['PHP_SELF']; ?>" style="padding-top:50px">
<?php
        /* "next month" control */
$next_month = '<a href="?month='.($month != 12 ? $month + 1 : 1).'&year='.($month != 12 ? $year : $year + 1).'" class="control" style="text-decoration:none; padding-left:50px;">Next Month  ></a>';

/* "previous month" control */
$previous_month = '<a href="?month='.($month != 1 ? $month - 1 : 12).'&year='.($month != 1 ? $year : $year - 1).'" class="control" style="text-decoration:none; padding-left:200px; padding-right:50px;"><  Previous Month</a>';

/*$next_year = '<a href="?year='.($year != 2050 ? $year + 1 : 1).'&year='.($year != 2050 ? $year : $year + 1).'" class="control" style="text-decoration:none; padding-left:10px;">Next Year  >></a>';

$previous_year = '<a href="?month='.($year != 2011 ? $year - 1 : 2050).'&year='.($year != 2011 ? $year : $year - 1).'" class="control" style="text-decoration:none; padding-left:150px;"><<  Previous Year</a>';

echo $previous_year;*/
echo $previous_month;
    ?>
<select name="month"><br/>
<?php
    $months = Array("January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December");

    for ($x=1; $x<=count($months); $x++){
        echo "<option value=\"$x\"";
    if ($x == $month){
            echo " selected";
        }
        echo ">".$months[$x-1]."</option>";
    }
    ?>
</select>
<select name="year">
<?php
    for ($x=2011; $x<=2050; $x++){
    echo "<option";
        if ($x == $year){
        echo " selected";
        }
        echo ">$x</option>";
    }
    ?>
</select>
<input type="submit" name="submit" value="Go!">
<?php
    echo $next_month;
    /*echo $next_year;*/
?>
</form>
<br />
<?php
    $days = Array("Sun", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat");
    echo "<table border=\"1\" style=\"padding-left:100px;\"><tr>\n";
    foreach ($days as $day) {
        echo "<td style=\"background-color: #000000; width: 100px\" align=\"center\">
              <strong style=\"color:#FFFFFF;\">$day</strong></td>\n";
    }

    for ($count=0; $count < (6*7); $count++) {
        $dayArray = getdate($start);
        if (($count % 7) == 0) {
        if ($dayArray["mon"] != $month) {
            break;
        } else {
                echo "</tr><tr>\n";
        }
        }
        if ($count < $firstDayArray["wday"] || $dayArray["mon"] != $month) { //wday - Numeric representation of the day of the week
        echo "<td height=\"110px\"> </td>\n";
        } else { //mday - Numeric representation of the day of the month
            $chkEvent_sql = "SELECT event_title, event_shortdesc FROM calendar_events WHERE month(event_start) = '".$month."' AND dayofmonth(event_start) = '".$dayArray["mday"]."' AND year(event_start) = '".$year."' ORDER BY event_start";
       $chkEvent_res = mysql_query($chkEvent_sql, $con) or die(mysql_error($con));

        if (mysql_num_rows($chkEvent_res) > 0) {
            $event_title = "<br/>";
            while ($ev = mysql_fetch_array($chkEvent_res)) {
                    $event_title .= "<font color=\"#006600\">" . stripslashes($ev["event_title"])."</font><br/>";
                    //$event_shortdesc .= stripslashes($ev["event_shortdesc"])."<br/>";
            }
                mysql_free_result($chkEvent_res);
            } else {
            $event_title = "";
            $event_shortdesc = "";
            }

        echo "<td height=\"110px\" style=\"color : #0000CC;\">".$dayArray["mday"]."<a href=\"event.php?m=".$month."&d=".$dayArray["mday"]."&y=".$year."\" style=\"text-decoration:none;\"><img src=\"images/Add Event.jpg\" alt=\"Add Event\" title=\"Add Event\" height=\"20px\" width=\"20px\" style=\"padding-left:20px;\"/></a><br/>".$event_title."</td>\n";
         unset($event_title);

            $start += ADAY;
        }
    }
    echo "</tr></table>";
    mysql_close($con);
    ?>

</body>
</html>

Please help me out its urgent..

Thank you in advance...

Php Calendar Help

Similar Tutorials

View Content

Hello Guys,
My goal is to make a Php and SQL calendar. I started learning php and sql a while ago, and basically got distracted. I'm now back, with a new project in the unhelpful position of having forgotten most of what I had learnt!

I am making a project where I want to make a booking system. I have 3 rooms that are available to be booked Room 1, Room 2 and Room 3. I want to make a table that displays the current year in the top row, with the option to be able to click on a '<' or a '>' to change years. I want the same option for months and weeks. I think I am happy with how I would do this. The next bit is more tricky. I want a column for each of the days of the week. directly under this I want to display the correct date, under the correct day, starting with the current week we are on. for example it might look like this:

-------------------------------------------
| < 2012 > |
-------------------------------------------
| < March > |
-------------------------------------------
| < 2 > |
-------------------------------------------
|mon | tues | wed| thur | fri | sat | sun |
| 5th | 6th | 7th| 8th |9th |10th| 11th |
---------------------------------------------
Room 1 | yes | | | | | | |
----------------------------------------------
Room 2 | | | yes | | | | |
----------------------------------------------
Room 3 | | | | |yes | | |
----------------------------------------------

Although at the moment I'm struggling with the whole flippin' thing, the main issue is getting the correct dates to line up under the correct days of the week. I'm not asking for you to do this for me- but a bit of gentle help in this, and maybe some general advice in what I'm trying to achieve would be really useful!

Regards,

AJLX

Help With Php Calendar Please

Similar Tutorials

View Content

    Good Evening ! 
little help or a lot please ?

I have coded a calendar on my site and am now trying to input the data info from MySQL into the 
calendar by PHP for each corresponding date...the calendar code works but I cant figure out how to 
get the info that's submitted in to the specified/corresponding date in the calendar :/ but I can get 
it to the bottom of the page.

I've been at this 3 days and a million searches to find an example to follow but now I am at my wits 
end ! been about 15 years since I've done this. PLEASE help :) and thank you so much
The HTML is good I can add to it if needed but the problem area is the calendar portion and putting 
it all in the right place without an error or code issue.

I'm not sure how much more information i can provide. Like I said I am still trying to remember all 
of this stuff and trying to teach myself again and im not having much luck but i am a fast learner 
and 
can pickup by seeing how the code is written usually

Here is my code: or at least the PHP portion of it. I hope this helps.

<?php
/*MAKES THE CONNECTION*/
include 'config.php';
$conn = mysqli_connect($servername, $username, $password, $dbname);
// CHECK CONNECTION
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}
/*DRAWS CALENDAR*//
function draw_calendar($month,$year){

$calendar = '<table cellpadding="0" cellspacing="0" class="calendar">';

$headings = array('Sunday','Monday','Tuesday','Wednesday','Thursday','Friday','Saturday');
$calendar.= '<tr class="calendar-row"><td class="calendar-day-head">'.implode('</td><td 
class="calendar-day-head">',$headings).'</td></tr>';

$running_day = date('w',mktime(0,0,0,$month,1,$year));
$days_in_month = date('t',mktime(0,0,0,$month,1,$year));
$days_in_this_week = 1;
$day_counter = 0;
$dates_array = array();
$start_day = 

$calendar.= '<tr class="calendar-row">';

for($x = 0; $x < $running_day; $x++):
    $calendar.= '<td class="calendar-day-np"> </td>';
    $days_in_this_week++;
endfor;

for($list_day = 1; $list_day <= $days_in_month; $list_day++):
    $calendar.= '<td class="calendar-day">';
        /* add in the day number */
        $calendar.= '<div class="day-number">'.$list_day.'</div>';

        /** QUERY THE DATABASE FOR AN ENTRY FOR THIS DAY !!  IF MATCHES FOUND, PRINT THEM !! **/
        $sql = "SELECT * FROM $tablename WHERE $current_epoch BETWEEN $start_day AND $end_day";
        /** NEED TOQUERY THE DATABASE FOR AN ENTRY FOR THIS DAY !!  IF MATCHES FOUND, PRINT THEM !! 
**/
$calendar.= str_repeat('<p>'.$start_day.'</p>',2);

     $calendar.= '</td>';
    if($running_day == 6):
        $calendar.= '</tr>';
        if(($day_counter+1) != $days_in_month):
            $calendar.= '<tr class="calendar-row">';
        endif;
        $running_day = -1;
        $days_in_this_week = 0;
    endif;
    $days_in_this_week++; $running_day++; $day_counter++;
endfor;

if($days_in_this_week < 8):
    for($x = 1; $x <= (8 - $days_in_this_week); $x++):
        $calendar.= '<td class="calendar-day-np"> </td>';
    endfor;
endif;

/* final row */
$calendar.= '</tr>';

/* end the table */
$calendar.= '</table>';

return $calendar;
}
$sql = "SELECT id, name, phone, item, start_day, end_day, start_time, end_time FROM $tablename";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
echo $calendar. "id: " . $row["id"]. " - Name: " . $row["name"]. " - Phone: " . $row["phone"]. " - 
Item: " . $row["item"]. " - Start Day: " . $row["start_day"]. " - End Day:  " . $row["end_day"]. " - 
Start Time:  " . $row["start_time"]. " - End Time:  " . $row["end_time"]. "<br>";
}
} else {
echo "0 results";
}

	
	/*END OF SHOWINGCALENDAR_________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
*/	
	
	
$sql = "SELECT id, name, phone, item, start_day, end_day, start_time, end_time FROM $tablename";
$result = $conn->query($sql);
	
/*GETS THE RESULTS OF THE CALENDAR FROM DATABASE TABLE*/
if ($result->num_rows > 0) {
  // output data of each row
  while($row = $result->fetch_assoc()) {
    echo $calendar. "id: " . $row["id"]. " - Name: " . $row["name"]. " - Phone: " . $row["phone"]. " - Item: " . $row["item"]. " - Start Day: " . $row["start_day"]. " - End Day:  " . $row["end_day"]. " - Start Time:  " . $row["start_time"]. " - End Time:  " . $row["end_time"]. "<br>";
  }
} else {
  echo "0 results";
}

Edited January 18 by Isfun42ofus

Event Calendar

Similar Tutorials

View Content

Hi,

I am using the backbone.js and full calendar script in my website. However, on clicking OK in the popup to add events, no action is taking place. Actually the event should be displayed on that specific date on clicking OK. the cancel button is working fine. I am using the link
http://blog.shinetech.com/2011/08/05.../#comment-2245

Help me please.

Thank you in advance

Calendar Help Arrays

Similar Tutorials

View Content

Hi All,
I am writing a calendar code using Keith Devens PHP Calendar (version 2.3).
What I am trying to acheive is this on one of my database tables I have a list of properties I have 41 property lists and each one has 2 sections for rates each section is named accordingly "a" for Jan for the first rate and "ma" for Jan for the second rate and there is 31 for each ie: a1 to a31 and ma1 to ma31 accordingly.
At any given time there can be a rate in any one of these fields what I am trying to do is pull a 12 month view calendar on screen which show all these rates to the corresponding date on the calendar.
The problem im having is with Keith Devens day Array() as ive never been too good with arrays.
The code I have is pulling the data but only the first one it hits and I need to put them all into the array.
I have included the code if someone can help I would appreciate it.

<?php
# PHP Calendar (version 2.3), written by Keith Devens
# http://keithdevens.com/software/php_calendar
#  see example at http://keithdevens.com/weblog
# License: http://keithdevens.com/software/license

function generate_calendar($year, $month, $days = array(), $day_name_length = 3, $month_href = NULL, $first_day = 0, $pn = array()){
    $first_of_month = gmmktime(0,0,0,$month,1,$year);
    #remember that mktime will automatically correct if invalid dates are entered
    # for instance, mktime(0,0,0,12,32,1997) will be the date for Jan 1, 1998
    # this provides a built in "rounding" feature to generate_calendar()

    $day_names = array(); #generate all the day names according to the current locale
    for($n=0,$t=(3+$first_day)*86400; $n<7; $n++,$t+=86400) #January 4, 1970 was a Sunday
        $day_names[$n] = ucfirst(gmstrftime('%A',$t)); #%A means full textual day name

    list($month, $year, $month_name, $weekday) = explode(',',gmstrftime('%m,%Y,%B,%w',$first_of_month));
    $weekday = ($weekday + 7 - $first_day) % 7; #adjust for $first_day
    $title   = htmlentities(ucfirst($month_name)).' '.$year;  #note that some locales don't capitalize month and day names

    #Begin calendar. Uses a real <caption>. See http://diveintomark.org/archives/2002/07/03
    @list($p, $pl) = each($pn); @list($n, $nl) = each($pn); #previous and next links, if applicable
    if($p) $p = '<span class="calendar-prev">'.($pl ? '<a href="'.htmlspecialchars($pl).'">'.$p.'</a>' : $p).'</span> ';
    if($n) $n = ' <span class="calendar-next">'.($nl ? '<a href="'.htmlspecialchars($nl).'">'.$n.'</a>' : $n).'</span>';
    $calendar = '<table class="calendar" border="1">'."\n".
        '<caption class="calendar-month">'.$p.($month_href ? '<a href="'.htmlspecialchars($month_href).'">'.$title.'</a>' : $title).$n."</caption>\n<tr>";

    if($day_name_length){ #if the day names should be shown ($day_name_length > 0)
        #if day_name_length is >3, the full name of the day will be printed
        foreach($day_names as $d)
            $calendar .= '<th abbr="'.htmlentities($d).'">'.htmlentities($day_name_length < 4 ? substr($d,0,$day_name_length) : $d).'</th>';
        $calendar .= "</tr>\n<tr>";
    }

    if($weekday > 0) $calendar .= '<td colspan="'.$weekday.'"> </td>'; #initial 'empty' days
    for($day=1,$days_in_month=gmdate('t',$first_of_month); $day<=$days_in_month; $day++,$weekday++){
        if($weekday == 7){
            $weekday   = 0; #start a new week
            $calendar .= "</tr>\n<tr>";
        }
        if(isset($days[$day]) and is_array($days[$day])){
            @list($link, $content2) = $days[$day];
            $content  = $day;
            $calendar .= '<td>'.
                ($link ? '<a href="'.htmlspecialchars($link).'">'.$content.'</a>' : $content).$content2.'</td>';
        }
        else $calendar .= "<td>$day</td>";
    }
    if($weekday != 7) $calendar .= '<td colspan="'.(7-$weekday).'"> </td>'; #remaining "empty" days

    return $calendar."</tr>\n</table>\n";
}

function set($month, $year)
{

$days = array();

$kez = 1;

$bef = 31;

while($kez <= $bef)

{

$k2 = $kez;

$host="localhost"; // Host name
$username="root"; // Mysql username
$password=""; // Mysql password
mysql_connect("$host", "$username", "$password")or die("cannot connect");
if ($month == 1){$m = 'a'; $ma = 'ma';}
if ($month == 2){$m = 'b'; $ma = 'mb';}
if ($month == 3){$m = 'c'; $ma = 'mc';}
if ($month == 4){$m = 'd'; $ma = 'md';}
if ($month == 5){$m = 'e'; $ma = 'me';}
if ($month == 6){$m = 'f'; $ma = 'mf';}
if ($month == 7){$m = 'g'; $ma = 'mg';}
if ($month == 8){$m = 'h'; $ma = 'mh';}
if ($month == 9){$m = 'i'; $ma = 'mi';}
if ($month == 10){$m = 'j'; $ma = 'mj';}
if ($month == 11){$m = 'k'; $ma = 'mk';}
if ($month == 12){$m = 'l'; $ma = 'ml';}
$sql = "SELECT * FROM db213585521.property_list WHERE $m$k2 > 0 ";
$q = @mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_array($q);

$sql2 = "SELECT * FROM db213585521.property_list WHERE $ma$k2 > 0 ";
$q2 = @mysql_query($sql2) or die(mysql_error());
$row2 = mysql_fetch_array($q2);

if ($row[$m.$k2] > 0 || $row[$ma.$k2] > 0) {
if ($row[$m.$k2] > 0){

$code = $row['var'].'<br>£'.$row[$m.$k2].'<br>';

}else{$code = '';}
if ($row2[$ma.$k2] > 0){$code2 = $row2['var'].'<br>£'.$row2[$ma.$k2].'<br>';}else{$code2 ='';}
if($k2 != 0) $days[$k2] = array('', $code.$code2);
}

$kez++;

}

setlocale(LC_TIME, 'en_GB');
echo generate_calendar($year, $month, $days, 3, NULL);
}
?>
<table style="margin: auto">

<tr>

    <?php for($month=1; $month<=12; $month++){ ?>

        <td style="vertical-align: top">

            <?php set($month, date('Y')); ?>

        </td>

        <?php if($month%4 == 0 and $month<12){ ?>

            </tr><tr>

        <?php } ?>

    <?php } ?>

</tr>

</table>

Help With Php Calendar Display

Similar Tutorials

View Content

I'm trying to help someone out with their website (which is entirely in PHP) and I've come across a problem I can't seem to figure out.

On the site is a php calendar that should display as so:

However, sometimes for no apparent reason the calendar appears as so:

I cannot seem to determine what is causing this to display incorrectly. It just started happening for no discernible reason.

Anyone have any idea where I should start looking to find the issue? It is linked to a MySQL database that is somewhat wonky, could that be the issue?

Thanks for any advice you guys can give me.

Php Sql Calendar Add Events

Similar Tutorials

View Content

I am working on a small project, creating a calendar based booking system which includes the following features: 1) A color coded key for Booked days, Available, Partly Booked, Off Days 2) Clickable days which open up a form with available time slots 3) When time slots selected another form which allows the user to enter details about the event and then book the day I am using php, sql to complete the project. I am aware that there are scripts available online but i want to do this from scratch. Stuck On
The code below is for a php calendar, above is what i need to achieve. Please can someone help me on how to complete this.

<?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;
}
?>

<table width="400" border="5" align="center">
<tr align="center">
<td bgcolor="#999999" style="color:#FFFFFF">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<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>
<td align="center">
<table width="100%" border="2" cellpadding="2" cellspacing="2">
<tr align="center">
<td colspan="7" bgcolor="#999999" style="color:#FFFFFF">
<strong> <?php echo $monthNames[$cMonth-1].' '.$cYear; ?> </strong>
</td>
</tr>
<tr>
<td align="center" bgcolor="#999999" style="color:#FFFFFF"><strong>S</strong></td>
<td align="center" bgcolor="#999999" style="color:#FFFFFF"><strong>M</strong></td>
<td align="center" bgcolor="#999999" style="color:#FFFFFF"><strong>T</strong></td>
<td align="center" bgcolor="#999999" style="color:#FFFFFF"><strong>W</strong></td>
<td align="center" bgcolor="#999999" style="color:#FFFFFF"><strong>T</strong></td>
<td align="center" bgcolor="#999999" style="color:#FFFFFF"><strong>F</strong></td>
<td align="center" bgcolor="#999999" style="color:#FFFFFF"><strong>S</strong></td>
</tr>


<?php 
$timestamp = mktime(0,0,0,$cMonth,1,$cYear);
$maxday = date("t",$timestamp);
$thismonth = getdate ($timestamp);
$startday = $thismonth['wday'];
for ($i=0; $i<($maxday+$startday); $i++) {
    if(($i % 7) == 0 ) echo "<tr> ";
    if($i < $startday) echo "<td></td> ";
    else echo "<td align='center' valign='middle' height='20px'>". ($i - $startday + 1) . "</td> ";
    if(($i % 7) == 6 ) echo "</tr> ";
}
?>
</table>
</td>
</tr>
</table>