Insert array to database table

You have to make dynamic string array and implode each value separate by common into the string.

The dynamic string would be generated and then you can insert that string into the table.

Yo can use php serialize method for generating a storable representation of a value. And when you get data from database, use unserialize

You have to write a query to achieve that, ofcourse you have to loop your Array.

There are ofcourse better ways to achieve this but for simple practicing I suggest you do it this way, you got alot of string cutting and so on with it.

Use echo $query to test the result of your code before executing it.

A working example could look like this:

$query = "INSERT INTO myTable (`name`, `company`, `adress_1`) VALUES (";

foreach($myArray as $data) {
    $query .= "'" . mysql_real_escape_string($data["recNAME"]) . "', ";
    $query .= "'" . mysql_real_escape_string($data["company"]) . "', ";
    $query .= "'" . mysql_real_escape_string($data["address1"]) . "'), (";
}

$query = substr($query, 0, strlen($query) - 3);

echo $query;

mysql_query($query);

The best solution is to write / find a useful MySQL handler class that delivers simple functions like an insert function that accepts an array.

But I am not certain how much you know about OOP. It is best if you understand the princip how to do it manually and then write the class yourself, then you have fully understood it for sure.

However, the more complex way: This is not a complete example!

class MySQL
{
    private $handle = null;
    private function connect() {
        $this->handle = mysql_connect("127.0.0.1", "user", "pass", "db");
    }

    public function execute($query) {
        if($this->handle == NULL) {
            $this->connect();
        }
        if($this->handle != NULL) {
            mysql_query($query, $this->handle);
        }
    }

    public function insert($table, $fields, $values) {
        $query = "";
        if(is_array($fields) == true && is_array($values) == true) {
            $query .= "INSERT INTO `$table` (";
            foreach($fields as $field) {
                $query .= "`$field`" . ", ";
            }
            $query = substr($query, 0, strlen($query) - 2);
            $query .= ") VALUES (";
            $count = 0;
            foreach($values as $value) {
                $query .= "'" . mysql_real_escape_string($value) . "'";
                if($count == count($fields)) {
                    $query .= ", ";
                } else {
                    $query .= "),(";
                }
                $count++;
            }
            $query = substr($query, 0, strlen($query) - 2);
        }

        if(strlen($query) > 0) {
            $this->execute($query);
            return true;
        }

        return false;
    }
}

Ofcourse this example is not very complete, its just a short example you can store results, numrows and much more in the class, however here is the usuage:

$sql = new MySQL();
$sql->insert("myTable", array("name, "company", "adress_1"), array("guy, "company a", "street 1", "girl", "company b", "street 2"));