php - ajax returns success but mysql db not updated -

-

i have javascript loop sends array ajax page update mysql database.

i echo result original page , echos success when check db nothing has changed

my javascript loop sends array

for(var m=0; m<array.length; m++){     $.post("update_page_positions.php",{page_ref:array[m][0], ref:array[m][12], menu_pos:array[m][1], sub_menu_pos:array[m][2], top_menu:array[m][3], pagelink:array[m][4], indexpage:array[m][5], hidden:array[m][6], page_title:array[m][7], page_desc:array[m][8], page_keywords:array[m][9], page_name:array[m][10], deletedpage:array[m][11]},                  function(data,status){               alert("data="+data+" status="+status);    });

here php ajax page updates db

<?     include("connect.php");          $ref = $_post['ref'];     $page_ref = $_post['page_ref'];     $menu_pos = $_post['menu_pos'];     $sub_menu_pos = $_post['sub_menu_pos'];       $top_menu = $_post['top_menu'];     $indexpage = $_post['indexpage'];            $page_name = $_post['page_name'];         $page_title = $_post['page_title'];     $page_desc = $_post['page_desc'];        $page_keywords = $_post['page_keywords'];        $hidden = $_post['hidden'];      $pagelink = $_post['pagelink'];      $deletedpage = $_post['deletedpage'];         $query = mysql_query("select * pages ref='$ref' , page_ref='$page_ref'");   if(mysql_num_rows($query)==0){     mysql_query("insert pages(page_ref, ref, page_name, menu_pos, sub_menu_pos, top_menu, link, indexpage) values('$page_ref','$ref','$page_name','$menu_pos','$sub_menu_pos','$top_menu','$pagelink','$indexpage')"); }   if($deletedpage=="1"){         mysql_query("delete pages ref='$ref' , page_ref='$page_ref'");                  mysql_query("delete site_content ref='$ref' , page_ref='$page_ref'");  }   else{               if(mysql_query("update pages set menu_pos='$menu_pos', sub_menu_pos='$sub_menu_pos', top_menu='$top_menu', indexpage='$indexpage', page_name='$page_name', page_title='$page_title', desc1='$page_desc', keywords_list='$page_keywords', hidden='$hidden', link='$pagelink' ref='$ref' , page_ref='$page_ref'")){          echo "updated!";      } else{         echo "error";                  }   }    ?>

the insert , delete functions fine update returns success statement not update db.

can see problem is?

posted answer because comment hard read:

rather echoing "updated", try echoing 

"update pages set menu_pos='$menu_pos', sub_menu_pos='$sub_menu_pos', top_menu='$top_menu', indexpage='$indexpage', page_name='$page_name', page_title='$page_title', desc1='$page_desc', keywords_list='$page_keywords', hidden='$hidden', link='$pagelink' ref='$ref' , page_ref='$page_ref'"

(ie. query you're trying run).

see if gives clues.


Comments

Post a Comment

Popular posts from this blog

c++ - Creating new partition disk winapi -

-
i'am trying create new partition , mount volume new, thought createfile let me this, code : lpctstr lpfilename=l"\\\\.\\device\\harddisk0\\partition3"; handle handl=createfile( lpfilename, generic_read | generic_write, file_share_read | file_share_write, null, create_always, file_attribute_normal, null ); if (handl==invalid_handle_value) { qdebug()<<"handl invalid"<<" error"<<getlasterror();} bool success = definedosdevice(ddd_raw_target_path,l"i:",l"\\device\\harddisk0\\partition3"); if(!success) qdebug()<<" definedosdevice failed "<<getlasterror(); bflag = getvolumenameforvolumemountpoint( l"i:\\", // input volume mount point or directory /** u in dir
Read more

Android Prevent Bluetooth Pairing Dialog -

-
i'm developing internal application uses bluetooth printing. want bluetooth pairing occur without user input. have managed working trapping android.bluetooth.device.action.pairing_request broadcast. in broadcast receiver call setpin method, , pairing works ok, bluetoothpairingdialog displayed second or two, disappears - see link below. https://github.com/android/platform_packages_apps_settings/blob/master/src/com/android/settings/bluetooth/bluetoothpairingdialog.java since broadcast non-ordered, can't call abortbroadcast() , , wondering if there other way prevent pairing dialog appearing. can hook window manager in way? i haven't been able come way without modifying sdk. if you're oem, it's easy (i'm on 4.3): in packages/apps/settings/androidmanifest.xml, comment intent filter pairing dialog: <activity android:name=".bluetooth.bluetoothpairingdialog" android:label="@string/bluetooth_pairing_request"
Read more

VBA function to include CDATA -

-
i have following function include cdata: function cdatasection() dim objdom domdocument dim objkmlrootelement ikmldomelement dim objkmlelement ikmldomelement dim cdata ikmldomcdatasection set objdom = new domdocument set objkmlrootelement = objdom.createelement("balloonstyle") objdom.appendchild objkmlrootelement set objkmlelement = objdom.createelement("text") objkmlrootelement.appendchild objkmlelement set cdata = objdom.createcdatasection("text") cdata.data = "<![cdata[<b>latitude = $[latitude]</b>?]]>;" end function when run above, getting error "user defined data type not found" function. yes ripster says find library reference. vba window tools>references for list of relevant references see... http://msdn.microsoft.com/en-us/library/windows/desktop/ms763701%28v=vs.85%29.aspx however, if have hard time tracking down reference, replace dim sta
Read more