SnowCMS[OOP][MySQLi]

Quote:

---

Originally Posted by HillBilly

What made you choose MySQLi over PDO?



Why are you spamming so much and posting every time the same?
You dont create a CMS in a week or two. I bet the only thing he has is some bunch of code, being its base. You're asking for screens but there is no layout yet (I think). If there is progress being made I think he will post it here, untill then just wait.

---

Calm down.

Will thois work with Phoenix and BcStorm?

Quote:

---

Originally Posted by HillBilly

What made you choose MySQLi over PDO?

---

The way you say that makes MySQLi so bad, which isn't at all.

You guys are fucking genius. Using the old MySQL extention when it's deprecated like a boss. And suddenly they know PDO and prefer that one over MySQLi? I guess you like named prepared params better?

Or is it the cross database engine that did it, which you dont even need in the current Habbo development as everyone uses MySQL....

I'm trying to update my register a bit by using functions and prepared statements. But I'm getting a really annoying error and I don't know why I get it :S

The error:
Catchable fatal error: Object of class mysqli could not be converted to string in C:\xampp\htdocs\SnowCMS\classes\class_user.php on line 10

The line:

PHP Code:

---

$checkuser = $this->$DB->prepare("SELECT * FROM users WHERE username = ?"); 


---

The function:

PHP Code:

---

public function CheckUser($username)
        {
            global $DB;
            
            $checkuser = $this->$DB->prepare("SELECT * FROM users WHERE username = ?");
            $checkuser->bind_param('s', $username);
            
            if($checkuser->execute())
            {
                $checkuser->store_result();
            }
            
            return false;
        } 


---

Quote:

---

Originally Posted by iGalaxy

Calm down.

Will thois work with Phoenix and BcStorm?

---

At the moment it uses swiftdb. I thought phoenix and swift had the same ticketsystem (or how you call it), so it will work on both as long as you add cms_news. In the release I will give a simple sql to add it.

Quote:

---

Originally Posted by HillBilly

What made you choose MySQLi over PDO?

---

Can't really answer that =P I thought PDO isn't that useful in the habbo section. Also I didn't really think about using PDO at all =P I just learned MySQLi.

Take a min to review this bit:

Quote:

---

global $DB;

$checkuser = $this->$DB

---

PHP Code:

---

public function CheckUser($username)
        {
            global $DB;
            
            $checkuser = $this->$DB->prepare("SELECT * FROM users WHERE username = ?");
            $checkuser->bind_param('s', $username);
            
            if($checkuser->execute())
            {
                $checkuser->store_result();
            }
            
            return false;
        } 


---

Shouldnt it be:

PHP Code:

---

public function CheckUser($username)
        {
            global $DB;
            
            $DB->prepare("SELECT * FROM users WHERE username = ?");
            $DB->bind_param('s', $username);
            
            if($DB->execute())
            {
                $DB->store_result();
            }
            return false;
        } 


---

Quote:

---

Originally Posted by HillBilly

PHP Code:

---

public function CheckUser($username)
        {
            global $DB;
            
            $checkuser = $this->$DB->prepare("SELECT * FROM users WHERE username = ?");
            $checkuser->bind_param('s', $username);
            
            if($checkuser->execute())
            {
                $checkuser->store_result();
            }
            
            return false;
        } 


---

Shouldnt it be:

PHP Code:

---

public function CheckUser($username)
        {
            global $DB;
            
            $DB->prepare("SELECT * FROM users WHERE username = ?");
            $DB->bind_param('s', $username);
            
            if($DB->execute())
            {
                $DB->store_result();
            }
            return false;
        } 


---

---

No...

Verstuurd van mijn HTC Butterfly

Quote:

---

Originally Posted by Joopie

Take a min to review this bit:

---

I don't think that's a problem, this is in my core:

PHP Code:

---

$c = Config::$DB;
$DB = new mysqli($c['db_host'], $c['db_user'], $c['db_pass'], $c['db_name']); 


---

Quote:

---

Originally Posted by HillBilly

PHP Code:

---

public function CheckUser($username)
        {
            global $DB;
            
            $checkuser = $this->$DB->prepare("SELECT * FROM users WHERE username = ?");
            $checkuser->bind_param('s', $username);
            
            if($checkuser->execute())
            {
                $checkuser->store_result();
            }
            
            return false;
        } 


---

Shouldnt it be:

PHP Code:

---

public function CheckUser($username)
        {
            global $DB;
            
            $DB->prepare("SELECT * FROM users WHERE username = ?");
            $DB->bind_param('s', $username);
            
            if($DB->execute())
            {
                $DB->store_result();
            }
            return false;
        } 


---

---

That's kind of impossible? You know it are prepared statements right? =P

Quote:

---

Originally Posted by KevinZuiker

I don't think that's a problem, this is in my core:

PHP Code:

---

$c = Config::$DB;
$DB = new mysqli($c['db_host'], $c['db_user'], $c['db_pass'], $c['db_name']); 


---

That's kind of impossible? You know it are prepared statements right? =P

---

You do know that when you do $this->$db that $db supossed be a string or class with a matic string function. Remove $this-> might work.

Verstuurd van mijn HTC Butterfly

Wow this PHP confuses me, anyone can teach me that PHP? LOL

I have a new problem, when is try to go to for example this url:

Quote:

---

http://localhost/index.php?name=kevin

---

It automatical redirects to:

Quote:

---

http://localhost/index.php?name=kevin.php

---

I know why this happends, the only problem is, I don't know how to fix it :/

Update: Made a function to get handlers for pages like the register:

PHP Code:

---

public function GetHandler()
    {
        global $page;
        
        if(is_file('/CMS/TPL/handlers/handler_'.$page.'.php'))
        {
            require('/CMS/TPL/handlers/handler_'.$page.'.php');
        }
    } 


---

Also coded the route system into a function instead of in the index.php.

Quote:

---

Originally Posted by iGalaxy

Wow this PHP confuses me, anyone can teach me that PHP? LOL

---

It's just OOP using MySQLi.

Quote:

---

Originally Posted by KevinZuiker

I have a new problem, when is try to go to for example this url:


It automatical redirects to:


I know why this happends, the only problem is, I don't know how to fix it :/

Update: Made a function to get handlers for pages like the register:

PHP Code:

---

public function GetHandler()
    {
        global $page;
        
        if(is_file('/CMS/TPL/handlers/handler_'.$page.'.php'))
        {
            require('/CMS/TPL/handlers/handler_'.$page.'.php');
        }
    } 


---

Also coded the route system into a function instead of in the index.php.


It's just OOP using MySQLi.

---

I know its OOP...

Going to be totally honest and straight up, this project looks like shit. A part of this actually looks like you have no idea what you are doing. I wish you the best though.

Use constructors, not globals

Wow, how great. I restarted my PC and all the files I had opened in notepad changed in to files with only this:

Quote:

---

NUL NUL NUL NUL etc...

---

Happily I know how I coded the stuff so I hope I can code it all back this weekend.

Update: I already coded it and also made it better, this weekend Ill post some updates.

This coding looks like shit, you should first learn proper PHP and then do a CMS
Also as they say you shouldnt use globals