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
<br /> <br /> <br /><?php session_start(); ob_start(); <br /> <br />include_once("includes/header.php"); <br /> <br /> <br /> <br /> <br /> <br /> <br />if(isset($_REQUEST['submit'])){ <br /> <br />$c1 = rand(0,9);$c2 = rand(0,9);$c3 = rand(0,9);$c4 = rand(0,9); <br />$rand = $c1.$c2.$c3.$c4; <br /> <br />for($i=0;$i<count($_FILES['upload_photo']['name']);$i++) <br />{ <br />if($_FILES['upload_photo']['name'][$i]!="") <br />{ <br /> $dir_path = $res.$rand.$_FILES['upload_photo']['name'][$i]; <br /> $dir_path1.= $res.$rand.$_FILES['upload_photo']['name'][$i].","; <br />} <br /> <br />if(move_uploaded_file($_FILES['upload_photo']['tmp_name'][$i],'upload/'.$dir_path)) <br />{ <br />} <br /&
Read more

String Separation

PHP->IMAGE UPLOAD : (UPLOAD IMAGES using Move upload function) $image_file1 = $_FILES['file']['name']; $c1 = rand(0,9);$c2 = rand(0,9);$c3 = rand(0,9);$c4 = rand(0,9); $rand = $c1.$c2.$c3.$c4; $date = mktime(); if($image_file1!='') { move_uploaded_file($_FILES['file']['tmp_name'],'../video/'.$rand.$_FILES['file']['name']); $path1 = '../video/'.$rand.$_FILES['file']['name']; } ================================================================================================= PHP->JAVASCRIPT VALIDATION : (for listbox checked) var Item=form.template.selectedIndex; var Result=form.template.options[Item].value; if(Result=="") { alert("select anyone of the template");form.template.focus();return false; } --------------------------------------- $date = date('l,F j,Y'); monday,j
Read more

Only number restrictions

Image
<br /><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <br /><html xmlns="http://www.w3.org/1999/xhtml"> <br /><head> <br /><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <br /><title></title> <br /><link rel="stylesheet" href="style.css" type="text/css" /> <br /></head> <br /><body > <br /><table width="1000" border="0" cellspacing="0" cellpadding="0" align="center"> <br /> <br /> <tr> <br /> <td><table width="100%" border="0" cellspacing="0" cellpadding="0"> <br /> <tr> <br /> <br /> <td><table width="100%" bord
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

Add and Separate more records by comma operator

<br /> <br /> <br /> <? <br /> session_start(); ob_start(); <br /> include "include/connect.php"; <br />include "include/settings.php"; <br />if($_REQUEST['fiedname']=='prisonname'){ <br /> <br />$arr=explode(",",$_SESSION['prisonname']); <br />$arr1=explode(",",$_SESSION['prisonnumber']); <br />$value=$_REQUEST['value']; <br /> <br />for($a=0;$a<sizeof($arr);$a++) <br />{ <br />if($a!=$value){ <br /> $prisonnamenew.=$arr[$a].","; <br />}else{ } <br />} <br /> <br />for($a=0;$a<sizeof($arr1);$a++) <br />{ <br />if($a!=$value){ <br /> $prisonnumbernew.=$arr1[$a].","; <br />}else{ } <br />} <br /> <br />//Avoid semicolon <br />$prisonnamenewarray=explode(",",$prisonnamenew); <br />for($n=0;$
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 restful routi
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 browser, determine the document's display. It describes the structure of a Web page. It i
Read more