Re: [PHP-DB] Arabic characters displayed as garbage !!

[martin73]

Did you set a character encoding on your page to Arabic? (eg. ISO-8859-6)

> Hi,
>
> I'm working on a website that needs to save and display Arabic characters.
> I'm using MySQL database and no matter how I insert the data either using
> phpMyAdmin or inserting it using a script of my own, when I try to show
> (display) the data I previously saved (which contains Arabic characters),
> the output is rubbish and has no relation with the words I saved
>
> the script I'm using for displaying the data is as simple as the following
> one
>
> //===
>   include("db.php");
>  $result = mysql_query("select * from mem_applications");
>  if ($result)
>  {
>while ($row = mysql_fetch_array($result))
>{
>  echo $row['first_name'];
>   echo "";
>   echo $row['mid_name'];
>   echo "";
>   echo $row['last_name'];
>   echo "";
>}
>  }
> ?>
> //===
>
> Thanks in advance
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Arabic characters displayed as garbage !!

[martin73]

By default, MySQL uses the ISO-8859-1 (Latin1) character set. I guess you
need to set this parameter to something suitable for Arabic (if it is
supported by MySQL). I suggest you read "The Character Set Used for Data
and Sorting" part of MySQL manual. That's all I can help with.

Cheers

> yes I did .. and the problem only happens for arabic text stored in
> database
>
> <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
>> Did you set a character encoding on your page to Arabic? (eg.
>> ISO-8859-6)
>>
>> > Hi,
>> >
>> > I'm working on a website that needs to save and display Arabic
> characters.
>> > I'm using MySQL database and no matter how I insert the data either
> using
>> > phpMyAdmin or inserting it using a script of my own, when I try to
>> show
>> > (display) the data I previously saved (which contains Arabic
> characters),
>> > the output is rubbish and has no relation with the words I saved
>> >
>> > the script I'm using for displaying the data is as simple as the
> following
>> > one
>> >
>> > //===
>> > > >  include("db.php");
>> >  $result = mysql_query("select * from mem_applications");
>> >  if ($result)
>> >  {
>> >while ($row = mysql_fetch_array($result))
>> >{
>> >  echo $row['first_name'];
>> >   echo "";
>> >   echo $row['mid_name'];
>> >   echo "";
>> >   echo $row['last_name'];
>> >   echo "";
>> >}
>> >  }
>> > ?>
>> > //===
>> >
>> > Thanks in advance
>> >
>> > --
>> > PHP Database Mailing List (http://www.php.net/)
>> > To unsubscribe, visit: http://www.php.net/unsub.php
>> >
>> >
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Database Backup

[martin73]

You can simply copy files from 'data' subfolder of mysql database or
create php script to make a dump of db and run it on regular basis as a
cron job.

Cheers,
Martin

> What is everyone doing to backup a MySQL database.  Just in case...I'd
> like
> to backup mine, but I was wondering if there was a way to do it without
> going to a page and clicking a button.  Is there a way to run a php script
> on a time schedule and then push a backup file to an FTP server or
> something.  Anyone out there doing anything like this?
>
> Thanks,
>
> Aaron
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php