PHP - Time Based Mysql Events

I am a little confused with the difference between Symfony Events and Event Listners and Doctrine Events.

The Doctrine events look pretty straight forward and are primary used for entity persistence, and I have outlined my understanding below:

Doctrine Lifecycle Callbacks. Single entity and single Doctrine event. Method in class. Good performance. Don't have access to Symfony services (all others do) Doctrine Lifecycle Listeners. All entities and single Doctrine event. Separate class and configured in config.service.yaml. Doctrine Entity Listeners. Single entities and single Doctrine event. Separate class and configured in config.service.yaml. Doctrine Lifecycle Subscribers. All entities and multiple Doctrine event. Must implement EventSubscriber (or probably EventSubscriberInterface) Separate class and configured in config.service.yaml.

I am more confused with the Symfony events and my interpretation as listed below is likely incorrect.

Symfony Event Listeners. Single Symfony event. Separate class and configured in config.service.yaml. More flexible because bundles can enable or disable each of them conditionally depending on some configuration value. Symfony Event Subscribers. All specified Symfony events. Must implement EventSubscriberInterface Separate class but NOT configured in config.service.yaml but in class. Easier to reuse because the knowledge of the events is kept in the class rather than in the service definition.

Are they used for totally different purposes or can one use Symfony events to also deal with entities?  Where would one want to use these Symfony events?

Is there a reason why Doctrine Lifecycle Subscribers are located in src/EventListener and not src/EventSubscriber

Are Doctrine Lifecycle and Entity Listeners really only for a single event as I interpret the documentation states, or is it one method per Doctrine event such as the following?

    App\EventListener\SearchIndexer:
        tags:
            -
                name: 'doctrine.event_listener'
                event: 'postPersist'
            -
                name: 'doctrine.event_listener'
                event: 'postUpdate'

 

Hello everyone, here is my problem.

I am working for someone that would like users to be able to create a Trial Account on their website. This trial account is to be used for 24 hours, once the 24 hours is completed they can no longer login/use that account.

Everything about the Trial Account is completed, other then the account timer.

I am at a loss on how to get this part done.

I was thinking that I would use the MySQL commands, GETDATE() and DATEADD(), to get the date and time that the account was created and using the DATEADD() command I would add 24 hours to the GETDATE() value. Then if the user logs into at a date past the DATEADD() value the Users Account type is switched to 3(This means that the account has been disabled) and then is directed to the Logout page, which then redirects him back to the homepage.

After this point, the user can no longer login due to the code preventing any user with an account type of 3 to login.

The problem is that I am unaware how to incorporate the GETDATE() and DATEADD() functions into my PHP code.

Would anyone be able to explain how I can get this done, or suggest a better method of inputting a starting time and ending time for the account?

Thank You for any/all help.

Been googling this for hours now and I can't find something that doesn't give a parse error.

I found this thread: http://www.phpfreaks.com/forums/index.php?topic=160855 ..and tried to work around the answer but with no luck.

All I really want to do is something like this:

<td class="

<?php
if ($time<20:00&>1:00) { echo "class1";}
else if($time>20:00&<2:00) { echo "class2";}?>

"></td>

I want the class to change to another one if the user see the table cell within a specific hour of the day.

Hi, i am thinking of creating a text based game mmorpg using php/mysql etc... I know that a lot of these types of games use a tick based system, but i want it to be realtime, the only game i cna find that uses this is Torn, does anyone know how they make it realtime? I know that ticks can be controlled by cronjobs, but how about realtime?

The problem is that the game might involve the player building a house, in a tick based system it could be easy to manage by saying the house will take 3 ticks to complete, but i want the house to be like in 10 minutes of 32 minutes, how can i do this. Someone said to check whenever the player next logs in to check if the house has finished and then say it has been built, but seeing as it is an mmorpg it could affect everyones gameplay, not just the person building it, so this will not work.

Thanks and sorry if this is a bit confusing.

Hi,

I have a project where i want to send the sms to the customers at the particular time calling from the database, how to do these in php?

