<h1 class="H02"><span class="NEW2">NEW</span>RHYMES</h1> <img src="images/cloudunderline.png" alt="" class="img"/> </div> <div class="col-md-8 horoadd"> <img src="images/horoadd.png" alt="" class="img-responsive"/> </div> </div> <div class="col-md-12 div6 div606"> <div class="clearfix"></div> <br/> <?php $rhymes = getRhymes(); if ($rhymes > 0) { while ($rhyme = mysql_fetch_array($rhymes)) { ?> <a href="view-rhyme.php?id=<?php echo $rhyme['rhyme_id']; ?> "> <div style="width:19%; float:left; border:#000 px solid; margin-left:10px;color: #fff; height:180px;"> <img src="rhymes/<?php echo $rhyme['rhyme_image']; ?> " alt="<?php echo $rhyme['rhyme_name']; ?> " class="img-responsive img-thumbnail"/>
<?php require_once 'connect.inc.php'; $postdata = file_get_contents("php://input"); $request = json_decode($postdata, true); $wordObj = $request; $rhymeResults = getRhymes($wordObj, 1000); if ($rhymeResults == 'false') { echo 'no rhymes found'; exit; } // echo count($rhymeResults); echo json_encode($rhymeResults); function getRhymes($word, $frequency) { $max_syllables = $word['syllables'] + 2; $query = "SELECT text, rhyme_text, first_pos, all_pos, end_letter, syllables, frequency FROM words WHERE last_vowels=? AND syllables<=? ORDER BY CASE WHEN rhyme_text=? AND end_text=? THEN '1' WHEN end_text=? THEN '2' ELSE '3' end, end_text, syllables, frequency desc"; $query_Params = array("sisss", &$word['last_vowels'], &$max_syllables, &$word['rhyme_text'], &$word['end_text'], &$word['end_text']); $results = query($query, $query_Params); return $results; } function query($query, $queryParams) { global $conn; if ($results = $conn->prepare($query)) { //$results->bind_param("s",$word); call_user_func_array(array($results, 'bind_param'), $queryParams); $results->execute(); //!! This object contains all rows $rows = $results->get_result(); // $nouns=get_nouns($rows);