This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| jQuery.fn.fadeToggle = function(speed, easing, callback) { | |
| return this.animate({opacity: 'toggle'}, speed, easing, callback); | |
| }; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| jQuery.fn.slideFadeToggle = function(speed, easing, callback) { | |
| return this.animate({opacity: 'toggle', height: 'toggle'}, speed, easing, callback); | |
| }; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| function fadeImages($item) { | |
| // Affichage des images en fade | |
| var items = $item.hide(); | |
| var i = 0; | |
| (function displayImages() { | |
| items.eq(i++).fadeIn(200, displayImages); | |
| })(); | |
| } |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <script type="text/javascript"> less = { env: 'development' }; </script> |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| grant CREATE,INSERT,DELETE,UPDATE,SELECT on newdatabse.* to newuser@localhost; | |
| update user set password = password('new password') where User='newuser'; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT field, count(*) | |
| FROM table GROUP BY field | |
| HAVING count(*) > 1 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| $requete = "select reference,count(*) AS Number from ps_product group by reference having Number > 1 ORDER BY Number desc;"; | |
| $result = mysql_query($requete,$connection); // envoi de la requête | |
| while ($row = mysql_fetch_array($result)) { | |
| if ($row['reference'] != '') { | |
| echo $row['reference'].' => '.$row['Number'].' fois<br>'; | |
| } | |
| } |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| private function _getInfoAboutProduct($params){ | |
| $id_product = isset($_REQUEST['id_product'])?(int)$_REQUEST['id_product']:0; | |
| if($id_product != 0){ | |
| $id_lang = intval($params['cookie']->id_lang); | |
| $result = Db::getInstance()->ExecuteS(' | |
| SELECT p.*, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, p.`ean13`, | |
| i.`id_image`, il.`legend`, m.`name` AS manufacturer_name |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| => Démarrer -> exécuter -> taper "cmd" + CTRL+SHIFT+ENTREE | |
| Exemple : at 10:00 /EVERY:l,ma,me,j,v "C:\wamp\bin\php\php.exe -f C:\wamp\www\cron\cron-cadeau-anniversaire.php" |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $nbDays = 30; | |
| $query = ' | |
| SELECT DISTINCT c.id_customer, firstname, lastname, email | |
| FROM '._DB_PREFIX_.'customer c | |
| LEFT JOIN | |
| '._DB_PREFIX_.'orders o ON (c.id_customer = o.id_customer) | |
| WHERE |