<?php require_once('../../Connections/conngenchem.php'); ?>
<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}

$editFormAction = $HTTP_SERVER_VARS['PHP_SELF'];
if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
  $editFormAction .= "?" . $HTTP_SERVER_VARS['QUERY_STRING'];
}

if ((isset($HTTP_POST_VARS["MM_insert"])) && ($HTTP_POST_VARS["MM_insert"] == "form1")) {
  $insertSQL = sprintf("INSERT INTO copperamminedata (`Time`, `Value1`, `Value2`) VALUES (%s, %s, %s)",
                       GetSQLValueString($HTTP_POST_VARS['Time'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['Value1'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['Value2'], "text"));

  mysql_select_db($database_conngenchem, $conngenchem);
  $Result1 = mysql_query($insertSQL, $conngenchem) or die(mysql_error());

  $insertGoTo = "index.php";
  if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
    $insertGoTo .= $HTTP_SERVER_VARS['QUERY_STRING'];
  }
}

mysql_select_db($database_conngenchem, $conngenchem);
$query_rs1 = "SELECT Trial, `Time`, Value1, Value2, value3, value4, (MONTH(mod_timestamp)), (DAYOFMONTH(mod_timestamp)), (YEAR(mod_timestamp)), (HOUR(mod_timestamp)), (MINUTE(mod_timestamp)) FROM copperamminedata ORDER BY Time ASC";
$rs1 = mysql_query($query_rs1, $conngenchem) or die(mysql_error());
$row_rs1 = mysql_fetch_assoc($rs1);
$totalRows_rs1 = mysql_num_rows($rs1);

mysql_select_db($database_conngenchem, $conngenchem);
$query_rs2 = "SELECT Trial, (MONTH(mod_timestamp)), (DAYOFMONTH(mod_timestamp)), (YEAR(mod_timestamp)), (HOUR(mod_timestamp)), (MINUTE(mod_timestamp)) FROM copperamminedata ORDER BY Trial DESC";
$rs2 = mysql_query($query_rs2, $conngenchem) or die(mysql_error());
$row_rs2 = mysql_fetch_assoc($rs2);
$totalRows_rs2 = mysql_num_rows($rs2);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Copper Mine Data</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="../../styles/basictext.css" rel="stylesheet" type="text/css">
</head>

<body onLoad="MM_preloadImages('../../Library/imagesalt/mainpage_f3.gif','../../Library/imagesalt/mainpage_f2.gif','../../Library/imagesalt/mainpage_f4.gif','../../Library/imagesalt/lectures_f3.gif','../../Library/imagesalt/lectures_f2.gif','../../Library/imagesalt/lectures_f4.gif','../../Library/imagesalt/lab_f3.gif','../../Library/imagesalt/lab_f2.gif','../../Library/imagesalt/lab_f4.gif','../../Library/imagesalt/webct_f3.gif','../../Library/imagesalt/webct_f2.gif','../../Library/imagesalt/webct_f4.gif','../../Library/imagesalt/tas_f3.gif','../../Library/imagesalt/tas_f2.gif','../../Library/imagesalt/tas_f4.gif','../../Library/imagesalt/students_f3.gif','../../Library/imagesalt/students_f2.gif','../../Library/imagesalt/students_f4.gif','../../Library/imagesalt/staff_f3.gif','../../Library/imagesalt/staff_f2.gif','../../Library/imagesalt/staff_f4.gif')">
<script language="JavaScript">
<!--
function MM_reloadPage(init) {  //reloads the window if Nav4 resized
  if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
    document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
  else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
// -->
</script>
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}

function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}

