Mysqli does not run Insert within a function

Question

I have that function:

function envia($mensgem) {
    $odb = mysqli_connect(HOST, USER, PASS, DATABASE);
    mysqli_query($odb, "INSERT INTO pedidos VALUES ('$mensagem')");
    mysqli_close($odb);
}

I use this function on another page calling her by require('funcoes/envia.php');, run this function using envia('Olá mundo');, I will check on phpMyAdmin and nothing has been registered.

I would like Insert to perform within functions to facilitate :)

PS: The HOST, USER, PASS and DATABASE were correctly defined

Answer 1

But you are not specifying the message column for which table column pedidos goes that text ($mensagem)? You must specify:

mysqli_query($odb, "INSERT INTO pedidos (<NOME DA COLUNA AQUI>) VALUES ('$mensagem')");

http://www.w3schools.com/php/func_mysqli_query.asp

And you should wear Prepared statements, http://php.net/manual/en/mysqli.quickstart.prepared-statements.php

Answer 2

Use Mysql_execute($Seuinsert) and at the end use mysql_close(Your connection);