<?php
  class Connection extends mysqli{
    //Connection data
    private $DB_NAME = "datos";
    private $DB_TABLE = "user";
    private $DB_HOST = "localhost";
    private $DB_PASSWORD = "password";
    private $DB_USER = "root";
    public $DB_CHARSET = "utf8";

    //Constructor
    public function __construct(){
      parent::__construct($this->DB_HOST,$this->DB_USER,$this->$DB_PASSWORD,$this->DB_NAME);
      if ($this->connect_errno) echo "<div class='mensaje'>Error:
        {$this->connect_errno} -> {$this->connect_error}</div>";
      $this->set_charset($this->$DB_CHARSET);
    }

    //Insert new record
    public function insert($id,$name,$password){
      $sql_comand = "INSERT INTO {$this->DB_TABLE} VALUES (?,?,?)";
      if(!($sentence = $this->prepare($sql_comand))){
        echo "Error(prepare): {$this->connect_errno} -> {$this->connect_error}";
      }
      $sentence = $this->bind_param("iss",$id,$name,$password);
      $sentence->execute();
    }
  }

  $conexion = new Connection();
?>