Re: [PHP-DB] Arabic characters displayed as garbage !!
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 !!
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
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