function MM_nbGroup(event, grpName) { //v6.0
  var i,img,nbArr,args=MM_nbGroup.arguments;
  if (event == "init" && args.length > 2) {
    if ((img = MM_findObj(args[2])) != null && !img.MM_init) {
      img.MM_init = true; img.MM_up = args[3]; img.MM_dn = img.src;
      if ((nbArr = document[grpName]) == null) nbArr = document[grpName] = new Array();
      nbArr[nbArr.length] = img;
      for (i=4; i < args.length-1; i+=2) if ((img = MM_findObj(args[i])) != null) {
        if (!img.MM_up) img.MM_up = img.src;
        img.src = img.MM_dn = args[i+1];
        nbArr[nbArr.length] = img;
    } }
  } else if (event == "over") {
    document.MM_nbOver = nbArr = new Array();
    for (i=1; i < args.length-1; i+=3) if ((img = MM_findObj(args[i])) != null) {
      if (!img.MM_up) img.MM_up = img.src;
      img.src = (img.MM_dn && args[i+2]) ? args[i+2] : ((args[i+1])? args[i+1] : img.MM_up);
      nbArr[nbArr.length] = img;
    }
  } else if (event == "out" ) {
    for (i=0; i < document.MM_nbOver.length; i++) {
      img = document.MM_nbOver[i]; img.src = (img.MM_dn) ? img.MM_dn : img.MM_up; }
  } else if (event == "down") {
    nbArr = document[grpName];
    if (nbArr)
      for (i=0; i < nbArr.length; i++) { img=nbArr[i]; img.src = img.MM_up; img.MM_dn = 0; }
    document[grpName] = nbArr = new Array();
    for (i=2; i < args.length-1; i+=2) if ((img = MM_findObj(args[i])) != null) {
      if (!img.MM_up) img.MM_up = img.src;
      img.src = img.MM_dn = (args[i+1])? args[i+1] : img.MM_up;
      nbArr[nbArr.length] = img;
  } }
}

function MM_displayStatusMsg(msgStr) { //v1.0
  status=msgStr;
  document.MM_returnValue = true;
}

