sangoku

Any sugestions how to optimize this I have a class which when called makes a query to the BD and populates it self. <?php class name { private $DB_table_name= 'somthing'; private $table_fields = array('bla', 'pi','po'); private $bla; private $pi; private $po; function __construct($user_id){ // it gets the data and populates it self, mean the bla pi po //each private is a representation of a value in the row of a DB } } //now here is the roblem i have a class which extends this class class damn extends name { // now here i have some other data private $pika; private $toka; private $njanajnjanaja; //here i have a function function __construct ($input){ $this->doSome(); } private function doSome(){ //do some //and hee is the problem i need to make some changes in the name class BUT it needs to be in this object // i use a function which copys the resulting object into the vlaues of this object $parent_object = new name($this->toka); //and now i sopy the result into the object via some while loops //is there a bether way to popoulate this object ???? // the copyng ceates much overhead..... } } ?> the coping creates much over head can i somehow avoid it?

know that mean any suggestions is there any good testing script you can recommend?

ye right create a 10 k test entrys... any idea how?

Well the main problem is that that table is called very very often but most of the time it is called in that way that most of the table data is not needed (by viewing of the user) and that table will be very big. like around 100k of entrys

Yes, but when i try to reference the table with partitioning, the MySQL work branch says it cant do it so i belived it.... I mean when a table references a partitioned table to be exact.

as far i know it dous not, but maybe the damn tool is out of date il check it later manually i use MySQL workbranch.... Can you recomand any bether????

Lols.... I knew about horizontal partitioning but not about this weirdness of a thing... I use horizontal already but the thing is it duos not support FK constrains... is it the same with the vertical????

Hy guys i have a bit of a dilema here i am making a MySQL table and i have 2 tables. CREATE TABLE IF NOT EXISTS `Forum`.`user_hash` ( `user_ID` INT(10) UNSIGNED NOT NULL , `username` VARCHAR(45) NOT NULL , `user_is_online` TINYINT(1) NOT NULL , `password_hash` VARCHAR(40) NOT NULL , `usergroup_id` SMALLINT(5) UNSIGNED NOT NULL , `avatar_loc` VARCHAR(250) NULL , `energy` INT(7) UNSIGNED NOT NULL DEFAULT 26 , `reputation` INT(7) UNSIGNED NOT NULL DEFAULT 1 , `Broj_odgovora` INT( UNSIGNED NOT NULL DEFAULT 0 , `zadnji_login_u` TIMESTAMP NOT NULL , `user_tema` INT(3) NOT NULL , `pocetna_stranica` INT( UNSIGNED NOT NULL DEFAULT 1 , `downloadovao_kolicina` INT(10) UNSIGNED NOT NULL , `broj_downlaoda` INT(10) UNSIGNED NOT NULL , PRIMARY KEY (`user_ID`) , INDEX `fk_user_id` (`user_ID` ASC) , INDEX `fk_CSS_tema` (`user_tema` ASC) , INDEX `username` (`username` ASC, `user_ID` ASC) , INDEX `pocetna_stranica` (`pocetna_stranica` ASC) , INDEX `usergroup` (`usergroup_id` ASC) , CONSTRAINT `fk_user_id` FOREIGN KEY (`user_ID` ) REFERENCES `Forum`.`user_data` (`user_ID` ) ON DELETE CASCADE ON UPDATE NO ACTION, CONSTRAINT `fk_CSS_tema` FOREIGN KEY (`user_tema` ) REFERENCES `Forum`.`CSS_stil` (`ID_stila` ) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `pocetna_stranica` FOREIGN KEY (`pocetna_stranica` ) REFERENCES `Forum`.`meni_stranice` (`ID_stranice` ) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `usergroup` FOREIGN KEY (`usergroup_id` ) REFERENCES `Forum`.`usergroup` (`usergroup_ID` ) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB and another one CREATE TABLE IF NOT EXISTS `Forum`.`user_data` ( `user_ID` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT , `dan_registracije` DATE NOT NULL , `registarcioni_IP` INT(12) UNSIGNED NOT NULL , `locked_ip` BINARY NOT NULL DEFAULT 0 , `banovan` TINYINT(1) NOT NULL DEFAULT false , `GMT_time` INT(2) UNSIGNED NOT NULL , `mail` VARCHAR(120) NOT NULL , `pol_korisnika` TINYINT(1) NOT NULL COMMENT 'true je male, false female XD' , `msn` VARCHAR(120) NULL , `yahoo` VARCHAR(120) NULL , `alm` VARCHAR(120) NULL , `ICQ` VARCHAR(120) NULL , `facebook` VARCHAR(120) NULL , `gmail` VARCHAR(120) NULL , `homepage` VARCHAR(240) NULL , `show_mail` TINYINT(1) NULL DEFAULT false , `show_other_mails` TINYINT(1) NULL DEFAULT false , PRIMARY KEY (`user_ID`) , INDEX `mail` (`mail` ASC) ) ENGINE = InnoDB The names are on Serbian but that duos not mater. I am in a dilemma here, is it good practice to keep the data that is by its nature big and not regular like alternate user data which is in the second statement in a separate table and the usually called and often accessed. My question is. Is it better to keep those data in a single table or, in separate ones?

Hy i have a bit of a dilemma here the one like what first egg or the chicken... Here is my dilemma i have classes like: attachment which is a factory for - pictures -rar, zip -reputation -value ... another class... another class... user which has some values -money -energy. ... Now i need to construct a class that would handle all of those data like the scenario user opens a attachment-->attachments receives some values-->user receives some values-->user gets the requested attachment now the user can request many thing not only attachment he can evaulete tags, edit bla bla... Now my dilemma is where the heck shall i store the data? shall i make the object update the DB or shall i store the data in a session.... And one more shall i use a interface to implement all the other sessions or shall i use a abstract class?

Ehm,,, sorry but can you be a BIT more detailed what files are you using, etcetera.... and do you have some viruses on your pc, as far you use some...

quite few, but to lithe explanation jokes aside. i had teh same problem to for some time. you probably made one of the files which contain your php code in a difrent code than the encoding you are giving in the header of your html.... you will have quite a mess to corect it. go to all files and save them in the utf or what ever encoding you are using.

There are quite good books on line which tell you how to handle user uploads like: store the files under custom random names, store the names in a DB, store the files outside the www directory and so on.... really good books like Secure file upload in PHP web applications Alla Bezroutchko June 13, 2007 i dont know if i can uload it here but i can send it to you via mail

I am not an expert in RSS, but as fat i know RSS is only a XML file which can only be accessed and can access back... as far i know But i could be wrong. On every single API i encountered until now (opera mozila mobiile rss reader...) you have to acess the page to check if there are new chanels. As far i know it is not possible, as far...

:'( found the solution it was so simple yet brilliant i just checked if $this was set XD if yes dont make new object

could i use get_called_class to find this out because it says in help Returns the class name. Returns FALSE if called from outside a class. duos it mean if it is called inside a class it will always turn true even if is called over a static function??? il hack it now... edit: damn it dous..... what now.... when you call it like class a{ static function b(){ return get_called_class() ; } } $a = a::b(); you get a......... AAAaaaa!!!

Hy as told i need a way to to let a class function know if i is either called before any object is made, eg. in a static function or inside a object. pls can someone help me out ups. had 2 windows open typed in a wrong one can someone delete/move this massage. to php coding help

Ok I admit it I am an giant idiot @selfdefence: Well you cant blame me im on the computer over 12 h already and it is 0:25 ,,, you cant return a object inside an object you have to use $this-> statments.... :'( On to rewriting my other classes....

ok solved it but still have some quirks.

ok i have a class: class bruteAttackLog extends DatabaseObject { protected static $table_name = 'brute_attack_log'; protected static $db_fields = array('IP_adresa','broj_napada','zakljucana_do','broj_zakljucavanja','trajno_zatvorena','MAC_adresa'); // these are the rows in the database public $IP_adress; public $attak number; public $locked_untill; public $locked_times; public $perma lock; public $MAC_adresa; function makeLog() { $log = self::find_by_IP(); //this thing finds the ip if it exists in the brut lock table and returns it in a form of a object of this object if (!$log){//if it dous not exist then make one $this->IP_adresa = funkcijeOsnovne::uzmiIP(); $this->broj_napada = 1; $this->create(); //crate is defined in an another class and works 100% and it populates the object } else {//if teh entry exists then: //we check if there is a over step if($log->attacked<= max_nr_of_attacks) { $log->locked_until = date('c',time()-1); // we set the locked until time $log->attack_nr += 1; $log->update();//update returns false/true no object just like save return $log; and here it returns the object here is my problem!!!!!!!!!!!!! } } } this is not the whole class, it is pretty big my point is when i call the class like $log = new bruteAttackLog(); $log->makeLog(); it duos the create thing, it duos even the update. But id duos not return the object to the $log object when the update hapens....i still get a empty object, how do i correct it?????????? I am out of ideas....

i corrected it XD but not how i wanted i will post the files that are included ok i have a class: class bruteAttackLog extends DatabaseObject { protected $kljuc = 'IP_adresa'; protected static $table_name = 'brute_attack_log'; protected static $db_fields = array('IP_adresa','broj_napada','zakljucana_do','broj_zakljucavanja','trajno_zatvorena','MAC_adresa'); public $IP_adresa; public $broj_napada; public $zakljucana_do; public $broj_zakljucavanja; public $trajno_zatvorena; public $MAC_adresa; /** * stvara, updejtuje banuje pri instanciranju * * @param curent $ip * */ function newLog() { //ukoliko imamo ip adresu zabiljezenu unutar baze onda $log = self::find_by_IP(); if (!$log){//provjeravamo dali ima data ip zabilježena $this->IP_adresa = funkcijeOsnovne::uzmiIP(); $this->broj_napada = 1; $this->create();//ukoliko ne onda pravimo novi zapis } else {// kada postoji objekat radimosliedeće operacije //provjeravamo dali je prekoracen max br napada if($log->broj_napada <= MAX_NAPADA) { $log->zakljucana_do = date('c',time()-1); // postavljamo zakljucavanje na proslo vreme tako da imamo vreme zadnjeg ristupa $log->broj_napada += 1; $log->update(); } else { //postavljamo zaključavanje na 3 sata $log->zakljucana_do = date('c',(time() + (3* 60 * 60))); $log->broj_napada = 0; $log->broj_zakljucavanja += 1; $log->update(); } } } function __destruct() { } /** * Vraca vrednost false ukoliko nema unosa, permanent ukoliko je permanentan ban * i vrijeme preostalog bana u seundama * * @param IP $ip * @return false, permanent, time remaining */ public static function daliJeBanovana($ip){//provjeravamo dali je ip banovan $ip = self::find_by_IP($ip);//nalazimo ip u bazi podazi podataka if (!$ip){ return false;//ukolilkop ne postoji ip u bazi vracamo false } if ($ip->trajno_zatvorena){ return 'permanent'; //ukoliko je trajno zatvorena vracamo 'permanent' } if ( isset($ip->zakljucana_do)){ $ban = mktime($ip->zakljucana_do); if ($ban >= time() ){ $ban = $ban - time(); return $ban; } } } private static function find_by_IP() { $res = self::find_by_id(ip2long(funkcijeOsnovne::uzmiIP()),'IP_adresa'); if ($res) $res ->IP_adresa = long2ip($res->IP_adresa) ; return $res; } /** * postavlja trajno Zatvaranje na true * * @param IP $ip * */ private function zakljucavac($ip){ $ip = self::find_by_IP($ip); $ip->trajno_zatvorena = true; $ip->update(); } public function update(){ $this->IP_adresa = ip2long($this->IP_adresa); parent::update(); } public function create(){ $this->IP_adresa = ip2long($this->IP_adresa); parent::create(); } public function delete(){ $this->IP_adresa = ip2long($this->IP_adresa); return parent::delete(); } } and the extendet class class DatabaseObject { /** * nađi sve u datoj tabeli * */ public static function find_all() { return self::find_by_sql("SELECT * FROM " .static::$table_name); } /** * nađi u tabeli id vrednost prema koloni ID_is * * @param int $id * @param text $kljuc * @return mixed */ public static function find_by_id($id=0, $kljuc) { $result_array = static::find_by_sql("SELECT * FROM ".static::$table_name." WHERE {$kljuc}={$id} LIMIT 1"); return !empty($result_array) ? array_shift($result_array) : false; } /** * Izvršavanje sql upita sa instanciranjem * * @param mixed $sql */ public static function find_by_sql($sql="") { global $DB; $result_set = $DB->query($sql); $object_array = array(); //OVO INSTANCIRA VIŠE OBJEKATA ODJEDNOM!!!!!! //OVO INSTANCIRA VIŠE OBJEKATA ODJEDNOM!!!!!! while ($row = $DB->fetch_array($result_set)) { $object_array[] = static::instantiate($row); } //OVO INSTANCIRA VIŠE OBJEKATA ODJEDNOM!!!!!! //OVO INSTANCIRA VIŠE OBJEKATA ODJEDNOM!!!!!! return $object_array; } /** * Nađi koliko elemenata je u tabeli * @return int $read */ public static function count_all(){ global $DB; $sql = "SELECT COUNT( * ) FROM ".static::$table_name; $rezult_raw = $DB->query($sql); $red = $DB->fetch_array($rezult_raw); return array_shift($red); } /** * iscitava atribute iz klase i vraca ih kao array * * @return array $atributi */ protected function attributes() { $attributes = array(); foreach (static::$db_fields as $field){ if (property_exists($this,$field )) { $attributes[$field] = $this->$field; } } return $attributes; } /** * uvraca ociscene atribute od nepotrebnih vrednosti * * @return array $cisti_atributi */ protected function sanitized_attributes() { global $DB; $clean_atttributes = array(); foreach ($this->attributes() as $key => $value ){ $clean_atttributes[$key] = $DB->sql_prep($value); } return $clean_atttributes; } /** * update izaziva update * * @param autoincrement $id * @param update */ public function create(){ global $DB; $atrributes = $this->sanitized_attributes(); $sql = "INSERT INTO ".static::$table_name." (". join(", ", array_keys($atrributes)) .") VALUES ('"; $sql .= join("', '",array_values($atrributes) ); $sql .= "')"; if ($DB->query($sql)) { $key = $this->kljuc; $this->$key =$DB->insert_id(); // pozivamo $this->$this->kljuc da bi vrednost kljuc bila pozvana kao atribut $this return TRUE; } else { return FALSE; } } public function update(){ global $DB; $atttributes = $this->sanitized_attributes(); $atttribute_pairs = array(); //nalazimo trenutne vrednosti objekta i pohranjujemo ga u array foreach ($atttributes as $key =>$value ){ $atttribute_pairs[] = "{$key} = '{$value}'"; } $sql = "UPDATE ".static::$table_name." SET "; //dati array koristimo kao upit $sql .=join(", ",$atttribute_pairs)." "; $kljuc = $this->kljuc; $sql .="WHERE {$DB->sql_prep($this->kljuc)} = ".$DB->sql_prep($this->$kljuc); //id predstavlja ime referencirane autoinkrementirane kolone $DB->query($sql); return($DB->affected_rows() == 1) ? TRUE : FALSE; } public function delete(){ global $DB; $sql = "DELETE FROM ".static::$table_name. " WHERE ".$DB->sql_prep($this->kljuc)." = "; $sql .= $DB->sql_prep($this->$this->kljuc); $DB->query($sql); return($DB->affected_rows() == 1) ? TRUE : FALSE; } /** * instancira objekat po zavrsavanju upita * * @param mixed $record * @return object $object */ private static function instantiate($record) { $class_name = get_called_class(); $object = new $class_name; foreach($record as $attribute=>$value){ if($object->has_attribute($attribute)) { $object->$attribute = $value; } } return $object; } /** * provjera dali postoji dati atribut * * @param mixed $attribute * @return bool */ private function has_attribute($attribute) { $object_vars = $this->attributes($this); return array_key_exists($attribute, $object_vars); } } and the class this class extends <?php /** * @author Siniša Čulić * @version 1.0 * * @created 10-02-2010 01:31:22 */ //provijera pristupa i logovanje napada if (!defined('ACESS')){// ukoliko pristup nije opravdan radi: if (!defined('SITE_ROOT')) { $sada = $_SERVER['PHP_SELF']; //saznajemo lokaciju samoga fajla $root = explode('/',$sada, 3);// izdvajamo samo lokacju osnovnog foldera define ('SITE_ROOT',$_SERVER['DOCUMENT_ROOT'].$root[1]); // i date informacije definisemo } include_once(SITE_ROOT.'/protected/internaSigurnost.php'); }// kraj provjere sigurnosti class MySQLDatabase{ //Privatni atributi private $connection; private $magic_quotes_active; private $real_escape_string_exists; //---------------javni atributi:-------------*/ public $zadni_upit; //---------------kraj javni atributi:-------------*/ //konstruktor za datu klasu function __construct(){ $this->open_conection();//otvaramo konekciju pri inicijalizaciji $this->magic_quotes_active = get_magic_quotes_gpc(); $this->real_escape_string_exists = function_exists( "mysql_real_escape_string" ); // i.e. PHP >= v4.3.0 } //javna metoda otvaranje konekcije public function open_conection(){ $this->connection = mysql_connect(DB_SERVER,DB_USER,DB_PASS); if (!$this->connection) { //die("Database connection failed: " . mysql_error()); log::loguj('SQL',$this->zadni_upit); }else { $db_select = mysql_select_db(DB_NAME, $this->connection); if (!$db_select) { log::loguj('SQL',$this->zadni_upit); } } } //javna metoda //zatvori konekciju public function close_connection(){ if (isset($this->connection)) { mysql_close($this->connection); unset($this->connection); } } //Javna metoda //Izvršava upit $sql i provijeranva dali je izvršen upit public function query($sql) { $this->zadni_upit= $sql;//pohranuje vrijednost u zadnji upit $result = mysql_query($sql, $this->connection); $this->confirm_query($result); return $result; } //Priprema pohranjivanja u mysql bazu public function sql_prep( $value ) { if( $this->real_escape_string_exists ) { // PHP v4.3.0 ili stariji // undo bilo koje magic quote effects tako da mysql_real_escape_string može da radi if( $this->magic_quotes_active ) { $value = stripslashes( $value ); } $value = mysql_real_escape_string( $value ); } else { // Prije PHP v4.3.0 // ako magic quotes nisu već upaljene onda dodaj / manuelno if( !$this->magic_quotes_active ) { $value = addslashes( $value ); } // Ako su magic quotes aktivne, onda / već su unutra } return $value; } //Intermodulacija date funkcije public function fetch_array ($rez){ return mysql_fetch_array($rez); } //Intermodulacija date funkcije public function num_rows($rez){ return mysql_num_rows($rez); } //Uzmi zadnji id ubacen preko trenutne DB konekcije //pravi datu funkciju modularnom public function insert_id(){ return mysql_insert_id($this->connection); } //Normalizacija funkcije mysql_affected_rows tako da je modularno kompatibilna function affected_rows(){ return mysql_affected_rows($this->connection); } //Privatni atribut //Provijera upita koji se poziva, pozivaju samo funkcije unutar klase DB private function confirm_query($result){ if (!$result) { $output = "Database query failed: ". mysql_error()."<br />"; $output.="Last Query: ". $this->zadni_upit; log::loguj('SQL',$output); } } } ?> And the first class mentioned here bruteAttackLog needs to populates him self by calling it like $a= new bruteAttackLog(); and the function newLog should be called when the object is called. but when i call it i get a empty array The $a gets an empty reply if an update or save ocures. can somone help me out here????? As told earlier, it is on serbian i sugest to use the google translator so ou get more meaning of it.

I could post the whole project here but it is around 1000 rows...(and coments, names... is on serbian) so i have to try to narrow the problem down. it is like this: I have a class which is a representation of some BD data, i defined a function which needs to update the data by creation of the object. the data should load automatically according to some static data (ip address). grab the data and lets me work with it. the update function i wrote duos the update in the DB but looses the object in the process because the sql query function returns true or false. My question is, when duos a object get destroyed? class class(){ $a; $b; function __construct(){ self::do(); } function do(){ do some DB changes; repopulate the object; } and when i calll the new class i get into the varable 0; Any idea why this happens?

hy again , :'( Have a bit of confusion here how do i call a function inside a class which should handle the class but not destroy it? i have the folowing problem some class which inside of it has a function which makes this class and manipulates it then updates some DB data and returns false or true but when i call this function from lets say $a = new class() $a-> theFunction(); it ends up destrozing the object... no return no tnohing in it but still destroys the damn object... My question is why dous the object get destroyed?

no error an ENDLESS loop i cant find a way to limit the call from the construct intern content, it calss it selff over and over again. Any way i just decidet that i will call the function outside of the constructor it is not pretty but,,, im out of options. i I could see if object exists but then if i ever needet to call more of thosue classes i would be ina giant O.o Ps. the problem is explained in the code coment...

Hy i have a big problem i have a class class a(){ $a; $b; . . function _construct() { check some value; self::do-some(); } function do-some(){ //this f. does retrieve data from DB and needs to return it as the class that is just instantiated how to do it??? it forms a class but as it forms it it atempts to make a new class which creates a endless loop } }

Hy I am currently at the planing stage of a forum which I am making for my diploma work, and i intend to use it later on and expand. I am having a bit of trouble to figure out the structure of some parts of a forum so i wondered if you guys can give me some theoretical advise in it. The topic in discussion are : 1. Which table engine i should use INOODB or some other for the structure. => + The good I need the high read/write/edit rate it provides and the on update cascade has it neat features to like spearing me of coding and above all valuable IO time betwen the mysql and the php engine. => - The bad I INOODB engine duos not have the vale of rows in it so some statical data would have to be added to the archive and would have to be updated which increases the workload and as i know the access and over all performance is far bather in the standard BD, but updating would be pretty problematic. 2. How should i realize the structure of the topic -> posts -> attachment problem =>? A possible way: The structure it self is pretty clear topic -> posts structure is pretty straight forward topic as starting point list with OFFSET and limit create pagination. the topic -> posts structure is simple to just to link them. the problem: How should i handle the attachments and other stuff like the attachments and other stuff i want add to a post the querys are bound to create a bunch of reads in the DB and only for viewing!!! like take one sample: 15 posts in a side of a topic-> 15 read req for the topic table => which results in: 15 read req in the user table (30 reads) => lats say that those posts all have attachments in them = :? 15 rads in the attachment table(45 reads)=> results in the 15 thumbnail detail table read (60 reads) => get the point? 60 reads! for one page to load! one assistant on my university brought me to the idea: Why not create a hash row in user table which stores all data which are relevant for it ?? => + The good Only 15 reads per page => - The bad Disturbs the DB normalization principles all in one giant shot. ??Any Ideas on this one?? 3. How do i create the navigation menu which is on this frum made on the adobe hi a pixel principle(joke)? A big no idea for it for now all suggestions are open pls tell me how :rofl: 4. Should i implement a group policy in it or shall i only use the user level aces ???? => + The good No idea, guess easy administration => -The bad performance,,, additional stupid toilet clogging stuff.... 5. How should i implement the user messages in user table or together with posts or separately? :?: which options should messages have>>>??? open for suggestions. 6. How the hell should i realize administrator assignment? :'( I dont have a clue yet...... ?-> How to assign a post or more of them to a admin >.<` ?-> How to regulate the read/aces/write property's of users/admins? 7. How to implement the search option in a forum? all opinions are welcome. most useful would be performance and structure ideas XD And that is all fouks Any comment at all is welcome on any of above given points for consderation, all are welcome even if they are like are you nuts?