Private Server CMS

[.Light]

Alright so I've been working on a CMS [Content Management System] for a Conquer Online Private Server. So far, this is what I have:

 Spoiler

1. This is the actual site and how it's supposed to look.


2.

PHP Code:

<?php
$con=mysqli_connect("xx.xxx.xx.xxx","user","pass","co");
// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }

$result = mysqli_query($con,"SELECT * FROM articles");
?>
<div class="main main_title">
<?php while($row = mysqli_fetch_array($result))
  {
  echo $row['title'];
  echo "<br>";
  }
?>
        </div><div class="main main_content">
        <?php 
        $result = mysqli_query($con,"SELECT * FROM articles");
        while($row = mysqli_fetch_array($result))
        {
        echo $row['content'];
        echo "<br>";    
        }
?>
  <div align="right"><?php
        $result = mysqli_query($con,"SELECT * FROM articles");
        while($row = mysqli_fetch_array($result))
        {
        echo $row['author'];    
        }
  
          mysqli_close($con);
        ?>
 </div> 
</div>
         <div class="main main_bottom">
        </div>

3. This is the database table [articles]. Each id is different.

This is the point where I am stuck...What I need it to do, for every different id in the 'articles' database it needs to have a new box. A new box meaning the css coding around it so that it looks good. Kind of like this:

PHP Code:

<div class="main main_title"> TITLE PHP CODE </div>
<div class="main main_content">CONTENT PHP CODE</div>
<div class="main main_bottom">BOTTOM BORDER CSS</div> 


So for the title it needs to have the "main main_title" div tags around it.
The contect needs "main main_content" div tags around it.
The bottom border can just be put in at the end.

Not sure if this is the right spot for this, it is an idea that I am planning on releasing for the private server community, just need a little help (;

Any help is appreciated and please, if you're not going to help, please don't comment! xD

[turk55]

Model View Controller

[Super Aids]

Well that was some messy and ugly code.

[.Light]

Originally Posted by turk55

Model View Controller

Okay, so I have looked into it, I understand the concept. I just don't understand how I would implement it into my coding. Any examples you can show me? Or start on my coding so I can see it in use.

Originally Posted by Super Aids

Well that was some messy and ugly code.

Hey, at least I'm trying? Thanks for stating the obvious lol

[Spirited]

Originally Posted by turk55

Model View Controller

^ This is absolutely correct. I'm glad someone is on board with web servers.
@Light, if you're not a programmer, I'd recommend just a very simple PHP website. Nothing too complicated. If you're a programmer and you're comfortable with a programming language, I'd use a web server API such as ASP.NET (C#) or JSP (Java). You can continue using PHP as well, I'm sure there are many APIs out there with templates if you need a helping hand.

[.Light]

Originally Posted by Fang

^ This is absolutely correct. I'm glad someone is on board with web servers.
@Light, if you're not a programmer, I'd recommend just a very simple PHP website. Nothing too complicated. If you're a programmer and you're comfortable with a programming language, I'd use a web server API such as ASP.NET (C#) or JSP (Java). You can continue using PHP as well, I'm sure there are many APIs out there with templates if you need a helping hand.

Thanks for the reply, I'll see if I can get it figured out.

[turk55]

You don't really need a api to write a mvc model in php.

[.Light]

I got it working xD Thanks to someone on HackForums lol

PHP Code:

<?php $database = array(
    "host" => "xx.xxx.xx.xxx",
    "dbname" => "co",
    "user" => "user",
    "pass" => "pass"
);

$dbh = new PDO("mysql:host={$database['host']};dbname={$database['dbname']}", $database['user'],$database['pass']);
$articles = $dbh->query("SELECT * FROM `articles` ORDER BY id DESC");
foreach($articles as $article){
    echo "<div class='main main_title'> {$article['title']}</align></div>";
    echo "<div class='main main_content'>{$article['content']}</br><div align='right'>-{$article['author']}</div></div>";
    echo "<div class='main main_bottom'></div>";
} 

?>

[turk55]

Originally Posted by .Light

I got it working xD Thanks to someone on HackForums lol

PHP Code:

<?php $database = array(
    "host" => "xx.xxx.xx.xxx",
    "dbname" => "co",
    "user" => "user",
    "pass" => "pass"
);

$dbh = new PDO("mysql:host={$database['host']};dbname={$database['dbname']}", $database['user'],$database['pass']);
$articles = $dbh->query("SELECT * FROM `articles` ORDER BY id DESC");
foreach($articles as $article){
    echo "<div class='main main_title'> {$article['title']}</align></div>";
    echo "<div class='main main_content'>{$article['content']}</br><div align='right'>-{$article['author']}</div></div>";
    echo "<div class='main main_bottom'></div>";
} 

?>

That has nothing to do with MVC (Model View Controller), click the link I posted in my previous post for more info about Model View Controller and how to set one up.

Note: Sooner or later you can't write your code like that anymore, PHP is OOP as of PHP 5.5

Edit: Added a small example.