| Index
» Projects
» phpMyEdit
» Forum
» Help me with trigger |
 |
fefe64
Joined: 11 Dec 2006
Posts: 13
Posted: 2006-12-28 19:19
Back to top
Reply with quote
|
Hello, i have a problem with french accent.
i want to edit a field from another table
but the field is like that:
field name: PE_nom and PE_prenom
é,ric Douglas and i would like to have
éric Douglas
so i would like to use a trigger like that:
$newsval= htmlspecialchars(addslashes($oldval));
but i don't know how to do that!
Here is my code:
$opts['fdd']['FI_producteur_3']['values']['table'] = 'table_personne';
$opts['fdd']['FI_producteur_3']['values']['column'] = 'PE_code';
$opts['fdd']['FI_producteur_3']['values']['description']['columns'][0] = 'PE_nom';
$opts['fdd']['FI_producteur_3']['values']['description']['divs'][0] = ' ';
$opts['fdd']['FI_producteur_3']['values']['description']['columns'][1] = 'PE_prenom';
$opts['fdd']['FI_producteur_3']['name']='Producteur';
$opts['fdd']['FI_producteur_3']['select'] = 'D';
$opts['fdd']['FI_producteur_3']['sort'] = true;
Please help me!!Thank you
Fredy
|
michal
Joined: 17 Jun 2003
Posts: 537
Location: Slovakia
Posted: 2007-01-04 12:40
Back to top
Reply with quote
|
there are two posibilities:
- you don't have encoding set in your html header (the easier one)
- concate made by the description array is not made correctly. put just
['description'] = 'PE_nom';
if that resolves the issue (that will remove concate from the sql commad).
|
fefe64
Joined: 11 Dec 2006
Posts: 13
Posted: 2007-01-04 15:13
Back to top
Reply with quote
|
Sorry, but i tried what you told me but the result is the same.
I just would like to know how can i do if i want to use a trigger to do that before edit :
newvals=htmlspecialchars(addslashes($oldvals))
|
fefe64
Joined: 11 Dec 2006
Posts: 13
Posted: 2007-01-04 15:16
Back to top
Reply with quote
|
Hello it's me again!!!
what i would like to do is the same to that:
to use the escape
$opts['fdd']['CE_id_expediteur']['escape'] = false;
but now i want to use the escape on a field from another table
i tried that but that doesn't work:
$opts['fdd']['CE_id_expediteur']['values']['description']['columns'][0]['escape']=false;
I hope you understand what i want to do
Thanks
Fred
|
|
Post new topic
Reply to topic
|
|
|
|
Login
Registration
Slovak
