mysqli::set_charset

Exemple

Exemple 1 - style orienté objet

Modifiez le jeu de caractères du client par défaut:

 <span class="token php language-php"><span class="token delimiter important"><? Php</span>
<span class="token variable">$ mysqli</span> <span class="token operator">=</span> <span class="token keyword">new</span> <span class="token class-name">mysqli</span> <span class="token punctuation">(</span> <span class="token string double-quoted-string">"localhost"</span> <span class="token punctuation">,</span> <span class="token string double-quoted-string">"my_user"</span> <span class="token punctuation">,</span> <span class="token string double-quoted-string">"my_password"</span> <span class="token punctuation">,</span> <span class="token string double-quoted-string">"my_db"</span> <span class="token punctuation">)</span> <span class="token punctuation">;</span>

<span class="token keyword">if</span> <span class="token punctuation">(</span> <span class="token variable">$ mysqli</span> <span class="token operator">-></span> <span class="token property">connect_errno</span> <span class="token punctuation">)</span> <span class="token punctuation">{</span>
  <span class="token keyword">Echo</span> <span class="token string double-quoted-string">"n&#39;a pas réussi à se connecter à MySQL:"</span> <span class="token operator">.</span> <span class="token variable">$ mysqli</span> <span class="token operator">-></span> <span class="token property">connect_error</span> <span class="token punctuation">;</span>
  <span class="token keyword">sortie</span> <span class="token punctuation">(</span> <span class="token punctuation">)</span> <span class="token punctuation">;</span>
<span class="token punctuation">}</span>

<span class="token keyword">Echo</span> <span class="token string double-quoted-string">"Le jeu de caractères initial est:"</span> <span class="token operator">.</span> <span class="token variable">$ mysqli</span> <span class="token operator">-></span> <span class="token function">caractères_set_name</span> <span class="token punctuation">(</span> <span class="token punctuation">)</span> <span class="token punctuation">;</span>

<span class="token comment">// modifie le jeu de caractères sur UTF8</span>
<span class="token variable">$ mysqli</span> <span class="token operator">-></span> <span class="token function">set_charset</span> <span class="token punctuation">(</span> <span class="token string double-quoted-string">"utf8"</span> <span class="token punctuation">)</span> <span class="token punctuation">;</span>

<span class="token keyword">Echo</span> <span class="token string double-quoted-string">"Le jeu de caractères actuel est:"</span> <span class="token operator">.</span> <span class="token variable">$ mysqli</span> <span class="token operator">-></span> <span class="token function">caractères_set_name</span> <span class="token punctuation">(</span> <span class="token punctuation">)</span> <span class="token punctuation">;</span>

<span class="token variable">$ mysqli</span> <span class="token operator">-></span> <span class="token function">close</span> <span class="token punctuation">(</span> <span class="token punctuation">)</span> <span class="token punctuation">;</span>
<span class="token delimiter important">?></span></span>

Exemple 2 - Style procédural

Modifiez le jeu de caractères du client par défaut:

 <span class="token php language-php"><span class="token delimiter important"><? Php</span>
<span class="token variable">$ con</span> <span class="token operator">=</span> <span class="token function">mysqli_connect</span> <span class="token punctuation">(</span> <span class="token string double-quoted-string">"localhost"</span> <span class="token punctuation">,</span> <span class="token string double-quoted-string">"my_user"</span> <span class="token punctuation">,</span> <span class="token string double-quoted-string">"my_password"</span> <span class="token punctuation">,</span> <span class="token string double-quoted-string">"my_db"</span> <span class="token punctuation">)</span> <span class="token punctuation">;</span>

<span class="token comment">// Vérifiez la connexion</span>
<span class="token keyword">if</span> <span class="token punctuation">(</span> <span class="token function">mysqli_connect_errno</span> <span class="token punctuation">(</span> <span class="token punctuation">)</span> <span class="token punctuation">)</span> <span class="token punctuation">{</span>
  <span class="token keyword">Echo</span> <span class="token string double-quoted-string">"n&#39;a pas réussi à se connecter à MySQL:"</span> <span class="token operator">.</span> <span class="token function">mysqli_connect_error</span> <span class="token punctuation">(</span> <span class="token punctuation">)</span> <span class="token punctuation">;</span>
  <span class="token keyword">sortie</span> <span class="token punctuation">;</span>
<span class="token punctuation">}</span>

<span class="token keyword">Echo</span> <span class="token string double-quoted-string">"Le jeu de caractères initial est:"</span> <span class="token operator">.</span> <span class="token function">mysqli_character_set_name</span> <span class="token punctuation">(</span> <span class="token variable">$ con</span> <span class="token punctuation">)</span> <span class="token punctuation">;</span>

<span class="token comment">// modifie le jeu de caractères sur UTF8</span>
<span class="token function">mysqli_set_charset</span> <span class="token punctuation">(</span> <span class="token variable">$ con</span> <span class="token punctuation">,</span> <span class="token string double-quoted-string">"utf8"</span> <span class="token punctuation">)</span> <span class="token punctuation">;</span>

<span class="token keyword">Echo</span> <span class="token string double-quoted-string">"Le jeu de caractères actuel est:"</span> <span class="token operator">.</span> <span class="token function">mysqli_character_set_name</span> <span class="token punctuation">(</span> <span class="token variable">$ con</span> <span class="token punctuation">)</span> <span class="token punctuation">;</span>

<span class="token function">mysqli_close</span> <span class="token punctuation">(</span> <span class="token variable">$ con</span> <span class="token punctuation">)</span> <span class="token punctuation">;</span>
<span class="token delimiter important">?></span></span>