mysql - PHP Mysqli replace comma if data is Null or empty during fetch -

-

have issue comma "," when fetching data if data selected id empty coma(,) shows want if data null or empty "," should not show unable do.

say selecting data for
id 1 ,2 ,3where id 1 num 6789 , id 2 has no num , id 3 has 12345

 $query="select  num euser userid in (select id master  aa='aa' , cc='cc')" ;         $data=mysqli_query($mysqli,$query)or die(mysqli_error());         $num = array();         while($row=mysqli_fetch_array($data)){             $num[] = $row['num'];          }         $numstr = implode(',', $num);           echo $numstr;      mysqli_close($mysqli);

present output

6789,,12345

expecting output

6789,12345

use isset()

while ($row = mysqli_fetch_array($data)) {     if (isset($row['num']) && $row['num'] != "") {         $num[] = $row['num'];     } } $numstr = implode(',', $num);

Comments

Post a Comment

Popular posts from this blog

qt - Using float or double for own QML classes -

-
i've created components , helper methods using c++ , qt used in qml gui. of methods calculate gui elements (size, transformations, scene graph items creation). target arm 32 bit using opengl / eglfs render output. opengl using float , qml using real (defined double ). what should use in c++ do not lose precision? if use qreal ( double ) shouldn't lose precision. if git grep float in qtbase.git , can find out bit more: dist/changes-5.2.0-**************************************************************************** dist/changes-5.2.0-* important behavior changes * dist/changes-5.2.0-**************************************************************************** dist/changes-5.2.0- dist/changes-5.2.0- - qt compiled qreal typedef'ed double on dist/changes-5.2.0: platforms. qreal float on arm chipsets before. guarantees more dist/changes-5.2.0- consistent behavior between platforms qt supports, binary dist/chan...
Read more

json - ORA-06502: PL/SQL: numeric or value error: character string buffer too small - Convert Clob to varchar2 -

-
im getting error while trying convert clob varchar2 using api. the 'body' field im trying retrieve clob, want convert varchar2(1000). please advice why error occurred : merge xxx d using ( select v_ticket_id ticket_id, json_ext.get_number(json(value(s)),'id') comment_id, json_ext.get_number(json(value(s)),'author_id') author_id , dbms_lob.substr(json_ext.get_string(json(value(s)),'body'),1000,1) body, json_ext.get_string(json(value(s)),'via.channel')channel, case when lower(json(value(s)).get('public').to_char()) = 'true' 1 else 0 end is_public, to_date(replace(replace(json_ext.get_string(json(value(s)),'created_at'),'t',' '),'z',nul...
Read more

ios - Swift Array Resetting Itself -

-
i have 2 arrays: pointhistory , datehistory . have nstimer , , when timer runs out, action called. in action appending int pointhistory , , current date string datehistory . here timer action: func timeraction() { let steppervalue = int(stepper.value) employee.numberofpoints = steppervalue networking.saveemployee(employee, completion: { (error) -> void in if error != nil { let alert = uialertcontroller(title: "error", message: "there error updating \(self.employee.name)'s points", preferredstyle: .alert) let alertaction = uialertaction(title: "ok", style: .cancel, handler: nil) alert.addaction(alertaction) self.presentviewcontroller(alert, animated: true, completion: nil) } }) var dateformatter = nsdateformatter() dateformatter.dateformat = "mm-dd-yyyy" dateformatter.timezone = nstimezone.localtimezone() var date = nsdate() var ...
Read more