Difference between revisions of "HTML/PHP Database Dump"

From Pathology Education Instructional Resource
Jump to: navigation, search
(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...")
 
 
(5 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 +
<syntaxhighlight lang="php" enclose="div">
 
<?php
 
<?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.  
+
$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 23: Line 24:
 
       </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 30: Line 31:
 
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*/
Line 44: Line 45:
 
';
 
';
 
?>
 
?>
 +
</syntaxhighlight>
 +
 +
 +
{{This Is Your Brain On Informatics}}
 +
 +
[[Category:This Is Your Brain On Informatics]]

Latest revision as of 02:40, 19 March 2014

<?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())
{
	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 `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.
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['accession'] . '</td>
        <td>' . $row['ordering'] . '</td>
        <td>' . $row['test'] . '</td>
        <td>' . $row['tat'] . '</td>
        <td>' . $row['result'] . '</td>
      </tr>  
	'; /*This closes out the echo*/
}
echo '
    </table>
  </body>
</html>
';
?>