HTML/PHP Database Dump - Revision history

Tikenn at 02:40, 19 March 2014

2014-03-19T02:40:29Z

Tikenn at 02:39, 19 March 2014

2014-03-19T02:39:37Z

Tikenn at 03:34, 18 January 2014

2014-01-18T03:34:36Z

Tikenn at 19:05, 23 October 2013

2013-10-23T19:05:33Z

Seung Park at 18:21, 23 October 2013

2013-10-23T18:21:42Z

Tikenn at 17:28, 23 October 2013

2013-10-23T17:28:28Z

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>
';
?>

@@ Line 46: / Line 46: @@
 ?>
 </syntaxhighlight>
 {{This Is Your Brain On Informatics}}
 [[Category:This Is Your Brain On Informatics]]

← Older revision		Revision as of 02:39, 19 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]]

@@ Line 1: / Line 1: @@
-<syntaxhighlight lang="php">
+<syntaxhighlight lang="php" enclose="div">
 <?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.

← Older revision		Revision as of 19:05, 23 October 2013
Line 46:		Line 46:
	?>		?>
	</syntaxhighlight>		</syntaxhighlight>
		+
		+	{{This Is Your Brain On Informatics}}

@@ Line 1: / Line 1: @@
-<pre>
+<syntaxhighlight lang="php">
-&lt;?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.
 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!!*/
 echo '
-&lt;html&gt;
+<html>
-   &lt;head&gt;
+   <head>
-     &lt;title&gt;Ooga&lt;/title&gt;
+     <title>Ooga</title>
-   &lt;/head&gt;
+   </head>
-   &lt;body&gt;
+   <body>
-     &lt;h1&gt;It is Tims Fault&lt;/h1&gt;
+     <h1>It is Tims Fault</h1>
-     &lt;table border="1"&gt;
+     <table border="1">
-       &lt;tr&gt;
+       <tr>
-         &lt;th&gt;Accession&lt;/th&gt;
+         <th>Accession</th>
-         &lt;th&gt;Ordered By&lt;/th&gt;
+         <th>Ordered By</th>
-         &lt;th&gt;Test&lt;/th&gt;
+         <th>Test</th>
-         &lt;th&gt;Turn Around Time&lt;/th&gt;
+         <th>Turn Around Time</th>
-         &lt;th&gt;Result&lt;/th&gt;
+         <th>Result</th>
-       &lt;/tr&gt;
+       </tr>
 ';
 $sql = "SELECT * FROM `test2`;";
@@ Line 30: / Line 30: @@
+{
 	echo '
-       &lt;tr&gt;
+       <tr>
-         &lt;td&gt;' . $row['accession'] . '&lt;/td&gt;
+         <td>' . $row['accession'] . '</td>
-         &lt;td&gt;' . $row['ordering'] . '&lt;/td&gt;
+         <td>' . $row['ordering'] . '</td>
-         &lt;td&gt;' . $row['test'] . '&lt;/td&gt;
+         <td>' . $row['test'] . '</td>
-         &lt;td&gt;' . $row['tat'] . '&lt;/td&gt;
+         <td>' . $row['tat'] . '</td>
-         &lt;td&gt;' . $row['result'] . '&lt;/td&gt;
+         <td>' . $row['result'] . '</td>
-       &lt;/tr&gt;
+       </tr>
 	'; /*This closes out the echo*/
+}
 echo '
-     &lt;/table&gt;
+     </table>
-   &lt;/body&gt;
+   </body>
-&lt;/html&gt;
+</html>
 ';
-?&gt;
+?>
-</pre>
+</syntaxhighlight>