Updating mysql table (UTF8) using form method

Question

I am trying to update a table query UTF8 using a form. Its displays in form but not able to edit. Please let me know what the fault in query?

<?php
error_reporting(E_ERROR | E_WARNING | E_PARSE);
require_once("./includeadmin/membersite_config.php");
require_once("./includeadmin/membersite_config_editorial.php");
include("database1.php");
if(!$fgmembersite->CheckLogin())
{
$fgmembersite->RedirectToURL("index.php");
exit;
}


$idi = $_POST['id2'];
$sql = mysql_connect("localhost","username","password");

if (!$sql) {
die ('Could not connect!: ' . mysql_error());
}
mysql_select_db("nam33_articles", $sql);
mysql_query("UPDATE editorial SET date = '$_POST[date]', tag =         
'$_POST[tag]', title = '$_POST[title]', small = '$_POST[small]', image = 
'$_POST[image]', smallimage = '$_POST[smallimage]', english = 
'$_POST[english]', full = '$_POST[full]') WHERE id_user = '$idi'");
?>

Can you use query line from my answer and echo it so we got the query and find the error on that query. — Sachin, Oct 15 '18 at 04:53
its all content converted to question marks. No error showing. Edited parts echoing successfully. But all content converted to question marks — Chathan, Oct 15 '18 at 06:08
Okay so question mark display on query or database if your query contains correct string and database contain ??? then you need to change Collation from database to utf16_bin — Sachin, Oct 15 '18 at 06:15
I changed the collation to utf16_bin...now its showing some Japanese characters. — Chathan, Oct 15 '18 at 06:18
refre this link https://stackoverflow.com/questions/20987358/inserting-data-to-mysql-in-malayalam — Sachin, Oct 15 '18 at 06:26
I changed. Echoing showing correctly. But the table not upadating. — Chathan, Oct 15 '18 at 06:31
Let us [continue this discussion in chat](https://chat.stackoverflow.com/rooms/181862/discussion-between-sachin-and-chathan). — Sachin, Oct 15 '18 at 06:32

Sachin · Accepted Answer · 2018-10-15T07:53:26.977

Update your query parameters and set utf8.

mysql_query("set names 'utf8'",$sql);
$query = "UPDATE editorial SET date = '".$_POST['date']."', tag = '".$_POST['tag']."', title = '".utf8_encode($_POST['title'])."', small = '".utf8_encode($_POST['small'])."', image = '".$_POST['image']."', smallimage = '".$_POST['smallimage']."', english = '".$_POST['english']."', full = '".utf8_encode($_POST['full'])."' WHERE id_user = '$idi'";
mysql_query($query);

Updating mysql table (UTF8) using form method

1 Answers1