modify chars in files

[Bob Bedford]

I've an XML file where I've "'" char. I want to modify in all file the
"&apos" by "'". it's there any way to do it before parsing the XML file ?

Bob

[Hartmut Holzgraefe]

Bob Bedford wrote:

I've an XML file where I've "'" char. I want to modify in all file
the "&apos" by "'". it's there any way to do it before parsing the XML
file ?

Why do you want to do that? The various XML parsing PHP extensions
will transparently handle that for you anyway ...

--
Hartmut Holzgraefe, Senior Support Engineer .
MySQL AB, www.mysql.com

Are you MySQL certified? www.mysql.com/certification

[Bob Bedford]

"Hartmut Holzgraefe" <ha*****@mysql.com> a écrit dans le message de news:
cs**********@online.de...

Bob Bedford wrote:

I've an XML file where I've "&apos;" char. I want to modify in all file
the "&apos" by "'". it's there any way to do it before parsing the XML
file ?

Why do you want to do that? The various XML parsing PHP extensions
will transparently handle that for you anyway ...

--
Hartmut Holzgraefe, Senior Support Engineer .
MySQL AB, www.mysql.com

Are you MySQL certified? www.mysql.com/certification

Probably I didn't get the right extension, but when trying to get
attributes, the parser separate my text in 3
text: xxxxx'yyy
output:
xxxxx
'
yyy

Anyway I want to save such string in a Mysql table, so I've to care about,
as the insert statement is like insert.....,'xxxxx'yyy',
I've removed the ' with ereg_replace, but I'd like to get such character in
Mysql table, but don't know how.

Bob

[Hartmut Holzgraefe]

Bob Bedford wrote:

Probably I didn't get the right extension, but when trying to get
attributes, the parser separate my text in 3
text: xxxxx'yyy
output:
xxxxx
'
yyy
This is something you always have to be aware of:
The parser may split character data into several chunks
and it is your responsibility to join them together if
needed.
Anyway I want to save such string in a Mysql table, so I've to care
about, as the insert statement is like insert.....,'xxxxx'yyy',
I've removed the ' with ereg_replace, but I'd like to get such character
in Mysql table, but don't know how.

http://php.net/mysql_real_escape_string

--
Hartmut Holzgraefe, Senior Support Engineer .
MySQL AB, www.mysql.com

Are you MySQL certified? www.mysql.com/certification

[Bob Bedford]

> http://php.net/mysql_real_escape_string

Thanks for your asnwer.
I've seen you are senior support Enginner for mysql, you probably may help
for a question that wasn't answered. (very short)

I've a page where I get the result of a query. Each result points to a page
where there is the detail of the record. I'd like to add "previous" and
"next"buttons. The only way I've found is to put the results in an array,
then on any page, the array will tell me the next and previous record. It's
there a better way using mysql ?

Bob

[Jacob Atzen]

On 2005-01-19, Bob Bedford <be******@YouKnowWhatToDoHerehotmail.com> wrote:

I've a page where I get the result of a query. Each result points to a
page where there is the detail of the record. I'd like to add
"previous" and "next"buttons. The only way I've found is to put the
results in an array, then on any page, the array will tell me the next
and previous record. It's there a better way using mysql ?

Offsets:

SELECT [...] FROM [table] LIMIT 20, 1;

<http://dev.mysql.com/doc/mysql/en/SELECT.html>

--
Cheers,
- Jacob Atzen

[Bob Bedford]

"Jacob Atzen" <ja***@aub.dk> a écrit dans le message de news:
sl******************@morpheus.aub.dk...

On 2005-01-19, Bob Bedford <be******@YouKnowWhatToDoHerehotmail.com>
wrote:

I've a page where I get the result of a query. Each result points to a
page where there is the detail of the record. I'd like to add
"previous" and "next"buttons. The only way I've found is to put the
results in an array, then on any page, the array will tell me the next
and previous record. It's there a better way using mysql ?

Offsets:

SELECT [...] FROM [table] LIMIT 20, 1;

<http://dev.mysql.com/doc/mysql/en/SELECT.html>

List.php (with limit 20):
<a href="detail.php?article=2>detail 2</a>
<a href="detail.php?article=3>detail 3</a>
<a href="detail.php?article=4>detail 4</a>
.....

Ok, once I click on article detail 3, how to make previous or next from
there since I'm on an other page and I don't run the query every time ? From
detail.php, it wouldn't be possible to go to 2 or 4 without coming back to
list.php.

Bob