how to convert array into variables in php [duplicate]

Question

I want to create a function that takes the name of a table and an array with the column name and value to use it to generate an INSERT in MySQL

Check my code.

Unfortunately this technique does not work as it always generates a comma after each value and this generates an error when entering data. Anyone know a better way to create this function?

<?php
$arrayDados = array('nome' => 'Renato', 'idade' => 24, 'peso' => 36, 'mae' => 'neide');
$colunas = "";
$valores = "";
$tabela = 'cadastro';

    foreach ($arrayDados as $key => $value) {
        $colunas .=  $key . ', ';
        $valores .= $value.', ';
    }
$sql = "INSERT INTO $tabela ($colunas) VALUES ($valores)";

echo $sql;`

use implode(',', array_keys($arrayDados)) for columns and implode("','", array_values($arrayDados)) for values — air4x
– air4x, Commented Oct 6, 2012 at 4:58

Brad · Accepted Answer · 2012-10-06 04:59:18Z

2

Take a look at implode(): http://php.net/manual/en/function.implode.php

implode(',', $yourArray);

Really though, use prepared queries instead of stuff like this where possible, to avoid problems with unescaped data.

answered Oct 6, 2012 at 4:59

Brad

164k57 gold badges380 silver badges559 bronze badges

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

Comments

Niet the Dark Absol · Accepted Answer · 2012-10-06 04:59:56Z

1

$sql = "INSERT INTO $tabela (".implode(",",array_keys($arrayDados)).") VALUES (".implode(",",array_values($arrayDados)).")";

Docs: array_keys - array_values - implode

answered Oct 6, 2012 at 4:59

Niet the Dark Absol

326k86 gold badges480 silver badges604 bronze badges

Collectives™ on Stack Overflow

how to convert array into variables in php [duplicate]

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related