SnowCMS[OOP][MySQLi]

Hi Ragezone,

At the moment I'm busy coding a complete new CMS called SnowCMS. It will have the same style as FunCMS (maby normal index en quickregister if you guys didn't like that style). It wil be coded in OOP using MySQLi. I'll use a bootstrap so it will be easy to edit this CMS without using <?php echo ?> but with things like {url} and {shortname}.

Here are some snippets:

PHP Code:

---

<?php

require('/SnowCMS/config.php');
require('/SnowCMS/classes/class_mysql.php');

$page = trim($_SERVER['REQUEST_URI'], '/');
$url = 'http://'.$_SERVER['SERVER_NAME'];

if (empty($page))
{
    $page = 'index';
}

ob_start();

include ('/SnowCMS/content/'.$page.'.php');

$content = ob_get_contents();

ob_end_clean();

$vars = Array(
'{url}' => $url,
'{shortname}' => Config::$name,
);

echo str_ireplace(array_keys($vars), array_values($vars), $content);

?>

---

PHP Code:

---

<?php

class mysql
{
    private $connect;
    
        function __construct()
        {
            $c = Config::$DB;
            $this->connect = new mysqli($c['db_host'], $c['db_user'], $c['db_pass'], $c['db_name']);
        }
}

?>

---

PHP Code:

---

<?php

class Config {

    static $name = 'Snow';

    static $DB = Array(
        'db_host' => '127.0.0.1',
        'db_user' => 'root',
        'db_pass' => 'Owner502',
        'db_name' => 'nieuw',
    );
    
    static $hash = 'sha1';

}
    
    
    
?>

---

I hope you guys like it.
Please say if you didn't like the style of FunCMS than I will make normal quickregister and index.
And say whatever what's bad or good about my code. I want to make it as good as possible.

Thanks :thumbup:

Thread approved, good luck on your project and hope you see it through the end.

Quote:

---

Originally Posted by KevinZuiker

It wil be coded in OOP and MySQLi.

---

I think you're going to OOP it in PHP using MySQLi. Am I correct?

Does your users class even work? O.o

Verstuurd van mijn HTC Butterfly

Quote:

---

Originally Posted by Joopie

Does your users class even work? O.o

Verstuurd van mijn HTC Butterfly

---

Simple answer, No.

I'm sorry but that users class made me laugh.

I have absolutely no faith in this project whatsoever, so no positive comments from me.

Woops i actually didnt noticed that I ruined the userclass cause I didnt test it yet :$
I will update it tomorrow.
And Leon, I'll proove you I can finish it :)

Good luck, post screenshots throughout the progress of this CMS please! Hope this turns out great.

I made a normal index and register because no one liked the style :/

I'm busy finishing register and login. (It's harder for me because I never made that kind a shit in OOP :P).

KevinZuiker? Any updates? Goodluck with project.

I'm sorry I didn't update it for a while. I was busy because my school started a vew days ago and I needed to do some stuff :P

Started with quickregister and I'm going to use prepared statements:

PHP Code:

---

<?php

    session_start();
    
    if (!isset($_SESSION['bean_month']))
    {
        
        header("Location: start");
        exit;
        
    }
    
    if (isset($_POST['name']))
    {
    
        if (empty($_POST['name']) || empty($_POST['email-address']) || empty($_POST['pass']) || empty($_POST['pass2']))
        {
            $error = 'Vul asjeblieft alle velden in!';
        }
        
        
        $selectname = $DB->prepare("SELECT * FROM users WHERE username = ?");
        
        if ($selectname->execute($_POST['name']))
        {
            echo 'Je naam is al in gebruik!';
            
        }
            
    }
    
    
    
?>

---

It isn't fisished but you can see what I'm doing at the moment.

Do I need to post screens since every hotel uses quickregister and stuff.

Oh and I have a quick question:

PHP Code:

---

$selectname = $DB->prepare("SELECT * FROM users WHERE username = ?");
        
        if ($selectname->execute($_POST['name']))
        {
            echo 'Je naam is al in gebruik!';
            
        } 


---

Is there a way to put this in a class including the error thing?

Too lazy to write a full working function, hope you get it.

PHP Code:

---

public function checkUserExists $name 
{
    if prepare->num_rows(select username from users where name = $name) == 1
        choose another name
    
    return false
} 


---

Quote:

---

Originally Posted by Nathandj

Too lazy to write a full working function, hope you get it.

PHP Code:

---

public function checkUserExists $name 
{
    if prepare->num_rows(select username from users where name = $name) == 1
        choose another name
    
    return false
} 


---

---

No matters, I understand how it workes and will use it in a way. Thanks!

Any updates as yet? Some screenies of how much you have done so far would be good.

What made you choose MySQLi over PDO?

Quote:

---

Originally Posted by iGalaxy

Any updates as yet? Some screenies of how much you have done so far would be good.

---

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.

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

Finished login and quickregister. At the moment Im thinking about how I can code my tab system.

I ll have to agree with the guy above me even though i can't code PHP OOP / PDO good or not al that the code looks pretty bad and as JOopie said i don't have faith in this development at all at this point.

I've started with PHP myself and I'm now going pretty good on learning PDO so maybe you should try that as well and then maybe later open a development

Please don't flame my code except if you can point me what I can do better.
And don't tell me my code is worse if you don't know how to code lol.

Well that's a good point your making here to be honest and i can code but i just don't think your coding is good and what i advice you and myself is to learn more before you want to open a development and I've not opened a development yet just because I'm incapable of making a CMS which I'm learning for.

Good luck with your development would also like to see the design.

Well, now I have holidays. I've got time to code my CMS :).

So I decided to create my own style:

http://snag.gy/yKSiK.jpg

http://snag.gy/n0kLg.jpg

http://snag.gy/QkfLe.jpg


Hope you guys finally like this development...

From what I can tell you're not very good with the OOP model, why not just try procedural? Their is nothing wrong with creating modules and not using an OOP approach especially if you're more comfortable with it?

Kevin, forget what everyone is saying. Do your project, release it, and see how many people will use it. Trust me the main ones flaming are the ones that may use it. Good luck.

Review your design, seriously. It isn't pleasant to see. But anyway, good luck w/ your project.

Quote:

---

Originally Posted by Roush

From what I can tell you're not very good with the OOP model, why not just try procedural? Their is nothing wrong with creating modules and not using an OOP approach especially if you're more comfortable with it?

---

When I started this project you were propably right. But I've improved my code. I even made my own template system. Although I cannot show you my new code (snippets) because my laptop needs to get fixed. I will update it as soon as possible.

Quote:

---

Originally Posted by BeatScript

Review your design, seriously. It isn't pleasant to see. But anyway, good luck w/ your project.

---

Why don't you like it? Please tell, I would like to improve the design.


Verstuurd van mijn GT-S5830i met Tapatalk

This is ugly:
http://i.imgur.com/Q8lQDCp.png

Try something else as it makes my brains crash.

What do you suggest? I don't have a lot of inspiration but I'd like to be original.

Verstuurd van mijn GT-S5830i met Tapatalk

Quote:

---

Originally Posted by KevinZuiker

What do you suggest? I don't have a lot of inspiration but I'd like to be original.

Verstuurd van mijn GT-S5830i met Tapatalk

---

Then please don't rip my design of the menu.
http://scr.bmcom.nl/1382473062_G.png

I like it, But the homepage doesn't suit the skin try to work on that ;) 4/10

Quote:

---

Originally Posted by ValorAngel

I like it, But the homepage doesn't suit the skin try to work on that ;) 4/10

---

On topic: This is a development so things are still being built, maybe a better homepage will come by in the later part of this development.

Off topic: LOL @ your sig pic ;O

Quote:

---

Originally Posted by KevinZuiker

Hi Ragezone,

At the moment I'm busy coding a complete new CMS called SnowCMS. It will have the same style as FunCMS (maby normal index en quickregister if you guys didn't like that style). It wil be coded in OOP using MySQLi. I'll use a bootstrap so it will be easy to edit this CMS without using <?php echo ?> but with things like {url} and {shortname}.

Here are some snippets:

PHP Code:

---

<?php

require('/SnowCMS/config.php');
require('/SnowCMS/classes/class_mysql.php');

$page = trim($_SERVER['REQUEST_URI'], '/');
$url = 'http://'.$_SERVER['SERVER_NAME'];

if (empty($page))
{
    $page = 'index';
}

ob_start();

include ('/SnowCMS/content/'.$page.'.php');

$content = ob_get_contents();

ob_end_clean();

$vars = Array(
'{url}' => $url,
'{shortname}' => Config::$name,
);

echo str_ireplace(array_keys($vars), array_values($vars), $content);

?>

---

PHP Code:

---

<?php

class mysql
{
    private $connect;
    
        function __construct()
        {
            $c = Config::$DB;
            $this->connect = new mysqli($c['db_host'], $c['db_user'], $c['db_pass'], $c['db_name']);
        }
}

?>

---

PHP Code:

---

<?php

class Config {

    static $name = 'Snow';

    static $DB = Array(
        'db_host' => '127.0.0.1',
        'db_user' => 'root',
        'db_pass' => 'Owner502',
        'db_name' => 'nieuw',
    );
    
    static $hash = 'sha1';

}
    
    
    
?>

---

I hope you guys like it.
Please say if you didn't like the style of FunCMS than I will make normal quickregister and index.
And say whatever what's bad or good about my code. I want to make it as good as possible.

Thanks :thumbup:

---

Is the CMS gonna be compatible with UberEmu ?

I think it would work with any database. Maby you'll need to add one or two tables.

And there is a problem. My laptop it's charger doesn't work anymore. It cannot be fixed and my laptop is really old so I have to buy a new one.

So unfortunately, all the progress will be gone...
I'm really sorry. But if I get my new laptop I will immediately recreate it.

Verstuurd van mijn GT-S5830i met Tapatalk

Just take the harddrive out and get the data from it?

Quote:

---

Originally Posted by KevinZuiker

I think it would work with any database. Maby you'll need to add one or two tables.

And there is a problem. My laptop it's charger doesn't work anymore. It cannot be fixed and my laptop is really old so I have to buy a new one.

So unfortunately, all the progress will be gone...
I'm really sorry. But if I get my new laptop I will immediately recreate it.

Verstuurd van mijn GT-S5830i met Tapatalk

---

Remove the battery and put your laptop on, maybe it would work.

Like Eronisch said, take the hard drive out and get data from it.

Made my own template system:
http://www.mediafire.com/?t5ayxxvjhxkmviv

And I do not use any PHP in the content at all :)

Verstuurd van mijn GT-S5830i met Tapatalk

Those 'Snippets' are just copies of Global.php, COnfig.php... How can we know that it isn't a Rename or something like that?
...

Quote:

---

Originally Posted by VariousCoderz

Those 'Snippets' are just copies of Global.php, COnfig.php... How can we know that it isn't a Rename or something like that?
...

---

You can't.

Well I recoded the whole system (I think it's much better now).
Not the content since I'm not able to find the images on the internet anymore :mad: xd

Will update the snippets tomorrow.

This dead???

Seems to be dead maybe the moderator just needs to close this thread untill the developer is back .