Advertisement
Guest User

I HAVE NO IDEA HOW TO SOLVE THIS

a guest
Sep 2nd, 2015
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.21 KB | None | 0 0
  1. <main>
  2.  
  3. <?php
  4.  
  5. //Define $text to use in form
  6.  
  7. if(isset($_POST['translate'])){
  8.  
  9.     $text = $_POST['text'];
  10.  
  11. }else{
  12.  
  13.     $text = '';
  14.  
  15. }
  16.  
  17. ?>
  18.  
  19.     <form action="" method="post">
  20.  
  21.         <textarea name="text" placeholder="Type text to be translated"><?php echo $text ?></textarea><br>
  22.  
  23.         <input type="submit" name="translate" value="translate">
  24.  
  25.     </form>
  26.  
  27. <?php
  28.  
  29. //predefine empty variables and arrays
  30.  
  31. $stringArray = [];
  32.  
  33. $allKeys = [];
  34.  
  35. $allTranslate = [];
  36.  
  37. $keys = [];
  38.  
  39. $translate = [];
  40.  
  41. $dbArr = [];
  42.  
  43. $finArray =[];
  44.  
  45. //explode input $text into array $stringArray
  46.  
  47. $stringArray = explode(' ', $text);
  48.  
  49. //If languages are specified, add those to the query, if not take Faroese and English as default
  50.  
  51. if(isset($_GET['langone']) && isset($_GET['langtwo'])){
  52.  
  53.     $sql = "SELECT one.word as word, two.word AS trans_to
  54.         FROM words one
  55.         INNER JOIN words two
  56.         ON one.numberInLang = two.numberInLang
  57.         WHERE one.numberInLang = two.numberInLang
  58.         AND one.languageId = {$_GET['langone']}
  59.         AND two.languageId = {$_GET['langtwo']};";
  60.  
  61. }else{
  62.  
  63.     $sql = "SELECT one.word as word, two.word AS trans_to
  64.         FROM words one
  65.         INNER JOIN words two
  66.         ON one.numberInLang = two.numberInLang
  67.         WHERE one.numberInLang = two.numberInLang
  68.         AND one.languageId = 1
  69.         AND two.languageId = 2;";
  70.  
  71. }
  72.  
  73. //Send query to database
  74.  
  75. $translateQuery = $con->query($sql);
  76.  
  77. //take the whole database and put it into two arrays, $allKeys and $allTranslate
  78.  
  79. while($trans = $translateQuery->fetch_object()){
  80.  
  81.     $allKeys[].= $trans->word;
  82.  
  83.     $allTranslate[].= $trans->trans_to;
  84.  
  85. }
  86.  
  87. //Figure out what input does not exist in $allTranslate and output it
  88.  
  89. foreach($stringArray as $value){
  90.  
  91.     if(!in_array($value, $allTranslate)){
  92.  
  93.         echo "{$value}<br>";
  94.  
  95.     }
  96.  
  97. }
  98.  
  99. //Put $allKeys as key in $dbArr and $allTranslate as value in $dbArr
  100.  
  101. for($i = 0; $i <= count($allTranslate); $i++) {
  102.  
  103.     $dbArr[$allKeys[$i]].= $allTranslate[$i];
  104.  
  105. }
  106.  
  107.     echo '<br><br>stringArray<pre>';
  108.     var_dump($stringArray);
  109.     echo '</pre>';
  110.  
  111.     echo 'dbArr<pre>';
  112.     var_dump($dbArr);
  113.     echo '</pre>';
  114.  
  115.  
  116. if(isset($_POST['translate']) && $text == ''){
  117.  
  118.     echo "You haven't typed anything";
  119.  
  120. }elseif($text == ''){
  121.  
  122.     echo "No entry";
  123.  
  124. }
  125.  
  126. ?>
  127.  
  128. </main>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement