if i want to search this array,how do this sql?thanks
-----????-----
???: Matthew Delmarter [mailto:[EMAIL PROTECTED]]
????: 2001?7?31? 11:34
???: Ben Bleything
??: PHP Mailing List
??: 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:
<select name='name[]' size='5' multiple>
<option value='id'>name</option>
</select>
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]
