Error code arabic lang

Username (e.g. epiz_XXX) or Website URL

http://st-timothy-g.epizy.com
(please specify the website or account you are asking about)
in site arabic language appear ???"when get data from database " but in sql database appear correct letters

code

</html>
</head>
<html>
  <head>
            <meta http-equiv="Content-Type" content="text/html;charset=UTF-8">
            <meta charset="UTF-8">
<body>
	<div class="container mt-5">
		<div class="row">
		    <h1 class="w3-xxlarge">ST.Timothy.G (saint Timothy gathering ) </h1>
            <meta http-equiv="Content-Type" content="text/html;charset=UTF-8">
            <meta charset="UTF-8">
			<div class="col-xl-12 col-lg-12 col-md-12 col-12 m-auto">
				<table class="table table-bordered table-hovered table-striped" id="productTable">
					<thead>
						<th> User name </th>
						<th> Group Name</th>
						<th> scores </th>

					
					</thead>

					<tbody>

					<?php 
						foreach($products as $product) : ?>

							<tr>
                                <td> <?php echo "<a  href=\"detailed.php?product_id=".$product['idUser']."\"> ".$product['nameUser'] ." </a>"; ?> </td>
                                <td> <?php echo $product['NameGroup']; ?> </td>
								<td> <?php echo $product['SUM(`score`)']; ?> </td>

							</tr>


						<?php endforeach; ?>	
					</tbody>	
				</table>
			</div>
		</div>
	</div>

	<script src="https://code.jquery.com/jquery-3.2.1.slim.min.js"></script>
	<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.12.9/umd/popper.min.js"></script>
	<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap.min.js"></script>

	<!-- CDN jQuery Datatable -->
	<script type="text/javascript" charset="utf8" src="https://cdn.datatables.net/1.10.19/js/jquery.dataTables.js"></script>
</head>
</body>
</html>


If I understood correctly, the intention is to store Arabic
only sometimes show ???? chars

6 Likes

thanks alot

1 Like

the soulution
set
$mysqli → set_charset(“utf8”);
in connection sql

2 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.