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.

Refresh a page in jQuery?

Refresh a page in jQuery?

<html>
<head>
<title>Refresh a page in jQuery</title>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js" type="text/javascript"></script>
</head>
<body>
<a href="#" id="RefreshPage">Refresh Page in jQuery</a>
<script type="text/javascript">
$('#RefreshPage').click(function() {
         location.reload();
});
</script>
</body>
</html>

Joomla - add extra fields in joomla registration

Joomla - add extra fields in joomla registration

LIST OF FILES NEED TO EDIT

1. libraries\joomla\database\table\user.php
add two extra fields like phone and website, let’s these fields as optional
put the follow lines before above lines or near line 116

var $params = null;

var $phone = null;
var $website = null;
var $address = null;
/**
* @param database A database connector object
*/
function __construct( &$db )
{
2. add alter your user table
ALTER TABLE jos_users ADD phone varchar(255) DEFAULT '' AFTER password;
ALTER TABLE jos_users ADD website varchar(255) DEFAULT '' AFTER phone;

3. Go to administrator\components\com_users\views\user\tmpl
open file form.php and put the following lines after line 132 … just add as new row in table

<tr>

          <td width="150" class="key">

              <label for="phone">

                  <?php echo JText::_( 'Phone' ); ?>

              </label>

          </td>

          <td>

              <input type="text" name="phone" id="phone" class="inputbox" size="40" value="<?php echo $this->user->get('phone'); ?>" />

          </td>

      </tr>

      <tr><td width="150" class="key">

              <label for="website">

                  <?php echo JText::_( 'Website' ); ?>

              </label>

          </td>

          <td>

              <input type="text" name="website" id="website" class="inputbox" size="40" value="<?php echo $this->user->get('website'); ?>" />

          </td>

      </tr>

4. Goto administrator->site->User Manager




















5. front end registration
components\com_user\views\register\tmpl\default.php for edit

<tr>

<td height="40">

    <label id="phonemsg" for="phone">

        <?php echo JText::_( 'Phone' ); ?>:

    </label>

</td>

<td>

    <input type="text" name="phone" id="phone" size="40" value="<?php echo $this->escape($this->user->get( 'phone' ));?>" class="inputbox" maxlength="50" /> *

</td>

</tr>

<tr>

<td height="40">

    <label id="websitemsg" for="website">

        <?php echo JText::_( 'Website' ); ?>:

    </label>

</td>

<td>

    <input type="text" name="website" id="website" size="40" value="<?php echo $this->escape($this->user->get( 'website' ));?>" class="inputbox" maxlength="50" /> *

</td>

</tr>

Copy that default.php file from components\com_user\views\register\tmpl and now go to your current template folder. copy all the php files from components\com_user\views\register\tmpl to templates\{your custom template name here}\html\com_user\register

Jquery Ajax Requests submit loading Image

Jquery Ajax Requests submit loading Image

show a loading image when an AJAX request

<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js" type="text/javascript"></script>
<script type="text/javascript">
$(document).ready(function () {
$('#loading')
.hide()
.ajaxStart(function() {
    $(this).show();
})
.ajaxStop(function() {
    $(this).hide();
});
$('#submit').click(function() {
$('.test_content').load('load_content.php');
return false;
});
});
</script>
<h4>Jquery Ajax Requests submit loading Image </h4>
<div class='test_content'></div>
<p><a id="submit" href="#">Submit</a></p>

<div id="loading">
<img src="ajax-loader.gif"  />
</div>

//load_content.php
<?php
sleep(4);

echo '
This content was loaded from a PHP script.
';

?>

CSS Login Form Design

CSS Login Form Design

A sample of CSS form login

Demo

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

<style type="text/css">
body{background-color:#fff;margin: 40px;font-family:Arial, Lucida Grande, Verdana, Sans-serif;font-size:12px;color:#000;}
#content {margin: 0 auto;width: 350px;border:#ccc 1px solid;background-color:#fff;padding:20px 20px 12px 20px;-moz-border-radius:7px; -webkit-border-radius:7px;}
h1{font-weight:normal;font-size:20px;color:#aaaaaa;margin:0 0 4px 0;}
p{font-size: 20px;color: #dedede;}
a {color:#729e01;text-decoration:none;}
a:hover{color:#dedede;}
input.text{ border:#ccc 1px solid;-moz-border-radius:7px; -webkit-border-radius:7px;font-size: 20px;width:300px;}
.ptour_crtbtn{border:1px outset #ccc;padding:5px 2px 4px;color:#fff;min-width: 100px;text-align: center;cursor:pointer;background:#729e01;background:-webkit-gradient(linear, left top, left bottom,from(#a3d030),to(#729e01));background:-moz-linear-gradient(top,#a3d030,#729e01);background:-o-linear-gradient(top,#a3d030,#729e01);background:linear-gradient(top,#a3d030,#729e01);-moz-border-radius:7px; -webkit-border-radius:7px;
}
</style>
<div id="content">
 <h1>Login Form</h1>
 <form action="" method="POST">
 <p><label style="display: block;">Email:</label><input class="text" type="text" name="username" /></p>
 <p><label style="display: block;">Password:</label><input class="text" type="password" name="password" /></p>
 <p><button class="ptour_crtbtn" name="login" type="submit">Login</button></p>
 </form>
 <p><a href="#">Forgot password?</a></p>
</div>

How to: Add a Share on facebook link to your WordPress blog

How to: Add a Share on facebook link to your WordPress blog

Paste the following code on your single.php file, within the loop:

<a href="http://www.facebook.com/sharer.php?u=<?php the_permalink();?>&t=<?php the_title(); ?>" target="blank">Share on Facebook</a>

Font preview using Google font API

Font preview using Google font API

A sample of google font api font name Tangerine
Sample

<html>
<head>
<link rel="stylesheet" type="text/css" href="http://fonts.googleapis.com/css?family=Tangerine">
<style>
  body {
 font-family: 'Tangerine', serif;
 font-size: 48px;
 text-shadow: 4px 4px 4px #aaa;
 }
</style>
</head>
<body>
<h1>http://r-ednalan.blogspot.com/</h1>
</body>

Visit the Google Font Directory

FORM Validators for web developers

1. Live Validation form

LiveValidation is a small open source javascript library for making client-side validation quick, easy, and powerful.

Example Demo

http://livevalidation.com/examples




2. MooTools FormCheck

FormCheck is a class that allows you to perform different tests on form to validate them before submission.


Demo

http://mootools.floor.ch/en/labs/




3. ProtoForm

ProtoForm is an unltra lightweight, unobtrusive cross-browser and very easy to customize form validation + submit with Ajax based on prototype.js framework.

Demo

http://cssrevolt.com/upload/files/protoform/

Implement a jQuery AJAX Login Form into a Modal Box using fancybox.net modal

Implement a jQuery AJAX Login Form into a Modal Box using fancybox.net modal box

Integrate an Jquery AJAX Login Form into a Modal Box using a fancybox modal box This will show you how to implement JQuery ajax using facybox.

//jquery ajax
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4/jquery.min.js"></script>
<script type="text/javascript">
 $(document).ready(function() {
  $("#login_form").submit(function() {
   var unameval = $("#username").val();
   var pwordval = $("#password").val();
   $.post("login.php", { username: unameval, //login.php
   password: pwordval }, function(data) {
    $("#status").html(data);
   });
   return false;
  });
 });
</script>

//fancybox javascript
<script type="text/javascript" src="./fancybox/jquery.mousewheel-3.0.4.pack.js"></script>
<script type="text/javascript" src="./fancybox/jquery.fancybox-1.3.4.pack.js"></script>
<link rel="stylesheet" type="text/css" href="./fancybox/jquery.fancybox-1.3.4.css" media="screen" />
<link rel="stylesheet" href="style.css" />
<script type="text/javascript">
 $(document).ready(function() {
 
  $("#various1").fancybox({
   'titlePosition'  : 'inside',
   'transitionIn'  : 'none',
   'transitionOut'  : 'none'
  });

 
 });
</script>

//CSS
<style type="text/css">   
  form.registration{
     width:570px;
     float:left;
  
  }
  form.registration fieldset{
     border-top:0px solid #ccc;
      border-left:0;
      border-bottom:0;
      border-right:0;
      padding:6px;
      margin:0px 20px 0px 0px;
  }
 
  form.registration label{
   font-size: 20px;
      width:190px;
      float: left;
      text-align: right;
      color:#7F7F7F;
      clear:left;
      margin:10px 4px 0px 0px;
      padding:0px;
  }
  form.registration .textboxinput{
     font-family: Georgia;
     font-size: 28px;
      float:left;
      width:280px;
      border:1px solid #cccccc;
      margin:2px 0px 2px 2px;
      color:#00abdf;
      height:32px;
      padding:3px;
     -moz-box-shadow: 0 1px 3px rgba(0,0,0,0.5);
     -webkit-box-shadow: 0 1px 3px rgba(0,0,0,0.5);
     -webkit-border-radius: 5px;
     -moz-border-radius: 5px;
  }
 
 
  .button {
  -moz-border-radius:5px;
  -webkit-border-radius:5px;
  border-radius:5px;
  -moz-box-shadow:0 1px 3px rgba(0, 0, 0, 0.50);
  -webkit-box-shadow:0 1px 3px rgba(0, 0, 0, 0.50);
  box-shadow:0 1px 3px rgba(0, 0, 0, 0.50);
  background:#222222 url(button-overlay.png) repeat-x;
  border:1px solid rgba(0, 0, 0, 0.25);
  color:#FFFFFF !important;
  cursor:pointer;
  display:inline-block;
  font-size:13px;
  font-weight:bold;
  line-height:1;
  overflow:visible;
  padding:5px 15px 6px;
  position:relative;
  text-decoration:none;
  text-shadow:0 -1px 1px rgba(0, 0, 0, 0.25);
  width:auto;
  text-align:center;
  }
  .button:hover {
  background:#111111;
  color:#FFFFFF;
  }
  .button:active {
  background:#242424;
  }

  .orange.button {
  background-color:#FF5C00;
  }
  .orange.button:hover {
  background-color:#D45500;
  }
  .orange.button:active {
  background-color:#fd762a;
  }


  .fail      {
   background-color: #FFECE6;
   border: 1px solid #FF936F;
   color: #842100;
   background-image: url(delete00.png);
  }
  .fail {
   background-repeat: no-repeat;
   background-position: 10px center;
   height: 20px;
   text-transform: uppercase;
   font-size: 11px;
   line-height: 22px;
   margin-bottom: 20px;
   padding-top: 10px;
   padding-right: 10px;
   padding-bottom: 10px;
   padding-left: 50px;
  
  }
 </style>
//form
<a id="various1" href="#inline1" title="">LOG IN</a>
<div style="display: none;">
 <div id="inline1" style="width:565px;height:250px;overflow:auto;padding:10px">
  <span ><b>Sign In</b></span>
  <div id="flash" align="left"  ></div>
  <div id="status"></div>
  <form id="login_form" class="registration" method="post">
   <fieldset>
    <label>Username </label>
    <input class="textboxinput" type="text" id="username" name="username" maxlength="120" value=""/>
    <label>Password </label>
    <input class="textboxinput" type="password" id="password" name="password"/>                                        
   </fieldset>
   <fieldset> 
    <div style="float:right;padding-right:52px;"><input type="submit" class="large button orange input" value="Sign In" /></div>
   </fieldset> 
  </form>
 </div>
</div>

//login.php
<?php
$username = $_POST['username'];
$password = $_POST['password'];

if ($username == "test" && $password == "test")
{
 echo "<strong>Login succeeded!</strong>";
}
else
{
 echo  "<div class=\"fail\"><strong>Login failed! Please try again.</strong></div>";
}
?>

Download

http://dl.dropbox.com/u/3293191/JQUERY/login_modal.zip

Wrapping Long URLs and Text Content with CSS

Wrapping Long URLs and Text Content with CSS

pre {
white-space: pre; /* CSS 2.0 */
white-space: pre-wrap; /* CSS 2.1 */
white-space: pre-line; /* CSS 3.0 */
white-space: -pre-wrap; /* Opera 4-6 */
white-space: -o-pre-wrap; /* Opera 7 */
white-space: -moz-pre-wrap; /* Mozilla */
white-space: -hp-pre-wrap; /* HP Printers */
word-wrap: break-word; /* IE 5+ */
}

<pre class="wrapped">Lorem ipsum dolor sit ames. Ut justo. Suspendisse potenti.</pre>

Get Active/ Inactive/ Current tabs in Navigation Bar using PHP and jQuery

Get Active/ Inactive/ Current tabs in Navigation Bar using PHP and jQuery
php Code
Step 1: Get current page URL using PHP

$phpSelf = $_SERVER['REQUEST_URI'];

jQuery Code

Step 2: Check whether URL is similar to navigation bar button url, if they are similar we give it as the current active page,

< script type="text/javascript" >
$(document).ready(function(){
var root_url = "http://localhost"; var phpSelf = root_url+"<?php echo $phpSelf;?>"; $("#navigation li").each(function() {
var link = $(this).children("a").attr("href"); if(phpSelf == link){ $(this).addClass("active"); } }); }); < /script >

Change,
active to your active css class
http://localhost to website root directory

Displaying Number of Comments in your WordPress Blog

Displaying Number of Comments in your WordPress Blog

<?php
$numcomms = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->comments WHERE comment_approved = '1'");
if (0 < $numcomms) $numcomms = number_format($numcomms);
echo "There's ".$numcomms." total comments on my blog";
?>

Display Most Popular Posts in WordPress

Display Most Popular Posts in WordPress

<h2>Popular Posts</h2>
<ul>

<?php $result = $wpdb->get_results("SELECT
comment_count,ID,post_title FROM $wpdb->posts ORDER BY comment_count
DESC LIMIT 0 , 5");
foreach ($result as $post) {
setup_postdata($post);
$postid = $post->ID;
$title = $post->post_title;
$commentcount = $post->comment_count;
if ($commentcount != 0) { ?>

<li><a href="<?php echo get_permalink($postid); ?>" title="<?php echo $title ?>">
<?php echo $title ?></a> {<?php echo $commentcount ?>}</li>
<?php } } ?>
</ul>

Just change the 5 in line 3 to change the number of displayed popular posts