have a look at get_html_translation_table() in the php manual.
there is an example of conversion of all special chars so they can be
inserted into the database as text (i.e. �>£) and a cool way of
'decoding' them if you need to write them to a file. A Browser wil interpret
them correctly when they are displayed.
This must be the question of the day as i have posted this answer three
times today :-)
Let me know if you need any more help
Steve
get_html_translation_table manual page is below:
PHP Manual
Prev Next
----------------------------------------------------------------------------
----
get_html_translation_table
(PHP 4 >= 4.0b4)
get_html_translation_table -- Returns the translation table used by
htmlspecialchars() and htmlentities()
Description
string get_html_translation_table (int table [, int quote_style])
get_html_translation_table() will return the translation table that is used
internally for htmlspecialchars() and htmlentities(). There are two new
defines (HTML_ENTITIES, HTML_SPECIALCHARS) that allow you to specify the
table you want. And as in the htmlspecialchars() and htmlentities()
functions you can optionally specify the quote_style you are working with.
The default is ENT_COMPAT mode. See the description of these modes in
htmlspecialchars(). Example 1. Translation Table Example
$trans = get_html_translation_table (HTML_ENTITIES);
$str = "Hallo & <Frau> & Kr�mer";
$encoded = strtr ($str, $trans);
The $encoded variable will now contain: "Hallo & <Frau> &
Krämer".
The cool thing is using array_flip() to change the direction of the
translation.
$trans = array_flip ($trans);
$original = strtr ($str, $trans);
The content of $original would be: "Hallo & <Frau> & Kr�mer".
Note: This function was added in PHP 4.0.
See also: htmlspecialchars(), htmlentities(), strtr(), and array_flip().
----------------------------------------------------------------------------
----
Prev Home Next
explode Up get_meta_tags
"Jay Fitzgerald" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Ok, I am still fairly new at PHP and MySQL also, so please bear with me.
>
>
> TASK: I have a client that wants to have job openings listed on their site
> and they want to be able to add, edit and delete the postings themselves.
I
> would do this in flat-file format but there is the risk of that file size
> getting too large and slowing down the server.
>
>
> SOLUTION: I have created a MySQL database that will hold all the postings
> in a table called 'jobs' and have created a PHP form that will post this
> jobs into the db.
>
> PROBLEM: When I go to the PHP form and enter all of the pertinent job
> information, there is one specific field that will have to have carriage
> returns/line breaks in it between paragraphs. Everything is working except
> for this. Is there a way whenever the user presses <ENTER>, that either
> PHP/MySQL will convert this into a <BR> tag only when being displayed in a
> browser and not in the db??
>
>
> Can anyone out there please help me with this? I am available off-list as
> well if it will be easier to pass code back and forth. Any assistance is
> greatly appreciated!
>
>
>
> Should you have any questions, comments or concerns, feel free to call me
> at 318-338-2034.
>
> Thank you for your time,
>
> Jay Fitzgerald, Design Director - CSBW-A, CPW-A, CWD-A, CEMS-A
> ==========================================================
> Bayou Internet..............(888)
> 30-BAYOU........................http://www.bayou.com
> Mississippi Internet.......(800)
> MISSISSIPPI...............http://www.mississippi.net
> Vicksburg Online..........(800)
> MISSISSIPPI................http://www.vicksburg.com
> ==========================================================
> Tel: (318) 338-2034 ICQ: 38823829 Fax:
> (318) 323-5053
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]