jquery - Php page display some strange symbols instead of BULLETED LISTS from CSV file?

Solution:

This is because different text-encoding (character set) is being used in your database and the text document displaying the bulleted list.

You should set you database and documents to use the same character set, usually UTF8.

For the database, you can do it in PHPMyAdmin, or if you are using PHP mysqli you can use the following PHP code:

$db->set_charset("utf8")
Copy code

In your documents, save with encoding UTF-8.

However, as pointed out in the comments, you should also separate out your data and presentation. The database should only hold data, your application decides how it should be displayed. Consider a situation where your app might need to display the data somewhere else, maybe with a different bullet?

As Saurabh says, save your data without bullets on separate lines. Then display them using:

echo '<ul><li>' . str_replace("\n", '</li><li>', $lines) . '</li></ul>'
Copy code

Also, it would be a good idea to put your styling into a separate CSS file.

Solution:

This means, there are different encodings.

In HTML you have to put

<meta charset="utf-8"> 
Copy code

at the beginning,in PHP you have to add

$db->set_charset("utf8");
Copy code

and at your database you have to set your charset also as utf-8-general.

Then it should work :)