Simple css message boxes
<style>
.message {
padding: 10px;
border: 2px solid #ddd;
background-color: #eee;
color: #222;
}
.notice {
background: #FFF6BF;
color: #817134;
border-color: #FFD324;
}
.success {
background: #E6EFC2;
color: #529214;
border-color: #C6D880;
}
.error {
background: #FBE3E4;
color: #D12F19;
border-color: #FBC2C4;
}
</style>
Password Strength Meter Script
CSS vertical menu hover basic
<style>
#menu_left {
float: left;
margin: 0 0 6px 0;
padding: 0 0 1px 0;
border-bottom: 2px solid #e2e2e2;
}
#menu_left li { list-style: none; }
#menu_left li a {
display: block;
color: #3F5B7F;
background: #C2CEDE url(arrow.gif) no-repeat center left;
width: 204px;
padding: 7px 23px 7px 23px;
margin: 0 0 1px 0;
font-weight: bold;
text-decoration: none;
}
#menu_left li a:hover { background: #9EB1C9 url(arrow.gif) no-repeat center left; color: #fff; }
</style>
CSS BUTTONS HOVERS
<style>
body {
margin:200px;
}
/* trigger button */
#download_now {
background:transparent url(download.png) no-repeat scroll 0 0;
display:block;
height:44px;
margin-bottom:30px;
overflow:hidden;
text-indent:-999em;
width:159px;
cursor:pointer;
}
/* mouseover state */
#download_now:hover {
background-position:0 -44px ;
}
/* clicked state */
#download_now:focus {
background-position:0 -88px;
}
</style>
Download now
Free SEO ToolsHere are some online SEO tools that you can use to check your PageRank, Link Popularity, Search Engine Position, Keyword Density, etc.
jQuery Cheat Sheets
Nivo Slider
PHP MYSQL - INSERT and UPDATE records function
$record['userid'] = $_GET['iuser'] ;
$record['busid'] = $_GET['busid'] ;
$record['cid'] = $_GET['cid'];
$record['dateprint'] = $dateadd;
$record['noprinted'] = +1;
$record['dateexpire'] = $dateexp;
$dateadd = date("Y-m-d H:m:s");
$tomorrow = mktime(0, 0, 0, date("m"), date("d")+1, date("y"));
$xtr = date("Y-m-d",$tomorrow);
$dateexp = $xtr." ".date("H:m:s");
$sqld = "SELECT * FROM dir_coupon_print WHERE busid = '{$_GET['busid']}' AND userid = '{$_GET['iuser']}'";
$result = mysql_query($sqld);
$total = mysql_num_rows($result);//total
//echo $total;
if (mysql_num_rows($result)>0){ //no records founds
while ($rw = mysql_fetch_array($result, MYSQL_ASSOC)){
if (($dateadd >! $rw['dateexpire'])) {
echo "You already consume coupon for this business. wait 24 hours before printing the coupon again. ";
}else{
updateCoupon($rw['id']); //UPDATE RECORDS
}
}
}else {
insertCoupon($record); //INSERT RECORDS
}
function updateCoupon($updateid)
{
$iUserId = intval($iUserId);
$run_sql = "UPDATE dir_coupon_print SET noprinted=noprinted+1 WHERE id = '$updateid'";
$iAlbumId = mysql_query($run_sql) or die( mysql_error()."-cant query");
return $iAlbumId;
}
function insertCoupon($record)
{
$iUserId = intval($iUserId);
$run_sql = "INSERT INTO dir_coupon_print
(userid, cid, busid, dateprint, noprinted, dateexpire)
VALUES ('".$record['userid']."', '".$record['cid']."', '".$record['busid']."', '".$record['dateprint']."', '".$record['noprinted']."', '".$record['dateexpire']."')";
$iAlbumId = mysql_query($run_sql) or die( mysql_error()."-cant query");
return $iAlbumId;
}
PHP MYSQL - List Records from database with select box
<select name="cat" class="m_heading" id="cat"?>
<?php
mysql_connect("localhost", "db_user", "db_passwd") or die(mysql_error());
mysql_select_db("db_name") or die(mysql_error());
$result = mysql_query("SELECT * FROM cats WHERE status='1' && type='videos'")
or die(mysql_error());
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
$catid = $row['id'];
$catname = $row['name'];
echo "$catname";
}
?>
</select?>
.htaccess
jQuery PhotoShoot Plugin 1.0
Learn How to Validate Forms in both sides using PHP and jQuery
Mastering-Integrated-HTML-and-CSS
Cheats Sheets for Designers n Developers
jQuery and Google Maps Tutorial: The BasicsPHP MYSQL - MySQL Average
<?php
$con = mysql_connect("localhost","root","ednalan");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
$query = "SELECT type, AVG(price) FROM products GROUP BY type"; //GROUP BY type
$result = mysql_query($query) or die(mysql_error());
// Print out result
while($row = mysql_fetch_array($result)){
echo "The average price of ". $row['type']. " is $".$row['AVG(price)'];
echo "
";
}
?>
//display
//The average price of Food is $8.730000
PHP MYSQL Basic
$con = mysql_connect("localhost","root","ednalan");
mysql_select_db("dbednalan", $con);
$sql = mysql_query("select * from dir_buscoupon WHERE busid = '{$_GET['busid']}'");
$rs = mysql_fetch_array($sql);
$id = $rs["id"];
$img = $rs["img"];
//1. list records where condition
$sql = mysql_query("select * from registrations WHERE id='$id'" ORDER BY asign_number Asc); ///////DESC Limit 5";
$rs = mysql_fetch_array($sql);
$id = $rs["id"];
$email = $rs["email"];
//2. while loop
define("REGISTRATION", "registration");
$sql_welcome = "SELECT * FROM ".REGISTRATION;
$sql_result = mysql_query($sql_welcome) or die("Could not connect");
while ($sql_row= mysql_fetch_array($sql_result, MYSQL_ASSOC)){
echo $sql_row['welcome'];
}
$sql="Select * From dbisubcategory";
$db_query=mysql_query($sql) or die("Could not requery");
while ($result=mysql_fetch_array($db_query, MYSQL_ASSOC))
{
$About=$result['id'];
echo($About);
}
//3 where condition
$result=mysql_query("SELECT * FROM gb_users where status='admin'") or die('Error 3- No database found.');
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$mail=$row['email'];
//4. Define table in view records in table
define("ABOUT", "tblabout");
$sql_announcement = "SELECT * FROM ".ABOUT." WHERE id=4";
$sql_result = mysql_query($sql_announcement) or die("Could not connect");
echo "
$sql_row[About] |
$qry = mysql_query("SELECT * FROM events WHERE id = '$event_id'") or die(mysql_error());
$rows = mysql_fetch_assoc($qry);
$event = $rows['name'];
$sqld = "SELECT * FROM dir_coupon_print WHERE busid = '{$_GET['busid']}' AND userid = '{$_GET['iuser']}'";
$result = mysql_query($sqld);
$total = mysql_num_rows($result);//total
//echo $total;
if (mysql_num_rows($result)>0){ //no records founds
while ($rw = mysql_fetch_array($result, MYSQL_ASSOC)){
if (($dateadd >! $rw['dateexpire'])) {
echo "You already consume coupon for this business. wait 24 hours before printing the coupon again. ";
}else{
updateCoupon($rw['id']); //UPDATE RECORDS
}
}
}else {
insertCoupon($record); //INSERT RECORDS
}