function MM_swapImgRestore() { //v3.0
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
//-->
</script><body onLoad="MM_preloadImages('imagesalt/mainpage_f3.gif','imagesalt/mainpage_f2.gif','imagesalt/mainpage_f4.gif','imagesalt/lectures_f3.gif','imagesalt/lectures_f2.gif','imagesalt/lectures_f4.gif','imagesalt/lab_f3.gif','imagesalt/lab_f2.gif','imagesalt/lab_f4.gif','imagesalt/webct_f3.gif','imagesalt/webct_f2.gif','imagesalt/webct_f4.gif','imagesalt/tas_f3.gif','imagesalt/tas_f2.gif','imagesalt/tas_f4.gif','imagesalt/students_f3.gif','imagesalt/students_f2.gif','imagesalt/students_f4.gif','imagesalt/staff_f3.gif','imagesalt/staff_f2.gif','imagesalt/staff_f4.gif')"> 
<!-- #BeginLibraryItem "/Library/genchemalt.lbi" -->
<table width="680" border="0" align="center" cellpadding="0" cellspacing="0">
<!-- fwtable fwsrc="genchemalt.png" fwbase="genchemalt.gif" fwstyle="Dreamweaver" fwdocid = "742308039" fwnested="0" -->
  <tr>
   <td><img src="../../Library/imagesalt/spacer.gif" width="15" height="1" border="0" alt=""></td><td><img src="../../Library/imagesalt/spacer.gif" width="90" height="1" border="0" alt=""></td><td><img src="../../Library/imagesalt/spacer.gif" width="1" height="1" border="0" alt=""></td><td><img src="../../Library/imagesalt/spacer.gif" width="2" height="1" border="0" alt=""></td><td><img src="../../Library/imagesalt/spacer.gif" width="88" height="1" border="0" alt=""></td><td><img src="../../Library/imagesalt/spacer.gif" width="2" height="1" border="0" alt=""></td><td><img src="../../Library/imagesalt/spacer.gif" width="1" height="1" border="0" alt=""></td><td><img src="../../Library/imagesalt/spacer.gif" width="89" height="1" border="0" alt=""></td><td><img src="../../Library/imagesalt/spacer.gif" width="1" height="1" border="0" alt=""></td><td><img src="../../Library/imagesalt/spacer.gif" width="2" height="1" border="0" alt=""></td><td><img src="../../Library/imagesalt/spacer.gif" width="88" height="1" border="0" alt=""></td><td><img src="../../Library/imagesalt/spacer.gif" width="2" height="1" border="0" alt=""></td><td><img src="../../Library/imagesalt/spacer.gif" width="1" height="1" border="0" alt=""></td><td><img src="../../Library/imagesalt/spacer.gif" width="89" height="1" border="0" alt=""></td><td><img src="../../Library/imagesalt/spacer.gif" width="3" height="1" border="0" alt=""></td><td><img src="../../Library/imagesalt/spacer.gif" width="90" height="1" border="0" alt=""></td><td><img src="../../Library/imagesalt/spacer.gif" width="2" height="1" border="0" alt=""></td><td><img src="../../Library/imagesalt/spacer.gif" width="1" height="1" border="0" alt=""></td><td><img src="../../Library/imagesalt/spacer.gif" width="89" height="1" border="0" alt=""></td><td><img src="../../Library/imagesalt/spacer.gif" width="3" height="1" border="0" alt=""></td><td><img src="../../Library/imagesalt/spacer.gif" width="21" height="1" border="0" alt=""></td><td><img src="../../Library/imagesalt/spacer.gif" width="1" height="1" border="0" alt=""></td></tr>

  <tr>
   <td colspan="21"><img name="genchemalt_r1_c1" src="../../Library/imagesalt/genchemalt_r1_c1.gif" width="680" height="29" border="0" usemap="#m_genchemalt_r1_c1" alt="General Chemistry Navigation Header"></td><td><img src="../../Library/imagesalt/spacer.gif" width="1" height="29" border="0" alt=""></td></tr>
  <tr>
   <td rowspan="3"><img name="genchemalt_r2_c1" src="../../Library/imagesalt/genchemalt_r2_c1.gif" width="15" height="33" border="0" alt="General Chemistry Navigation Header"></td><td rowspan="3" colspan="2"><a href="../../index.asp" target="_top" onClick="MM_nbGroup('down','navbar1','mainpage','../../Library/imagesalt/mainpage_f3.gif',1)" onMouseOver="MM_displayStatusMsg('GenChem main page');MM_nbGroup('over','mainpage','../../Library/imagesalt/mainpage_f2.gif','../../Library/imagesalt/mainpage_f4.gif',1);return document.MM_returnValue" onMouseOut="MM_swapImgRestore();MM_nbGroup('out');"><img name="mainpage" src="../../Library/imagesalt/mainpage.gif" width="91" height="33" border="0" alt="GenChem main page"></a></td><td rowspan="3" colspan="3"><a href="../../lectures/index.asp" target="_top" onClick="MM_nbGroup('down','navbar1','lectures','../../Library/imagesalt/lectures_f3.gif',1)" onMouseOver="MM_displayStatusMsg('Current lectures');MM_nbGroup('over','lectures','../../Library/imagesalt/lectures_f2.gif','../../Library/imagesalt/lectures_f4.gif',1);return document.MM_returnValue" onMouseOut="MM_swapImgRestore();MM_nbGroup('out');"><img name="lectures" src="../../Library/imagesalt/lectures.gif" width="92" height="33" border="0" alt="Current lectures"></a></td><td rowspan="3" colspan="3"><a href="../index.asp" target="_top" onClick="MM_nbGroup('down','navbar1','lab','../../Library/imagesalt/lab_f3.gif',1)" onMouseOver="MM_displayStatusMsg('Laboratory materials');MM_nbGroup('over','lab','../../Library/imagesalt/lab_f2.gif','../../Library/imagesalt/lab_f4.gif',1);return document.MM_returnValue" onMouseOut="MM_swapImgRestore();MM_nbGroup('out');"><img name="lab" src="../../Library/imagesalt/lab.gif" width="91" height="33" border="0" alt="Materials for lab"></a></td><td rowspan="3" colspan="3"><a href="../../webct/index.asp" target="_top" onClick="MM_nbGroup('down','navbar1','webct','../../Library/imagesalt/webct_f3.gif',1)" onMouseOver="MM_displayStatusMsg('WebCT');MM_nbGroup('over','webct','../../Library/imagesalt/webct_f2.gif','../../Library/imagesalt/webct_f4.gif',1);return document.MM_returnValue" onMouseOut="MM_swapImgRestore();MM_nbGroup('out');"><img name="webct" src="../../Library/imagesalt/webct.gif" width="92" height="33" border="0" alt="WebCT"></a></td><td rowspan="3" colspan="3"><a href="../../tas/resources/index.asp" target="_top" onClick="MM_nbGroup('down','navbar1','tas','../../Library/imagesalt/tas_f3.gif',1)" onMouseOver="MM_displayStatusMsg('Teaching assistants');MM_nbGroup('over','tas','../../Library/imagesalt/tas_f2.gif','../../Library/imagesalt/tas_f4.gif',1);return document.MM_returnValue" onMouseOut="MM_swapImgRestore();MM_nbGroup('out');"><img name="tas" src="../../Library/imagesalt/tas.gif" width="93" height="33" border="0" alt="Teaching assistants"></a></td><td rowspan="3" colspan="2"><a href="../../students/index.asp" target="_top" onClick="MM_nbGroup('down','navbar1','students','../../Library/imagesalt/students_f3.gif',1)" onMouseOver="MM_displayStatusMsg('Information for students');MM_nbGroup('over','students','../../Library/imagesalt/students_f2.gif','../../Library/imagesalt/students_f4.gif',1);return document.MM_returnValue" onMouseOut="MM_swapImgRestore();MM_nbGroup('out');"><img name="students" src="../../Library/imagesalt/students.gif" width="92" height="33" border="0" alt="Student information"></a></td><td rowspan="3" colspan="3"><a href="../../staff/index.asp" target="_top" onClick="MM_nbGroup('down','navbar1','staff','../../Library/imagesalt/staff_f3.gif',1)" onMouseOver="MM_displayStatusMsg('Information for faculty and staff');MM_nbGroup('over','staff','../../Library/imagesalt/staff_f2.gif','../../Library/imagesalt/staff_f4.gif',1);return document.MM_returnValue" onMouseOut="MM_swapImgRestore();MM_nbGroup('out');"><img name="staff" src="../../Library/imagesalt/staff.gif" width="93" height="33" border="0" alt="Faculty and staff info"></a></td><td rowspan="3"><img name="genchemalt_r2_c21" src="../../Library/imagesalt/genchemalt_r2_c21.gif" width="21" height="33" border="0" alt="General Chemistry Navigation Header"></td><td><img src="../../Library/imagesalt/spacer.gif" width="1" height="1" border="0" alt=""></td></tr>
  <tr>
   <td><img src="../../Library/imagesalt/spacer.gif" width="1" height="24" border="0" alt=""></td></tr>
  <tr>
   <td><img src="../../Library/imagesalt/spacer.gif" width="1" height="8" border="0" alt=""></td></tr>
<map name="m_genchemalt_r1_c1">
<area shape="poly" coords="338,12,461,12,461,29,338,29,338,12" href="#" title="Chemistry department home page" alt="Chemistry department home page" >
<area shape="poly" coords="220,12,338,12,338,29,220,29,220,12" href="#" title="UW-Madison home page" alt="UW-Madison home page" >
</map>
</table><!-- #EndLibraryItem -->
<p><!-- #BeginLibraryItem "/Library/TextNavBar.lbi" --> 
<link rel="stylesheet" href="../../styles/basictext.css" type="text/css">
<script language="JavaScript">
function breadCrumbs(base, delStr, defp, cStyle, tStyle, dStyle, nl) {
    loc = window.location.toString();
    subs = loc.substr(loc.indexOf(base) + base.length + 1).split("/");
    document.write("<a href=\"" + getLoc(subs.length - 1) + defp + "\" class=\"" + cStyle + "\">Home</a>  " + "<span class=\"" + dStyle + "\">" + delStr + "</span> ");
    a = (loc.indexOf(defp) == -1) ? 1 : 2;
    for (i = 0; i < (subs.length - a); i++) {
        subs[i] = makeCaps(unescape(subs[i]));
        document.write("<a href=\"" + getLoc(subs.length - i - 2) + defp + "\" class=\"" + cStyle + "\">" + subs[i] + "</a>  " + "<span class=\"" + dStyle + "\">" + delStr + "</span> ");
    }
    if (nl == 1) {
        document.write("<br>");
    }
    document.write("<span class=\"" + tStyle + "\">" + document.title + "</span>");
}

function makeCaps(a) {
    g = a.split(" ");
    for (l = 0; l < g.length; l++) {
        g[l] = g[l].toUpperCase().slice(0, 1) + g[l].slice(1);
    }
    return g.join(" ");
}
 
function getLoc(c) {
    var d = "";
    if (c > 0) {
        for (k = 0; k < c; k++) {
            d = d + "../";
        }
    }
    return d;
}
 </script>
<div align="center" width="100%"> 
  <p><span class="basictextoutdent"><u>Page tracking links</u>: 
    <script language="JavaScript">
 breadCrumbs("genchem.chem.wisc.edu",">>","index.asp","link1","basictextoutdent","headoutdented","0");
</script>
    </span></p>
  </div>
<!-- #EndLibraryItem --><p></p>
<p align="center"><img src="../../images/redline.png" width="100%" height="3"></p>
<p align="center" class="lgheadoutdentedbold">Chem 104 (Landis) Copper Mine Lab</p>
<?php if ($totalRows_rs1 == 0) { // Show if recordset empty ?>
<p align="center" class="lgheadoutdentedbold">There is currently no Copper Mine 
Data</p>
<?php } // Show if recordset empty ?>

<?php if ($totalRows_rs1 > 0) { // Show if recordset not empty ?>
<p align="center" class="lgheadoutdentedbold">Current Copper Mine Data<br>
<span class="basictextoutdent">(Sorted by Elapsed Time)</span><br>
<span class="basictextoutdent">Last entry: <?php echo $row_rs2['(MONTH(mod_timestamp))']; ?>-<?php echo $row_rs2['(DAYOFMONTH(mod_timestamp))']; ?>-<?php echo $row_rs2['(YEAR(mod_timestamp))']; ?> 
<?php echo $row_rs2['(HOUR(mod_timestamp))']; ?>:<?php echo $row_rs2['(MINUTE(mod_timestamp))']; ?> 
</span></p>
<table width="80%" border="1" align="center" cellpadding="1"  cellspacing="1" bordercolor="#FFFFFF" class="basictextoutdent">
<tr bgcolor="#999999"> 
<th width="10%" scope="col">Entry number</th>
<th width="14%" scope="col">Elapsed time<br>
(hours)</th>
<th width="12%" scope="col">pH<br>
(&quot;C&quot;)</th>
<th width="22%" scope="col">Cu(II) ion<br>
concentration<br>
(g/L) (&quot;C&quot;)</th>
<th width="14%" scope="col">pH<br>
(&quot;D&quot;)</th>
<th width="28%" scope="col">Cu(II) ion<br>
concentration<br>
(g/L) (&quot;D&quot;)</th>
</tr>
<?php do { ?>
<tr bgcolor="#CCCCCC"> 
<td> 
<div align="center"><?php echo $row_rs1['Trial']; ?></div></td>
<td> 
<div align="center"><?php echo $row_rs1['Time']; ?></div></td>
<td> 
<div align="center"><?php echo $row_rs1['Value1']; ?></div></td>
<td> 
<div align="center"><?php echo $row_rs1['Value2']; ?></div></td>
<td><center>
<?php echo $row_rs1['value3']; ?> </center></td>
<td><center>
<?php echo $row_rs1['value4']; ?> </center></td>
</tr>
<?php } while ($row_rs1 = mysql_fetch_assoc($rs1)); ?>
</table>
<?php } // Show if recordset not empty ?>
<p align="center" class="headoutdentedbold"><a href="add.php">Add, edit, or delete 
data&#8230;</a></p>
<p align="center" class="headoutdentedbold">&nbsp;</p>
<p align="center" class="basictextoutdented">&nbsp;</p>
<p align="left" class="headoutdentedbold"><!-- #BeginLibraryItem "/Library/Footer.lbi" --><!-- #BeginLibraryItem "/Library/Basicemailfedosky@.lbi" -->
<link rel="stylesheet" href="../../styles/basictext.css" type="text/css"><div class="basictextoutdent" align="center" width="100%"> <!-- #BeginLibraryItem "/Library/footer_080703.lbi" --> 
<p align="center"><br>
  <font size="1" face="Verdana, Arial, Helvetica, sans-serif">If you have any questions 
  about this website or web page, email the GenChem webmaster, Diana Duff, at</font><br>
  <a href="mailto:dlduff@facstaff.wisc.edu" class=link1 onMouseOver="className='link2'" onMouseOut="className='link1'">dlduff@facstaff.wisc.edu.</a></p>
</div><!-- #EndLibraryItem --></p> 
<p></p>
</body>
</html>
<?php
mysql_free_result($rs1);

mysql_free_result($rs2);
?>

