PHP - Question Of Design

Hi guys, I don't know if I'm over complicating things here and cannot see the wood for the trees, but I seem to have got myself confused. What I'm simply trying to do is get teamName and teamresults of a team from a database.  The code will perhaps explain better than I can (note I haven't included the DB class which is fine).

class TeamCollection {
    protected $database;
    protected $teamid;
    protected $team_name;
    
    // pass db by dependency injection...
    public function __construct(Database $database) {
            $this->database = $database;    
    }

    public function getTeam($teamid){
            $this->team_id = $teamid;
            $this->database->query("SELECT  team_name, nickname, founded FROM club WHERE team_id=:teamid");
            $this->database->bind(':teamid', $this->team_id);    
            
        // spawn a new Team object if query is valid, if not throw exception and end via try/catch...
        if ($result = $this->database->single()) {
                return new Team($result); // create new Team passing $result to Team constructor
        }
        else {
                throw new exception ('No Valid Team returned');
        }
    }
    
    public function getResults($teamid){
            $this->team_id = $teamid;
            $this->database->query("SELECT result FROM results WHERE team_id=:teamid");
            $this->database->bind(':teamid', $this->team_id);    
    
        // If a Team has valid results, return array of match scores..
        if ($scores = $this->database->results()) {
                return $scores;
        }
        else {
            throw new exception ('No Valid Team Results to return');
        }
    }

} //end class

// Team is abstracted from DB
class Team {
    
    private $team_name;
    private $result;
    private $scores;
    
    public function __construct(array $result) {
        $this->team_name = $result['team_name'];
    }
    
    public function getName() {
        $this->team_name;
    }
    
    public function getResults(array $scores) {
        foreach ($scores as $row){
            echo $row;    
        }
    }
}
// implementation

$team_id =9; // passed variable..

$database = new Database($server,$db_type); // create db..

$database->connect(); // connect to db..

$collection = new TeamCollection($database); // pass live DB link to TeamCollection Class

try {
    
    $team = $collection->getTeam($team_id); // try and spawn a valid Team Object..

    echo $name = $team->getName(); // If so lets return a Team name

    $scores = $team->getResults($team_id); // Now try and get Team Results..

    $display_results = $scores->getResults($scores); // Display results by passing them to Team class to

    }

catch (Exception $e) {
    Echo 'Exception Thrown: ' . $e->getMessage();    
}

My basic difficulty is where to put the getResults method and how to use it? I'm fine spawning a new Team as required, but is my logic for then moving on to getResults sound? I was trying to abstract my Team class from having any database association at all. Is this a wise approach or just not required? Am I overcomplicating the issue or missing something? Can anyone help? I guess my difficulty is between connecting classes and objects in the best manner. Thanks in advance.
Edited by mich2004, 19 May 2014 - 06:48 AM.

Okay, not sure what exactly I need but I need to store data in a MySQL database.

The financial data for each user has to be stored for each day.

I.e. User 1 has 20 financial data columns say (rent, maintenance, wages, shopping... etc). I need to store each of those separately so they can be displayed in a report.

There is more than one user. Most likely a couple of hundred users although it needs to work for up to a few thousand users.

Also, each user's daily financial data has to be stored against the date of that data so the user can see the change in finances between day X and day Y for example.

So far my best idea has been to create a table for each user and then in that table store the financial data in the columns against the date as the primary key. Does anyone have a better way for this or should I do this?

I have designed a database for my institute. Here I have attached my design for better understanding.   I am expecting your reviews who are professional for the database design.   Thank You.     Attached Files  Database Design for Institute Registration.jpg   61.29KB   0 downloads

I have a php file, call it "mypage.php"
it makes come calculations, create 5 different arrays,
and creates a table by using the arrays.

I found simpleXML to create XMLs easily.
I want to make an xml file by using the contents of mypage.php.

I want to do that with an argument like that "mypage?type=xml"
I'm aware that i should use "$_GET" or "$_POST"
But where should i put the php code in page,
so when i use argument "xml" it will create an xml file.
When i don't give argument it will create an html type file.

Or should i use another php that includes mypage.php??
And get arrays from that file?

Thank you.

This topic has been moved to Application Design.

http://www.phpfreaks.com/forums/index.php?topic=357188.0

Hi all!

I'm a real noob and this is my first time making a website and I haven't hosted it yet.
I'm trying to make a website that is fast and secure.
My pages look something like this.

