HTML/PHP Database Dump - Revision history

Tikenn at 02:40, 19 March 2014

2014-03-19T02:40:29Z

← Older revision		Revision as of 21:40, 18 March 2014
Line 46:		Line 46:
	?>		?>
	</syntaxhighlight>		</syntaxhighlight>


	{{This Is Your Brain On Informatics}}		{{This Is Your Brain On Informatics}}

	[[Category:This Is Your Brain On Informatics]]		[[Category:This Is Your Brain On Informatics]]

Tikenn at 02:39, 19 March 2014

2014-03-19T02:39:37Z

← Older revision		Revision as of 21:39, 18 March 2014
Line 48:		Line 48:

	{{This Is Your Brain On Informatics}}		{{This Is Your Brain On Informatics}}

			[[Category:This Is Your Brain On Informatics]]

Tikenn at 03:34, 18 January 2014

2014-01-18T03:34:36Z

← Older revision		Revision as of 22:34, 17 January 2014
Line 1:		Line 1:
	<syntaxhighlight lang="php">		<syntaxhighlight lang="php" enclose="div">
	<?php		<?php
	$con = mysqli_connect("localhost", "gbs788db", "pw", "gbs788db"); //This references the database. We store it as a variable only so that we don't have to keep writing it out.		$con = mysqli_connect("localhost", "gbs788db", "pw", "gbs788db"); //This references the database. We store it as a variable only so that we don't have to keep writing it out.

Tikenn at 19:05, 23 October 2013

2013-10-23T19:05:33Z

← Older revision		Revision as of 14:05, 23 October 2013
Line 46:		Line 46:
	?>		?>
	</syntaxhighlight>		</syntaxhighlight>

			{{This Is Your Brain On Informatics}}

Seung Park at 18:21, 23 October 2013

2013-10-23T18:21:42Z

← Older revision		Revision as of 13:21, 23 October 2013
Line 1:		Line 1:
	<~~pre~~>		<syntaxhighlight lang="php">
	~~<~~?php		<?php
	$con = mysqli_connect("localhost", "gbs788db", "pw", "gbs788db"); //This references the database. We store it as a variable only so that we don't have to keep writing it out.		$con = mysqli_connect("localhost", "gbs788db", "pw", "gbs788db"); //This references the database. We store it as a variable only so that we don't have to keep writing it out.
	if(mysqli_connect_errno())		if(mysqli_connect_errno())
Line 9:		Line 9:
	/If we made it this far, it means that we successfully connected and made it to the next line. By putting echo, we are including html now!!/		/If we made it this far, it means that we successfully connected and made it to the next line. By putting echo, we are including html now!!/
	echo '		echo '
	~~<~~html~~>~~		<html>
	~~<~~head~~>~~		<head>
	~~<~~title~~>~~Ooga~~<~~/title~~>~~		<title>Ooga</title>
	~~<~~/head~~>~~		</head>
	~~<~~body~~>~~		<body>
	~~<~~h1~~>~~It is Tims Fault~~<~~/h1~~>~~		<h1>It is Tims Fault</h1>
	~~<~~table border="1"~~>~~		<table border="1">
	~~<~~tr~~>~~		<tr>
	~~<~~th~~>~~Accession~~<~~/th~~>~~		<th>Accession</th>
	~~<~~th~~>~~Ordered By~~<~~/th~~>~~		<th>Ordered By</th>
	~~<~~th~~>~~Test~~<~~/th~~>~~		<th>Test</th>
	~~<~~th~~>~~Turn Around Time~~<~~/th~~>~~		<th>Turn Around Time</th>
	~~<~~th~~>~~Result~~<~~/th~~>~~		<th>Result</th>
	~~<~~/tr~~>~~		</tr>
	';		';
	$sql = "SELECT * FROM `test2`;";		$sql = "SELECT * FROM `test2`;";
Line 30:		Line 30:
	{		{
	echo '		echo '
	~~<~~tr~~>~~		<tr>
	~~<~~td~~>~~' . $row['accession'] . '~~<~~/td~~>~~		<td>' . $row['accession'] . '</td>
	~~<~~td~~>~~' . $row['ordering'] . '~~<~~/td~~>~~		<td>' . $row['ordering'] . '</td>
	~~<~~td~~>~~' . $row['test'] . '~~<~~/td~~>~~		<td>' . $row['test'] . '</td>
	~~<~~td~~>~~' . $row['tat'] . '~~<~~/td~~>~~		<td>' . $row['tat'] . '</td>
	~~<~~td~~>~~' . $row['result'] . '~~<~~/td~~>~~		<td>' . $row['result'] . '</td>
	~~<~~/tr~~>~~		</tr>
	'; /This closes out the echo/		'; /This closes out the echo/
	}		}
	echo '		echo '
	~~<~~/table~~>~~		</table>
	~~<~~/body~~>~~		</body>
	~~<~~/html~~>~~		</html>
	';		';
	?~~>~~		?>
	</~~pre~~>		</syntaxhighlight>

