how to store php array data into mysql database

Question

<?PHP

// primarily a method for storing data
// arrays are counted from 0

$hosts = array(
array("ronmexico.kainalopallo.com/","beforename=$F_firstname%20$F_lastname&gender=$F_gender","Your Ron Mexico Name is ","/the ultimate disguise, is ([^<]+)<\/b><\/u>/s"),<u><b>([^<]+)<\/b><\/u>/s"),

array("rumandmonkey.com/widgets/toys/mormon/index.php","gender=$F_gender&firstname=$F_firstname&surname=$F_lastname","Your Mormon Name is ","/
My <p>My Mormon name is
<b>([^<]+)<\/b>!<br \/>/s")
);

return $hosts;

?>

How to store this array into mysql database.

You should make a start by learning the basics here: w3schools.com/php/php_mysql_intro.asp — Adam Holmes
– Adam Holmes, Commented Nov 27, 2010 at 11:00

worenga · Accepted Answer · 2010-11-27 11:03:49Z

1

just iterate the array and insert every element into the table

foreach($hosts as $key => $value){
    mysql_query('INSERT INTO table (field) VALUES ("'.$value.'")');
}

answered Nov 27, 2010 at 11:03

worenga

5,8663 gold badges33 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

robjmills · Accepted Answer · 2010-11-29 16:45:16Z

1

You can use the PHP serialize function to store arrays and objects in MySQL

answered Nov 29, 2010 at 16:45

robjmills

18.6k16 gold badges81 silver badges124 bronze badges

2 Comments

AlexV Over a year ago

+1 for answer but OP should avoid to store arrays/objects in the database!

robjmills Over a year ago

@AlexV - totally agree its almost never the right thing to do but in edge cases it can be useful

xianvalencia · Accepted Answer · 2012-04-23 10:10:45Z

1

You can use json_encode when storing:

$fruit_color = array("apple" => "red", "banana" => "yellow", "cherry" => "red");
$encoded = json_encode($fruit_color); //Turn your array into json-readable string

And json_decode when retrieving from database:

$result = mysql_fetch_assoc($sql);
$decoded = json_decode( $result[column_name] );

answered Apr 23, 2012 at 10:10

xianvalencia

715 bronze badges

Collectives™ on Stack Overflow

how to store php array data into mysql database

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related