Question

PHP对postgreSQL数据库进行增删查改，该怎么处理

Answer 1

jQuery("#crud").jqGrid({

url:'server.php?q=2',

datatype:"json",

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

colModel:[

{name:'id',index:'id', width:55, editable:true, editoptions:{readonly:true}, sorttype:'int'},

{name:'invdate',index:'invdate', width:90, sorttype:'date', editable:true, editrules:{date:true},formatter:'date', datefmt:'d/m/Y'},

{name:'name',index:'name asc, invdate', width:100,editable:true},

{name:'amount',index:'amount', width:80, align:"right",editable:true,editrules:{number:true},sorttype:'number'拍兆码,formatter:'number'},

{name:'tax',index:'tax', width:80, align:"right",editable:true,editrules:{number:true},sorttype:'number',formatter:'number'},

{name:'total',index:'total', width:80,align:"right",editable:true,editrules:{number:true},sorttype:'number',formatter:'number'},

{name:'袭哪note',index:'note', width:150, sortable:false,editable:true}