wp custom query db (wpdb)

PHP 29

Wp custom query db (wpdb) By micha on 19th July 2019 03:38:08 PM

<?php
/*
<!-----------------------------
Calendar - Upcoming
------------------------------>
*/
global $wpdb;
$table_name = $wpdb->prefix . 'ci_entries';
$result = $wpdb->get_results('SELECT * FROM ' . $table_name . ' WHERE dt_start >= CURRENT_DATE() ORDER BY dt_start ASC LIMIT 3');
echo "<h3>Unsere nächsten Termine</h3>";
foreach ($result as $event) {
$dt_start = $event->dt_start;
$dt_end = $event->dt_start;
$unix_dt_start = strtotime($dt_start);
$start_date = date('d.m.Y',$unix_dt_start);
$start_date_shrt = date('d.m.y',$unix_dt_start);
$start_time = date('H:i',$unix_dt_start);
$unix_dt_end = strtotime($dt_end);
$end_date = date('d.m.Y',$unix_dt_end);
$end_time = date('H:i',$unix_dt_end);
if ($start_date == $end_date) {
if ($start_time == $end_time) {
if ($start_time == '00:00:00') {
$event_date_formatted = $start_date;
} else {
$event_date_formatted = $start_date.' @ '.$start_time;
}
} else {
$event_date_formatted = $start_date.' @ '.$start_time.' - '.$end_time;
}
} else {
$event_date_formatted = $start_date.' @ '.$start_time.' - '.$end_date.' @ '.$end_time;
}
if (!empty($event->description)) {
$event_tooltip_text = $event->description;
} else {
$event_tooltip_text = $event->summary;
}
echo '<span class="tooltip" data-tooltip="'.$event_date_formatted. ' — '.$event_tooltip_text.'">'
.$start_date_shrt.' — '.$event->summary.'</span>';
echo '<br />';
}
?>

Recent Pastes

Elementor Sticky[...]

JS baseURL

ASCI Banner

Jump to anchor / go[...]

Phpstorm[...]

Wp user[...]

WP CPT Custom Icon[...]

WP get assigned[...]

Linux / Ubuntu[...]

SQL replace[...]

Raw Paste

<?php
  /*
  
  */
  global $wpdb;
  $table_name   = $wpdb->prefix . 'ci_entries';
  $result       = $wpdb->get_results('SELECT * FROM ' . $table_name . ' WHERE dt_start >= CURRENT_DATE() ORDER BY dt_start ASC LIMIT 3');

echo "<h3>Unsere nächsten Termine</h3>";

foreach ($result as $event) {
  
	$dt_start       = $event->dt_start;
	$dt_end         = $event->dt_start;
  
	$unix_dt_start  = strtotime($dt_start);
	$start_date     = date('d.m.Y',$unix_dt_start);
	$start_date_shrt = date('d.m.y',$unix_dt_start);
	$start_time     = date('H:i',$unix_dt_start);
  
	$unix_dt_end    = strtotime($dt_end);
	$end_date       = date('d.m.Y',$unix_dt_end);
	$end_time       = date('H:i',$unix_dt_end);
  
	if ($start_date == $end_date) {
	  if ($start_time == $end_time) {
		if ($start_time == '00:00:00') {
		  $event_date_formatted = $start_date;
		} else {
		  $event_date_formatted = $start_date.' @ '.$start_time;
		}
	  } else {
		$event_date_formatted = $start_date.' @ '.$start_time.' - '.$end_time;
	  }
	} else {
	  $event_date_formatted = $start_date.' @ '.$start_time.' - '.$end_date.' @ '.$end_time;
	}
  
	if (!empty($event->description)) {
	  $event_tooltip_text = $event->description;
	} else {
	  $event_tooltip_text = $event->summary;
	}
  
	echo '<span class="tooltip" data-tooltip="'.$event_date_formatted. ' — '.$event_tooltip_text.'">'
		 .$start_date_shrt.' — '.$event->summary.'</span>';
	echo '<br />';
  
  }
  ?>