ammarfaizi2 / php-icetea Goto Github PK

Would you please solve the fatal error and commit them to the branch dev2? and, Please tell me that it done. Then I'll merge it. Thanks

commit 11fd19e
Author: Ammar Faizi [email protected]
Date: Fri Jun 9 21:38:26 2017 +0700

Update login model

I tried updating a table with DB::table('table_name')->where(...)->update(...) but the result is a Fatal Error.
Any advice?

Fatal error: Uncaught Error: Call to undefined function System\Crayner\Database\makeUpdateParameter() in /home/redangel/public_html/newicetea/System/Crayner/Database/DB.php:385

Stack trace:
#0 /home/redangel/public_html/newicetea/App/Controllers/test.php(26): System\Crayner\Database\DB::update(Array)
#1 /home/redangel/public_html/newicetea/System/Crayner.php(71): App\Controllers\test->index()
#2 /home/redangel/public_html/newicetea/public/index.php(4): System\Crayner->run()
#3 {main}
 thrown in /home/redangel/public_html/newicetea/System/Crayner/Database/DB.php on line 385

Could you fix it and commit them to the branch dev2 ?
and please tell me that it done. Then I will merge it to the main branch. Thanks!

How can i execute this query with querybuilder?
UPDATE `register_history` SET try = try+1 WHERE hash = :hash

Can you add increment and decrement method to querybuilder like laravel ?
It is a future challenge. I would welcome the PR.

When i try delete a row, it throw me an error
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's 'e' AND 1='' LIMIT 1' at line 1"

Debug test

 public function logout($userid, $session)
    {
        try{
            $a = DB::table("login_session")->where(["userid", $userid],["session", $session])->limit(1)->delete();
        } catch(\PDOException $e) {
            var_dump("<br><br>".DB::getInstance()->statement,"<br><br>" .$e->getMessage());
        }
    }

I was able to delete all rows without where method but not with it.

Recently commit
commit 3292749
Author: Ammar Faizi [email protected]
Date: Sat Jun 10 19:36:45 2017 +0700

Update Login model