3v4l.org

run code in 300+ PHP versions simultaneously

@ 2014-04-04T16:46:40Z

<?php

// This library is to rewrite MSYQL queries into formatted text

class query2text {

	private $key_arr;

	public function addline ($query,$keyword)
	{
		$fixed = str_ireplace(" ".$keyword,"<br>&nbsp;".$keyword,$query);
		return $fixed;
	}

	public function convert($query)
	{
		$key_arr = array("FROM","LEFT JOIN","RIGHT JOIN","INNER JOIN","OUTER JOIN","WHERE","AND","OR","ORDER","GROUP");
		foreach($key_arr AS $key)
		{
			$query = $this->addline($query,$key);
		}
		$query .= "<br><br>\n";
		return $query;
	}

}

$query = "SELECT patients.patient_id,patients.last_name,patients.first_name,appts.*,appt_types.type,appt_types.color,appt_types.bgcolor"
		. ",DATE_FORMAT(appts.start,'%m/%d/%Y') AS date"
		. ",DATE_FORMAT(appts.start,'%h:%i %p') AS time"
		. ",TIMEDIFF(appts.end,appts.start) AS duration"
		. " FROM patients,appts,appt_types"
		. " WHERE appts.cancelled IS NULL"
		. " AND YEAR(appts.start)='" . $year . "'"
		. " AND MONTH(appts.start)='" . $month . "'"
		. " AND DAY(appts.start)='" . $day . "'"
		. " AND patients.patient_id = appts.patient_id"
		. " AND appts.type = appt_types.appt_type_id";


$q2t = new query2text();
echo "<hr>" . $q2t->convert($query) . "<hr>\n";

Output for git.master, git.master_jit, rfc.property-hooks: Warning: Undefined variable $year in /in/3TqDc on line 34 Warning: Undefined variable $month in /in/3TqDc on line 35 Warning: Undefined variable $day in /in/3TqDc on line 36 <hr>SELECT patients.patient_id,patients.last_name,patients.first_name,appts.*,appt_types.type,appt_types.color,appt_types.bgcolor,DATE_FORMAT(appts.start,'%m/%d/%Y') AS date,DATE_FORMAT(appts.start,'%h:%i %p') AS time,TIMEDIFF(appts.end,appts.start) AS duration<br> FROM patients,appts,appt_types<br> WHERE appts.cancelled IS NULL<br> AND YEAR(appts.start)=''<br> AND MONTH(appts.start)=''<br> AND DAY(appts.start)=''<br> AND patients.patient_id = appts.patient_id<br> AND appts.type = appt_types.appt_type_id<br><br> <hr>

This tab shows result from various feature-branches currently under review by the php developers. Contact me to have additional branches featured.

Active branches

Archived branches

Once feature-branches are merged or declined, they are no longer available. Their functionality (when merged) can be viewed from the main output page

2020-03-21 RFC: Is_Literal - declined
2020-12-04 Enumerations - included in PHP 8.1
2018-06-15 Typed Properties v2 - implemented in PHP 7.4
2016-08-12 Object typehint - included in PHP 7.2
2016-08-14 Arrow functions - withdrawn
2016-05-29 array_change_keys() - withdrawn
2016-04-19 Lexical scope support for anonymous classes - suspended
2016-04-17 Functional Interfaces - declined
2016-03-16 Typed Properties - superseded in favor of Typed Properties 2.0
2015-08-27 Callable Prototypes - declined
2015-05-01 Short Closures - declined / withdrawn in favor of Arrow Functions
2015-02-18 Scalar type hints v5 - included in PHP 7
2015-02-14 Union Types - declined
2013-09-22 Anonymous classes - included in PHP 7

preferences:dark modelive preview

49.61 ms | 402 KiB | 8 Q