classes, quick question...

phpn00bf4life

index.php

<?php
/*
*Page created on Saturday, May 21
*Created by EliteKsK, Jon
*US
*/
include_once("./required.php");
include_once("./".$wg_req_folder."/IT.PHP");

$theme = new html_Theme;

$theme->db = "SELECT title FROM ".$wg_req_db_pre."config WHERE id = 1 LIMIT 1";

$title = $theme->site_queries();
$site_title = $result;
$type = "news";
echo''.$site_title.'';
$display_theme = $theme->html_template($site_title);

die();
?>

<?php
/*
*Page created on Saturday, May 21
*Created by EliteKsK, Jon
*US
*/
class html_Theme {
	var $db;
	var $title;
	var $copyright;
	var $new;
	function site_queries(){
		$query = trim($this->db);
		$result = mysql_query($query);

}
function html_template($site_title){
	$title = $site_title;
	echo'<html><head><title>'.$title.'</title></head>';
	//here comes some fun...next line we need to determine what we're doing, so we can throw it into the main site
}
}
?>

Well my problem is, it doesn't get the mysql_thing i need... it's a problem mainly because i've checked all the mysql stuff, and made sure that there's an entry, so what should i do?

norpel

your site_queries function doesnt set any of the variables of the html_theme object... all it does is do a query on the database but not do anything with the result... not even return it.

try adding

$row = mysql_fetch_array($result);
return $row;

to your site_queries function.

and replace the lines

$title = $theme->site_queries();
$site_title = $result;

with

$myresult = $theme->site_queries();
$site_title = $myresult[title];

this will get your code working, but seems a bit long winded way to do a query - do you really need a class to do this function when it does nothing more really than just query the database.

hope this helps,
norpel

phpn00bf4life

it's more or less a simple and easy way to learn classes 🙂 thanks bro!

norpel

probably the 'nicest' way to do this stuff would be to add a load() function to your html_theme
class

function load($id) {
  // assume that this object always comes from one table - myconfig
  $query = "SELECT * FROM myconfig WHERE id=".$id;
  $result =mysql_query($query);
  $row = mysql_fetch_array($result);
  $this->title = $row['title'];
  $this->copyright = $row['copyright'];
  $this->new = $row['new'];
}

then in index.html

$mytheme = new html_theme();
$mytheme->load(1);
$site_title = $mytheme->title;

this load function can then be used for any other information you require at other places & in other scripts