-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Clare Media wrote:
Guys really in need of some assistance here.
I am reading an xml file and want to loop through the entire file and
display the information.
Unfortunately I am only showing 1 item. how can I go about showing all news
item?
That is not a two dimensional array. Its two one dimensional arrays and yo
do it like this
while ($row = mysql_fetch_array($result))
{
$title[] =$row['title'];
$description[] =$row['description'];
}
bastien
From: elk dolk [EMAIL PROTECTED]
To: php-db@lists.php.net
Sancar Saran [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
On Sunday 04 March 2007 23:04, Sancar Saran wrote:
Hi,
I want to know is there any db server around there for store php arrays
natively.
Regards
Sancar
Thanks for responses, it seems I have to give more info about
Wrong! Take a look at the SET datatype
http://dev.mysql.com/doc/refman/4.1/en/set.html. This allows you to have an
array of values in a single field, and the user can select any number of
them.
Sort of, but not really: This is a really specialized keyword, and
depends on binary mapping
Sancar Saran wrote:
Thanks for all those replies. It seems there was no easy solution (and or
serializing was better solution) for us.
Our arrays contains lots of things.. XML may not fit because content of
array may broke xml structure.
Before you give up, take a look at the XMLDBX PHP
-db@lists.php.net, php-general@lists.php.net
Subject: Re: [PHP-DB] array field type
Date: Sun, 04 Mar 2007 15:04:42 -0800
Not a single field, but there's several methods of storing trees of
information, which is what an array is. Here's one:
Nested Array storage table:
ArrayID (int, autonumber
Thanks for all those replies. It seems there was no easy solution (and or
serializing was better solution) for us.
Our arrays contains lots of things.. XML may not fit because content of array
may broke xml structure.
Thanks for help.
Regards
Sancar.
Hi,
I want to know is there any db
On Sunday 04 March 2007 23:04, Sancar Saran wrote:
Hi,
I want to know is there any db server around there for store php arrays
natively.
Regards
Sancar
Thanks for responses, it seems I have to give more info about situation.
In my current project, we had tons of arrays. They are very deep
Not a single field, but there's several methods of storing trees of
information, which is what an array is. Here's one:
Nested Array storage table:
ArrayID (int, autonumber)
keyname (text)
parent (int)
data (bigtext or whatever would be appropriate for the data you're storing)
For an array
Hi Ron,
how do I put each word into an array (so there would be 12 components in
the array) as well as remove the period and make the C in Check and the
Y in You lower case
This isn't a DB question, please ask questions in the appropriate list.
But for reference, look up the str_replace,
Use the strtolower function to reduce all letters to lower case.
Then use the stripos() function to find where the spaces are in the string
and use that position in the substr() function to parse out the individual
words in the string. From there you can put the chunks into an array or a
query or
Title: RE: [PHP-DB] Array
This is hardly database related but nonetheless.
?
$myString = Check one two three four. You did well to count to four.;
$myString = str_replace(.,,$myString);
$myString = strtolower($myString);
$myWords = explode( , $myString);
// do stuff here with your array
Dunno if its relevant, but the recommended way to use sessions is to assign
stuff to a $_SESSION['varname']...I don't really see anything wrong with the
code...
Also, what arrays are causing the problems?
bastien
From: NIPP, SCOTT V (SBCSI) [EMAIL PROTECTED]
To: php-db@lists.php.net
Where would that go?
Stuart
--- Matt M. [EMAIL PROTECTED] wrote:
if ( is_array( $_SESSION['l_industry'] ) ) {
foreach ( $_SESSION['l_industry'] as $p )
{
$query = INSERT INTO Profiles_Industries
(ProfileID,
IndID)
VALUES ($LID, $p);
}
do you have a } for the if
if ( is_array( $_SESSION['l_industry'] ) ) {
foreach ( $_SESSION['l_industry'] as $p ) {
$query = INSERT INTO Profiles_Industries (ProfileID,IndID) VALUES
($LID, $p);
} //foreach ( $_SESSION['l_industry'] as $p )
} //if ( is_array( $_SESSION['l_industry'] ) )
--
Yep, I had found it shortly before.
Only it's not looping. It is taking last value only.
Stuart
--- Matt M. [EMAIL PROTECTED] wrote:
if ( is_array( $_SESSION['l_industry'] ) ) {
foreach ( $_SESSION['l_industry'] as $p ) {
$query = INSERT INTO Profiles_Industries
where is your insert statement? I am guessing it is after your loop
if ( is_array( $_SESSION['l_industry'] ) ) {
foreach ( $_SESSION['l_industry'] as $p ) {
$query = INSERT INTO Profiles_Industries (ProfileID,IndID) VALUES
($LID, $p);
/This is where
Actually it did just loop. I need to test again.
The insert statement is the the one $query =
So it's after yes, but contained in the braces, like
you diagram below.
Stuart
--- Matt M. [EMAIL PROTECTED] wrote:
where is your insert statement? I am guessing it is
after your loop
if (
Hopefully these functions will explain it.
I'm starting the transaction, then provided it takes
with no errors it gets the commit
function begin()
{
mysql_query(BEGIN);
}
function commit()
{
mysql_query(COMMIT);
}
function rollback()
{
mysql_query(ROLLBACK);
}
begin();
$query = INSERT
$arr = array('key' = array('key2' = 'value', 'key3' = 'value', ...),
...);
$arr['key2'] = array('key2' = 'value', ...);
$arr['key3]['key2'] = 'value';
On Thu, 26 Aug 2004 16:11:27 -0500, Miguel Guirao [EMAIL PROTECTED] wrote:
Hi!!
I have a table with many options from when the user can
Since you provided no value's it's a little tough, but the general for would
be:
$parts = array(
array(PN = $row1col1, Desc = $row1col2, Qty = $row1col3),
array(PN = $row2col1, Desc = $row2col2, Qty = $row2col3)
);
Depending on your implimentation, it maybe easier to use some sort of loop
NIPP, SCOTT V (SBCSI) wrote:
I am trying to populate an array from a MySQL database. I think I
have the code correct to populate the array, but I need to somehow
sort the array eliminating duplicate values. I think I can loop
through the array doing a comparison and building a new
Hi
From what I can work out you need to use a function called
in_array(value,array);
http://www.php.net/manual/en/function.in-array.php here is the php manual
link
Hope this is what you want
Brett
-Original Message-
From: peppe [mailto:[EMAIL PROTECTED]
Sent: 11 December 2003 16:07
To:
Hi
Pete I forgot to write that $acces is a field from Db and there are values
1,2,3,4
a need to split those values to make that IF
Brettking thanx mate I think that is a solution
Brettking [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hi
From what I can work out you need to use a
From: ShortStay [EMAIL PROTECTED]
How do you delete a value and key from an array? I know the value.
You need to know the key.
unset($Array[$key]);
There are various array functions that'll find the key for you if you know
the value.
Is it OK to post array questions to the db list?
Not
First, are you sure there is data in $my_array?
Add this after you set the array:
echo pre.print_r($my_array)./pre;
You'll need to loop through the array , writing each line in the file at
a time.
Something like:
//open the file stuff here
foreach ($my_array AS $values)
{
fputs($fp,
:
Subject: RE: [PHP-DB] array issue
08/17/2003 11:33
?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: August 17, 2003 11:48 AM
To: Aaron Wolski
Cc: 'PHP-DB'; 'OpenSource'
Subject: RE: [PHP-DB] array issue
This may or may not make sense for your issue. but if you have the
whole
array in memory you can
PROTECTED]
Cc: 'PHP-DB' [EMAIL PROTECTED]; 'OpenSource' [EMAIL PROTECTED]
Sent: Sunday, August 17, 2003 10:04 AM
Subject: RE: [PHP-DB] array issue
Good point and nice find, Jeff!
I wasn't sure where he was going with the data.. was he trying to save
the actual array, intact, for say a chaching
by many users.
Aaron
-Original Message-
From: OpenSource [mailto:[EMAIL PROTECTED]
Sent: August 17, 2003 12:28 PM
To: Aaron Wolski
Cc: PHP-DB; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] array issue
Importance: High
Hey guys thanks a lot
your method worked perfect Aaron, thanks
of the table, and that's not good (2500 rows)
so can please still somebody help me with this?
-Original Message-
From: Becoming Digital [mailto:[EMAIL PROTECTED]
Sent: dinsdag 10 juni 2003 15:42
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] array fill/sort question
I might be overlooking
() )
- compare successively item by item
HTH
Ignatius
_
- Original Message -
From: Snijders, Mark [EMAIL PROTECTED]
To: 'Becoming Digital' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, June 11, 2003 8:33 AM
Subject: RE: [PHP-DB] array fill/sort question
hi
Snijders, Mark wrote:
hi,
no the both sollutions won't work cause:
I can't sort within a query cause subnetaddr is a varchar (10.10.10.10)
so it will be ordere like this
10.10.10.10
100.10.10.10
60.10.10.10
and that's not good cause 60 is smaller as 100, so with the function
ip2long() i will
hi,
you can add the ip2long() function into your SELECT statement and have
an ORDER BY clause at the end like this...
SELECT s_id, subnet_name, ip2long('subnetaddr'), subnetmask,dnsdomain,
location, contact, ccn FROM subnets ORDER BY subnetaddrr;
hope it helps.
KD
On Tue, 10 Jun 2003,
I might be overlooking something, but can't you just do this?
$query = SELECT s_id, subnet_name,subnetaddr,subnetmask,dnsdomain,
location, contact, ccn FROM subnets ORDER BY subnetaddr;
If you can't, you can sort the array like this.
?
$query = SELECT s_id,
My database is set up in this way:
fan_roster: has player id (play_id) , week, and stats on that player for
that week. So there are 20 records for each player, because there are 20
weeks.
So what I need to do is add up all the players weekly totals. so pass_yrd1
for week1 + pass_yrd1 for week2
-Original Message-
From: Ian Fingold [mailto:[EMAIL PROTECTED]
Sent: 03 June 2003 16:58
Ok I'm trying to write this function to up date some fields
in my database
so i'm grabbing some info from a query and throwing it into
an array (with
mysql_fetch_array).
one of the values
CartArray['itemid'] = $itemid;
note
where $qty = CartArray['qty'];
/note
Gary Every
Sr. UNIX Administrator
Ingram Entertainment
(615) 287-4876
Pay It Forward
mailto:[EMAIL PROTECTED]
http://accessingram.com
-Original Message-
From: Boa Constructor [mailto:[EMAIL PROTECTED]
Sent:
RE: [PHP-DB] Array QuestionCheers Gary, and in the html would I put something like:
a href=myscript.php?itemid=1qty=2buy this item/a
Simple question I know!
Jay, yup thats all I want to do, just assign two values into an array.
Thank you,
Graeme :)
- Original Message -
From
Hello everyone. If I wanted to pass a item ID along with a quantity to an
associative array called CartArray how would I pass it to the PHP
script?
I'll get this shopping cart working yet !!
If the question is how do you pass an array to another PHP page, you
serialize() and urlencode() it,
On Wednesday 26 February 2003 00:37, Jorge Miguel Fonseca Martins wrote:
As this has nothing to do with databases you should post to the php-general
list.
$test[]=a;
$test[]=b;
foreach ($test as $key=$value)
{
if($key == something) echo $key
}
even though theres no key in the
There are really a few ways that you can solve this problem. I would use
and associative array to do this.
Making the array associative would work like this:
$ALL_VALUES[$year] += $value;
To retrieve the information back you would use the following loop:
While($element = each($ALL_VALUES))
{
On Friday 24 January 2003 14:18, Tyler Whitesides wrote:
I have been having a lot of trouble getting an array into the MySQL table
like I want it. This is supposed to take the current maintenance tasks
from a table in the database on apple.php each of these is given a name
$item[autoNo]
on 1/22/03 12:08 AM, Michael Conway at [EMAIL PROTECTED] appended the
following bits to my mbox:
I find myself stuck in coming up with a way to cycle through this
array of db results for porting to a graphing script that I did not
write. My latest attempt to get around this problem is below.
On Monday 20 January 2003 17:50, Dave Carrera wrote:
I have nearly got this working but it dose not seem to loop though or
return the result
I have done something wrong and I ask one of you coders that are much
cleverer that I to glance over my code to see the obvious mistake / s.
Can you
$arr = array(.co.uk,.com,.net,.me.uk);
echo Top Level Domains: ;
while(list(,$tld)=each($arr)) {
echo $tld., ;
}
On Sun, 19 Jan 2003, Dave Carrera wrote:
Hi All
I am trying to create a tld lookup script for uk and main us domains.
I have success by creating multiple function hardcode the
Just loop through the first index, then search on the second index:
while ( list( $key, $value ) = each( $my_arr ) ) {
// now $value is your ( [0] = 10 [1] = 40 [2] = 50 [3] = 80 [4] =
130 [5] = 220 [6] = 320 ) array
// sort your array by values
sort( $value ) ;
// get the last
to precise:
$array = Array('name'='Maxim', 'surname'='Maletsky');
unset($array['name']);
// now array has this structure:
// Array('surname'='Maletsky')
--
Maxim Maletsky
[EMAIL PROTECTED]
Jason Wong [EMAIL PROTECTED] wrote... :
On Friday 08 November 2002 17:25, nikos wrote:
Does
$newInfo[$stripped] = $value;
---John Holmes...
-Original Message-
From: Rich Hutchins [mailto:[EMAIL PROTECTED]]
Sent: Sunday, October 13, 2002 3:42 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Array Initialization
Please forgive me ahead of time, but I didn't want to subscribe
On Thursday 20 June 2002 23:26, Richard Black wrote:
By passing a second parameter to mysql_fetch_array, MYSQL_ASSOC
This means you only get back an array with the values indexed by
fieldname.
Or just use mysql_fetch_assoc().
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
Open
Try putting the hidden element statement down inside the while loop in he
second page, but change it to INPUT TYPE=\hidden\ NAME=\id[]\
VALUE=\$id\ and add
$id=$row['id'];
before it.
I will show below where it should go.
HTH
MB
jas [EMAIL PROTECTED] said:
I have made the changes you
That's not Array Hell, this is Array Hell:
$Hell = array(satan,fire,brimstone);
-Mike
-Original Message-
From: jas [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 22, 2002 4:37 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Array HELL
I don't know what it is but I am having
Well ok now that I know it isn't an array I am having problems with, how
exactly am I supposed to create a variable (that can be passed to another
page) from a selected set of records?
Thanks again for the politeness,
Jas
Spyproductions Support Team [EMAIL PROTECTED] wrote in message
[EMAIL
Ok, you have almost got it. I have made little remarks further down in your
code which should just about do it for you.
jas [EMAIL PROTECTED] said:
I don't know what it is but I am having a hell of a time trying to get some
results of a query setup into an array or variable (too much of a
It looks like you need only one array, $date[begin] = $date[end].
Let's see, I think it'll work. I'll write it in your code then you try:
$i=0;
$result = mysql_query (SELECT DISTINCT date FROM linktracker WHERE name
LIKE '$PHP_AUTH_USER' ORDER BY date);
if ($row = mysql_fetch_array($result)) {
- Original Message -
From: Jim Lucas [EMAIL PROTECTED]
To: Bart Verbeek [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, October 24, 2001 12:42 PM
Subject: Re: [PHP-DB] array-problems
Try this:
BEGIN:PHP-CODE
$result = mysql_query (SELECT DISTINCT date FROM linktracker
For one, why are you redefining the array 3 times in that script? ...
I'm trying to follow here... and its not making sense.
-Original Message-
From: Larry Linthicum [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 05, 2001 12:14 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] array from
the subarrays contain variable data and I tried to express that by showing
the array structure that way
if I access $needed_data[0]
it would be an array of two pieces of data ( both variable)
$needed_data[1] would also be an array of two variable pieces of data, etc
if I loop through them all
Hi,
I think you can use the eval() function to execute the stored info. The code
will look something like this
$res=mysql_query(...)
eval($row_from_query);
If you want to change the name of the array you could use
eval(str_replace($array,$newarray,$row_from_query));
HTH
Dobromir Velev
thanks dobromir,
unfortunately that doesnt seem to work ...
although looking at the php manual you seem to be on the right track..
could the way the textfield is parsed passed back affect the array?
cheers!
brendan
Dobromir Velev wrote:
Hi,
I think you can use the eval() function to
scratch that, i had a syntax error in the array..
you were completely right dobromir eval() works perfectly..
thanks!
Brendan wrote:
thanks dobromir,
unfortunately that doesnt seem to work ...
although looking at the php manual you seem to be on the right track..
could the way the
In article 061201c0a063$08eab5a0$[EMAIL PROTECTED],
[EMAIL PROTECTED] ("Keith Spiller") wrote:
This associative array embedded within a function and declared as a global at
the start of the function, is meant to be a multidimensional array, but with
every loop of the while ($myrow = mysql
. Emery
IT Sr. Project Manager
"There is no 'trying'...
There is only 'Do' or 'Not Do' "
-Original Message-
From: Cal Evans [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 27, 2001 6:50 AM
To: Keith Spiller
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] array awry
Hi Keith,
1: D
63 matches
Mail list logo