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???