All pastes #910662 Raw Edit

Anonymous

public text v1 · immutable
·published 2008-02-20 02:41 UTC
rendered paste body
#main index.php

function AddNote()

{

	var newNote = new PhotoNote('Add note text here...',-1,new PhotoNoteRect(10,10,50,50));

    newNote.onsave = function (note) { return saveNoteDb(note); };

    newNote.ondelete = function (note) { return deleteNoteDb(note); };

    notes.AddNote(newNote);

    newNote.Select();

     newNote.nid = 0;

        return false;

}

function saveNoteDb(note){

	note.Save();

	var url = 'saveNote.php?text='+ encodeURIComponent(note.text)+' &width=' + note.rect.width + '&height=' + note.rect.height + '&left=' +note.rect.left+'&top=' + note.rect.top +'&id='+note.id ;
		var retorno = new Ajax.Request(url, {   

		method: 'get',   

		onSuccess: function(transport) {     

		var notice = $('divResultado');
		if (transport.responseText > 0) 

		{   

			notice.update('Note saved!').setStyle({ background: '#dfd' });

			note.id = transport.responseText;

		}

		else      

		{

			notice.update('Note not saved!<br>'+transport.responseText).setStyle({ background: '#fdd' });

		}

		} 

	}); 

	return 1;

}


function deleteNoteDb(note){ 
	var url = 'deleteNote.php?id='+note.id ;
        
	var retorno = new Ajax.Request(url, {   
		asynchronous: true,
		method: "get",   
		onSuccess: function(request) {  
		var notice = $('divResultado');  
		if (request.responseText > 0) 
		{  
			
			notice.update('Note Deleted!').setStyle({ background: '#dfd' });

			note.Delete();   

		}
		
		} 

	}); 

	return 1;

}






</script>



</body>

</html>


#deleteNote.php

<? 

	$link_id=mysqli_connect("localhost", "root","");



	mysqli_select_db($link_id,"bang");

	$id=(int)$_GET['id'];
	if(($_GET['id'])<0)

	{

		die("-1");

	}

	else

	{

		$sql = "delete from NOTE where ID=".$id;

		$result = mysqli_query($link_id,$sql);

		echo "1";

	}


?>