Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <main>
- <?php
- //Define $text to use in form
- if(isset($_POST['translate'])){
- $text = $_POST['text'];
- }else{
- $text = '';
- }
- ?>
- <form action="" method="post">
- <textarea name="text" placeholder="Type text to be translated"><?php echo $text ?></textarea><br>
- <input type="submit" name="translate" value="translate">
- </form>
- <?php
- //predefine empty variables and arrays
- $stringArray = [];
- $allKeys = [];
- $allTranslate = [];
- $keys = [];
- $translate = [];
- $dbArr = [];
- $finArray =[];
- //explode input $text into array $stringArray
- $stringArray = explode(' ', $text);
- //If languages are specified, add those to the query, if not take Faroese and English as default
- if(isset($_GET['langone']) && isset($_GET['langtwo'])){
- $sql = "SELECT one.word as word, two.word AS trans_to
- FROM words one
- INNER JOIN words two
- ON one.numberInLang = two.numberInLang
- WHERE one.numberInLang = two.numberInLang
- AND one.languageId = {$_GET['langone']}
- AND two.languageId = {$_GET['langtwo']};";
- }else{
- $sql = "SELECT one.word as word, two.word AS trans_to
- FROM words one
- INNER JOIN words two
- ON one.numberInLang = two.numberInLang
- WHERE one.numberInLang = two.numberInLang
- AND one.languageId = 1
- AND two.languageId = 2;";
- }
- //Send query to database
- $translateQuery = $con->query($sql);
- //take the whole database and put it into two arrays, $allKeys and $allTranslate
- while($trans = $translateQuery->fetch_object()){
- $allKeys[].= $trans->word;
- $allTranslate[].= $trans->trans_to;
- }
- //Figure out what input does not exist in $allTranslate and output it
- foreach($stringArray as $value){
- if(!in_array($value, $allTranslate)){
- echo "{$value}<br>";
- }
- }
- //Put $allKeys as key in $dbArr and $allTranslate as value in $dbArr
- for($i = 0; $i <= count($allTranslate); $i++) {
- $dbArr[$allKeys[$i]].= $allTranslate[$i];
- }
- echo '<br><br>stringArray<pre>';
- var_dump($stringArray);
- echo '</pre>';
- echo 'dbArr<pre>';
- var_dump($dbArr);
- echo '</pre>';
- if(isset($_POST['translate']) && $text == ''){
- echo "You haven't typed anything";
- }elseif($text == ''){
- echo "No entry";
- }
- ?>
- </main>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement