HowTo:Font Awesome - Revision history

Bryans at 20:16, 28 April 2021

2021-04-28T20:16:28Z

2021-04-28T20:10:25Z

← Older revision		Revision as of 20:10, 28 April 2021
Line 11:		Line 11:
	[https://fontawesome.com/icons/ See all the icons]		[https://fontawesome.com/icons/ See all the icons]
	<hr/>		<hr/>
	{{EpiphanyHelpText\|Detail\|~~114~~}}		{{EpiphanyHelpText\|Detail\|457}}
	<hr/>		<hr/>
	{{EpiphanyHelpText\|Detail\|53}}		{{EpiphanyHelpText\|Detail\|53}}

2021-04-28T20:09:42Z

← Older revision		Revision as of 20:09, 28 April 2021
Line 11:		Line 11:
	[https://fontawesome.com/icons/ See all the icons]		[https://fontawesome.com/icons/ See all the icons]
	<hr/>		<hr/>
	{{EpiphanyHelpText\|Detail\|21}}		{{EpiphanyHelpText\|Detail\|114}}
	<hr/>		<hr/>
	{{EpiphanyHelpText\|Detail\|53}}		{{EpiphanyHelpText\|Detail\|53}}

2021-04-28T19:51:01Z

← Older revision		Revision as of 19:51, 28 April 2021
Line 11:		Line 11:
	[https://fontawesome.com/icons/ See all the icons]		[https://fontawesome.com/icons/ See all the icons]
	<hr/>		<hr/>
	{{EpiphanyHelpText\|21}}		{{EpiphanyHelpText\|Detail\|21}}
	<hr/>		<hr/>
	{{EpiphanyHelpText\|53}}		{{EpiphanyHelpText\|Detail\|53}}

2021-03-22T15:27:23Z

← Older revision		Revision as of 15:27, 22 March 2021
Line 14:		Line 14:
	<hr/>		<hr/>
	{{EpiphanyHelpText\|53}}		{{EpiphanyHelpText\|53}}
	~~<syntaxhighlight lang="php"><?php~~
	~~$serverName = "sql01.crystalcomputer.com";~~
	~~$connectionOptions = array(~~
	~~"database" => "epiphany",~~
	~~"uid" => "epiphany",~~
	~~"pwd" => "ccc"~~
	);

	~~// Establishes the connection~~
	~~$conn = sqlsrv_connect($serverName, $connectionOptions);~~
	~~if ($conn === false) {~~
	~~die(formatErrors(sqlsrv_errors()));~~
	}
	~~$hid=intval($_GET['hid']);~~

	~~// Select Query~~
	~~$tsql = "SELECT FlexScreenDetail.HelpText as HelpText~~
	~~FROM FlexScreenMaster~~
	~~LEFT JOIN Relationships Rel1 ON Rel1.ObjectID1=5 AND Rel1.ItemID1=FlexScreenMaster.ID AND Rel1.ObjectID2=6 AND Rel1.Type=0~~
	~~LEFT JOIN FlexScreenDetail ON FlexScreenDetail.ID=Rel1.ItemID2~~
	~~WHERE FlexScreenMaster.ID = $hid;";~~

	~~// Executes the query~~
	~~$stmt = sqlsrv_query($conn, $tsql);~~

	~~// Error handling~~
	~~if ($stmt === false) {~~
	~~die(formatErrors(sqlsrv_errors()));~~
	}

	~~while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)) {~~
	~~$s = ltrim(rtrim($row['HelpText']));~~
	~~if (strlen($s) > 0) {~~
	~~echo "<p>$s</p>" . PHP_EOL;~~
	}
	}

	~~sqlsrv_free_stmt($stmt);~~
	~~sqlsrv_close($conn);~~

	~~function formatErrors($errors)~~
	{
	~~// Display errors~~
	~~echo "Error information: <br/>";~~
	~~foreach ($errors as $error) {~~
	~~echo "SQLSTATE: ". $error['SQLSTATE'] . "<br/>";~~
	~~echo "Code: ". $error['code'] . "<br/>";~~
	~~echo "Message: ". $error['message'] . "<br/>";~~
	}
	~~}</syntaxhighlight>~~

2021-03-22T15:16:53Z

← Older revision		Revision as of 15:16, 22 March 2021
Line 14:		Line 14:
	<hr/>		<hr/>
	{{EpiphanyHelpText\|53}}		{{EpiphanyHelpText\|53}}
			<syntaxhighlight lang="php"><?php
			$serverName = "sql01.crystalcomputer.com";
			$connectionOptions = array(
			"database" => "epiphany",
			"uid" => "epiphany",
			"pwd" => "ccc"
			);

			// Establishes the connection
			$conn = sqlsrv_connect($serverName, $connectionOptions);
			if ($conn === false) {
			die(formatErrors(sqlsrv_errors()));
			}
			$hid=intval($_GET['hid']);

			// Select Query
			$tsql = "SELECT FlexScreenDetail.HelpText as HelpText
			FROM FlexScreenMaster
			LEFT JOIN Relationships Rel1 ON Rel1.ObjectID1=5 AND Rel1.ItemID1=FlexScreenMaster.ID AND Rel1.ObjectID2=6 AND Rel1.Type=0
			LEFT JOIN FlexScreenDetail ON FlexScreenDetail.ID=Rel1.ItemID2
			WHERE FlexScreenMaster.ID = $hid;";

			// Executes the query
			$stmt = sqlsrv_query($conn, $tsql);

			// Error handling
			if ($stmt === false) {
			die(formatErrors(sqlsrv_errors()));
			}

			while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)) {
			$s = ltrim(rtrim($row['HelpText']));
			if (strlen($s) > 0) {
			echo "<p>$s</p>" . PHP_EOL;
			}
			}

			sqlsrv_free_stmt($stmt);
			sqlsrv_close($conn);

			function formatErrors($errors)
			{
			// Display errors
			echo "Error information: <br/>";
			foreach ($errors as $error) {
			echo "SQLSTATE: ". $error['SQLSTATE'] . "<br/>";
			echo "Code: ". $error['code'] . "<br/>";
			echo "Message: ". $error['message'] . "<br/>";
			}
			}</syntaxhighlight>

2021-02-02T16:17:55Z

← Older revision		Revision as of 16:17, 2 February 2021
Line 11:		Line 11:
	[https://fontawesome.com/icons/ See all the icons]		[https://fontawesome.com/icons/ See all the icons]
	<hr/>		<hr/>
	{{EpiphanyHelpText\|1\|21}}		{{EpiphanyHelpText\|21}}
	<hr/>		<hr/>
	{{EpiphanyHelpText\|2\|53}}		{{EpiphanyHelpText\|53}}

2021-02-02T15:45:25Z

← Older revision		Revision as of 15:45, 2 February 2021
Line 11:		Line 11:
	[https://fontawesome.com/icons/ See all the icons]		[https://fontawesome.com/icons/ See all the icons]
	<hr/>		<hr/>
	{{EpiphanyHelpText\|21}}		{{EpiphanyHelpText\|1\|21}}
	<hr/>		<hr/>
	{{EpiphanyHelpText\|53}}		{{EpiphanyHelpText\|2\|53}}

2021-02-02T15:43:19Z

← Older revision		Revision as of 15:43, 2 February 2021
Line 11:		Line 11:
	[https://fontawesome.com/icons/ See all the icons]		[https://fontawesome.com/icons/ See all the icons]
	<hr/>		<hr/>
	{{EpiphanyHelpText\|53}}		{{EpiphanyHelpText\|21}}
	<hr/>		<hr/>
	{{EpiphanyHelpText\|53}}		{{EpiphanyHelpText\|53}}

2021-02-02T15:42:57Z

← Older revision		Revision as of 15:42, 2 February 2021
Line 11:		Line 11:
	[https://fontawesome.com/icons/ See all the icons]		[https://fontawesome.com/icons/ See all the icons]
	<hr/>		<hr/>
	{{EpiphanyHelpText\|21}}		{{EpiphanyHelpText\|53}}
	<hr/>		<hr/>
	{{EpiphanyHelpText\|53}}		{{EpiphanyHelpText\|53}}