• 18-02-2023, 23:31:45
    #1
    empty
  • 18-02-2023, 23:39:59
    #2
    function insert($table, $data) {
        $connect = new PDO("mysql:host=localhost;dbname=testing", 'root', '');
    
        $keys = array_keys($data[0]);
        $columns = implode(',', $keys);
    
        $values = array();
        foreach ($data as $rowValues) {
            $rowValues = array_map(function($value) use ($connect) {
                return $connect->quote($value);
            }, $rowValues);
            $values[] = '(' . implode(',', $rowValues) . ')';
        }
        $values = implode(',', $values);
    
        $query = "
            INSERT INTO $table
            ($columns)
            VALUES
            $values
        ";
    
        $statement = $connect->prepare($query);
        if($statement->execute()){
            return true;
        }
        else{
            return false;
        }
    }
    
    $data = array(
        array('ad' => "Kemal", 'soyad' => "Sunal"),
        array('ad' => "Şener", 'soyad' => "Şen"),
        array('ad' => "Sadri", 'soyad' => "Alışık"),
    );
    insert('oyuncular', $data);
  • 18-02-2023, 23:43:25
    #3
    empty