require('util2.php'); extract($_REQUEST); $term = ''; $date = date("Y-m-d"); $sql = " select GLOSSARY.term, GLOSSARY.definition from GLOSSARY, GLOSSARY_X_REF where GLOSSARY.term = ? or GLOSSARY_X_REF.alt_term = ? and GLOSSARY.term = GLOSSARY_X_REF.term "; $link = dbconnect(); if ($stmt = mysqli_prepare($link, $sql)) { /* bind parameters for markers */ mysqli_stmt_bind_param($stmt, "ss", $word, $word); /* execute query */ mysqli_stmt_execute($stmt); /* bind result variables */ mysqli_stmt_bind_result($stmt, $term, $definition); /* fetch value */ mysqli_stmt_fetch($stmt); /* close statement */ mysqli_stmt_close($stmt); } /* close connection */ mysqli_close($link); $term = trim($term); $definition = trim($definition); $title = ucfirst($term); if ($term=='') { $title = 'Term not found'; } ?>
echo "$definition"; ?> |
Close this window |