鼠标悬停时写入MySQL

Question

After months of testing, I'm not succeeding to create a script that writes a logtext to the MySQL when a div gets a mouseover.

I think I have to use $.ajax, the only problem is, is that ajax (still) is the language which I'm not very good at.

One of the 100 things i've tried:

<?
echo "<div id='div0' rel=".$someid.">Some dynamic text</div>";
?>

<script>
           $('.div0').mouseover(function() {
           $('#result').load('../../../system/molog.php?cid='+$(this).attr('rel');
           });
</script>

Who can help?

Answer 1

Ok, there's a much better way to do this, but since I'm on a phone that's dying and you have been waiting a year...

var info = $("#div0").html();
// if Js in a php file you can do var info = <?php echo $logtext ?>; To bring it to JS 
$.get("phpfilehere.php", {info:info}, function(data){
alert(data);
});

The mouseover function...

$("#div0").on("mouseover", function(){ 
// my JS code above goes here
 });

PHP file:

if(isset($_GET['info'])){
$log = $_GET['info']; 
// Put ur stuff here, make sure u only echo when u want ur php script to stop and be sent back to Ajax function as data var.
// insert $log  
echo "test";
} else {
echo "no get info supplied": 
}

And here is a tool I made to teach people how to write prepared statements for SQL queries :) if you need it...

http://wbr.bz/QueryPro/index.php?query_type=prepared_insert