PHP and MySQL syntax - Revision history

Planetoid: /* Debug */

2024-06-27T03:16:04Z

Debug

← Older revision		Revision as of 11:16, 27 June 2024
Line 433:		Line 433:
	== Debug ==		== Debug ==
	PHP		PHP
	[https://www.php.net/manual/en/function.debug-backtrace.php PHP: debug_backtrace - Manual]		* [https://www.php.net/manual/en/function.debug-backtrace.php PHP: debug_backtrace - Manual]

	MySQL		MySQL

Planetoid: /* debug */

2024-06-27T03:15:51Z

debug

← Older revision		Revision as of 11:15, 27 June 2024
Line 431:		Line 431:
	# (optional) Adjust the text size to 10		# (optional) Adjust the text size to 10

	== ~~debug~~ ==		== Debug ==
	[[SQL syntax debug]]		PHP
			[https://www.php.net/manual/en/function.debug-backtrace.php PHP: debug_backtrace - Manual]

			MySQL
			* [[SQL syntax debug]]

	== References ==		== References ==

Unknown user: /* Convert date time from T Z format */

2023-04-26T11:11:38Z

Convert date time from T Z format

← Older revision		Revision as of 19:11, 26 April 2023
Line 187:		Line 187:
	</pre>		</pre>

	==== Convert date time from ~~T Z~~ format ====		==== Convert date time from Zulu format ====
	[[Convert date time from ~~t z format \| Convert date time from T Z~~ format]]		[[Convert date time from zulu format]] e.g. {{Template:Today}}T10:59:39.000Z

	==== Previous month based on current month ====		==== Previous month based on current month ====

Unknown user: /* Convert the datetime to ISO foamt time format */

2023-03-29T06:19:34Z

Convert the datetime to ISO foamt time format

@@ Line 158: / Line 158: @@
 // output: 2021-03-29
-$date = DateTime::createFromFormat('M d D Y G:i', "Jun 04 Sun 2023 08:25");
+$date = DateTime::createFromFormat('M d D Y H:i', "Jun 04 Sun 2023 08:25");
 echo $date->format('Y-m-d H:i:s');
 // output: 2023-06-04 08:25:00
 </pre>

Unknown user: /* specified time */

2023-03-29T06:16:22Z

specified time

← Older revision		Revision as of 14:16, 29 March 2023
Line 101:		Line 101:
	{{exclaim}} Since {{kbd \| key=<nowiki>echo $(date '+%N')</nowiki>}} was not supported on {{Mac}}<ref>[https://superuser.com/questions/599072/how-to-get-bash-execution-time-in-milliseconds-under-mac-os-x macos - How to get Bash execution time in milliseconds under Mac OS X? - Super User]</ref>, alternative approach is the installation of {{kbd \| key=gdate}}.		{{exclaim}} Since {{kbd \| key=<nowiki>echo $(date '+%N')</nowiki>}} was not supported on {{Mac}}<ref>[https://superuser.com/questions/599072/how-to-get-bash-execution-time-in-milliseconds-under-mac-os-x macos - How to get Bash execution time in milliseconds under Mac OS X? - Super User]</ref>, alternative approach is the installation of {{kbd \| key=gdate}}.

	=== ~~specified~~ time ===		=== Specified time ===
	==== Convert the unix timestamp to '''human readable''' time format ====		==== Convert the unix timestamp to '''human readable''' time format ====
	ex: 2010-12-21 10:05:06		ex: 2010-12-21 10:05:06
Line 149:		Line 149:
	* MySQL: [http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_str-to-date STR_TO_DATE(str,format)] ex: {{kbd \| key=SELECT STR_TO_DATE('{{CURRENTMONTHNAME}} {{CURRENTDAY}}, {{CURRENTYEAR}}', '%M %d, %Y');}} // Returns {{Template:Today}} <ref>[http://stackoverflow.com/questions/7027129/mysql-monthname-from-numbers MySQL MONTHNAME() from numbers - Stack Overflow]</ref>		* MySQL: [http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_str-to-date STR_TO_DATE(str,format)] ex: {{kbd \| key=SELECT STR_TO_DATE('{{CURRENTMONTHNAME}} {{CURRENTDAY}}, {{CURRENTYEAR}}', '%M %d, %Y');}} // Returns {{Template:Today}} <ref>[http://stackoverflow.com/questions/7027129/mysql-monthname-from-numbers MySQL MONTHNAME() from numbers - Stack Overflow]</ref>
	* Excel		* Excel

			==== Convert the datetime to ISO foamt time format ====
			Using the [https://www.php.net/manual/en/datetime.createfromformat.php DateTime::createFromFormat]<ref>[https://stackoverflow.com/questions/10306999/php-convert-date-format-dd-mm-yyyy-yyyy-mm-dd PHP convert date format dd/mm/yyyy => yyyy-mm-dd - Stack Overflow]</ref>

			<pre>
			$date = DateTime::createFromFormat('d/m/Y', "29/03/2021");
			echo $date->format('Y-m-d');
			// output: 2021-03-29

			$date = DateTime::createFromFormat('M d D Y G:i', "Jun 04 Sun 2023 08:25");
			echo $date->format('Y-m-d H:i:s');
			// output: 2023-06-04 08:25:00
			</pre>

	==== Convert date time from T Z format ====		==== Convert date time from T Z format ====

Unknown user: /* current timestamp */

2023-03-23T09:39:15Z

current timestamp

← Older revision		Revision as of 17:39, 23 March 2023
Line 35:		Line 35:

	==== current '''timestamp''' ====		==== current '''timestamp''' ====
	The number of seconds since 1970/01/01. [https://zh.wikipedia.org/wiki/UTC%C2%B10 UTC±0] e.g. 2011-05-30 01:56:38 returns 1306720622
			The number of '''seconds''' since 1970/01/01. [https://zh.wikipedia.org/wiki/UTC%C2%B10 UTC±0] e.g. 2011-05-30 01:56:38 returns 1306720622
	* BASH for {{Linux}} & {{Mac}}: {{kbd \| key=<nowiki>echo $(date +%s)</nowiki>}} "%s - seconds since 1970-01-01 00:00:00 UTC"<ref>[https://linux.die.net/man/1/date date(1): print/set system date/time - Linux man page]</ref>		* BASH for {{Linux}} & {{Mac}}: {{kbd \| key=<nowiki>echo $(date +%s)</nowiki>}} "%s - seconds since 1970-01-01 00:00:00 UTC"<ref>[https://linux.die.net/man/1/date date(1): print/set system date/time - Linux man page]</ref>
	* BASH for {{Mac}}: (1) {{kbd \| key=<nowiki>brew install coreutils</nowiki>}} (2) key-in {{kbd \| key=<nowiki>gdate +%s</nowiki>}}<ref>[https://www.gsp.com/cgi-bin/man.cgi?section=1&topic=gdate gdate(1) - print or set the system date and time]</ref>		* BASH for {{Mac}}: (1) {{kbd \| key=<nowiki>brew install coreutils</nowiki>}} (2) key-in {{kbd \| key=<nowiki>gdate +%s</nowiki>}}<ref>[https://www.gsp.com/cgi-bin/man.cgi?section=1&topic=gdate gdate(1) - print or set the system date and time]</ref>
	* php: {{kbd \| key=<nowiki>echo time();</nowiki>}}		* php: {{kbd \| key=<nowiki>echo time();</nowiki>}}
			* mysql: {{kbd \| key=<nowiki>SELECT UNIX_TIMESTAMP();</nowiki>}}
			* EXCEL: [http://stackoverflow.com/questions/1703505/excel-date-to-unix-timestamp Excel date to Unix timestamp - Stack Overflow]

			'''current Unix timestamp with microseconds'''
	* php: {{kbd \| key=<nowiki>echo microtime();</nowiki>}} [http://php.net/manual/en/function.microtime.php PHP: microtime - Manual] "Returns current Unix timestamp with microseconds" //ex: 0.45920500 1406776901		* php: {{kbd \| key=<nowiki>echo microtime();</nowiki>}} [http://php.net/manual/en/function.microtime.php PHP: microtime - Manual] "Returns current Unix timestamp with microseconds" //ex: 0.45920500 1406776901
	* mysql: {{kbd \| key=<nowiki>SELECT UNIX_TIMESTAMP();</nowiki>}}
			'''current Unix timestamp in milliseconds'''
	* javascript: getTime() Method ex: {{kbd \| key=<nowiki>new Date().getTime();</nowiki>}} //Return the number of milliseconds since 1970/01/01 <ref>[http://w3schools.com/jsref/jsref_gettime.asp JavaScript getTime() Method]</ref>		* javascript: getTime() Method ex: {{kbd \| key=<nowiki>new Date().getTime();</nowiki>}} //Return the number of milliseconds since 1970/01/01 <ref>[http://w3schools.com/jsref/jsref_gettime.asp JavaScript getTime() Method]</ref>
	* EXCEL: [http://stackoverflow.com/questions/1703505/excel-date-to-unix-timestamp Excel date to Unix timestamp - Stack Overflow]

	compare the timestamp and human readable time format using MySQL		compare the timestamp and human readable time format using MySQL

Unknown user: Text replacement - "== references ==" to "== References =="

2022-07-10T09:09:46Z

Text replacement - "== references ==" to "== References =="

← Older revision		Revision as of 17:09, 10 July 2022
Line 391:		Line 391:
	[[SQL syntax debug]]		[[SQL syntax debug]]

	== ~~references~~ ==		== References ==
	<references/>		<references/>

Unknown user: /* export/import sql file */

2021-08-12T02:03:52Z

export/import sql file

← Older revision		Revision as of 10:03, 12 August 2021
Line 360:		Line 360:
	* SELECT column FROM table GROUP BY column		* SELECT column FROM table GROUP BY column

	== ~~export~~/~~import sql~~ file ==		== Export/Import the SQL file ==
	[[MySQL commands]]		[[MySQL commands]]

			== Export/Import the Excel file ==
			[[Database management tools]]

	== reverse the boolean value ==		== reverse the boolean value ==

Unknown user: /* time / timestamp */

2021-05-29T02:04:11Z

time / timestamp

← Older revision		Revision as of 10:04, 29 May 2021
Line 1:		Line 1:
	mulitple approaches to completing the same/similar task using PHP, MySQL and Excel		mulitple approaches to completing the same/similar task using PHP, MySQL and Excel

	== time / timestamp ==		== Date time / unix timestamp ==

	=== now ===		=== now ===

Unknown user: /* Date interval */

2021-04-03T07:27:52Z

Date interval

← Older revision		Revision as of 15:27, 3 April 2021
Line 252:		Line 252:
	* SELECT * FROM `table_name` WHERE `time` BETWEEN '{{Template:Today}} 00:00:00' AND '{{Template:Today}} 23:59:59'		* SELECT * FROM `table_name` WHERE `time` BETWEEN '{{Template:Today}} 00:00:00' AND '{{Template:Today}} 23:59:59'
	* SELECT * FROM `table_name` WHERE DATE(`time`) = '{{Template:Today}}'		* SELECT * FROM `table_name` WHERE DATE(`time`) = '{{Template:Today}}'

			=== Days before ===
			[[Days before]]

	=== date format ===		=== date format ===