Webmaster2020.com

Sound like a problem in your regex.

If you post some of you code, we could check it out.

I usually create my own function and use it with usort: function num_sort($a,$b) { return strcmp($a[2],$b[2]); } And call it with usort($multi_array,"num_sort"); The array is in this case the second field named '2' (But you can give it any name you want). $multi_array['key1'][1]="valu...

You can create your own function:

Code: Select all

function search_multi_arr($needle,$haystack)
{
  foreach ($haystack as $key => $val)
  {
    if ($val[1] === $needle) return $key;
  }
  return null;
}

You can call the function with

Code: Select all

$key=search_multi_arr($search_value,$multi_array);

If you still have problems.
you can also use, in php:

Code: Select all

mb_internal_encoding("UTF-8");

It tells php to do everything in UTF-8 character-set.

You can test if your server and browser are "speaking" in UTF-8 with printing the following string. $test='Iñtërnâtiônàlizætiøn'; echo $test."\n"; If you don't see the string correctly, try adding the HTML line: <meta http-equiv="Content-Type" content="text/html; c...

Are your text string wrong in the database, or do you see the results in you browser. Because the problem with character set is that all programs need to know what character set is used. Not only the database server (MySQL), but also the application server (php/apache, ASP/IIS, ...) and your browser...

With MySQL you can give the following command: SELECT table_schema "database_name",sum( data_length + index_length ) / 1024 /1024 "Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema; This tells the size in MB. But you can install phpMyAdmin ( http://www.ph...

You probably set default-character-set=utf8 Under [client] in /etc/mysql/my.cnf You also need to set it under [mysqld] ; Actually character-set-server=utf8 would be better. This should take care of the Server characterset . For your database you have to do some additional steps. in MySQL give the fo...

You probably set default-character-set=utf8 Under [client] in /etc/mysql/my.cnf You also need to set it under [mysqld] ; Actually character-set-server=utf8 would be better. This should take care of the Server characterset . For your database you have to do some additional steps. in MySQL give the fo...

You can use TININT(1) to set a value of 1 bit (0 or 1).

But my personal favorite is EMNUM

Code: Select all

valuename enum('true','false') NOT NULL default 'false'

note: ENUM can have more then 2 values, up to 65,535.

Webmaster2020.com

Search found 197 matches

Re: PHP Warning: preg_match(): Compilation failed: missing

Re: Sort multi-array

Re: Ho do I search in multi-array

Re: convert MySQL db from Latin1 to UTF8

Re: convert MySQL db from Latin1 to UTF8

Re: convert MySQL db from Latin1 to UTF8

Re: How do I find the size of my database?

Re: convert MySQL db from Latin1 to UTF8

Re: convert MySQL db from Latin1 to UTF8

Re: Set bit to TRUE/FALSE