Code: [Select]
<?php include("header.php");include("sidebar.php"); ?>
HTML CODES
<?php include("footer.php"); ?>

1. Are these php files cached after their first load? When I go to another page, those parts seem to stay still.
2. Is this code secure?

And now I'm starting to make product pages which will be around 40 pages.
So I'm considering something like  this...

Code: [Select]
<?php include("header.php");include("sidebar.php"); ?>
<a href="index.php?page=a">Page A</a>
<?php 
$page = $_GET['page'];
if (file_exists('pages/'.$page.'.php'))
{
   include('pages/'.$page.'.php');
}
?>
<?php include("footer.php"); ?>

3. Is it better to make every page like this since it will load header, sidebar, footer only once?
4. How should I protect from the user input data, by making an array of allowed files or by prohibiting "." and "/" ?

Thank you in advance.

Hi there,   This may not be the correct space to post this - but I'm very new to all this.   I've created a page that will run a php script to output a query. I would then like to send that same query via email - however from a design perspective I don't think the correct process is to click 'submit' to view the query and then 'submit' to send the result via email?   Can you please advise on some design solutions regarding this issue?   Thanks!  

Hey guys,
I have been programming for a while and I want to know what sort of design patterns I should look into when making a game?
For example what design pattern is best for:
Database management
User management
Forum management
Etc
I can only think of singleton or factory (for user/forum)
I am reasonably new to OOP, but would like to learn it properly, so I thought creating a simple program such as rock-paper-siccors would work to be able to expand it eventually, and hopefully it will teach me reusable code practice.

Im trying to get a login/register script to work in my existing page design but im getting an error, i have no idea what im doing i know next to nothing about php, i just follow tutorials. Most of the error is hidden because the font is the same color as the background but is says:
   
Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/aretheyh/public_html/nealeweb.com/index.php:16) in /home/aretheyh/public_html/nealeweb.com/index.php on line 25

Heres the page link where the error occurs:

http://www.nealeweb.com/index.php

Please help, im useless!

Len M. Kaiser Web Design is a freelance custom web design firm specializing in web design & development including forums, shopping carts, content management systems, & blogs skins and maintenance. I follow the Wc3 standards for coding and make sure that the sites & skins I create are 100% XHTML compliant. I also create complete 100% table less designs for a web site and some skin depending upon the template structure that is already built in.

Len M. Kaiser Web Design is an affordable North Charleston, SC based freelance web design firm that also serves clients all over the world. I specialize in web design, development, maintenance, & custom vBulletin related services such as vBulletin 3 & 4 styles (skins), installs, template coding, upgrades & maintenance. I have 8 years of experience in the freelance web design business & 15 years experience working with vBulletin forums and offer a hands on, individual approach with each and every client. I offer totally unique designs for your web site, forum, CMS, blog or e-Commerce site. I also have experience in various other PHP scripts such as XenForo, Wordpress, Joomla, OSCommerce, CubeCart, phpBB, Drupal, Magento, X-Cart and more! Check out My Services for a more in depth listing of what I can do for you and your business or hobby site.

I offer free quotes for potential clients.

Services I offer:

1. Custom web design & development
2. Custom forum skins such as vBulletin, XenForo, phpBB, MyBB, etc
3. Custom E-Commerce skins such as OSCommerce, X-Cart, Magento, CubeCart, ZenCart etc.
4. Custom CMS skins such as Joomla, Drupal, iScripts SocialWare etc.
5. Custom Blog skins such as Wordpress, Tumblr, Blogger etc.
6. Web site Maintenance including backups, web site moves, some hosting setups etc.
7. Installations & upgrades of any PHP script, plugin, component or software.

Thanks,
Len M. Kaiser

http://lenmakiser.com

I am trying to build an object-oriented interface for a website. My classes include a "Database" class with a constructor method that connects to a database and a destructor method that disconnects from the database, a child class called "Content" that will display content stored in the database, another child class called "User" that handles registration, updating user info, logging in, and logging out, etc., and a "Validator" class that will validate all forms. So far I have the database class, the content class, and the index.php page started. My problem is that I cannot get the data returned from the function (using mysqli prepared statements) to display on the main page. I have read tutorials using MySQL, but I am using MySQLi with prepared statements. Any help is appreciated.