Thanks,

I would really appreciate help and I hope my problem can be solved easily. I am attempting to display the date/time based on the user's location. I have installed the timezone.js plugin for help as well. Is there a way to convert the Jquery variable that displays the users timezone location and insert it inside the PHP date_default_timezone_set?   If there is an easier way to display the users timezone date and time please let me know otherwise this was the only solution I could find.   Thanks in advanced...   Here is my code   Header

<header>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.5.1/jquery.min.js"></script>
<script src="Time/detect_timezone.js"></script>
<script src="Time/jquery.detect_timezone.js"></script>
<script>
$(document).ready(function(){
  $('#tzvalue').set_timezone({'default' : 'America/Los_Angeles'});
});
</script>
</header>

 

This code works just fine to display a list of reservations for a given day and sums the guest and table counts just fine for the entire day. Sums all reservations returned. What I am trying to do or figure out is a way to get totals based on specific time intervals. For example how many guests and tables at 8:00, 9:00, 10:00, etc.... I can see where the sums are calculated, but need help adding a way to add a variable to look at the reservation_time and sum by hour rather than just daily total.

       $tablesum ++;
        $guestsum += $row->reservation_pax;
<?php echo $guestsum;?>&nbsp;&nbsp;<?php echo _guest_summary;?>

The full code that pulls in the data and then sums it up in total:

