How to insert all array data into mysql ?
i want to insert all array string in to mysql , can i do that ?
<?PHP
include("connect.php");
for ($i = 0; $i < 10; $i++)
{
$myArray[$i] = $i;
}
$sql = "INSERT INTO table
( all_array , user )
VALUES
('array($myArray)' , '11');";
$dbQuery = mysql_query($sql);
?>
You can save all array in json type. But you should not use mysql_* functions, use PDO.
For example:
<?PHP
include("connect.php");
for ($i = 0; $i < 10; $i++)
{
$myArray[$i] = $i;
}
$json_array = json_encode($myArray);
$sql = "INSERT INTO table
( all_array , user )
VALUES
('$json_array' , '11');";
$dbQuery = mysql_query($sql);
?>
[0,1,2,3,4,5,6,7,8,9] to array again , how can i do ?
You can use PHP's implode function to join array elements with a string.
$arrayAsAString = implode(",", $myArray);
NOTE: I just saw @onuri 's answer. So consider this an alternative.
CAVEAT: Performing database queries would be tough, whichever method you choose.
Use php implode function, it will break all the elements of your array into comma separated string. Change your code as below.
<?PHP
include("connect.php");
for ($i = 0; $i < 10; $i++)
{
$myArray[$i] = $i;
}
$arrayString= implode(", ", $myArray);
$sql = "INSERT INTO table
( all_array , user )
VALUES
('$arrayString' , '11');";
$dbQuery = mysql_query($sql);
?>
$json_array = implode(", ", $myArray);?
implode returns a valid json-string or has anything to do with json?i would do that with json
<?PHP
include("connect.php");
for ($i = 0; $i < 10; $i++)
{
$myArray[$i] = $i;
}
$myJSON = json_encode($myArray);
$sql = "INSERT INTO table ( all_array , user ) VALUES ('$myJSON' , '11');";
$dbQuery = mysql_query($sql);
?>
this will return the array as a JSON-String which can be stored in db. if i select it later i can easy transform the JSON-String back to an array if neede like:
$myArray = json_decode($myJSONString);
all_array?"1","2","3","4"