Code: [Select]
Database.php
/*
The Database class handles connecting to and disconnecting from the database. All interaction with the database is then extended from this class. The constructor will be run automatically each time a new instance of the Database class (or one of its child classes) is made.
*/
abstract class Database {
// assign variables to use in the constructor
private $host = 'localhost';
private $user = '';
private $password = '';
private $database = '';

// define constructor method to connect to database
public function __construct() {
$this->connect = new mysqli($this->host, $this->user, $this->password, $this->database);
// if the connection failed kill the script and display an error
if($this->connect->connect_errno) {
die('Critical database error: ' . $this->database->error . '. Please contact a site administrator.');
}
}

// define destructor method to disconnect from the database
public function __destruct() {
$this->connect->close();
}
}


Content.php

require_once('Database.php');
/*
This class will display all website content that is held in the database. Anything that is stored in the database that needs to be shown on the front end of the website will go through this class.
*/
class Content extends Database {

public function pageInfo($page) {
$query = $this->connect->prepare('SELECT pageTitle, pageHeading, pageContent FROM pageInfo WHERE pageName = ?');
$query->bind_param('s', $page);
$query->execute();
$query->bind_result($title, $heading, $content);
return $query->fetch();
// procedurally this returns the values of the bound variables which then I can use just by typing echo $variableName
// if i echo the variables out inside this method, they display at the top of index.php
// how do i call them into my variables to display where i want
// return $query->fetch(); should return that object to main script but then how do i call those values
}

public function displayUsers() {

}

public function searchUsers() {

}

}


index.php
<?php 
$page = 'index.php';
require_once('modules/Content.php');
$page = new Content();
list($title, $heading, $content) = $page->pageInfo('index.php');
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title><?php echo $title; ?></title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<link href="includes/style.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="scripts/cufon-yui.js"></script>
<script type="text/javascript" src="scripts/arial.js"></script>
<script type="text/javascript" src="scripts/cuf_run.js"></script>
</head>
<body>

<!--begin main-->
<div class="main">
 
<?php include('header.php'); ?>

<?php include('menu.php'); ?>
 
<!--begin content-->
    <div class="content">
   
    <!--begin content_resize-->
    <div class="content_resize">
     
<!--begin mainbar-->
        <div class="mainbar">
       
        <!--begin article-->
        <div class="article">
<h2><span><?php echo $heading; ?></span></h2>
<div class="clr"></div>
<p><?php echo $content; ?></p>
</div>
<!--end article-->

</div>
    <!--end mainbar-->

<?php include('sidebar.php'); ?>
     
<div class="clr"></div>
   
    </div>
    <!--end content_resize-->
 
</div>
<!--end content-->
 
<?php include('footer.php'); ?>
   
</div>
<!--end main-->

</body>
</html>

Hi,

A web site designed about 5 years ago is doing well in search engines but I am designing a new web site using PHP, CSS and MySQL. The old site was HTML and CSS.

Do you have any design tips for Search Engines Optimisation when using PHP and MySQL? --- I will start coding soon, so all tips will be used.

Thanks,

Matt.

I have spent lots of time trying to design a nice structure for my project and I would like some feedback to what you guys think, please note this is the first time I've ever done anything like this.   About My Project I am creating a service where advertisers can search through a catalog of websites they want to directly advertise on. Once they have found a website, they can upload an image, pay the fees and start advertising on that website instantly.   I have designed an image of how I think the structure should look, I have designed it this way for efficiency but I am pretty sure I could improve with some help. If you need more info or have any questions, please ask.   Project Structure Design Image   Thanks for reading, what do you think about this structure? Can I improve it?
Edited by itsliamoco, 26 July 2014 - 09:34 PM.

This topic has been moved to Application Design.

http://www.phpfreaks.com/forums/index.php?topic=327717.0

Hi Guys   I need some help with DB design and implementation of a feature my next website will have.  OK so I'm building a system that will warn the current user that the current client needs a certain test before they can have their next treatment.  Not all treatments required tests.   So far I have the following tables   user                  treatment                         treatmentTest                         treatmentUser         iduser               idtreatment                        idtreatmentTest                        idtreatment                         idtreatmentTest                  treatmentTestExpiry                 iduser                                                                                                                      dateOfTreatment  (stored in yyyy-mm-dd)                                                                      (the treatmentTestExpiry stores how long until the treatment will expire   e.g   +1 month)     So every time a user comes in for a treatment we log the treatment in the treatmentuser table.  This works fine and I can see what treatments the user has had.  So certain treatments required a test to be done before the user can have that actual treatment.    What I want is when you view the users profile page it says if they have not had a particular test or a previous test has expired and they will need another. I have no idea how to go about this.  Im just wondering if someone could help talk me through it?