Foreign language characters in my mysql Data Base?

Foreign language characters in my mysql Data Base?

Is the connection to the database also UTF-8 encoded?

Give this a try: right after connecting to the mysql database, run the following query.

SET NAMES utf8;

Great! It worked wonderfully! I added $conn->query('SET NAMES utf8'); Thanks again!

mysql_query("SET NAMES utf8");
[Google Ads]

POPULAR POSTS ::

Add multiple upload box

Image
include_once("includes/header.php"); if(isset($_REQUEST['submit'])){ $c1 = rand(0,9);$c2 = rand(0,9);$c3 = rand(0,9);$c4 = rand(0,9); $rand = $c1.$c2.$c3.$c4; for($i=0;$i { if($_FILES['upload_photo']['name'][$i]!="") { $dir_path = $res.$rand.$_FILES['upload_photo']['name'][$i]; $dir_path1.= $res.$rand.$_FILES['upload_photo']['name'][$i].","; } if(move_uploaded_file($_FILES['upload_photo']['tmp_name'][$i],'upload/'.$dir_path)) { } } $insert_upload="insert into ".MY_UPLOADS." set `userid`='".$_SESSION['USERID']."',`files`='$dir_path1',`date`='".date("Y-m-d h:m:s")."'"; $out_upload=mysql_query($insert_upload); $MSG="File uploaded successfully !..It will be posted after admin review!"; echo " "; } ?> ...
Read more

String Separation

str_replace function str_replace is a string function that replaces occurrences of a substring with another substring. Syntax : str_replace(find, replace, string, count) Parameters: -find: The substring to search for. -replace: The substring to replace with. -string: The original string. -count(optional): The number of replacements made. Example: $string = "Hello, welcome world!"; $new_string = str_replace("world", "universe", $string); echo $new_string; // Output: "Hello, universe!" strlen() fnction is a PHP function that returns the length of a string. Syntax: strlen(string) Parameter: -string: The input string Return Value: The length of the string (integer). Example: $string = "Hello, World!"; $length = strlen($string); echo $length; // Output: 13 [Google Ads]   PHP->IMAGE UPLOAD : (UPLOAD IMAGES using Move upload function) $image_file1 = $_FILES['file']['name']; $c1 = ran...
Read more

The top Web development PHP frameworks

Image
The top Web development PHP frameworks : A good framework can help you develop a PHP application quickly, with more simplicity, and with a vision of 'best-practices-oriented'. Examine this list of 9 great PHP frameworks and provide your preference or a new link to a framework not included in this list. 1. Laravel PHP Framework   Regardless of your level of experience with PHP web frameworks, Laravel is a framework that can adapt to your needs.   Laravel's web application framework is both expressive and elegant in its syntax. This framework has a starting point that allows you to concentrate on creating something amazing while we handle the details.   Laravel is committed to providing an incredible developer experience by offering powerful features like thorough dependency injection, an expressive database abstraction layer, queues and scheduled jobs, unit and integration testing, and more.   It is a popular choice for building rich web applications due to its restfu...
Read more

Only number restrictions

Image
a Jipsoft Techonologies venture Home | Profile | Contact | Faq | Feedback   Donor Login User ID Password Forgot Password? Today's Blood Request Warning : mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/blood/include/header1.php on line 104 Warning : mysql_fetch_array(): supplied argument is not a valid MySQL result resou...
Read more

HTML Document structure and it's Syntax format

  HTML Document structure and it's Syntax format: HTML is the abbreviation for Hypertext Markup Language, which is utilized to make HTML web pages that are displayed on browsers. The set of rules and guidelines that make HTML code work is known as its syntax.    HTML Syntax Structure Overview    Angle brackets (<unk> and >) are used to enclose tags that represent elements in HTML documents.  The fundamental idea is that an HTML element consists of a start tag, content, and a closing end tag.    <start tagname>content</end tagname>      The arrangement of tags is usually in pairs, with the opening tag preceding the content and the closing tag following it.In closing tags, the tag name is preceded by a forward slash (/).    [Google Ads] Example looks like:    <b>This is a paragraph element.</b>        HTML tags, which are not visible in a bro...
Read more

Add and Separate more records by comma operator

session_start(); ob_start(); include "include/connect.php"; include "include/settings.php"; if($_REQUEST['fiedname']=='prisonname'){ $arr=explode(",",$_SESSION['prisonname']); $arr1=explode(",",$_SESSION['prisonnumber']); $value=$_REQUEST['value']; for($a=0;$a { if($a!=$value){ $prisonnamenew.=$arr[$a].","; }else{ } } for($a=0;$a { if($a!=$value){ $prisonnumbernew.=$arr1[$a].","; }else{ } } //Avoid semicolon $prisonnamenewarray=explode(",",$prisonnamenew); for($n=0;$n { if($prisonnamenewarray[$n]!=''){ if((sizeof($prisonnamenewarray)-2)!=$n){ $prisonnamenew1.=$prisonnamenewarray[$n].","; }else{ $prisonnamenew1.=$prisonnamenewarray[$n]; } } } $prisonnumbernewarray=explode(",",$prisonnumbernew); for($n=0;$n { if($prisonnumbernewarray[$n]!=''){ if((sizeof($prisonnumbernewarray)-2)!=$n){ ...
Read more

Addslashes

Error 1: in mysql db we cant fetch the record by value while using 'type =tEXT' and also addslashes it is better to use varchar or mediumtext
Read more