array values into mysql

Question

I have an array that looks like:

Array ( [0]  => 'overview' 
        [53] => 'PUBLIC' 
        [54] => '-friendsD' 
        [55] => 'XHTML' 
        [56] => '1.0' 
        [57] => 'Transitional' 
        [77] => 'People' );

How can I take those values and put them into MySQL with an INSERT? For example INSERT INTO array_value VALUES ('$arrayvalues'). For each array value is a new post into MySQL.

I tried this:

  <?php
$homepage = file_get_contents('http://www.mysiteexample.com/');
$array = explode(" ",$homepage);
foreach($array as $val) {
$servername = "localhost";
$username = "111";
$password = "111";
$dbname = "111";
    // Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
    // Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} else {
if ($val != " "){
$val = $val. " ";
    $query = "INSERT INTO `111` (word) VALUES ('$val')";

       $executeQuery = $conn->query($query) === TRUE;

    }

    if ($executeQuery === TRUE) {
        //echo "New record created successfully";
echo $val;
    } else {
        //echo "Error: " . $query . "<br>" . $conn->error;
echo $val. " ";
    }}
    $conn->close();
}
?>

This works to some extent. It produces many empty results how could it be filtered to have no empty posts. I tried the $val != " " but this didnt work.

Have you tried something? Show it!

Rizier123
– Rizier123

2015-08-06 22:47:15 +00:00
Commented Aug 6, 2015 at 22:47 — Rizier123
– Rizier123, Commented Aug 6, 2015 at 22:47
Did you try the answer I provided?

Script47
– Script47

2015-08-06 22:58:06 +00:00
Commented Aug 6, 2015 at 22:58 — Script47
– Script47, Commented Aug 6, 2015 at 22:58

Script47 · Accepted Answer · 2015-08-07 01:09:07Z

2

You can loop through the array and build the query. Then execute it.

<?php
$homepage = file_get_contents('http://www.mywebsite.com/');
$array = explode(" ",$homepage);

$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";

    // Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
    // Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} else {
    $executeQuery;

    for ($i = 0; $i < count($array); $i++) {
        if (!empty($array[$i])) {
            $executeQuery = $conn->query("INSERT INTO `yourTable` (yourField) VALUES ('" . $array[$i]  . "')");
        }
    }

    if ($executeQuery === TRUE) {
        echo "New record created successfully";
    } else {
        echo "Error: " . $query . "<br>" . $conn->error;
    }
    $conn->close();
}
?>

edited Aug 7, 2015 at 1:09

answered Aug 6, 2015 at 22:48

Script47

14.6k4 gold badges49 silver badges69 bronze badges

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

Collectives™ on Stack Overflow

array values into mysql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related