mareimorsy / db Goto Github PK

If ID = 13 the update function will send 1 to the query.
If ID = 25 the function sends 2.

And so on
Thank you

EDIT
The issue is when ID is send as an array

$db->update(cliente, [ 'nome_cliente' => $nome_cliente, 'tel1' => $tel1, 'tel2' => $tel2, 'endereco' => $endereco ],$id);

Works fine
But

$db->update(cliente, [ 'nome_cliente' => $nome_cliente, 'tel1' => $tel1, 'tel2' => $tel2, 'endereco' => $endereco ],[$id]);
Doesn't

Hello, the following function wasn't working for me:
$db->updateCliente('cliente', [ 'nome_cliente' => $nome_cliente, 'tel1' => $tel1, 'tel2' => $tel2, 'endereco' => $endereco ],['id_cliente',1]);

So I used var_dump and got:
...UPDATE cliente SET nome_cliente = ?,tel1 = ?, te2l = ?, endereco = ? WHERE id = ?"...

The issue is that 'id' didn't chage to 'id_cliente'.
To fix that I copied the update function and manually changed line 241 from
$this->where .= "id = ?";

To

$this->where .= "id_cliente = ?";

Thank you

when I import my DB From a server to a localServer on my PC using XAMPP then I try to fetch data from DB using JSON Api and Retrofit I found that error

java.lang.IllegalStateException: Expected BEGIN_OBJECT but was STRING at line 1 column 1 path $
My Api.php that is in C:\xampp\htdocs\

<?php

include 'DB.php';
$db = DB::getInstance();
header("Content-Type: application/json;charset=utf-8");

function UserLoginMethod($username , $password , $lat, $long){
    global $db;
    $sql = "SELECT * FROM users WHERE user_email = ? AND  user_password = ?
             LIMIT 1";
    $user_info = $db->query($sql, [$username, $password]);


    CheckIsEmpty($user_info);
    //echo $db->getSQL();
    echo PrintJSON($user_info[0]);

}

switch (@$_GET['function']) {
    case "Login":
        UserLoginMethod(@$_GET['user_email'], @$_GET['user_password'], $_GET['user_location_latitude'], $_GET['user_location_longitude']);
        break;


}



function CheckIsEmpty($query) {
    if (is_null($query)||empty($query)){
        die (json_encode(array('error' => 'no items funded.'),JSON_FORCE_OBJECT));
    }
}
function PrintJSON($q){
    $j = json_encode($q);
    if (count($j) > 0 && !is_null($q) )
        return $j;
    else
        die (json_encode(array('error' => 'no items funded.'),JSON_FORCE_OBJECT));
}


function CreateDieError($body){
    die (json_encode(array("error" => $body),JSON_FORCE_OBJECT));
}

?>

the current development environment in DB.php that is in C:\xampp\htdocs\

$db_config = [
//current development environment
"env" => "development",
//Localhost
"development" => [
"host" => "127.0.0.1",
"database" => "egydcom_family",
"username" => "root",
"password" => ""
],
//Server
"production" => [
"host" => "127.0.0.1",
"database" => "egydcom_family",
"username" => "root",
"password" => ""
]
];

Hi, every query that I try to execute get to me this Notice:

PHP Notice: Array to string conversion in /home/libraries/DB.php on line 511

Query work good, but always get me that error.

Is there any way to use Like, Having anf Grouy By ?

I have issues on some Turkish character like (ı,ü,ğ) t how can I set charset to fix problem ?

هل المكتبة تدعم
select * from table where name in (val1,val2)

Parse error: syntax error, unexpected 'list' (T_LIST), expecting identifier (T_STRING) in /home/u489986511/public_html/DB.php on line 800

I'm not php developer this could be a simple issue but please refer back if I'm wrong.

I got this message when I use the Class:

<br/>
<b>Deprecated</b>
:  Return type of MareiCollection::offsetExists($offset) should either be compatible with ArrayAccess::offsetExists(mixed $offset): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in <b>C:\laragon\www\operations\php\MareiDB-1.0\db.php</b>
on line <b>820</b>
<br/>
<br/>
<b>Deprecated</b>
:  Return type of MareiCollection::offsetGet($offset) should either be compatible with ArrayAccess::offsetGet(mixed $offset): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in <b>C:\laragon\www\operations\php\MareiDB-1.0\db.php</b>
on line <b>828</b>
<br/>
<br/>
<b>Deprecated</b>
:  Return type of MareiCollection::offsetSet($offset, $value) should either be compatible with ArrayAccess::offsetSet(mixed $offset, mixed $value): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in <b>C:\laragon\www\operations\php\MareiDB-1.0\db.php</b>
on line <b>781</b>
<br/>
<br/>
<b>Deprecated</b>
:  Return type of MareiCollection::offsetUnset($offset) should either be compatible with ArrayAccess::offsetUnset(mixed $offset): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in <b>C:\laragon\www\operations\php\MareiDB-1.0\db.php</b>
on line <b>824</b>

hello thanks for class but i want add Views counter
db->update('users',['last_id' => last_id+1])->where([['id_user','=',$id_user]])->exec();

some help to make a @backup of the database

all pagination systems depend on getting last group of items then go to the old one but your class do the opposite
please fix.
Thanks

Parse error: syntax error, unexpected 'list' (T_LIST), expecting identifier (T_STRING) in C:\xampp\htdocs\test\DB.php on line 800