XQTO.com    A Collection of Web Scripts
Home | Table Manager | File Manager | Date Picker| Help Forum

Help Forum

Support and discussion on development and bugs

You are not logged in.

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

mike59999
New member

Problems with some Records

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

Offline

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

xqto
Administrator

Re: Problems with some Records

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

Offline

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

mike59999
New member

Re: Problems with some Records

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

Offline

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

xqto
Administrator

Re: Problems with some Records

looks like a nice idea,

thanks

Offline

Board footer

Powered by FluxBB

 

 

Copyright © 2008 XQTO.com. All rights reserved.