mysql - PHP : How to get Sum of values in column in a variable -


i'm trying sum of salary column table. need echo total salary. tried,

select sum(salarycol) my_table;

how can query result variable in php?

select sum(salarycol) total_salary my_table;

Comments

Post a Comment

Popular posts from this blog

python - RuntimeError: can't re-enter readline -

i making python 3 app has prompt user enters commands. i'm running python 3.5 on macos sierra. i'm trying prevent exiting ctrl+c , having users exit instead typing exit prompt. i doing using method: https://stackoverflow.com/a/6019460/7450368 however, when prompting user again, runtimeerror: can't re-enter readline . is there way can fix this? here's code: import interpret import signal def siginthand(sig, frm): print("\nuse 'exit' exit.") prompt() signal.signal(signal.sigint, siginthand) version = ("v0.0.3") class commanderror(exception): pass def prompt(): try: task = input("einstein " + version + " > ") except runtimeerror: task = input("einstein " + version + " > ") try: execute(task) except commanderror e: print(e) prompt() def execute(command): command = command.lower() interpret.interp...
Read more

php - Need to store a large amount of data in session with CI 3 but on storing large data in session it is itself destorying automatically -

i working on large web application need database retrieved session instead of database. first time retrieving db , saving session onward calls of data going session. it handling data @ stage when got more data stored in session session got destroyed automatically... "this problem seems similar question says title session destroyed after redirect other pages of site." i got answer questions point here how handle thing when know in future have more data stored inside session, i wanted know little bit more involved answer right in development stage on production when have user 100000 or more how session behave, application behave in same manner did before. kindly discuss me, researching, need corporation more technical in php discussion may solution many of people facing same kind of issues.. you need use native php session because php session stores id in cookie. codeigniter stores data in cookie , problem stuck. so either need use native php sessions...
Read more

ios - Pass NSDictionary from Javascript to Objective-c in JavascriptCore -

i'm using javascriptcore in app. now, i'm passing variables jscontext can passed objective-c. however, 1 of variables, nsdictionary, not passing through correctly. run code below: var evaluate = function(variables) { app.setdictionary(variables.dictionary); } this simple example has these following methods set in jscontext . this setdictionary() method: - (void)setdicationary:(nsdictionary *)dictionary { self.mutabledictionary = [dictionary mutablecopy]; } this variables.dictionary : - (nsdictionary *)dictionary { return self.values; } and how call evaluate() : jsvalue *jsfunction = self.context[@"evaluate"]; jsvalue *value = [jsfunction callwitharguments:@[self.variables]]; however, in setdictionary method, don't nsdictionary, instead nsstring containing [object object] . any ideas how can solve this? although javascriptcore automatically converts types between objective-c or swift , javascript, suggest implement ex...
Read more