PHP - Weekly Event?

This topic has been moved to PHP Applications.

http://www.phpfreaks.com/forums/index.php?topic=330163.0

I have a listener which executes a HTTP request to a remote API before the User entity is persisted and uses the response to set one of the entity's properties.  It will also listen for update and remove and will make the appropriate HTTP request to the API but will not modify the entity.  All works as desired... Almost.  If when persisting the entity, I have some error, the remote API and my application become out of sync.  I wish to change my application to perform a second call to the API if an error occurs and reverse the previous call.  My thoughts on how to implement a

Place a try/catch block when executing the query.  Don't like this approach. Add an ExceptionListener which somehow retrieves the entity and makes the applicable changes.  Maybe part of the solution, but too complicated to be the full solution. When adding, updating, or deleting a user from the remote API under UserListener's three methods, adding a callback which gets executed upon a PDOException.  I think this is the best approach and expanded my thoughts below.

 

<?php

namespace App\EventListener;

use Doctrine\Persistence\Event\LifecycleEventArgs;
use App\Service\HelpDeskClient;
use App\Entity\AbstractUser;

final class UserListner
{
    private $helpDeskClient;

    public function __construct(HelpDeskClient $helpDeskClient)
    {
        $this->helpDeskClient = $helpDeskClient;
    }

    public function prePersist(AbstractUser $user, LifecycleEventArgs $event)
    {
        $this->helpDeskClient->addUser($user);   //$user will be updated with the HTTP response
    }

    public function preUpdate(AbstractUser $user, LifecycleEventArgs $event)
    {
        $this->helpDeskClient->updateUser($user);
    }

    public function preRemove (AbstractUser $user, LifecycleEventArgs $event)
    {
        $this->helpDeskClient->deleteUser($user);
    }
}

Okay, how do I actually do this?  Was thinking of modifying UserListner as follows:

//...
use Symfony\Component\HttpKernel\KernelEvents;

final class UserListner
{
    // ...
    
    public function prePersist(AbstractUser $user, LifecycleEventArgs $event)
    {
        $this->helpDeskClient->addUser($user);
        
        $event->getObjectManager()->getEventManager()->addEventListener(KernelEvents::EXCEPTION, function($something) use($user) {
            // Use $this->helpDeskClient to reverse the changes
        });
    }
    
    // Similar for update and remove
}

 

But when trying this approach, I get a PDOException, but my callback never gets excecated.  I've also tried replacing KernelEvents::EXCEPTION with '\PDOException' (note the quotes) with no success.

Any ideas what I should be doing differently?

Maybe some totally different approach?  I suppose I could make the request to the API after the DB query is complete for updating and deleting, but not for adding.

I want to recieve emails on weekly manner from thursday to thursday. For this how can i set the variables to pass to the sql query.
I worte this
$start_date = mktime(0, 0, 1, date("m"), date("j")-7, date("Y"));
but it will  calculate date from today.
And I want to recieve emails on every friday morning.
So please write the code for me also write the end date.

Thanks in advance.

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

I have a mysql database set up with 4 fields - id, month, day, event. The database will be filled with something like: month=Jan, day=4 and event=Meeting. All are text fields. The display will be Jan. 4: Meeting

I can set up the PHP to display the database in a unordered list. The code for this is:

<?php

$result = @mysql_query("SELECT id, month, day, event FROM homecalendar");

if (!$result) {
      exit('<p>Error performing query: ' . mysql_error() . '</p>');
      }
while ($row = mysql_fetch_array($result)) {

echo '<li>' . $row['month'] . $row['day'] .': ' . $row['event'] . '</li>'  ; 

}

?>

How can I limit the code to display items for only the current month and the next month?

I have a page where I want a success and a fail response. It's a contact page so, if they fill in all that's required, and send, a success "message" will pop up but if they send but for some reason, it fails, to display a fail "message".

What it does right now is the fail and success are constantly visible regardless.

So how do I make it display the corresponding message accordingly?