<!-- Begin reservation table data -->
<br/>
<table class="global resv-table-small" cellpadding="0" cellspacing="0">
	<tbody>
		<tr>
		
		<?php
		echo "<td class='noprint'> </td>";
		echo "<td>Time</td>";
		echo "<td>Guests/Type</td>";
		echo "<td>Name</td>";
		echo "<td>Special Instructions/Notes</td>";
		echo "<td class='noprint'>Table</td>";
		echo "<td class='noprint'>Status</td>";
		echo "<td class='noprint'>Created</td>";
		echo "<td class='noprint'>Details/Delete</td>";

	echo "</tr>";
		
		// Clear reservation variable
		$reservations ='';
		
		if ($_SESSION['page'] == 1) {
			$reservations =	querySQL('all_reservations');
		}else{
			$reservations =	querySQL('reservations');
		}
		
		// reset total counters
		$tablesum = 0;
		$guestsum = 0;
			
		if ($reservations) {
			
			//start printing out reservation grid
			foreach($reservations as $row) {
				// reservation ID
				$id = $row->reservation_id;
				$_SESSION['reservation_guest_name'] = $row->reservation_guest_name;
				// check if reservation is tautologous
				$tautologous = querySQL('tautologous');
				
			echo "<tr id='res-".$id."'>";
			echo "<td";
			// daylight coloring
			if ($row->reservation_time > $daylight_evening){
				echo " class='evening noprint'";
			}else if ($row->reservation_time > $daylight_noon){
				echo " class='afternoon noprint'";
			}else if ($row->reservation_time < $daylight_noon){
				echo " class='morning noprint'";
			}
			
			echo " style='width:10px !important; padding:0px;'>&nbsp;</td>";
			echo "<td id='tb_time'";
			// reservation after maitre message
			if ($row->reservation_timestamp > $maitre['maitre_timestamp'] && $maitre['maitre_comment_day']!='') {
				echo " class='tautologous' title='"._sentence_13."' ";
			}
			echo ">";
			echo "<strong>".formatTime($row->reservation_time,$general['timeformat'])."</strong></td>";
			echo "<td id='tb_pax'><strong class='big'>".$row->reservation_pax."</strong>&nbsp;&nbsp;<span class='noprint'>";
			printType($row->reservation_hotelguest_yn);
				//echo "<img src='images/icons/user-silhouette.png' class='middle'/>";
			echo "</span></td><td style='width:10%' id='tb_name'><span class='noprint'>".printTitle($row->reservation_title)."</span><strong> <a id='detlbuttontrigger' href='ajax/guest_detail.php?id=".$id."'"; 
			// color guest name if tautologous
			if($tautologous>1){echo" class='tautologous tipsy' title='"._tautologous_booking."'";}
			echo ">".$row->reservation_guest_name."</a></strong>";
			
			// old reservations symbol
			if( (strtotime($row->reservation_timestamp) + $general['old_days']*86400) <= time() ){
				echo "<img src='images/icons/clock-bolt.png' class='help tipsyold middle smicon' title='"._sentence_11."' />";
			}
			// recurring symbol
			if ($row->repeat_id !=0) {
	            echo "&nbsp;<img src='images/icons/loop-alt.png' alt='"._recurring.
					 "' title='"._recurring."' class='tipsy' border='0' >";
	        }
	
			echo"</td><td style='width:10%' id='tb_note'>";
				if ($_SESSION['page'] == 1) {
			 		echo $row->outlet_name;
			 	}else{
					echo $row->reservation_notes;
				}
			echo "</td>";
			
			if($_SESSION['wait'] == 0){
				echo "<td class='big tb_nr' style='width:85px;' id='tb_table'><img src='images/icons/table_II.png' class='tipsy leftside noprint' title='"._table."' /><div id='reservation_table-".$id."' class='inlineedit'>".$row->reservation_table."</div></td>";
			}
			echo "<td class='noprint'><div>";
				getStatusList($id, $row->reservation_status);
			echo "</div></td>";
			echo "<td class='noprint'>";
			echo "<small>".$row->reservation_booker_name." | ".humanize($row->reservation_timestamp)."</small>";
			echo "</td>";
			echo "<td class='noprint'>";
			// MOVE BUTTON
			//	echo "<a href=''><img src='images/icons/arrow.png' alt='move' class='help' title='"._move_reservation_to."'/></a>";
			
			// WAITLIST ALLOW BUTTON
			if($_SESSION['wait'] == 1){
				$leftspace = leftSpace(substr($row->reservation_time,0,5), $availability);
				if($leftspace >= $row->reservation_pax && $_SESSION['outlet_max_tables']-$tbl_availability[substr($row->reservation_time,0,5)] >= 1){	    
					echo"&nbsp;<a href='#' name='".$id."' class='alwbtn'><img src='images/icons/check-alt.png' name='".$id."' alt='"._allow."' class='help' title='"._allow."'/></a>&nbsp;&nbsp;";
				}
			}
			// EDIT/DETAIL BUTTON
			echo "<a href='?p=102&resID=".$id."'><img src='images/icons/pen-fill.png' alt='"._detail."' class='help' title='"._detail."'/></a>&nbsp;&nbsp;";
			// DELETE BUTTON
			if ( current_user_can( 'Reservation-Delete' ) && $q!=3 ){
		    	echo"<a href='#modalsecurity' name='".$row->repeat_id."' id='".$id."' class='delbtn'>
					<img src='images/icons/delete.png' alt='"._cancelled."' class='help' title='"._delete."'/></a>";
			}
		echo"</td></tr>";
		$tablesum ++;
		$guestsum += $row->reservation_pax;
			}
		}
		?>
	</tbody>
	<tfoot>

		<tr style="border:1px #000;">
			<td class=" noprint"></td><td></td>
			<td colspan="2" class="bold"><?php echo $guestsum;?>&nbsp;&nbsp;<?php echo _guest_summary;?></td>
			<td></td>
			<td colspan="2" class="bold"><?php echo $tablesum;?>&nbsp;&nbsp;<?php echo _tables_summary;?></td>
			<?php
			if($_SESSION['wait'] == 0){
				//echo "<td></td>";
			}
			?>
		</tr>
	</tfoot>
</table>
<!-- End reservation table data -->

Edited by mfandel, 26 October 2014 - 02:06 AM.

Hello Coder Guys,

I need a small help from you. I want to list all files & directories based on last file modification time of server. I want to list new files as first & old files as last.
Consider "files" as the directory name which contains all files & directories.

Please make the php code to display all files & directories from "files" directory based on last file modification time of server.

Thanks IN Advance !