Tikenn at 17:28, 23 October 2013

2013-10-23T17:28:28Z

← Older revision		Revision as of 12:28, 23 October 2013
Line 1:		Line 1:
	<?php		<pre>
	$con = mysqli_connect("~~computer~~", "~~user~~", "~~password~~", "~~database~~"); //This references the database. We store it as a variable only so that we don't have to keep writing it out.		<?php
			$con = mysqli_connect("localhost", "gbs788db", "pw", "gbs788db"); //This references the database. We store it as a variable only so that we don't have to keep writing it out.
	if(mysqli_connect_errno())		if(mysqli_connect_errno())
	{		{
Line 8:		Line 9:
	/If we made it this far, it means that we successfully connected and made it to the next line. By putting echo, we are including html now!!/		/If we made it this far, it means that we successfully connected and made it to the next line. By putting echo, we are including html now!!/
	echo '		echo '
	<html>		<html>
	<head>		<head>
	<title>Ooga</title>		<title>Ooga</title>
	</head>		</head>
	<body>		<body>
	<h1>It is Tims Fault</h1>		<h1>It is Tims Fault</h1>
	<table border="1">		<table border="1">
	<tr>		<tr>
	<th>Accession</th>		<th>Accession</th>
	<th>Ordered By</th>		<th>Ordered By</th>
	<th>Test</th>		<th>Test</th>
	<th>Turn Around Time</th>		<th>Turn Around Time</th>
	<th>Result</th>		<th>Result</th>
	</tr>		</tr>
	';		';
	$sql = "SELECT * FROM `~~table~~`;";		$sql = "SELECT * FROM `test2`;";
	$result = mysqli_query($con, $sql); //This does what we have been doing in SQL: connecting to the database, and then putting in the query.		$result = mysqli_query($con, $sql); //This does what we have been doing in SQL: connecting to the database, and then putting in the query.
	while ($row=mysqli_fetch_array($result))//This command just looks at a table row by row.		while ($row=mysqli_fetch_array($result))//This command just looks at a table row by row.
Line 29:		Line 30:
	{		{
	echo '		echo '
	<tr>		<tr>
	<td>' . $row['~~col1~~'] . '</td>		<td>' . $row['accession'] . '</td>
	<td>' . $row['~~col2~~'] . '</td>		<td>' . $row['ordering'] . '</td>
	<td>' . $row['~~col3~~'] . '</td>		<td>' . $row['test'] . '</td>
	<td>' . $row['~~col4~~'] . '</td>		<td>' . $row['tat'] . '</td>
	<td>' . $row[''] . '</td>		<td>' . $row['result'] . '</td>
	</tr>		</tr>
	'; /This closes out the echo/		'; /This closes out the echo/
	}		}
	echo '		echo '
	</table>		</table>
	</body>		</body>
	</html>		</html>
	';		';
	?>		?>
			</pre>

Tikenn: Created page with "
2013-10-23T17:22:17Z

Created page with "<?php $con = mysqli_connect("computer", "user", "password", "database"); //This references the database. We store it as a variable only so that we don't have to keep writing i..."

New page
<?php
$con = mysqli_connect("computer", "user", "password", "database"); //This references the database. We store it as a variable only so that we don't have to keep writing it out.
if(mysqli_connect_errno())
{
die("Could not connect: " . mysqli_connect_errno());//Kills the connection if an error and uses mysqli_connect_errno () to print a readable message to the screen
/The error number will pass as a zero if it is successful; otherwise it will include an error number. The "." is a concatenator. /
}
/If we made it this far, it means that we successfully connected and made it to the next line. By putting echo, we are including html now!!/
echo '
<html>
<head>
<title>Ooga</title>
</head>
<body>
<h1>It is Tims Fault</h1>
<table border="1">
<tr>
<th>Accession</th>
<th>Ordered By</th>
<th>Test</th>
<th>Turn Around Time</th>
<th>Result</th>
</tr>
';
$sql = "SELECT * FROM `table`;";
$result = mysqli_query($con, $sql); //This does what we have been doing in SQL: connecting to the database, and then putting in the query.
while ($row=mysqli_fetch_array($result))//This command just looks at a table row by row.
/This while loop allows the computer to keep going back in and getting another result/
{
echo '
<tr>
<td>' . $row['col1'] . '</td>
<td>' . $row['col2'] . '</td>
<td>' . $row['col3'] . '</td>
<td>' . $row['col4'] . '</td>
<td>' . $row[''] . '</td>
</tr>
'; /This closes out the echo/
}
echo '
</table>
</body>
</html>
';
?>