| Poster |
Nucleophiles & Bases |
Lewis Acid/Base Interaction Matrix Database
0)
{
$query = "SELECT HTML FROM LAB_matrix_info WHERE cell_id = ".$entity_id."";
$result3 = mysqli_query($conn, $query) or die('Query www failed 99: ' . mysqli_error());
while($rowz = mysqli_fetch_row($result3)) { echo $rowz[0]; }
echo "
".$entity_name."
![](\"http://www.chemthes.com/icon_2/".$entity_id.".gif\")
|
";
$query = "SELECT name, data_04.entity_id FROM data_02 , data_04 WHERE generic_id = ".$entity_id." AND data_02.entity_id = data_04.entity_id AND common = 1 ORDER BY abc_name";
$result3 = mysqli_query($conn, $query) or die('Query www failed: ' . mysqli_error());
while($rowz = mysqli_fetch_row($result3)) {
echo "
![](http://www.chemthes.com/icon_1/".$rowz[1].".gif\")
|
".$rowz[0]."
more here
|
";
}
echo "
";
}
?>
0)
{
$queryTYPE = "SELECT name FROM data_10 WHERE type_id = ".$rxn_id;
$resultTYPE = mysqli_query($conn, $queryTYPE) or die('Error Type TTT: ' . mysqli_error());
while($rowTYPE = mysqli_fetch_array($resultTYPE, mysqli_NUM))
{
list($name) = $rowTYPE;
$contentTYPE .= "$name
\r\n";
}
$rxn_typeNAME = $contentTYPE;
echo "
";
echo "Interactions and reactions classified as:
".$rxn_typeNAME."";
echo " |
";
$query = "SELECT data_07.rxn_id, LHS1_stoich, LHS1_id, LHS2_stoich, LHS2_id, LHS3_stoich, LHS3_id, LHS4_stoich, LHS4_id, LHS5_stoich, LHS5_id, arrow_id, RHS1_stoich, RHS1_id, RHS2_stoich, RHS2_id, RHS3_stoich, RHS3_id, RHS4_stoich, RHS4_id, RHS5_stoich, RHS5_id, RHS6_stoich, RHS6_id
FROM data_07, data_09
WHERE data_07.rxn_id = data_09.rxn_id AND data_09.type_id = ".$rxn_id."";
$result = mysqli_query($conn, $query) or die('Error Type ppp: ' . mysqli_error());
while(list($rxn_id, $LHS1_stoich, $LHS1_id, $LHS2_stoich, $LHS2_id, $LHS3_stoich, $LHS3_id, $LHS4_stoich, $LHS4_id, $LHS5_stoich, $LHS5_id, $arrow_id, $RHS1_stoich, $RHS1_id, $RHS2_stoich, $RHS2_id, $RHS3_stoich, $RHS3_id, $RHS4_stoich, $RHS4_id, $RHS5_stoich, $RHS5_id, $RHS6_stoich, $RHS6_id) = mysqli_fetch_array($result))
{
//this is to set the plus signs between entities
$LHS2plus = ""; if($LHS2_id > 0) $LHS2plus = "+";
$LHS3plus = ""; if($LHS3_id > 0) $LHS3plus = "+";
$LHS4plus = ""; if($LHS4_id > 0) $LHS4plus = "+";
$LHS5plus = ""; if($LHS5_id > 0) $LHS5plus = "+";
$RHS2plus = ""; if($RHS2_id > 0) $RHS2plus = "+";
$RHS3plus = ""; if($RHS3_id > 0) $RHS3plus = "+";
$RHS4plus = ""; if($RHS4_id > 0) $RHS4plus = "+";
$RHS5plus = ""; if($RHS5_id > 0) $RHS5plus = "+";
$RHS6plus = ""; if($RHS6_id > 0) $RHS6plus = "+";
//This is to account fo null stoichiometries
$LHS1st = ""; if($LHS1_stoich > 0) $LHS1st = $LHS1_stoich;
$LHS2st = ""; if($LHS2_stoich > 0) $LHS2st = $LHS2_stoich;
$LHS3st = ""; if($LHS3_stoich > 0) $LHS3st = $LHS3_stoich;
$LHS4st = ""; if($LHS4_stoich > 0) $LHS4st = $LHS4_stoich;
$LHS5st = ""; if($LHS5_stoich > 0) $LHS5st = $LHS5_stoich;
$RHS1st = ""; if($RHS1_stoich > 0) $RHS1st = $RHS1_stoich;
$RHS2st = ""; if($RHS2_stoich > 0) $RHS2st = $RHS2_stoich;
$RHS3st = ""; if($RHS3_stoich > 0) $RHS3st = $RHS3_stoich;
$RHS4st = ""; if($RHS4_stoich > 0) $RHS4st = $RHS4_stoich;
$RHS5st = ""; if($RHS5_stoich > 0) $RHS5st = $RHS5_stoich;
$RHS6st = ""; if($RHS6_stoich > 0) $RHS6st = $RHS6_stoich;
//This is to set null entity_id
$LHS1gif = "0.png"; if($LHS1_id > 0) $LHS1gif = $LHS1_id."png";
$LHS2gif = "0.png"; if($LHS2_id > 0) $LHS2gif = $LHS2_id."png";
$LHS3gif = "0.png"; if($LHS3_id > 0) $LHS3gif = $LHS3_id."png";
$LHS4gif = "0.png"; if($LHS4_id > 0) $LHS4gif = $LHS4_id."png";
$LHS5gif = "0.png"; if($LHS5_id > 0) $LHS5gif = $LHS5_id."png";
$RHS1gif = "0.png"; if($RHS1_id > 0) $RHS1gif = $RHS1_id."png";
$RHS2gif = "0.png"; if($RHS2_id > 0) $RHS2gif = $RHS2_id."png";
$RHS3gif = "0.png"; if($RHS3_id > 0) $RHS3gif = $RHS3_id."png";
$RHS4gif = "0.png"; if($RHS4_id > 0) $RHS4gif = $RHS4_id."png";
$RHS5gif = "0.png"; if($RHS5_id > 0) $RHS5gif = $RHS5_id."png";
$RHS6gif = "0.png"; if($RHS6_id > 0) $RHS6gif = $RHS6_id."png";
echo "
|
$LHS1st |  |
$LHS2plus | $LHS2st |  |
$LHS3plus | $LHS3st |  |
$LHS4plus | $LHS4st |  |
$LHS5plus | $LHS5st |  |
 |
$RHS1st |  |
$RHS2plus | $RHS2st |  |
$RHS3plus | $RHS3st |  |
$RHS4plus | $RHS4st |  |
$RHS5plus | $RHS5st |  |
$RHS6plus | $RHS6st |  |
|
";
}
echo "
";
}
?>
| Poster |
Nucleophiles & Bases |
© Mark R. Leach 1999 –
Queries,
Suggestions, Bugs, Errors, Typos...
If you have any:
Queries
Comments
Suggestions
Suggestions for links
Bug, typo or grammatical error reports about this page,
please contact Mark R. Leach, the author, using mark@meta-synthesis.com
This free, open
access web book is an ongoing project and your input is appreciated.
