Javascript with MySQL request embedded in Php

Question

I've been working on that for a while, and google didn't help me that much on that one,

Basically, I am creating different divs, when you hover on them, you get more information. I managed to do that in a way that when you hover the div, the text changes.

Now, I would like to make it dynamic with a MySQL database, my different divs (already created) will get the text and change it with javascript.

UPDATE : The following code kinda works but doesn't show the iteration. My concern would be that the first div gets the first result (ID = 1), the second div gets the second result... and so on! I am fairly new to php/MySQL, and I didn't find a way to do it.

<script>
var n = 0;
$("div.enterleave").mouseenter(function() {
 n += 1;
 $(this).find("span").text( "<?php

        $reponse = $bdd->query('SELECT possesseur FROM jeux_video LIMIT 0, 4');
        while ($donnees = $reponse->fetch()) {
            echo $donnees['possesseur'] ; }
            $reponse->closeCursor(); 
    ?>");
}).mouseleave(function() {
 $(this).find("span").text("<?php

            $reponse = $bdd->query('SELECT nom FROM jeux_video LIMIT 0, 1');
            while ($donnees = $reponse->fetch()) {
                echo $donnees['nom'] ; }
                $reponse->closeCursor(); 
    ?>");
});

</script>

Thanks in advance!

Jasper · Accepted Answer · 2011-12-20 19:58:49Z

2

You have concoct before and after this MySQL-related code. You should put semicolon after [...]text('" and write echo before "'); (after closeCursor).

 <?php

echo "<script>
var n = 0;
$('div.enterleave').mouseenter(function() {
 n += 1;
 $(this).find('span').text('";
            $reponse = $bdd->query('SELECT nom FROM jeux_video LIMIT 0, 10');
            while ($donnees = $reponse->fetch()) {
                echo $donnees['nom'] ; 
                }
                $reponse->closeCursor();
echo "');
}).mouseleave(function() {
 $(this).find('span').text('What does Patrick likes?');
});

</script>";

?>

edited Dec 20, 2011 at 19:58

Jasper

76.1k14 gold badges153 silver badges148 bronze badges

answered Dec 20, 2011 at 19:55

Krzysztof

16.2k2 gold badges52 silver badges79 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Scott · Accepted Answer · 2011-12-20 19:58:27Z

1

You can't concatenate there.

echo "<script>
var n = 0;
$('div.enterleave').mouseenter(function() {
 n += 1;
 $(this).find('span').text('";


        $reponse = $bdd->query('SELECT nom FROM jeux_video LIMIT 0, 10');
        while ($donnees = $reponse->fetch()) {
            echo $donnees['nom'] ; 
            }
            $reponse->closeCursor();

 echo "');
}).mouseleave(function() {
 $(this).find('span').text('What does Patrick likes?');
});

</script>";

answered Dec 20, 2011 at 19:58

Scott

21.9k8 gold badges45 silver badges57 bronze badges

Collectives™ on Stack Overflow

Javascript with MySQL request embedded in Php

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related