incorrect class variable in mysql statement

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
afbase
Forum Contributor
Posts: 113
Joined: Tue Aug 15, 2006 1:29 pm
Location: SoCAL!!!!

incorrect class variable in mysql statement

Post by afbase »

ok I'm updating my db using this method

Code: Select all

class store_mysql extends stockdata{

function getdata_storemysql($ticker){
parent::mysql_bookval($ticker);

parent::mysql_annsales($ticker);

parent::mysql_multiplier($ticker);

parent::mysql_dividend($ticker);

parent::mysql_curass($ticker);

parent::mysql_long_term_debt($ticker);

parent::mysql_total_current_liabilities($ticker);


//insert values into mysql
$mysql_tickname_insert="UPDATE curldata SET dividend = 'parent::get_dividend()', curass = 'parent::get_curass()', multiplier = 'parent::get_multiplier()', bookval = 'parent::get_bookval()', long_term_debt = 'parent::get_long_term_debt()', total_cur_liabilities = 'parent::get_liabilities()' WHERE ticker='$this->ticker';";
if ( $sqldb = mysql_connect( "localhost", "root", "hockey" ) ) {
           print "Connection to coldowl.com username: root complete<br>";
}
        else {
           die ("Unable to connect to coldowl.com username: root . Error: <b>".
                                                                    mysql_error()."</b>");
}

        if ( mysql_select_db( intelligent , $sqldb )  ) {
          print "Select of intelligent complete<br>";
}
        else {
          die ("Select failed database name intelligent Error number: <b>".mysql_errno().
                                                           " Message: ".mysql_error()."</b>");
}

        if ( mysql_query( $mysql_tickname_insert, $sqldb )  ) {
          print $mysql_tickname_insert." complete<br>";
}
        else {
          print  $mysql_tickname_insert." failed. Error number: <b>".mysql_errno().
                                          " Message: ".mysql_error()."</b>";
}
mysql_close($sqldb);
}


//last bracket
}



The key problem is my mysql statement. The parent::get_"methods" ()'s just return the variable named after the method, i.e.:

Code: Select all

....
var $bookval;
function get_bookval(){return $this->bookval;}

when i run the php script, it doesn't post variable properly:
BDF

BDFConnection to coldowl.com username: root complete
Select of intelligent complete
UPDATE curldata SET dividend = 'parent::()', curass = 'parent::()', multiplier = 'parent::()', bookval = 'parent::()', long_term_debt = 'parent::()', total_cur_liabilities = 'parent::()' WHERE ticker='BDF'; complete




got any ideas on how to return the variable properly???
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

They cannot be apart of your string, but must be executable by PHP using concatenation.
afbase
Forum Contributor
Posts: 113
Joined: Tue Aug 15, 2006 1:29 pm
Location: SoCAL!!!!

Post by afbase »

ok i solved it
Post Reply