PHP|Débutant :: Forums

 <input onclick="showWait()" type="submit" value="Modifier" name="modif"/>

<SCRIPT LANGUAGE="JavaScript">
    document.writeln("<div id=\"jsWaitMessage\" style=\"font-family: Verdana; font-size: 10px; text-align: center; padding: 3px; position: absolute; left: 30%; top: 40%; height: 20px; width: 300px; z-index:3\"></div>" );
    document.writeln("<div id=\"jsWaitArea\" style=\"display: none; position: absolute; left: 30%; top: 40%; height: 20px; width: 300px; border: 1px black solid; background: #fdd46c;z-index:2\">" );
    document.writeln("<div id=\"jsWaitBlock\" style=\"position: relative; left: 0px; height: 20px; width: 50px; background: #fcbb10;z-index:2\"></div>" );
    document.writeln("</div>" );
    jsWait_defaultInstance = null;
   
  function showWait()
    {
    if (confirm('Etes-vous sûr de vouloir modifier ce grade ?')){
      jsWait_defaultInstance = new jsWait('jsWait_defaultInstance', "Modification en cours");
      jsWait_defaultInstance.show();
    }
    }
 
    function jsWait(name, message)
    {
      this.name = name;
      this.message = message;
      this.speed = 10;
      this.direction = 2;
      this.waiting = false;
      this.divMessage = document.getElementById("jsWaitMessage" );
      this.divArea = document.getElementById("jsWaitArea" );
      this.divBlock = document.getElementById("jsWaitBlock" );
    }
    jsWait.prototype.show = function()
    {
      this.divMessage.innerHTML = this.message;
      this.divMessage.style.display = "block";
      this.divArea.style.display = "block";
      this.divBlock.style.display = "block";
      this.divBlock.style.left = "0px";
      this.waiting = true;
     
      this.loop();
    }
    jsWait.prototype.setMessage = function(message)
    {
      this.message = message;
      this.divMessage.innerHTML = this.message;
    }
    jsWait.prototype.stop = function()
    {
      this.waiting = false;
      this.divMessage.style.display = "none";
      this.divArea.style.display = "none";
      this.divBlock.style.display = "none";
    }
    jsWait.prototype.loop = function()
    {
      myLeft = this.divBlock.style.left;
      myLeft = myLeft.substring(0, myLeft.length-2);
      intLeft = parseInt(myLeft);
      if(intLeft >= 250)
        this.direction = -2;
      if(intLeft <= 0)
        this.direction = 2;
      myLeft = "" + (intLeft+this.direction) + "px";
      this.divBlock.style.left = myLeft;
      if(this.waiting)
        setTimeout(this.name + ".loop()", this.speed);
    }
 </script>

$("#tr_intitule").empty().append($.ajax({url: 'select_intitule.php?var='+strthis.value}).responseText);

SELECT service, COUNT(*) as cat
FROM table2, table1
WHERE categorie IN ('a' , 'b' , 'c') AND code1=code2 AND groupe='1'
GROUP BY service
ORDER BY id2 ASC

select T2.service, COUNT(T1.categorie) AS cat
from table2 T2
left join table1 T1 on T1.code1 = T2.code2
WHERE categorie IN ('a','b','c') AND t2.groupe='1'
group by T2.service
ORDER BY t2.id2 ASC