The browser shows me "???" instead of UTF-8 characters
The browser shows me "???" instead of UTF-8 characters. What is the cause and how can I fix it?
Here is the HTML file:
<HTML>
<title>Search Engine</title>
<form action='search.php' method='GET'>
<font face='sans-serif' size='5'>
<center>
My Search Engine.<br>
<input type='text' size='50' name='search'> <input type='submit' name='submit' value='Search'><br>
</center>
</font>
<center><a href='submiturl.php'>Submit a URL</a></center>
</form>
</HTML>
This is the search.php:
<?php
//get data
$button = $_GET['submit'];
$search = $_GET['search'];
if (!$button)
echo "Please fill out the form";
else
{
if (strlen($search)<=2)
echo "The item you searched for was to small";
else
{
echo "You searched for <b>$search</b> <hr size='1'>";
//connect to database
mysql_connect('localhost','k_search','1234.');
mysql_select_db('k_search');
//explode search term
$search_exploded = explode(" ",$search);
foreach($search_exploded as $search_each)
{
//construct query
$x++;
if ($x==1)
$construct .= "keywords LIKE '%$search_each%'";
else
$construct .= " OR keywords LIKE '%$search_each%'";
}
//echo out construct
$construct = "SELECT * FROM searchengine WHERE $construct";
$run = mysql_query($construct);
$foundnum = mysql_num_rows($run);
if ($foundnum==0)
echo "No results found.";
else
{
echo "$foundnum results found.<p><hr size='1'>";
while ($runrows = mysql_fetch_assoc($run))
{
//get data
$title = $runrows['title'];
$desc = $runrows['description'];
$url = $runrows['url'];
echo "<b>$title</b><br>
$desc<br>
<a href='$url'>$url</a><p>";
}
}
}
}
?>
This is the submiturl.php:
<HTML>
<title>Search Engine</title>
<form action='submiturl.php' method='POST'>
<font face='sans-serif' size='5'>
<center>
Please fill out all fields to submit your URL.<br><br></font>
URL:<br><input type='text' size='50' name='url' value='http://www.'><br><br>
Site Name:<br><input type='text' size='50' name='title'><br><br>
Description (max 200 characters):<br><input type='text' size='50' name='description' maxlength='200'><br><br>
Keywords:<br><input type='text' size='50' name='keywords'><br><br>
<input type='submit' name='submit' value='Submit URL'>
</form>
<br><a href='index.html'>Go Back</a>
</center>
</HTML>
<?php
$submit = $_POST['submit'];
$title = $_POST['title'];
$description = $_POST['description'];
$url = $_POST['url'];
$keywords = $_POST['keywords'];
$connect = mysql_connect("localhost","k_search","1234.");
mysql_select_db("k_search");
if (开发者_如何学C!$title||!$description||!$url||!$keywords)
{
die ("<center>Please fill in all fields.</center>");
}
else
if ($submit)
{
mysql_query("INSERT INTO searchengine VALUES('','$title','$description','$url','$keywords')");
echo "<center>Website Submitted!</center>";
}
else
echo "<center>Please fill in all fields.</center>";
?>
This can have 2 causes:
- The DB wasn't instructed to use UTF-8 during
INSERT. - PHP wasn't instructed to use UTF-8 during echoing output.
To fix the one or other, read this: PHP UTF-8 cheatsheet.
That said, there are another problems in your code as well. The <font> and <center> tags are deprecated since 1998. Use CSS. Further the SQL is sensitive to SQL injection attacks. Sanitize your SQL parameters.
I used to struggle with "????????" characters, but I got the answer for me.
Try to use UTF-8 without BOM encoding for your PHP file. Notepad++ can handle this type of file encoding.
In Notepad++, just go to the Encoding then check UTF-8 without BOM.
If db is in utf-8-general-ci THEN you must set the php file Encoding to UTF-8
That works for me.
check you have declared a doc type and character set, this is often the cause..
I think the problem is with your "already set" table collation.
- Ensure that collation for the table is set to utf8_general_ci.
- Ensure that collation for every field in table is set to utf8_general_ci
you have to edit every field in the table for this :(
http://www.assistprogramming.com/wp-content/uploads/2007/09/table.jpg
加载中,请稍侯......
精彩评论