RE: [PHP] Storing Arrays in a database
Joe Harman mailto:[EMAIL PROTECTED] on Thursday, March 24, 2005 12:15 PM said: I was curious if anyone here stores arrays in MySQL... and how r u doing this... are you converting the values to a delimited string or is there another way? http://php.net/serialize and http://php.net/unserialize are probably what you want. Chris. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Storing Arrays in a database
check serialize() and unserialize() in manual. implode() and explode() functions too. -afan Joe Harman wrote: Hey, I was curious if anyone here stores arrays in MySQL... and how r u doing this... are you converting the values to a delimited string or is there another way? Thanks Joe -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Storing Arrays in a database
Joe Harman wrote: Hey, I was curious if anyone here stores arrays in MySQL... and how r u doing this... are you converting the values to a delimited string or is there another way? Thanks Joe http://us4.php.net/serialize -- John C. Nichel ÜberGeek KegWorks.com 716.856.9675 [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Storing Arrays?
[snip] If I wanted to store an array for future use in a MySQL TEXT Column (dont ask, it's complicated... hehe!) how would I go about it? I thought of just putting the results of print_r($myarray); into the text field and using eval() to get at it later... is that the right way to go? [/snip] Yes, that is certainly one right way to go. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Storing Arrays?
* and then Jay Blanchard declared [snip] If I wanted to store an array for future use in a MySQL TEXT Column (dont ask, it's complicated... hehe!) how would I go about it? I thought of just putting the results of print_r($myarray); into the text field and using eval() to get at it later... is that the right way to go? [/snip] Yes, that is certainly one right way to go. Actually, serialize() would be better suited I think, but thanks... -- Nick W -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Storing Arrays?
At 11:10 24-2-04, you wrote: Hi all, If I wanted to store an array for future use in a MySQL TEXT Column (dont ask, it's complicated... hehe!) how would I go about it? you could consider serialize() -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Storing Arrays?
depending how long you want to keep it, wrap the array in a object and then serialize the object in a session variable. Nick Wilson [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] * and then Jay Blanchard declared [snip] If I wanted to store an array for future use in a MySQL TEXT Column (dont ask, it's complicated... hehe!) how would I go about it? I thought of just putting the results of print_r($myarray); into the text field and using eval() to get at it later... is that the right way to go? [/snip] Yes, that is certainly one right way to go. Actually, serialize() would be better suited I think, but thanks... -- Nick W -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Storing Arrays?
rather just serialize() it. didnt read your question properly Jakes [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] depending how long you want to keep it, wrap the array in a object and then serialize the object in a session variable. Nick Wilson [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] * and then Jay Blanchard declared [snip] If I wanted to store an array for future use in a MySQL TEXT Column (dont ask, it's complicated... hehe!) how would I go about it? I thought of just putting the results of print_r($myarray); into the text field and using eval() to get at it later... is that the right way to go? [/snip] Yes, that is certainly one right way to go. Actually, serialize() would be better suited I think, but thanks... -- Nick W -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] storing arrays
?php $myarray = array(123,abcdef,4.567,another string); $ser = serialize($myarray); $ff = fopen(C:\myfile,w); fwrite($ff,$ser); fclose($ff); $fr = fopen(C:\myfile,r); $outser = fgets($fr,1000); fclose($fr); $outarray = unserialize($outser); print $outarray[0].\n; print $outarray[1].\n; print $outarray[2].\n; print $outarray[3].\n; print $outarray[4].\n; ? -Original Message- From: Clark [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 17, 2002 11:15 PM To: [EMAIL PROTECTED] Subject: Re: [PHP] storing arrays I'm having trouble storing my array to a text file, utilizing serialize() and unserialize(). Could you please show a very basic layout of the proper way to serialize and unserialize and store that to a file? Thanks. Matt [EMAIL PROTECTED] wrote in message 001e01c1b7c0$404d5be0$059aa8c0@Pooch">news:001e01c1b7c0$404d5be0$059aa8c0@Pooch... - Original Message - From: Clark [EMAIL PROTECTED] Sent: Saturday, February 16, 2002 9:15 PM Two questions: 1) Is it possible to write an array to a file? Yes, serialize it first with http://www.php.net/serialize. You can also place this in a db text field because it will be a character representation. 2) Is it possible to specify the name of the key to each item of an array when you get the array using file(). When retrieving the saved array, unserialize it, and you'll get the same array back. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] storing arrays
- Original Message - From: Clark [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, February 17, 2002 3:15 AM Subject: [PHP] storing arrays Two questions: 1) Is it possible to write an array to a file? not direct, use: $fp = fopen(/my/file, w); foreach($filearray as $row) fputs($fp, $row.\n); fclose($fp); 2) Is it possible to specify the name of the key to each item of an array when you get the array using file(). not direct, use: $keys = array(first, second, third, fourht); $filearray = file(/my/file); for($x = 0; $x count($filearray); $x++) $newfilearray[$keys[$x]] = $filearray[$x]; $filearray = $newfilearray; i think only a write version of file could be a useful function for php... mvgr, Joffrey van Wageningen -- .-[ Joffrey van Wageningen | WoLFjuh | [EMAIL PROTECTED] ]-- | Networking Event 2000 - www.ne2000.nl - IRCnet:#ne2000, Undernet:#clue | PGP:1024D/C6BA5863 - 3B93 52D3 CB91 9CB7 C50D FA79 865F 628A C6BA 5863 | * We demand guaranteed rigidly defined areas of doubt and uncertainty. | -- Douglas Adams -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] storing arrays
- Original Message - From: Clark [EMAIL PROTECTED] Sent: Saturday, February 16, 2002 9:15 PM Two questions: 1) Is it possible to write an array to a file? Yes, serialize it first with http://www.php.net/serialize. You can also place this in a db text field because it will be a character representation. 2) Is it possible to specify the name of the key to each item of an array when you get the array using file(). When retrieving the saved array, unserialize it, and you'll get the same array back. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] storing arrays
I'm having trouble storing my array to a text file, utilizing serialize() and unserialize(). Could you please show a very basic layout of the proper way to serialize and unserialize and store that to a file? Thanks. Matt [EMAIL PROTECTED] wrote in message 001e01c1b7c0$404d5be0$059aa8c0@Pooch">news:001e01c1b7c0$404d5be0$059aa8c0@Pooch... - Original Message - From: Clark [EMAIL PROTECTED] Sent: Saturday, February 16, 2002 9:15 PM Two questions: 1) Is it possible to write an array to a file? Yes, serialize it first with http://www.php.net/serialize. You can also place this in a db text field because it will be a character representation. 2) Is it possible to specify the name of the key to each item of an array when you get the array using file(). When retrieving the saved array, unserialize it, and you'll get the same array back. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php