PHP insert function not working

Question

I'm trying to make some insert function, but something is wrong, and can find where is the problem. Basically o just set some informations, and this same should be insert in database. The message errors are:

Notice: Undefined variable: conn in /Applications/AMPPS/www/teste/index.php on line 21

Fatal error: Call to a member function query() on a non-object in /Applications/AMPPS/www/teste/index.php on line 21

    ini_set('display_errors',1);
    ini_set('display_startup_erros',1);
    error_reporting(E_ALL);

    $dbtype     = "mysql";
    $dbhost     = "XXXXXXXXXX";
    $dbname     = "XXXXXXXXXX";
    $dbuser     = "XXXXXXXXXX";
    $dbpass     = "XXXXXXXXXX";
    $conn = new PDO("mysql:host=$dbhost;dbname=$dbname",$dbuser,$dbpass);
    function Insertdata($table,$field,$data){

        $field_values= implode(',',$field);
        $data_values=implode(',',$data);
        $sql = "INSERT into". " ".$table." ".$field_values. "VALUES(".$data_values.")";
        $result = $conn->query($sql);

      }
      $table="teste";
      $field_values=array("nome","idade","email","cidade");
      $data_values=array("Teste","14","teste@yahoo.com","Rio de Janeiro");
      $sample = Insertdata($table,$field_values,$data_values);
      if($result)
      {
        echo "inserted";
      }
      else
      {
        echo "not inserted";
      }

Within the php functions you will need to declare global $conn; to reference this variable. — , Feb 14 '18 at 13:24
@Adam answer is right. passing $conn to that function can solve this error. — Sugan Krishna, Feb 14 '18 at 13:26

score 0 · Answer 1 · answered Feb 14 '18 at 13:25

You didn't pass $conn to your function, you'll need to do that in order to have it in scope:

function Insertdata($table, $field, $data, $conn){

    $field_values= implode(',',$field);
    $data_values=implode(',',$data);
    $sql = "INSERT into". " ".$table." ".$field_values. "VALUES(".$data_values.")";
    $result = $conn->query($sql);

}

PHP insert function not working

1 Answers1