Warning: PDO :: __ construct () expects parameter 4 to be array, string given in

Question

Warning: PDO :: __ construct () expects parameter 4 to be array, string given in

Navigation

#1 by (0 votes)
#2 by (0 votes)

0

I'm starting to program in PHP and MySql and trying to connect the database with the PDO method marks me the error, This is my code:

else {
        try {
            $conexion  = new PDO('mysql:host=localhost;dbname=registro_prueba1', 'root', 'contraseña', '');
        } catch (PDOException $e) {
            echo "Error " . $e->getMessage();

The error that is presented is the following:

Warning: PDO :: __ construct () expects parameter 4 to be array, string given in

Does anyone know how to do it?

mysql php

asked by Mike Reyes 17.05.2017 в 17:52

source

2 answers

Hide Adobe Animate objects by variable, from EaselJS asp net mvc5 - resource file for web multi language

score 0 · Answer 1

What happens is that the last parameter of the function PDO::__construct() receives an array of options of type array(key=>value) and you are sending an empty string when putting your two quotes '' .

Simply omit it since it is optional, so that your construction function is as follows:

$conexion = new PDO('mysql:host=localhost;dbname=registro_prueba1', 'root', 'contraseña');

score 0 · Answer 2

I suppose you try to make a persistent connection with PDO PDO::ATTR_PERSISTENT , but you are sending an empty string due to your ' ' and that last parameter supports only an array array( PDO::ATTR_PERSISTENT => true

You can only delete these simple quotes ' ' after password, leaving your connection variable then:

$conexion = new PDO('mysql:host=localhost;dbname=registro_prueba1', 'root', 'contraseña');

With that you will connect in the same way with your database