Tutorialshore
if special characters are not displaying in php .if it is showing like “?” use below steps
1)Add below meta tag in between <head></head> section <meta charset=”utf-8” />
2) Use htmlentities function to display mysql query result
$value=htmlentities($row[‘name’]);
echo $value;
Database connection php mysql code
$servername = “localhost”;
$username = “username”;
$password = “password”;
$conn = mysql_connect($servername, $username, $password);
To select a database
mysql_select_db($con,”mydatabse”);
yes, it is possible priority of search in mysql Full text search.we can define priority of search by adding + and – before search phrase in boolean mode
+ means include that word
– means Excluding that word
For E.g SELECT * FROM product_table WHERE MATCH (column1, column2) AGAINST (‘”+mobile -charger”‘ IN BOOLEAN MODE);
it will only search for only mobiles in db , if it find “mobile charger ” it will skip that row.This way we can add priority of search in Full text search of MySQL.