Re: [PHP] storing array in mysql
> a:4:{i:0;s:1:"1";i:1;s:1:"2";i:2;s:1:"3";i:3;s:1:"
>
> When I output this to the screen I get the same as above. But when I
> try to echo the unserialized result I get nothing. I am using:
> echo $db_result->lists_actual (nothing is returned)
Show more code... Also use "View Source" in your browser to see what you
are *REALLY* getting.
>
> If I try to display the result using foreach I get the warning
> "Invalid argument supplied for foreach()". I am using:
> $array = unserialize($db_result->lists_actual);
> foreach($array AS $val) {
> echo $val;
> };
>
> I hope the problem is clear, I am thoroughly confused at this stage! I
> should admit that I am only just getting used to arrays...
What is the datatype of your lists_actual field in your database?
--
WARNING [EMAIL PROTECTED] address is an endangered species -- Use
[EMAIL PROTECTED]
Wanna help me out? Like Music? Buy a CD: http://l-i-e.com/artists.htm
Volunteer a little time: http://chatmusic.com/volunteer.htm
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] storing array in mysql
Whee! I'm a moron!
Anyhoo, I've always used mysql_fetch_array() =>
So... Like I said about the serialized data getting truncated... that's
still my best guess =>
Ben
-Original Message-
From: Ben Bleything [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 30, 2001 9:10 PM
To: 'Matthew Delmarter'
Cc: 'PHP Mailing List'
Subject: RE: [PHP] storing array in mysql
To be honest, I don't know what this line does:
Echo $db_result->lists_actual
I also noticed something... it appears that the serialized data is
incorrect... are you sure you copied the whole thing? I think there
should be more to that... is it possible that your MySQL datatype is too
small to store the serialized data?
Hope this helps =>
Ben
-Original Message-
From: Matthew Delmarter [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 30, 2001 8:34 PM
To: Ben Bleything
Cc: PHP Mailing List
Subject: RE: [PHP] storing array in mysql
Hi Ben,
This is a section of the insert statement I used ($lists_actual is the
array):
$lists_actual = serialize($lists_actual);
Then : INSERT INTO $table (lists_actual) VALUES
('$lists_actual')
When I look in the db there is serialized data there - it appears like
this:
a:4:{i:0;s:1:"1";i:1;s:1:"2";i:2;s:1:"3";i:3;s:1:"
When I output this to the screen I get the same as above. But when I
try to echo the unserialized result I get nothing. I am using:
echo $db_result->lists_actual (nothing is returned)
If I try to display the result using foreach I get the warning
"Invalid argument supplied for foreach()". I am using:
$array = unserialize($db_result->lists_actual);
foreach($array AS $val) {
echo $val;
};
I hope the problem is clear, I am thoroughly confused at this stage! I
should admit that I am only just getting used to arrays...
Matthew
-Original Message-
From: Ben Bleything [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 31, 2001 3:03 PM
To: 'Matthew Delmarter'
Subject: RE: [PHP] storing array in mysql
Have you tried serialize()'ing it before storing and then
unserialize()'ing it afterwards?
http://www.php.net/serialize
http://www.php.net/unserialize
=>
Ben
-Original Message-
From: Matthew Delmarter [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 30, 2001 8:10 PM
To: PHP Mailing List
Subject: [PHP] storing array in mysql
Hi all,
I want to store the results of a multiple select input box in a mysql
db. The box looks like this:
name
I cannot seem to store the array in a database and then output the
result using foreach. Any tips?
Regards,
Matthew Delmarter
Web Developer
AdplusOnline.com Ltd
www.adplusonline.com
Phone: 06 8357684
Cell: 025 2303630
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail:
[EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] storing array in mysql
To be honest, I don't know what this line does:
Echo $db_result->lists_actual
I also noticed something... it appears that the serialized data is
incorrect... are you sure you copied the whole thing? I think there
should be more to that... is it possible that your MySQL datatype is too
small to store the serialized data?
Hope this helps =>
Ben
-Original Message-
From: Matthew Delmarter [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 30, 2001 8:34 PM
To: Ben Bleything
Cc: PHP Mailing List
Subject: RE: [PHP] storing array in mysql
Hi Ben,
This is a section of the insert statement I used ($lists_actual is the
array):
$lists_actual = serialize($lists_actual);
Then : INSERT INTO $table (lists_actual) VALUES
('$lists_actual')
When I look in the db there is serialized data there - it appears like
this:
a:4:{i:0;s:1:"1";i:1;s:1:"2";i:2;s:1:"3";i:3;s:1:"
When I output this to the screen I get the same as above. But when I
try to echo the unserialized result I get nothing. I am using:
echo $db_result->lists_actual (nothing is returned)
If I try to display the result using foreach I get the warning
"Invalid argument supplied for foreach()". I am using:
$array = unserialize($db_result->lists_actual);
foreach($array AS $val) {
echo $val;
};
I hope the problem is clear, I am thoroughly confused at this stage! I
should admit that I am only just getting used to arrays...
Matthew
-Original Message-
From: Ben Bleything [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 31, 2001 3:03 PM
To: 'Matthew Delmarter'
Subject: RE: [PHP] storing array in mysql
Have you tried serialize()'ing it before storing and then
unserialize()'ing it afterwards?
http://www.php.net/serialize
http://www.php.net/unserialize
=>
Ben
-Original Message-
From: Matthew Delmarter [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 30, 2001 8:10 PM
To: PHP Mailing List
Subject: [PHP] storing array in mysql
Hi all,
I want to store the results of a multiple select input box in a mysql
db. The box looks like this:
name
I cannot seem to store the array in a database and then output the
result using foreach. Any tips?
Regards,
Matthew Delmarter
Web Developer
AdplusOnline.com Ltd
www.adplusonline.com
Phone: 06 8357684
Cell: 025 2303630
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail:
[EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] storing array in mysql
Hi Ben,
This is a section of the insert statement I used ($lists_actual is the
array):
$lists_actual = serialize($lists_actual);
Then : INSERT INTO $table (lists_actual) VALUES ('$lists_actual')
When I look in the db there is serialized data there - it appears like
this:
a:4:{i:0;s:1:"1";i:1;s:1:"2";i:2;s:1:"3";i:3;s:1:"
When I output this to the screen I get the same as above. But when I
try to echo the unserialized result I get nothing. I am using:
echo $db_result->lists_actual (nothing is returned)
If I try to display the result using foreach I get the warning
"Invalid argument supplied for foreach()". I am using:
$array = unserialize($db_result->lists_actual);
foreach($array AS $val) {
echo $val;
};
I hope the problem is clear, I am thoroughly confused at this stage! I
should admit that I am only just getting used to arrays...
Matthew
-Original Message-
From: Ben Bleything [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 31, 2001 3:03 PM
To: 'Matthew Delmarter'
Subject: RE: [PHP] storing array in mysql
Have you tried serialize()'ing it before storing and then
unserialize()'ing it afterwards?
http://www.php.net/serialize
http://www.php.net/unserialize
=>
Ben
-Original Message-
From: Matthew Delmarter [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 30, 2001 8:10 PM
To: PHP Mailing List
Subject: [PHP] storing array in mysql
Hi all,
I want to store the results of a multiple select input box in a mysql
db. The box looks like this:
name
I cannot seem to store the array in a database and then output the
result using foreach. Any tips?
Regards,
Matthew Delmarter
Web Developer
AdplusOnline.com Ltd
www.adplusonline.com
Phone: 06 8357684
Cell: 025 2303630
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail:
[EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
