title: Arabic language not store in mysql/php
body: <p>Arabic language not store in mysql/php</p>
  
  <p>i'm try to insert this query but it is store <strong>???? ???? ?? ????</strong>.</p>
  
  <p><code>INSERT INTO school_name (en_school_name, ar_school_name) VALUES ('some data', 'روضة احمد بنبل')</code></p>
  
  <p>For solution i have add this </p>
  
  <pre><code>ini_set('default_charset', 'utf-8');
  header('Content-type: text/html; charset=utf-8');
  mysqli_set_charset($conn,"utf8");
  mysqli_query($conn,"SET NAMES 'utf8'");
  mysqli_query($conn,'SET CHARACTER SET utf8'); 
  </code></pre>
  
  <p>and also prefer this Question but not work in my case, <a href="https://stackoverflow.com/questions/6859018/save-data-in-arabic-in-mysql-database">Save Data in Arabic in MySQL database</a></p>
  
  <p>if i'm run query manually it's work fine but when i'm try to insert query with this </p>
  
  <pre><code>$sql = "INSERT INTO school_name (en_school_name, ar_school_name)
          VALUES ('".$dat_val_en."', '".$dat_val_ar."')";
  
  if ($conn-&gt;query($sql) === TRUE) {
      echo "New record created successfully";
  } else {
      echo "Error: " . $sql . "&lt;br&gt;" . $conn-&gt;error; 
      echo "&lt;br&gt;";
  }
  </code></pre>
  
  <p>it is store <strong>???? ???? ?? ????</strong>. 
  <strong>Table structure</strong></p>
  
  <p><a href="https://i.stack.imgur.com/OQZUS.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/OQZUS.png" alt="enter image description here"></a></p>