Posts

Showing posts from March, 2012

Error 1577 "Cannot proceed because system table used by Event Scheduler were found damaged at server start"

There is an easy fix for this problem.

1. Change to mysql bin folder and type :

> mysql_upgrade -u yourusername -p

2. restart mysql server

your problem should be fixed by now.


source : http://forum.wampserver.com/read.php?2,47165

flexigrid + php with add and edit button

Image
this is a little example for flexigrid with add and edit button. Original source code of flexigrid could be found at
http://flexigrid.googlecode.com/files/flexigrid-1.1.zip

additional code that I have is :
function test(com,grid) { if (com=='Delete') { if($('.trSelected',grid).length>0){ if(confirm('Delete ' + $('.trSelected',grid).length + ' items?')){ var items = $('.trSelected',grid); var itemlist =''; for(i=0;i<items.length;i++){ itemlist+= items[i].id.substr(3)+","; } $.ajax({ type: "POST", dataType: "json", url: "delete.php", data: "items="+itemlist, success: function(data){ alert("Query: "+data.query+" - Total affected rows: "+data.tota…