M2R_info/word.php at master · DragonSkyMine/M2R_info · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
<?php
ini_set('memory_limit', '-1');
include_once("dao.php");
echo "<pre>";
$dao = new dao();


$req = $dao->db->prepare("SELECT DISTINCT wordId FROM keywords");
$req->execute();
while ($donnee = $req->fetch()) {

  $word = $donnee['wordId'];
  //echo $word.'<br />';

  $req2 = $dao->db->prepare("SELECT COUNT(wordId) FROM keywords WHERE wordId = :word");
  $req2->execute(array(
      'word' => $word,
    )
  );
  $donnee2 = $req2->fetch();
  //print_r($donnee2);
  $val = pow(0.9, $donnee2[0]);
  //echo $val . "<br/>";

  $req3 = $dao->db->prepare("UPDATE keywords SET idF = :val WHERE wordId = :word");
  $req3->execute(array(
      'val' => $val,
      'word' => $word
    )
  );

}


echo "</pre>";


?>