Member Avatar for FreshGe

Hello can you help me add utf-8 coding to this query
$settings = dbarray(dbquery ("SELECT * FROM ".DB_SETTINGS ));
it displayes whole mysql data

echo $settings;
echo $settings;
echo $settings;
etc

  • 2 Contributors
  • 1 Reply
  • 57 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by colweb
Member Avatar for colweb

Not sure what it is what you want. If you have your tables all utf-8 encoded and want your php script and queries to do the same all you need is

<?php
header('Content-type: text/html; charset=UTF-8');

to get php to work in utf-8 and

if (!$db->set_charset("utf8")) {
	echo "<p>Error: ".$db->error."</p>";
	echo "<p>Please contact your database administrator.</p>";
        exit();
}

($db = new mysql.... ) so all data in your queries go in utf-8 as well.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.