-3

I'm very lack of coding, so here my code before (get date from mysql = today --> alert) and I want to get help from y'all to make my code to (get date from mysql + 30 days = today --> alert)

<?php 
                    $periksa=mysql_query("select * from tor where target_tor = curdate()");
                    while($q=mysql_fetch_array($periksa)){  
                        if ($q['target_tor'] = mysql_query("Select Curdate()")){
                            ?>  
                            <script>
                                $(document).ready(function(){
                                    $('#pesan_sedia').css("color","red");
                                    $('#pesan_sedia').append("<span class='glyphicon glyphicon-asterisk'></span>");
                                });
                            </script>
                            <?php
                            echo "<div style='padding:10px' class='alert alert-warning'><span class='glyphicon glyphicon-info-sign'></span> PERINGATAN !!  Deadline kontrak <a style='color:red'>". $q['nama_tor']."</a> berakhir hariini!!</div>"; 
                        }
                    }
                    ?>    
                    </p>
Sera Sera
  • 3
  • 2

1 Answers1

0

1st : Warning !!! mysql_query, mysql_fetch_array,mysql_connect etc.. extensions were deprecated in PHP 5.5.0, and it was removed in PHP 7.0.0.

2nd : No need mutiple query just select in single query .simple use date_add() function

select * from tor where date_add(target_tor,INTERVAL 30 DAY )=curdate();

3rd : Try to use mysqli_* or PDO

JYoThI
  • 11,977
  • 1
  • 11
  • 26