*Also how am I to make the text within the boxes invisible ? But that's lower priority

howdy all

         I was wondering if anyone has any Basic Event calendar or a tutorial for a basic one.. I want to get a event calendar on my site but i want a basic one so i can tweak it to fit my likings.

Thank you
SilentHunter

Hello all

This may seem stupid coming in here with absolutely no code to show. I am in planning of a php event calender for my work place and I am a very PHP rookie  basically i am asking for directions to go with this.

I have written scripts before but not like this. I  currently have a database set up for the events and about to write to that  databases table. I have date as a primary key and in format of date (2012-05-14). what i am  trying to figure out is how do i take this date have it find the correct day on the calender?

I hope someone can help me a little here i know i have asked a lot  but  could use a point in the right direction.

Thank you,
Nis

I have a page for event registration and I have subevents that will have a check mark by them.  how do i make it so that a check mark only appears if a subevent is present?

i have built an event adding script...

when the admin adds an event a drop down menu pulls all the users in the DB to create the event for..

i set the option to their full name, but the value to the userid...

when it stores it to the database it stores the userid as XXX for example, but i'd like to store in another field their full name according to the userid, how is this acheivable im completly baffled.

I got this Event Calendar Script off of a site and i like it but it reads from a Flat File Database and i would like it to read from a mysql database. Can someone help me set it up so it will read from a mysql database? here is the script where its calling from the flat file..

Code: [Select]
   $counterfilepath="calendar.txt";
   if(file_exists($counterfilepath))
   {
    $filehandle=fopen($counterfilepath,"r");   
    $pointer = 1;
    while(!feof($filehandle))
    {
     $rowdata = fgets($filehandle);
     $day = floatval(substr($rowdata,3,2));
     $eventlastpos = strpos($rowdata,'{')-1;
     if($eventlastpos<=0){$eventlastpos=255;}
     $event = rtrim(substr($rowdata,11,$eventlastpos-10));
     $eventcaption = rtrim(substr($rowdata,$eventlastpos+2,strlen($rowdata)));
     $datalist = $this->eventsthismonth[$day];
     $rowmonth = floatval(substr($rowdata,0,2));
     $rowyear = floatval(substr($rowdata,6,4));

     if($rowmonth==$month and $rowyear==$year)
     {
     if($eventcaption=="")
       {$eventcaption='';}
     else
       {$eventcaption='<b>'.$eventcaption.'</b><br>';} 
   
     if($datalist=="")
       {
        $this->eventsthismonth[$day] = '<font name=Verdana size=1>'.$eventcaption.$event.'</font>';
       }
     else
       {
        $this->eventsthismonth[$day] = $datalist.'<br><hr size=1 color=#E0E0E0><font name=Verdana size=1>'.$eventcaption.$event.'</font>';
       }
     }
     $pointer = $pointer + 1;
    }
    fclose($filehandle);
   }

