如何在数据库类中创建插入函数以插入具有多个coloumns和多个值的新记录（使用PDO）？

Question

the problem is my function insert inserts my record in two rows.

this is my code to connect to database in a file named :

connect.php

<?php
try{
$db = new PDO("mysql:host=localhost;dbname=NPD" , "root" , "");

echo "connected";
}
catch(Exception $e){
    echo $e->getMessage();
}

this is my database class in a file

database.php

<?php

require 'connect.php';
class DB {
public function insertInto($tableName , $info){
        global $db;
        foreach ($info as $coloumnName => $coloumnValue) {          
            $stmt = $db->prepare("INSERT INTO $tableName ($coloumnName) VALUES ('$coloumnValue') ");
            $stmt->execute();   
        }
    }
}
$da = new DB;
$da->insertInto('tableOne',array('name' => 'lolo' , 'deg' => '100'));

the result in the database is : tableOne

how can to make the insert function inserts my record in one row.

note : i want to insert any number of columns and values.

Answer 1

try to do something like this:

$arr = array('name' => 'lolo' , 'deg' => '100');
$columns=array_keys($arr);
$values=array_values($arr);

           $str="INSERT INTO $tableName (".implode(',',$columns).") VALUES ('" . implode("', '", $values) . "' )";
           echo $str;//your sql
         //  $stmt = $db->prepare($str);
         //  $stmt->execute();//uncomment to execute