コード例 #1
0
ファイル: rhymes.php プロジェクト: azeemgolive/thefunkidsgame
<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"/>
コード例 #2
0
ファイル: getRhymes.php プロジェクト: andrieski/rhyme-space
<?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);