Get array from string

[Martijn Hertog]

Hi,

I would like to store data from a string in a database after some
stripping. So for example:

<li><a href="xxx">yyy</a> - zzz
<li><a href="aaa">bbb</a> - ccc

In this example (which is one string) I would like to store the
variable data in a MySQL table. In order to do that I need to first
get the variable data from the string, which I can manage I think.

But how do I get the data into the database? Do I need to insert the
data into one or more arrays? And how can I then insert it into the
table?

Kind regards,

Martijn

[Erwin Moller]

Martijn Hertog wrote:

Hi,

I would like to store data from a string in a database after some
stripping. So for example:

<li><a href="xxx">yyy</a> - zzz
<li><a href="aaa">bbb</a> - ccc

In this example (which is one string) I would like to store the
variable data in a MySQL table. In order to do that I need to first
get the variable data from the string, which I can manage I think.

But how do I get the data into the database? Do I need to insert the
data into one or more arrays? And how can I then insert it into the
table?

Kind regards,

Martijn

Hi Martijn,

I suggest you create a table with:
1) unique id (PK)
2) hrefvalue (text)
3) hlinktext (text)
4) extracomment (text)

and store a record at a time in it.
I don't see any advantage in storing arrays of strings in a database. (If
possible with MySQL, which I am not sure of because I only use Postgresql)

Regards,
Erwin Moller

[Martijn Hertog]

Erwin Moller <si******************************************@spam yourself.com> wrote in message news:<40*********************@news.xs4all.nl>...

Martijn Hertog wrote:

Hi,

I would like to store data from a string in a database after some
stripping. So for example:

<li><a href="xxx">yyy</a> - zzz
<li><a href="aaa">bbb</a> - ccc

In this example (which is one string) I would like to store the
variable data in a MySQL table. In order to do that I need to first
get the variable data from the string, which I can manage I think.

But how do I get the data into the database? Do I need to insert the
data into one or more arrays? And how can I then insert it into the
table?

Kind regards,

Martijn

Hi Martijn,

I suggest you create a table with:
1) unique id (PK)
2) hrefvalue (text)
3) hlinktext (text)
4) extracomment (text)

and store a record at a time in it.
I don't see any advantage in storing arrays of strings in a database. (If
possible with MySQL, which I am not sure of because I only use Postgresql)

Regards,
Erwin Moller

Thank you Erwin,

Which code can I use to get the data into the database table?

Kind regards,

Martijn

[Matthias Esken]

he*****@yahoo.com (Martijn Hertog) schrieb:

Which code can I use to get the data into the database table?

mysql_query()

Hava look at the documentation, starting at
http://www.php.net/manual/en/ref.mysql.php.

Regards,
Matthias

[Martin]

Okay, that seems to be a function that should be used of course. Could you
please send me an example code for the whole procedure, since I am not quite
sure how to get the variables ready for usage in an MySQL insert function.

Kind regards,

Martijn

"Matthias Esken" <mu******************@usenetverwaltung.org> wrote in
message news:c2**********@usenet.esken.de...

he*****@yahoo.com (Martijn Hertog) schrieb:

Which code can I use to get the data into the database table?

mysql_query()

Hava look at the documentation, starting at
http://www.php.net/manual/en/ref.mysql.php.

Regards,
Matthias

[Martin]

For example, I have the string:

#li##a href=http://www.cia.gov/cia/#CIA Factbook#/a# - Overview of Korea's
people, geography etc #li##a href=http://encarta.msn.com#Encarta#/a# -
Korean geography, society, culture, economy, government, and history.
----------
I would like the data in this string stored in a MySQL table, like this:
id url name
description
------------------------------------------------------------------------
1 http://www.cia.gov/cia/ CIA Factbook Overview ....
2 http://encarta.msn.com Encarta Korean ...

Kind regards,

Martijn
"Martin" <he*****@tiscali.nl> wrote in message
news:40**********************@dreader2.news.tiscal i.nl...

Okay, that seems to be a function that should be used of course. Could you
please send me an example code for the whole procedure, since I am not quite sure how to get the variables ready for usage in an MySQL insert function.

Kind regards,

Martijn

"Matthias Esken" <mu******************@usenetverwaltung.org> wrote in
message news:c2**********@usenet.esken.de...

he*****@yahoo.com (Martijn Hertog) schrieb:

Which code can I use to get the data into the database table?

mysql_query()

Hava look at the documentation, starting at
http://www.php.net/manual/en/ref.mysql.php.

Regards,
Matthias