Simple JQuery Accordion

Simple JQuery Accordion

A very simple and basic accordion script. If you need an accordion style UI without extended features, this script is easy to integrate with your own project.

<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js" type="text/javascript"></script>

<style>

div.slides { padding:8px; width:25%;}

div.slides h3 { margin:4px 0px 0px 0px; height:24px; background-color:#D3D3D3; border:1px #d3d3d3 solid; -moz-border-radius:0.5ex; -webkit-border-radius:0.5ex; border-radius:0.5ex; padding:4px 8px 0px 8px; cursor:pointer; }

div.slides div.content { border:1px #d3d3d3 solid; -moz-border-radius:0.5ex; -webkit-border-radius:0.5ex; border-top:0px; padding:8px 4px 4px 4px; }

</style>

<div class="slides">

<h3>Header 1</h3>

<div class="content">

 example content 1

</div>

<h3>Header 2</h3>

<div class="content">

 example content 2

</div>

<h3>Header 3</h3>

<div class="content">

 example content 3

</div>

</div>

<script>

$("div.content").hide();

$("div.content:first").show();

$("h3").bind("click", function() {

if ( $(this).next().css("display") == 'none' ) {

  $("div.content").hide();

  $(this).next().slideDown(250);

}

});

</script>

Effect Delay Trick

Effect Delay Trick

Here is a quick trick for getting an effect to delay without using setTimeout.

<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript">
$(document).ready(function() {
$('#show-alert').click(function() {
$('<div class="quick-alert">Message Effect Delay Trick</div>')
.insertAfter( $(this) )
.fadeIn('slow')
.animate({opacity: 1.0}, 3000)
.fadeOut('slow', function() {
$(this).remove();
});
});
});
</script>
<style>
.quick-alert {
width: 50%;
margin: 1em 0;
padding: .5em;
background: #ffa;
border: 1px solid #a00;
color: #a00;
font-weight: bold;
display: none;
}
</style>
<input type="submit" value="Show Alert" id="show-alert">

Demo

http://dl.dropbox.com/u/7106563/r-ednalan/Effect_Delay.html

PHP Parse_URL()

PHP Parse_URL()

$the_permalink = "http://r-ednalan.blogspot.com/php-parse_url";
$the_domain = parse_url($the_permalink, PHP_URL_HOST);
echo $the_domain;

Cakephp Custom group by pagination and a calculated field

Cakephp Custom group by pagination and a calculated field

Example of how to use the CakePHP paginator helper with the group by condition. this is from the original article from http://wiltonsoftware.com/posts/view/custom-group-by-pagination-and-a-calculated-field




In the Controller

<?
var $helpers = array('Paginator');
var $paginator = array('limit' => 20);

function admin_index($filter=null) {
 $conditions = array();
 $this->Comment->recursive = 0;
 if ($filter == 'count') {
     $conditions = array('Comment.status = 0');
     $this->paginate['Comment'] = array(
         'fields' => array(
             'Comment.id', 'Comment.ip', 'Count(Comment.ip) as Count'
         ),
         'conditions' => array(
             'Comment.status = 0'
         ),
         'group' => array(
             'Comment.ip'
         ),
         'order' => array(
             'Count' => 'desc'
         )
     );
     $data = $this->paginate('Comment', $conditions);
  
 } else {
     if ($filter == 'spam') {
         $conditions = array('Comment.status = 0');
     } else {
         $conditions = array('Comment.status > 0');
     }
     $this->paginate['Comment'] = array(
         'order' => array(
             'Comment.id' => 'desc'
         )
     );
 }
 $data = $this->paginate('Comment', $conditions);
}
?>

Model

function paginateCount($conditions = null, $recursive = 0, $extra = array()) {
  $parameters = compact('conditions');
  $this->recursive = $recursive;
  $count = $this->find('count', array_merge($parameters, $extra));
  if (isset($extra['group'])) {
      $count = $this->getAffectedRows();
  }
  return $count;
}

View

$paginator->options(array('url' => $this->passedArgs));

An AJAX Based Shopping Cart with PHP, CSS & jQuery

An AJAX Based Shopping Cart with PHP, CSS & jQuery

AJAX-driven shopping cart. All the products are going to be stored in a MySQL database, with PHP showing and processing the data. jQuery will drive the AJAX-es on the page, and with the help of the simpletip plugin will add to an interactive check out process.

Visit Site

http://tutorialzine.com/2009/09/shopping-cart-php-jquery/

Demo

http://demo.tutorialzine.com/2009/09/shopping-cart-php-jquery/demo.php

PHP Mysql jquery Delete Table Row With Confirmation like twitter message

PHP Mysql jquery Delete Table Row With Confirmation like twitter message

I am going to demonstrate a php mysql jqeury method I use to delete a row from mysql and then remove the html row with some nice jquery effects




dbconfig.php

//dbconfig.php
<?php
$mysql_hostname = "localhost";
$mysql_user = "root";
$mysql_password = "ednalan";
$mysql_database = "testdeleterowjquerymysql";
$bd = mysql_connect($mysql_hostname, $mysql_user, $mysql_password) or die("Could not connect database");
mysql_select_db($mysql_database, $bd) or die("Could not select database");
?>

index.php

//index.php
<style type="text/css">
.top_row {
background-color: #CCCCCC;
color: #FFFFFF;
border-bottom-width: 1px;
border-bottom-style: solid;
border-bottom-color: #9CF;
}
.manage_row {
background-color: #eeeeee;
color: #333;
text-align: center;
}
.message {
font-size: 24px;
padding: 5px;
text-align: center;
position: absolute;
left: 0px;
top: 0px;
right: 0px;
border-bottom-width: medium;
border-bottom-style: solid;
border-bottom-color: #F00;
background-color: #64943F;
display:none;
}
.manage_row td {
border-bottom-width: 1px;
border-left-width: 1px;
border-bottom-style: solid;
border-left-style: solid;
border-bottom-color: #CCC;
border-left-color: #CCC;
}
.top_row th {
padding: 5px;
border-bottom-width: 1px;
border-bottom-style: solid;
border-bottom-color: #333;
font-weight: bolder;
border-left-width: 1px;
border-left-style: solid;
border-left-color: #333;
}
</style>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.1/jquery.min.js"></script>
<script type="text/javascript" >
function deleterow(id){
if (confirm('Are you sure want to delete?')) {
 $.post('deleterow.php', {id: +id, ajax: 'true' },
 function(){
  $("#row_"+id).fadeOut("slow");
  $(".message").fadeIn("slow");
  $(".message").delay(2000).fadeOut(1000);
 });
}
}
</script>
<div class="message">Row Deleted Successfully</div>

<table id="main_table" align="center" border="0" cellpadding="0" cellspacing="0" width="438" height="96">
 <tbody>
 <tr class="top_row">
 <th scope="col" width="88">ID</th>
 <th scope="col" width="293">Name</th>
 <th scope="col" width="57">Delete</th>
  </tr>
</tbody>
<?php
include("dbconfig.php");
 $query4="select * from tblname order by id desc";
 $result4 = mysql_query($query4);
$n = 0;
while($row=mysql_fetch_array($result4))
{
 $n++;
 $id=$row["Id"];
 $name=$row["name"];
?>
<tbody>
<tr class="manage_row" id="row_<? echo $id; ?>">
  <td><? echo $n; ?></td>
  <td><? echo $name; ?></td>
  <td id="delete">
 <a href="#" onclick="deleterow(<? echo $id; ?>)">Delete</a>
</td>
</tr>
</tbody>
<? } ?>
</table>

deleterow.php

//deleterow.php
<?php
include("dbconfig.php");
$id=$_POST['id'];
$sql = "delete from lito_user where Id='$id'";
mysql_query( $sql);
?>

xampp phpmyadmin - No activity within 1800 seconds; please log in again

xampp phpmyadmin - No activity within 1800 seconds; please log in again

1. Find xampp\phpMyAdmin\config.inc.php
2. find
/* Authentication type and info */
3. change auth_type cookie to config
$cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)

How to Log-in Multiple Users in SKYPE version 4.0

How to Log-in Multiple Users in SKYPE version 4.0

1. Create a new shortcut for starting a new Skype instance with a different Skype user account.
2. Open Windows Explorer and go to "C:\Program Files\Skype\Phone."
3. Right click on the Skype icon and select "Create Shortcut."
4. Right click on the new shortcut and select "Properties."
5. Append " /secondary" to "Target" to become '"C:\Program Files\Skype\Phone\Skype.exe" /secondary.'
6. Click OK to save the change.
7. Log on to a new created Skype account.