6 
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Test</title>
</head>
<body>
<form action="" method="post" name="theform">
  <table width="693" border="1" style="table-layout:fixed;">
    <tr>
      <td width="683" id="mymessage" contenteditable="true" name="mymessage">Write message here...</td>
    </tr>
  </table>
  <script>
document.getElementById('mymessage').addEventListener('input', function() {
    document.getElementById('hiddenInput').value = this.innerHTML;
     console.log(document.getElementById('hiddenInput').value);
});

document.getElementById("mymessage").addEventListener("click", removePlace);    
function removePlace()
{
    document.getElementById("mymessage").innerHTML="";
}
</script>
<div id="google_translate_element"><span class="notranslate">Select language to translate your text above:</span></div>
<script type="text/javascript">
function googleTranslateElementInit() 
{
  new google.translate.TranslateElement({pageLanguage: 'en', includedLanguages: 'en,fr,it,ja,ko,ms,ru,ta,th,zh-CN', layout: google.translate.TranslateElement.InlineLayout.SIMPLE, multilanguagePage: true}, 'google_translate_element');
}
</script><script type="text/javascript" src="//translate.google.com/translate_a/element.js?cb=googleTranslateElementInit"></script>
<input type="hidden" id='hiddenInput' name='hiddenInput'>
  <span class="notranslate"><input type="submit" id="btnSend" name="btnSend" value="Send"></span>
</form>
<?php
$servername = "localhost";
$username = "mytranslateim";
$password = "qwerty";
$dbname = "test";
$dbconnectivity = mysqli_connect($servername, $username, $password, $dbname);
if (isset($_POST['btnSend']))
{
    $getmsg = $_POST['hiddenInput'];
    if($getmsg == "")
    {
        echo "nothing";
    }
    else
    {
    echo $getmsg;
    $sql = "INSERT INTO testing(testmsg) VALUES ('$getmsg')";//if i translated a text, for example i translate the word "test" in chinese, it will echo in chinese but will not save in database as chinese 
    $insertit = mysqli_query($dbconnectivity, $sql);
    }
}
?>
</body>
</html>

I want to save a translated text inside a php mysql table. Currently, the system will echo in translated text but it will not save in the database as the text i typed. For example, if i type the word "test" and translate it to japanese as "テスト", the database will save the word "test" and not "テスト". how can i make it save the translated text?

10
  • what collation has the field testmsg?
    – SnakeFoot
    Commented Mar 30, 2016 at 8:22
  • you probably have to check this out : dev.mysql.com/doc/refman/5.5/en/charset-charsets.html
    – SnakeFoot
    Commented Mar 30, 2016 at 8:23
  • hi, the collation involved inside is utf8_bin
    – Ivan
    Commented Mar 30, 2016 at 8:24
  • Try $mysqli->query("SET NAMES utf8"); before mysqli_query($dbconnectivity, $sql);
    – SASM
    Commented Mar 30, 2016 at 8:29
  • 1
    I dont think is the collalation problem because i can save japanese characters if i insert from mysql.
    – Ivan
    Commented Mar 30, 2016 at 8:29

1 Answer 1

Reset to default
0

You can use the Google Translation API to translate given post/get data with PHP directly. Than save it to any storage.

There is a good documentation here:

Example (from the docs):

<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Test</title>
</head>
<body>
<form method="post" accept-charset="utf-8">
  <input type="text" name="translate" value="enter your text to translate..." />
  <input type="submit" name="submit" value="translate" />
</form>
</body>
</html>
<?php
if (isset($_POST['submit']) {
# Includes the autoloader for libraries installed with composer
require __DIR__ . '/vendor/autoload.php';

# Imports the Google Cloud client library
use Google\Cloud\Translate\TranslateClient;

# Your Google Cloud Platform project ID
$projectId = 'YOUR_PROJECT_ID';

# Instantiates a client
$translate = new TranslateClient([
    'projectId' => $projectId
]);

# The text to translate
$text = $_POST['translate'];
# The target language
$target = 'jp';

# Translates some text into Russian
$translation = $translate->translate($text, [
    'target' => $target
]);

# This is the result. You can save it to any storage.
echo 'Text: ' . $text . '
Translation: ' . $translation['text'];
}
?>

You can extend the example with a language select-box as well.

Not the answer you're looking for? Browse other questions tagged or ask your own question.