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 |