Save and iterate array in php-mysql

Question

I have the following code to save an array in my DB:

public function agregarBolsasModel($datos, $tabla) {
        $datosL=array($datos["valoresBox"]);
        $stmt = Conexion::conectar() -> prepare("INSERT INTO $tabla(lote, caja, bolsa)VALUES(:one, :two, :three)");

        for($p = 0; $p < sizeof($datosL); $p++) {
            $stmt -> bindParam(":one", $datos["loteNum"], PDO::PARAM_INT);
            $stmt -> bindParam(":two", $datos["cajaNum"], PDO::PARAM_INT);
            $stmt -> bindParam(":three", $datosL[$p], PDO::PARAM_INT);
            $stmt->execute();
        }

        $stmt->close();
}

The value of three is an array like [1,2,3] where I don't know the size cause it's a dynamic array, but I can't save the data in my DB, also when I tried to save the data I received the following error:

Fatal error>: Uncaught error: Call to undefined method PDOStatement::close()

what is my mistake? How could I do to fix that?

Thanx

CritingZ · Accepted Answer · 2018-02-21 15:05:01Z

5

PDO doesn't have a "close" function. You can do

$this->db = null;

In your case, on $stmt

answered Feb 21, 2018 at 15:05

CritingZ

4413 silver badges18 bronze badges

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

Comments

Apetu Gideon · Accepted Answer · 2018-02-21 15:08:47Z

2

Use $stmt = null; instead of $stmt->close();

answered Feb 21, 2018 at 15:08

Apetu Gideon

1361 silver badge5 bronze badges

Collectives™ on Stack Overflow

Save and iterate array in php-mysql

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related