Forum

November 2nd, 2014
A A A
Avatar

Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

The forums are currently locked and only available for read only access
sp_Feed Topic RSS sp_Related Related Topics sp_TopicIcon
how to get errors messages from mysql en xml?
17/09/2012
19:58
Avatar
sebastiancb
COlombia
Member
Members
Forum Posts: 23
Member Since:
05/09/2011
sp_UserOfflineSmall Offline

Hello, what I need to show errors from mysql but in xml, because I am loading data with this format, like this:

jQuery("#list1").jqGrid({

url:'server.php?q=1', datatype: "xml",

colNames:['Inv No','Date', 'Client', 'Amount','Tax','Total','Notes'],

              colModel:[ {name:'id',index:'id', width:75},

                   {name:'invdate',index:'invdate', width:90},

                  {name:'name',index:'name', width:100},

                  {name:'amount',index:'amount', width:80, align:"right"},

                  {name:'tax',ndex:'tax', width:80, align:"right"},

                 {name:'total',index:'total', width:80,align:"right"},

                  {name:'note',index:'note', width:150, sortable:false} ],

rowNum:10, autowidth:

true, rowList:[10,20,30],pager: jQuery('#pager1'), sortname: 'id', viewrecords: true, sortorder: "desc", caption:"XML Example" }).

I have done this with JSON like this:

var json;

var editMessage = function(response,postdata){

 json   = response.responseText; // response text is returned from server.

var result = JSON.parse(json); // convert json object into javascript object

return [result.status,result.message,null];

}

jQuery.jgrid.edit = {

afterSubmit:editMessagemsg:{required:"El campo es obligatorio"},processData: "Processing...",reloadAfterSubmit:true,closeAfterEdit:true,bCancel: "Cerrar",bSubmit: "Guardar",editCaption: "Editar",

};

in the PHP file this to show the errors from mysql

$message="duplicated row";

$output['status']  = false;

$output['message'] = $message;

echo json_encode($output);

I need this but en XML

If someone needs the source code this is my e-mail: alxx28@hotmail.com

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
34 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

OlegK: 1255

markw65: 179

kobruleht: 144

phicarre: 132

YamilBracho: 124

Renso: 118

Member Stats:

Guest Posters: 447

Members: 11373

Moderators: 2

Admins: 1

Forum Stats:

Groups: 1

Forums: 8

Topics: 10592

Posts: 31289

Newest Members:

, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.com

Moderators: tony: 7721, Rumen[Trirand]: 81

Administrators: admin: 66

Comments are closed.
Privacy Policy   Terms and Conditions   Contact Information