noahheck / e_mysqli Goto Github PK

Hi,

I've dectected an issue by using bind_param function.
By exemple, after calling : bind_param(iis,$param1,$param2,$param3)

my variable $param1 is transformed into an array contening other parameters.

It is a problem if I want to reuser this parameter in another query...

can we use this utility , procedural mysqli ?

Hi I install just 8.1.1 php version . I get warning

( ! ) Deprecated: Return type of EMysqli\EMysqli::prepare($query) should either be compatible with mysqli::prepare(string $query): mysqli_stmt|false, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in E:\xampp\htdocs\kabaskal.com\vendor\noahheck\e_mysqli\src\EMysqli.php on line 29

First of all thank you for this great library, it helps a lot in my workflow!

Now, I want to INSERT more than one row at the same time, using something like this:

INSERT INTO table_name (ref_key, value) VALUES
    ROW(123, 'value_1'),
    ROW(123, 'value_2'),
    ROW(123, 'value_3');

In this case ref_key would always be the same, stored in the variable $ref_key = 123,
and the value would be different for each row, stored in the array $values = ['value_1', 'value_2', 'value_3'].

Is it possible to build a mysql statement like this using E_mysqli?

İ installed vie composer , so far so good .
but
require_once "path/to/vendor/autoload.php";
where is this folder???

Hello Noah,

thank you very much for this nice peace of code.

I got an error, when i run the script:
Strict Standards: Declaration of E_mysqli_stmt::bind_param() should be compatible with mysqli_stmt::bind_param($types) in ... on line 220

I have no idea why the parameters are to be wrong. The parameters seem to be like in the parent class function.

Do you have an idea?

Thank you

Dave