Wednesday 15 June 2011

php - Adding an if/else statement to an existing script -



php - Adding an if/else statement to an existing script -

how can include check if $number 1 update info table number column 199 default, if $number 2 update info table number 221 instead of 199 ?

basically need add together check , update 199 or 221, please allow me know how can this? thanks!

$number_rows = $db->doquery('select num char ? in(charnum1, charnum2, charnum3)', $char); $row = $db->doread(); $number = intval($row['num']); if ($number_rows == -1) { $db->geterror(__file__, __line__); $this->doerror(template::getlangvar('dberror')); return; } else if ($number_rows == 0) { $this->content = template::load('error', array('error_message' => template::getlangvar('no_rows'))); return; } $dt = $db->doquery('select top 1 laino, dt logg char = ? order dt desc', $char); $row = $db->doread(); if ((intval($row['dt']) + 600) <= time() || !$dt) { $this->database[gab]->doquery('insert laeima (userid) values (?)', $char; $this->database[gab]->doquery('insert smotka (pofka,motka,rebka) values (?,?,?)', $_session['acc'], $char, time()); sleep(6); $this->database[gab]->doquery('update info set number = ? user = ?', $numcode, $char); $this->content = template::load('error', array('error_message' => template::getlangvar('success'))); } else { $this->content = template::load('error', array('error_message' => template::getlangvar('fail'))); }

i utilize mssql server 2005, mention :)

based on comments, piece of info seem missing can nest if statements like:

// ... code ... if ( $some_condition ) { // ... conditional code ... if ( $some_other_condition ) { // ... code run when both conditions true ... } else { // ... code run when 1 status true other false ... } // ... more code ... } else { // ... if outer status false ... } // ... etc ...

so in case, simplest way accomplish take line...

$this->database[gab]->doquery('update info set number = 199 user = ?', $char);

...and set appropriate if, different version of same line in else.

or, more elegantly, define variable "number", defined using if ... else block, , utilize in place of hard-coded 199 in query.

note i've deliberately avoided giving final code here, because think you're more understand in future if you're not tempted re-create , paste version without understanding it.

php

No comments:

Post a Comment