I'm working on a project that has a lot of different timezone options, and all I have from the users is their UTC offset.

After weeks of doing tweaks, I come to new issues every time I add something, one would think it would be a lot easier to just get the correct time and day :)

The latest issue is that when I try to rewrite a date to a better fomat, it disregards the GMT offset. Like this:

4/14/19, 12:00 PM GMT+2 (=$date) becomes ... 14-04-2019 10:00 when using this code:

$bp_date_to_format = date_create_from_format('Y-m-d\TH:i:sP', $date);
echo date_format($bp_date_to_format, 'd-m-Y H:i');

I figured it would just rewrite the format, keeping the exact time. It isn't.

We do have all these sorts of localization functions as well, but because there doesn't seem to be one single standard (each 3rd party API connection we have uses its own default datetime format so it seems).

        // Remove UTC Text
        $UTC_offset = str_replace('UTC', '', $timezone);

        // Get Offset in Minutes
        if (stripos($UTC_offset, ':') !== false) {
            // Calculate seconds from offset
            list($hours, $minutes) = explode(':', $offset);
            $seconds = $hours * 60 * 60 + $minutes * 60;
        } else {
            $seconds = $UTC_offset * 60 * 60;
        }

        // Get User timezone name from seconds
        $timezone = timezone_name_from_abbr('', $seconds, 1);
        if ($timezone === false) {
            $timezone = timezone_name_from_abbr('', $seconds, 0);
        }
        // Set new TZ
        return date_default_timezone_set($timezone);

 

Isn't there any "one way"solution that can be used? It's confusing to say the least.

 

Cheers.

I've been researching online resources and seen a lot of code and functions for calculating an interval or difference between two date/time figures.  What I'm trying to do is somewhat in reverse... I want to establish an interval to determine a past date/time to be used in a MySQL Query but just can't figure the critical part.

// STEP #1 = DEFINE THE DESIRED DATE/TIME DIFFERENCE INTERVAL DESIRED FOR QUERIES

$timeinterval = '60'; // Interval is in MINUTES and can be changed as desired

// STEP #2 = GET THE CURRENT LOCAL SERVER DATE/TIME
// as YYYY-MM-DD HH:MN:SE

$serverdatetime = date('Y-m-d H:i:s'); // My local Server Date & time

// STEP #3 = CALCULATE THE ***PAST** (OLDER) DATE/TIME LIMIT BASED ON $timeinterval (Minutes)
// as YYY-MM-DD HH:MN:SE

$pastdatetime = [stuckinarut here] <- 60 MINUTES prior to current Server Date/Time

// STEP #4 = MySQL QUERY (`submitted` column is auto-timestampped on record insertions)

$sql="[columnsblahblah] FROM mydb WHERE `submitted` >= $pastdatetime";

In a Perfect World, the MySQL Query would yield ONLY records with a `submitted` DATE/TIME equal to 60 Minutes (or less) PRIOR TO from the Current Server Time.   Any assistance is appreciated!   Thanks.   -FreakingOUT    

Base Creative is changing and expanding. We have recently appointed a new creative director and a new technical project manager and we are looking for a: WEB DEVELOPER  Growth in our business has brought about the impetus to change the creative direction of the company along with the environment and atmosphere, under the direction of our creative head and with your input. We have a good reputation, a wealth of happy clients - big established names to smaller start-ups with fresh ideas - but we want to be more innovative, fun and much more creative, growing further into cross media and device skills, forging a recognised, stellar reputation for quality creativity in the industry. We are starting with gradually overhauling our own website and studio, so be prepared to play a part in this change immediately. Your Role You will have full control over your output, from the planning stage right through to the back end development, while working with our other staff on the creative and development team. You can become a part of something new and exciting, playing a key role in shaping the environment within which you work.  The perfect candidate will be 100% committed to a successful career with Base Creative, looking to learn and grow in knowledge and have a great portfolio underpinned by varied technical skills. Responsibilities and Tasks:

so im trying to setup a page for my bills that i pay monthly so me and my gf can access it remotely whenever we need to. we have a few loans that we are paying off in installment loans every month so i created a table like the picture below (which is actually in excel but it looks about the same).  i know how to pull via select and sum everything that i need but what i'm actually going for is this:

every month on those certain due dates i'd like for the monthly payment to be subtracted from the balance automatically..and it show the reflected balance. i'm not sure how to go about such a thing though as i've never worked with dates and times.  my logic is that i have to setup a beginning time stamp for it to work off of..and then every 30 days from that time stamp..subtract the payment.  then again, there's not always 30 days in a month and it'd get off track.  any ideas?

I used search function, could not find a subject that addressed my need.  I hope I am not repeating a well answered question.   I have two MySql fields I want to hyperlink, but not as text links, but with an image.   Here is truncated code, if more deatail is need, I can post.  Both links work fine now, but show the person's email name and google map link text - looks unproffessional and I think  the email links may be able to be harvested by spammers.   The E-mail link:   echo "<td><a href=mailto:".$row['email'] . ">" .$row['email'] . "</a></td>";   The Google map link:   echo "<td><a target='_blank' href=".$row['location_map_link'] . ">" .$row['location_map_link'] . "</a></td>";   Can we use images in this code?   I am not a PHP coder!!   Ron
 

Hi Guys. Hopefully someone can help me with this...New to coding and pretty lost on this.
I have a Mysql database which is displaying results to my webpage with no problems. However I would like to be able to add a combo box to my webpage that would update the mysql database results based on the combo box selection. For example if Ford is chosen from the combo box, the webpage would refresh and show all the results for Ford in the webpage. Can someone please help me?

Here is the code I have at the moment that works just fine. But results of the database are based on the WHERE statement.

Quote

<?php
$con = mysql_connect("server","database","password");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_select_db("a5525005_cars", $con);

$result = mysql_query("SELECT * FROM `cars` WHERE Makel='Ford'");

echo "<table class='ex1' border='0' width='113%' style=text-align:center; cellpadding='6' cellspacing='0'>

</tr>";

while($row = mysql_fetch_array($result))
  {
  echo "<tr style=font-family:verdana;font-size:80%;>";
 
    echo "<td width=13%>" . $row[""] . "<img src=\"" . $row["Photo"] . "\"></a>";
    echo '<td width="14%"><a class="mylink" href="' . $row['URL'] . '">' . $row['Model'] . '</a></td>';   
    echo '<td width="5%"><a class="mylink" href="' . $row['URL'] . '">' . $row['Year'] . '</a></td>';
    echo '<td width="4%"><a class="mylink" href="' . $row['URL'] . '">' . $row['Fuel'] . '</a></td>';
       
echo "</tr>";
  }
echo "</table>";
mysql_close($con);
?>

Hi!

Can anyone please help me form script for doing a MySQL query based on variables in a bbcode?

BBCode could be like this: [datatype::dataid]

Explode datatype and dataid intro separate strings and using them in querys.

Example of string containing bbcodes:
Code: [Select]
$body = "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi fringilla, enim eget dictum sodales, enim velit iaculis dolor, sed congue orci diam id ipsum. Integer ullamcorper elit ac arcu condimentum id elementum arcu tempus. Ut aliquam commodo eros, mollis tristique magna adipiscing eu.
[video::3456]
Duis congue turpis quis eros porta eu sollicitudin mi porttitor. Ut ac nisi id risus imperdiet aliquet. Suspendisse lacinia sem id ipsum blandit egestas. Mauris id vulputate ligula. In in quam urna. Nam purus augue, laoreet vel sodales nec, rutrum non augue.
[video::6789]
Phasellus facilisis commodo arcu, vel dapibus tortor pretium eu. Integer elit nisi, condimentum ut vehicula eget, ullamcorper non quam. Nullam suscipit tempor consequat. Vestibulum sollicitudin ante tristique neque vestibulum a fermentum nulla venenatis. In eget nulla nulla.";
I found something close he
http://stackoverflow.com/questions/2801228/php-bbcode-with-sql-selection