How to write jquery code within php code

Question

Hello, I would like to add some JQuery code when my MySQL query match a specific ID, here is my code:

<?php
$chkgreenmark ="select * from TABLE where PARAM = '$VARIABLE'";
$sqlchkgreenmark = mysqli_query($GLOBALS['mysqli'],$chkgreenmark);
$numsqlchkgreenmark = mysqli_num_rows($sqlchkgreenmark);
if($numsqlchkgreenmark > 0) { ?>

<script type="text/javascript">
    $(".calendercolumn .dragbox #dragID").append("<div class='detailssaved'><a href='#' ><img src='./images/check_mark.JPG' height='15' width='15'></a></div>");
</script>
<?php 
}?>

The problem is that I get the JQuery code even when I don't have any result.

Can anyone please help me?

try to echo $numsqlchkgreenmark first to see if it is returning correct results.. the issue has nothing to do with javascript code, it is fine, even the condition statement, you query has some issue try to print mysqli errors, what is $GLOBALS['mysqli'] ? — Qarib Haider
– Qarib Haider, Commented Dec 10, 2013 at 9:53

hichris123 · Accepted Answer · 2014-11-20 02:04:50Z

3

Try this

<?php
    $chkgreenmark ="select * from TABLE where PARAM = '$VARIABLE'";
    $sqlchkgreenmark = mysqli_query($GLOBALS['mysqli'],$chkgreenmark);
    $numsqlchkgreenmark = mysqli_num_rows($sqlchkgreenmark);
    if($numsqlchkgreenmark > 0)
    {
          echo '<script type="text/javascript">
            $(".calendercolumn .dragbox #dragID").append("<div class=\'detailssaved\'><a href=\'#\' ><img src=\'./images/check_mark.JPG\' height=\'15\' width=\'15\'></a></div>");
          </script>';
    }
?>

Live Demo

edited Nov 20, 2014 at 2:04

hichris123

10.3k15 gold badges58 silver badges70 bronze badges

answered Dec 10, 2013 at 9:52

rynhe

2,5291 gold badge22 silver badges27 bronze badges

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

Comments

user1860982 · Accepted Answer · 2014-04-26 16:30:00Z

0

I tried @rynhe answer, but didn't work for me until i added the Document Ready function

<?php
    $chkgreenmark ="select * from TABLE where PARAM = '$VARIABLE'";
    $sqlchkgreenmark = mysqli_query($GLOBALS['mysqli'],$chkgreenmark);
    $numsqlchkgreenmark = mysqli_num_rows($sqlchkgreenmark);
    if($numsqlchkgreenmark > 0)
    {
          echo '<script type="text/javascript">
                $(document).ready(function(e) {
                     $(".calendercolumn .dragbox #dragID").append("<div class=\'detailssaved\'><a href=\'#\' ><img src=\'./images/check_mark.JPG\' height=\'15\' width=\'15\'></a></div>");
                });
          </script>';
    }
?>

answered Apr 26, 2014 at 16:30

user1860982

Comments

Muhammet Arslan · Accepted Answer · 2013-12-10 09:47:50Z

-1

on php files or pages that u can use php tags , u can write php into jquery scripts. So that u can use it like below;

<script type="text/javascript">
    $(".calendercolumn .dragbox <?php echo $id;?>").append("<div class='detailssaved'><a href='#' ><img src='./images/check_mark.JPG' height='15' width='15'></a></div>");
</script>

answered Dec 10, 2013 at 9:47

Muhammet Arslan

9852 gold badges12 silver badges33 bronze badges

Collectives™ on Stack Overflow

How to write jquery code within php code

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related