Help Forum

mike59999 · 2010-02-17 20:14:22

Hi,

i use the Tablemanager and love it. But there is a small Probelm.
I have some Records with " in the Name.
In my pdfout i use mysql_real_escape_string. But i dont know where to set this in the Tablemanager.
The Type is 'input', if i change it to 'text' it displays correct but i cant edit the text only view it.

I hope you can help me.

Some Screenshots.
ahl-lager.de/1.jpg
ahl-lager.de/2.jpg
ahl-lager.de/3.jpg

Thank you and sorry for my bad english.

MfG Mik3

xqto · 2010-02-18 09:53:44

I have added this line to the script

$myrow[$field] = htmlspecialchars($myrow[$field]);

It appears on line 384 after
foreach($FIELDS as $field => $details) {

it should solve your problem

mike59999 · 2010-02-19 20:59:08

Works perfect. Thank you very much.
I have modified the Searchfunction a little bit.

Line 628 in tablemanager.php
Orig: $sql = "SELECT $CONFIG[primarykey], $displaycolumns FROM $CONFIG[tablename] WHERE $CONFIG[searchfield] LIKE '%$keywords%' ORDER BY $displaycolumns";

Modified: $sql = "SELECT $CONFIG[primarykey], $displaycolumns FROM $CONFIG[tablename] WHERE CONCAT$CONFIG[searchfield] LIKE '%$keywords%' ORDER BY artnr ASC";

In Config
Orig: $CONFIG['searchfield'] = 'columnname';

Modified: $CONFIG['searchfield'] = '(columnname1, columnname2, columnname3)';

Now i can search multiple columns, if you think its usefull feel free to use it.

Thank you again for the quick help.

MfG mik3

xqto · 2010-02-20 01:26:50

looks like a nice idea,

thanks

Help Forum

#1 2010-02-17 20:14:22

Problems with some Records

#2 2010-02-18 09:53:44

Re: Problems with some Records

#3 2010-02-19 20:59:08

Re: Problems with some Records

#4 2010-02-20 01:26:50

Re: Problems with some Records

Board footer