--- a +++ b/uinterface/wordsuggest.php @@ -0,0 +1,84 @@ +<?php +/*function conn() { + $mysqli = new mysqli('localhost', 'user', 'pass', 'cteligible'); + $mysqli->set_charset('utf8'); + return $mysqli; +} +*/ + +function conn() { + $mysqli = new mysqli('localhost', 'user', 'pass', 'cteligible'); + $mysqli->set_charset('utf8'); + + return $mysqli; +} + +function wordFunction($input) { + //lookup $input in database + $mysqli = new mysqli('localhost', 'user', 'pass', 'cteligible'); + $mysqli->set_charset('utf8'); + + $query= $mysqli->prepare("SELECT cscore FROM wordsuggest_tbl WHERE words=?"); + $query->bind_param('s',$input); + + $query->execute(); + $result = $query->get_result(); + $return = $result->fetch_all(); + + var_dump($return); + + // $query= "SELECT words, cscore FROM wordsuggest_tbl WHERE "; +// $results = get query results, hopefully with mysqli; +// $otherWordsFromDatabase = ? +// $returnedHTML = "<span class='wordsuggest' title='"; +// $returnedHTML .= $results["words"]; +// $returnedHTML .= ">" . $input . "</span>"; +// echo $returnedHTML; +echo "Test CSCORE"; + } + +// python3 parseInputSentence.py "Within 36 days prior to registration you must not have treatment"; +// Score: 31 + +?> +<!-- +<p>This is a <?php // wordFunction("word"); ?>.</p> +--> + +<!-- +mysql> +CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20), species VARCHAR(20), sex CHAR(1), birth DATE, death DATE); + +It's better to use the Platelet and the Haemoglobin Trial Data. Concentrate on the Numbers for Now. +Return the Scores for each criteria and also the weighted score for all the criteria on the page. + +DROP TABLE wordsuggest_tbl; + +CREATE TABLE IF NOT EXISTS wordsuggest_tbl (sn INT(255) NOT NULL AUTO_INCREMENT, cid VARCHAR(255) NOT NULL,words VARCHAR(255) NOT NULL, cscore VARCHAR(20) NOT NULL, PRIMARY KEY (sn))ENGINE=INNODB; + +INSERT INTO wordsuggest_tbl VALUES ('',"Within 36 days prior to registration you must not have treatment",'31'); + +INSERT INTO wordsuggest_tbl VALUES ('','40.2',"Platelet count greater than or equal to 100000 platelets per cubic milimeter",'58'); + +DESCRIBE wordsuggest_tbl; + +SELECT * FROM wordsuggest_tbl; + +CREATE TABLE parent ( + id INT NOT NULL, + PRIMARY KEY (id) +) ENGINE=INNODB; + +Severe, active co-morbidity, defined as follows: + +HIV_CTEPTrials_072018 + +Exclusion + +* Acquired immune deficiency syndrome (AIDS) based upon current Centers for Disease Control and Prevention (CDC) definition; note: human immunodeficiency virus (HIV) testing is not required for entry into this protocol; protocol-specific requirements may also exclude immuno-compromised patients + +AIDS excluded; immunocompromised excluded + + + +--> \ No newline at end of file