and the flat file looks like this
07/13/2005|Technology Advisory Meeting{2:00pm

I am workin on a event calendar and i ran into a problem.. it shows the calendar and the today's date and 1 event on each month but i want it to show all the events for each month. my problem is i can't figure out how to loop it so it will..

here is where im having trouble at..
Code: [Select]
for ($i=0; $i<($maxday+$startday); $i++) {
if(($i % 7) == 0 ){
echo "<tr>";
}
if($i < $startday){
echo ("<td bgcolor='414141'> </td>");
} else {
if (($i - $startday + 1) == $today && $currentmonth == $cMonth && $currentyear == $cYear){
echo ("<td bgcolor='FF0000'><center><font color='FFFFFF'>".($i - $startday + 1)."</font></center></td>");
} else {
[color=red]// this is where i need it to loop[/color]
if (($i - $startday + 1) == $eday && $eMonth == $cMonth && $eYear == $cYear){
echo ("<td bgcolor='0000FF'><center><a class='info' href='#'><font color='FFFFFF'>".($i - $startday + 1)."<span>".$event."<hr><br>".$event_des."</span></font></a></center></td>");
} else {
echo ("<td bgcolor='595959'><center><font color='FFFFFF'>".($i - $startday + 1)."</font></center></td>");
}
}
if(($i % 7) == 6 ) {
echo "</tr>\n";
}
}
}
i marked where the loop needs to go in red..

currently i have the sql query right above it in my script but i tried putting it where i need the loop and i get a error in there or it duplicates the calender and sometimes the numbers. can some please help me?

Thank you
Outsider_Child

How to self check what event i am using, my event : <checkout_cart_product_add_after> how to print, i tried :

$event = $observer->getEvent()->getName(); 

Mage::log($event, null, 'logfile.log');

its not printing

Good day!

I created a webpages and i have a login page consist of Username and Department. And i encountered problem in adding event in my calendar.

This is the flow of my webpage:
First I have a separate table for the user and calendar. In my user table it has a Username, Department, and Permission. In the permission I put True or False, only one user i put True because i want that user is the one who permitted to add event or if she is login the add event link appear, but if other login the add even0t did not appear.

This is my code in login:

<?php  
session_start();  
session_regenerate_id();  

if($_SESSION['loggedin']){  
//the user is already logged in, lets redirect them to the other page  
    header("Location:company.php");  
}  

//require_once 'conn.php';    
$db_name="dspi";  

mysql_connect("localhost", "root", "") or die("Cannot connect to server");  
mysql_select_db("$db_name")or die("Cannot select DB");     


        $department = mysql_real_escape_string($_POST['department']);     
        $username = mysql_real_escape_string($_POST['username']);  

        $sql=mysql_query("SELECT `Department`, `Username` FROM `tbllogin` WHERE `Department` = '{$department}' AND Username = '{$username}'") or die(mysql_error());  
        $ct = mysql_num_rows($sql);  
       
        if($ct == 1) {  
// im guessing this means that the user is valid.  
$_SESSION['loggedin'] = true; // now that the user is valid we change the session value.  
            $row = mysql_fetch_assoc($sql);    
             
            $_SESSION['username'] = $row['Username'] ; 
            $_SESSION['department'] = $row['Department']; 
             
            $Departments=array('Accounting', 'Engineering', 'Finishing_Goods', 'HRAD', 'MIS', 'Packaging_and_Design', 'Production', 'Purchasing_Logistic', 'QA_and_Technical', 'Supply_Chain'); 
             
            if (in_array($row['Department'], $Departments)){ 
                    header ('Location:company.php'); 
            }else{ 
                    echo "Incorrect Username or Department"; 
                    header ('Location:index.php'); 
            } 
        } 
?> 


and this is my code in calendar page:

<?php 

session_start(); 
$host = "localhost"; 

    $username = ""; 

    $password = ""; 

    $dbCnx = @mysql_connect($host, $username, $password) or die('Could not Connect to the database'); 

    $dbName = 'dspi'; 

    mysql_select_db($dbName);     
?> 
<html> 
<body> 
<script> 
function goLastMonth(month, year){ 
// If the month is January, decrement the year 
if(month == 1){ 
--year; 
month = 13; 
} 
document.location.href = '<?=$_SERVER['PHP_SELF'];?>?month='+(month-1)+'&year='+year; 
} 
//next function 
function goNextMonth(month, year){ 
// If the month is December, increment the year 
if(month == 12){ 
++year; 
month = 0; 
} 
document.location.href = '<?=$_SERVER['PHP_SELF'];?>?month='+(month+1)+'&year='+year; 
}  

function remChars(txtControl, txtCount, intMaxLength) 
{ 
if(txtControl.value.length > intMaxLength) 
txtControl.value = txtControl.value.substring(0, (intMaxLength-1)); 
else 
txtCount.value = intMaxLength - txtControl.value.length; 
} 

function checkFilled() { 
var filled = 0 
var x = document.form1.calName.value; 
//x = x.replace(/^\s+/,""); // strip leading spaces 
if (x.length > 0) {filled ++} 

var y = document.form1.calDesc.value; 
//y = y.replace(/^s+/,""); // strip leading spaces 
if (y.length > 0) {filled ++} 

if (filled == 2) { 
document.getElementById("Submit").disabled = false; 
} 
else {document.getElementById("Submit").disabled = true} // in case a field is filled then erased 

} 

</script> 

<?php 
//$todaysDate = date("n/j/Y"); 
//echo $todaysDate; 
// Get values from query string 
$day = (isset($_GET["day"])) ? $_GET['day'] : ""; 
$month = (isset($_GET["month"])) ? $_GET['month'] : ""; 
$year = (isset($_GET["year"])) ? $_GET['year'] : ""; 
//comparaters for today's date 
//$todaysDate = date("n/j/Y"); 
//$sel = (isset($_GET["sel"])) ? $_GET['sel'] : ""; 
//$what = (isset($_GET["what"])) ? $_GET['what'] : ""; 

//$day = (!isset($day)) ? $day = date("j") : $day = ""; 
if(empty($day)){ $day = date("j"); } 

if(empty($month)){ $month = date("n"); } 

if(empty($year)){ $year = date("Y"); }  
//set up vars for calendar etc 
$currentTimeStamp = strtotime("$year-$month-$day"); 
$monthName = date("F", $currentTimeStamp); 
$numDays = date("t", $currentTimeStamp); 
$counter = 0; 
//$numEventsThisMonth = 0; 
//$hasEvent = false; 
//$todaysEvents = "";  
//run a selec statement to hi-light the days 
function hiLightEvt($eMonth,$eDay,$eYear){ 
//$tDayName = date("l"); 
$todaysDate = date("n/j/Y"); 
$dateToCompare = $eMonth . '/' . $eDay . '/' . $eYear; 
if($todaysDate == $dateToCompare){ 
//$aClass = '<span>' . $tDayName . '</span>'; 
$aClass='class="today"'; 
}else{ 
//$dateToCompare = $eMonth . '/' . $eDay . '/' . $eYear; 
//echo $todaysDate; 
//return; 
$sql="select count(calDate) as eCount from calTbl where calDate = '" . $eMonth . '/' . $eDay . '/' . $eYear . "'"; 
//echo $sql; 
//return; 
$result = mysql_query($sql); 
while($row= mysql_fetch_array($result)){ 
if($row['eCount'] >=1){ 
$aClass = 'class="event"'; 
}elseif($row['eCount'] ==0){ 
$aClass ='class="normal"'; 
} 
} 
} 
return $aClass; 
} 
?> 
<div id="Calendar_Event"> 
<table width="350" cellpadding="0" cellspacing="0"> 
<tr> 
<td width="50" colspan="1"> 
<input type="button" value=" < " onClick="goLastMonth(<?php echo $month . ", " . $year; ?>);"> 
</td> 
<td width="250" colspan="5"> 
<span class="title" style="color:#FFFFFF"><?php echo $monthName . " " . $year; ?></span><br> 
</td> 
<td width="50" colspan="1" align="right"> 
<input type="button" value=" > " onClick="goNextMonth(<?php echo $month . ", " . $year; ?>);"> 
</td> 
</tr>  
<tr> 
<th>M</td> 
<th>T</td> 
<th>W</td> 
<th>T</td> 
<th>F</td> 
<th>S</td> 
<th>S</td> 
</tr> 
<tr> 
<?php 
for($i = 1; $i < $numDays+1; $i++, $counter++){ 
$dateToCompare = $month . '/' . $i . '/' . $year; 
$timeStamp = strtotime("$year-$month-$i"); 
//echo $timeStamp . '<br/>'; 
if($i == 1){ 
// Workout when the first day of the month is 
$firstDay = date("N", $timeStamp); 
for($j = 1; $j < $firstDay; $j++, $counter++){ 
echo "<td>&nbsp;</td>"; 
}  
} 
if($counter % 7 == 0 ){ 
?> 
</tr><tr> 
<?php 
} 
?> 
<!--right here--><td width="50" <?=hiLightEvt($month,$i,$year);?>><a href="<?=$_SERVER['PHP_SELF'] . '?month='. $month . '&day=' . $i . '&year=' . $year;?>&v=1"><?=$i;?></a></td>  
<?php 
} 
?> 
</table> 
</div> 
<div id="New_Event"> 
<?php 
if(isset($_GET['v'])){ 
if(isset($_POST['Submit'])){ 
$sql="insert into calTbl(calName,calDesc,calDate,calStamp) values('" . $_POST['calName'] ."','" . $_POST['calDesc'] . "','" . $_POST['calDate'] . "',now())"; 
mysql_query($sql); 
} 
$sql="select calName,calDesc, DATE_FORMAT(calStamp, '%a %b %e %Y') as calStamp from calTbl where calDate = '" . $month . '/' . $day . '/' . $year . "'"; 
//echo $sql; 
//return; 
$result = mysql_query($sql); 
$numRows = mysql_num_rows($result); 

$check=mysql_query("SELECT * FROM tbllogin WHERE Username='xxx' AND Department='HRAD' AND Permission='True'"); 
mysql_fetch_array($check); 
if($check['Username']=='xxx' && $check['Department']=='HRAD'){ 
$_SESSION['isallowed'] = $check['Permission']; 



//if (mysql_num_rows($check)>0){  
?> 
<a href="<?=$_SERVER['PHP_SELF'];?>?month=<?=$_GET['month'] . '&day=' . $_GET['day'] . '&year=' . $_GET['year'];?>&v=1&f=true">Add Even</a><a href="<?=$_SERVER['PHP_SELF'];?>?month=<?=$_GET['month'] . '&day=' . $_GET['day'] . '&year=' . $_GET['year'];?>&v=1&f=true">t</a><?php 
}else{ 
echo 'You cannot Add New Event'; 
}?> 
</div> 
<div id="Cal_Event"> 
<?php 
if(isset($_GET['f'])){ 
include 'calform.php'; 
} 
if($numRows == 0 ){ 
echo ''; 
}else{ 
//echo '<ul>'; 
echo '<h3>Event Listed</h3>'; 
while($row = mysql_fetch_array($result)){ 
?> 

<h5><?=$row['calName'];?></h5> 
<?=$row['calDesc'];?><br/> 
Listed On: <?=$row['calStamp'];?> 
<?php 
} 
} 
} 
?> 
</div> 
</body> 
</html> 


In that code when the user log is xxx and when she click a date she want to add event the appear is "You cannot Add Event".

I hope somebody can help me..


Thank you in advance...

Hi guys I have a script which displays the events on my calender throught the help of this code. In summary I basically was wondering how I could modify this code to display for events with a start and finish date:
Code: [Select]
IF(isset($events[$i])){
echo "<div align=\"left\"><span class=\"eventinbox\">\n";
while (list($key, $value) = each ($events[$i])) {
echo "&nbsp;<a href=\"javascript:MM_openBrWindow('event.php?id=$value','','width=500,height=200');\">" . $event_info[$value]['1'] . " " . $event_info[$value]['0']  . "</a>\n<br>\n";
}

echo "</span></div>\n";
}
That above is the display the events on the calender and here is the select query:
Code: [Select]
$sql = mysql_query("SELECT * FROM the_event WHERE event_month='$month' AND event_year='$year' ORDER BY event_time");
while($info = mysql_fetch_array($sql)){
    //planning to treat this as the event start date$day = $info['event_day'];
//I just added this column which would be the event end date$day2 = $info['event_day2'];
    $event_id = $info['events_id'];
    $events[$day][] = $info['events_id'];
    $event_info[$event_id]['0'] = substr($info['event_title'], 0, 8);;
    $event_info[$event_id]['1'] = $info['event_time'];
}
Please let me know if you need more info

Thanks