As you know, the user login box of the website contains the following fields username and password. Furthermore, most of them put the “Username” inside user name field and “********” inside password field to save the space within designing.In this post I’ll show you how to show “Password” text in the password field. It doesn’t actually does so but this tips will make it looks like so.
How it’s done
The type of field cannot be changed with Javascript from type=”text” to type=”password” so there are actually two fields for the password: a regular password field, and a second plain text field with the default “Password” value.
When the page is loaded the CSS makes the plain text field hidden. Then the jQuery / js makes the password field hidden and the plain text field visible. It’s best to do it this way so if Javascript is not enabled (or there’s a Javascript error which causes the rest of the script to stop running) then the user still has a regular password field with obscured text.
When the user clicks the plain text field, the jQuery / JS code makes the plain text field hidden, the password field visible and puts focus on the password field. On blur, if the password field contains an empty value the plain text field is restored as the visible one to show the default value.
How many types of join are supported by mysql? Which are they? Explain:
ans: there are three types of joins supported in mysql as inner, right and left.
The inner join displays all the rows from both tables where match is found.
Left join returns all the rows from first table even if the match is not found in second table.
While the right join returns all the rows from second table even if match is not found in first table.
What are the advantages of mysql comparing with oracle?
MySql has many advantages in comparison to Oracle.
1 – MySql is Open source, which can be available any time
2 – MySql has no cost of development purpose.
3 – MySql has most of features , which oracle provides
4 – MySql day by day updating with new facilities.
5 – Good for small application.
6 – easy to learn and to become master.
7 – MySql has a good power these days.
even though MySql having so many advantages, Oracle is best database ever in Software development.
What are the limitations of mysql in Comparison of Oracle?
Mysql supports six different types of tables, four of which do not support transactions (MyISAM, MERGE, ISAM, and HEAP)
MySQL only supports one index type
Unlike Oracle, MySQL date data types can store invalid dates, do not support time zones, and the precision of time values is limited to one second.
There are eleven drivers in MYSQL .Six of them from MySQL AB and five by MYSQL Communities. They are1.PHP Driver2.ODBC Driver3.JDBC Driver4.ado.net5.mxj6.CAPI1PHP DRIVER2.PERL DRIVER3.PYTHON DRIVER4.RUBY DRIVER5.C++ WRAPPER
How are triggers created in MySQL?
CREATE TRIGGER `tgr_name` AFTER UPDATE ON `addresses` FOR EACH ROW begin
update products set countryName = new.countryName where products.shippingAddressId = old.id;
You will get black background if you resize a transparent image. To fix it, You need set alpha channel imagecolorallocatealpha to 127. With imagecolorallocatealpha, it will allocate a color for an image.
Usage:
int imagecolorallocatealpha ( resource image, int red, int green, int blue, int alpha)
From PHP manual:
imagecolorallocatealpha() behaves identically to imagecolorallocate() with the addition of the transparency parameter alpha which may have a value between 0 and 127. 0 indicates completely opaque while 127
indicates completely transparent. Returns FALSE if the allocation failed.
Before using it, you must set to false the blending mode for an image and set true the flag to save full alpha channel information.
Description: phpThumb() uses the GD library to create thumbnails from images (JPEG, PNG, GIF, BMP, etc) on the fly. The output size is configurable (can be larger or smaller than the source), and the source may be the entire image or only a portion of the original image.
I have created this package file for ready to access. This package contains following list of files
index.php
css/mediabox.css
js/mediabox.js
js/swfobject.js
js/mootools.js
Installation:
extract the zip file in to system.
upload mediabox folder into your server.
access the mediabox folder from the browser.
Using the MooTools 1.11 JavaScript library, Media box lets you open flash, video, and html content in a floating “lightbox” style window.
Mediabox will read Flickr, Google, MetaCafe, MySpace, Revver, YouTube, Veoh, Viddler, and Vimeo links by automatically translating them into embed code and inserting the video into the lightbox style effect.
Flash animation, flash video, QuickTime, windows media, inline content and external html content is all automatically recognised as well. Every link listed below is shown with the code used to make it.
If you have a wordpress blog with one or more author, then it is most important to list author details in the wordpress post pages. The followings functions will help you list out author details such as
the_author
the_author_description
the_author_login
the_author_firstname
the_author_lastname
the_author_nickname
the_author_ID
the_author_email
the_author_url
the_author_link (Version 2.1)
the_author_aim
the_author_yim
the_author_posts
the_author_posts_link
wp_list_authors
Okay, will discuss in detail below,
the_author
Description: it displays Author’s ‘Public’ Name
Syntax: <?php the_author(); ?>
Example: <p> this post was written by <?php the_author(); ?></p>
the_author_description
Description: Displays the contents of the about yourself field in an author’s profile (Administration > Profile > Your Profile). About yourself is a block of text often used to publicly describe the user and can be quite long. This tag must be used within The Loop.
Description: This tag displays the login name of the author of a post. The login is also referred to as the Username an author uses to gain access to a Wordpress blog. This tag must be used within The Loop
Note: It’s usually not a good idea to provide login information publicly. But it can be used for some other purposes
Description: The following tags display the name for the author of a post. The First Name field is set in the user’s profile (Administration > Profile > Your Profile). This tag must be used within The Loop.
Example: <p>This post was written by <?php the_author_firstname(); ?></p>
the_author_ID
Description: Displays the unique numeric user ID for the author of a post; the ID is assigned by Wordpress when a user account is created. This tag must be used within The Loop.
Syntax: <?php the_author_ID(); ?>
Example: <a href="/blog/index.php?author=<?php the_author_ID(); ?>">View all
posts by <?php the_author_nickname(); ?></a>
the_author_email
Description: This tag displays the email address for the author of a post. The E-mail field is set in the user’s profile (Administration > Profile > Your Profile). This function must be used within The Loop.
Note that the address is not encoded or protected in any way from harvesting by spambots
Syntax: <?php the_author_email(); ?>
Example: <a href="mailto:<?php the_author_email(); ?>">Contact the author</a>
Secure your author’s email:
This example partially 'obfuscates' address by using the internal function antispambot()
to encode portions in HTML character entities (these are read correctly by your browser).
Note the example uses get_the_author_email() function, because the_author_email()
echoes the address before antispambot() can act upon it.
Description: This tag displays the URL to the Website for the author of a post. The Website field is set in the user’s profile (Administration > Profile > Your Profile). This tag must be used within The Loop.
Description: This tag displays the AOL Instant Messenger screenname for the author of a post. The AIM field is set in the user’s profile (Administration > Profile > Your Profile). This tag must be used within The Loop.
Syntax: <?php the_author_aim(); ?>
Example: <p>Contact me on AOL Instant Messenger: <?php the_author_aim(); ?></p>
the_author_yim
Description: This tag displays the Yahoo IM ID for the author of a post. The Yahoo IM field is set in the user’s profile (Administration > Profile > Your Profile). This tag must be used within The Loop.
Syntax: <?php the_author_yim(); ?>
Example: <p>Contact me on Yahoo Messenger: <?php the_author_yim(); ?></p>
the_author_posts
Description: Displays the total number of posts an author has published. Drafts and private posts aren’t counted. This tag must be used within The Loop.
Syntax: <?php the_author_posts(); ?>
Example: <p><?php the_author(); ?> has blogged <?php the_author_posts(); ?>
posts</p>
the_author_posts_link
Description: Displays a link to all posts by an author. The link text is the user’s Display name publicly as field. The results of clicking on the presented link will be controlled by the Template Hierarchy of Author Templates. This tag must be used within The Loop.
Syntax: <?php the_author_posts_link(); ?>
Example: <p>Other posts by <?php the_author_posts_link(); ?></p>
wp_list_authors
Description: Displays a list of the blog’s authors (users), and if the user has authored any posts, the author name is displayed as a link to their posts. Optionally this tag displays each author’s post count and RSS feed link.
Syntax: <?php wp_list_authors(‘arguments’); ?>
Example: <?php $defaults = array(
'optioncount' => false,
'exclude_admin' => true,
'show_fullname' => false,
'hide_empty' => true,
'feed' => ,
'feed_image' => ); ?>
By default, the usage shows:
* Does not display the count of the number of posts
* Excludes the 'admin' author from the list
* Does not display the full name (first and last) but displays the author nickname
SimpleModal Jquery plugin helps you to create Ajax form with style pop up. It is very easy to setup in the web pages. It supports almost alkind of browsers. This download was written in php(contact.php).
This plugin uses “contact.php” where you need to change your email id.
Click this demo button to see the DEMO instantly
For Dot net developers need to change the contact.php according to their needs.
For more reference and Download link:http://www.ericmmartin.com/simplemodal/
Image zooming using JQuery
This Jquery helps you to integrate small magnifier window close to the image or images on your web page easily. It’s the best way to display images in incredible detail. Users do not need to click anything – they just move their mouse over the image to see every detail of your product!
Features
Fast – the page loads as normal, then the high-resolution image downloads invisibly in the background.
Easy – add it to your website in minutes.
Customisable – change the size, position, colors to suit your website.
FOR MORE DETAILS AND DOWNLOADS: http://www.mind-projects.it/blog/jqzoom_v10
The following are percept by me, when I go through the net for comparison of shopping cart.
A website with selling products is having good content, and a content site that is indexed can very easily leverage its traffic and sell products. The open source carts and CMS are somewhat related and there is a way to take the core OSCommerce shopping cart functionality and put it into the admin of a CMS.
Virtuemart is a branded version of this attempt. If you look at the admin of Virtuemart it would look like a Joomla/Mambo admin but you would see a new menu option which opens up a OSCommerce shopping cart functionality.
In short if you have Virtuemart then you have OSCommerce. If you like OSCommerce you are better off with CRE Loaded or Zen Cart (especially if your osCom does not have Easy Populate, Sale Maker, Cross Sell, Specials, Featured Products, HTML editors, etc). However, if you have good content and want to sell Virtuemart is a great option for you.
The best open source system depends on what you want to do and how you want to do it.
I have listed features of Virtuemart, OSCommerce and CRE-loaded
Virtuemart
In short:
Virtuemart is great option when the sites’ having rich contents with small and medium range shopping cart sites and also it is open source.
The followings are the some of feature of Virtuemart,
GENERAL FEATURES:
capable of using Secure Sockets Layer (https) Encryption (128-bit)
flexible Tax Models
Model 1: Ship To Address-based Tax Calculation
Model 2: Store Address-based Tax Calculation
Model 3: EU Mode (Store Owner based Tax Calculation when Customer comes from an EU Country)
Shoppers can manage their User Accounts (registration required)
Shipping Address Management (Customers can enter their own Shipping Addresses)
Order History: Shopper can view all their previous Orders (and Order Details)
Order Confirmation Mail (customizable!) is sent to Shopper and Store Owner
Multiple Currencies (you can allow Customers to change the Currency and buy using an alternative Currency)
Manages an unlimited Number of Products and Categories
Can be used as a Shop or just as an Online-Catalog (you can even turn off Price Display)
quick Search for Products, Categories and Manufacturers; filter by features or discounted Products
Product Ratings & Testimonials (moderated or auto-published)
feature specific Products by setting them “on special”
Product Availability: show how fast a Customer can expect delivery
Handles downloadable Products (virtual Goods)
“Product is back in Stock”-Notification for subscribed Customers.
ADMIN SIDE FEATURES
multiple Images and Files (like Spec Sheets and Flyers) per Product
Product Attributes (like Size or Color) can be added to Product
Product Types for Classification (like “Car”, “Motorbike” or “Music Album”)
Shopper Groups for Customers (allows different Price Levels and Payment Options),
multiple Prices per Product (Quantity-based and/or Shopper Group-based Prices)
flexible Price Display (number & currency formatting; including or excluding tax)
On-the-Fly Price Conversion between different Currencies using Live Rates from the ECB or other banks
Shop Statistics / Control Panel with a Summary of new Customers, new Orders….
Stock Level Control for Products and Item
Order Management with Order History, Customer Notification and Order Edit Functionality
basic Reporting Feature: sold Items, monthly/yearly Revenue
Order Status Management
manage different Currencies, Countries & States
PAYMENT MODULES
capable of live Credit Card Processing
pre-defined Payment Gateways like authorize.net®, PayPal, 2Checkout, eWay, Worldpay, PayMate and NoChex
Extend your Shop with other Payment Modules using the Payment Module API!
Shipping Modules
flexible Shipping Carriers and Rates Configuration
Live-Shipping Rates using Shipping Modules (e.g. InterShipper, UPS, USPS, FedEx or Canada Post; Modules can use the Shipping Rate API).
Extend your Shop with other Shipping Modules using the Shipping Module API!
OSCOMMERCE
In-short:OSCommerce is great option for small and medium range shopping carts. It doesn’t come up with CMS.
osCommerce is a free, open source online shop software. The default installation includes a large number of features that you can easily enable and configure. You can easily install osCommerce on your website with the help of the Fantastico auto-installer.
With osCommerce shopping cart you can add multiple products on your site, organize them in categories, set discounts and special promotions. osCommerce allows you to set your prices in different currencies and accept all popular payment methods: PayPal, credit cards, cheques. osCommerce has a built-in shipping and tax functionalities.
Email newsletter subscription status (can easily subscribe and unsubscribe)
View all customers registered
Email specific, all or subscribed customers
Edit customer information
Temporarily set special price
Can be percentage or number
Does not effect actual price data
Special price is shown next to actual price
Specials are highlighted through out the site
Product reviews by site members
Bestseller lists automatically calculated
Display what other customers have brought (relating to the current product displayed)
Send to a friend
New design for user-friendliness
Backup tool
Statistics for products and customers
Add/Edit/Remove
Tax zones, classes, and rates
Configuration parameters in database for remote editing
Not tied together with the catalog module (admin module can be installed on another server)
CRE Loaded Standard à $95
CRE Loaded Professional à $295
CRE Loaded Professional B2B à$350
Order Confirmation
Customer Account (what the customer sees)
Customer Management (what you see)
Most shopping carts do not address marketing. OSCommerce brings high end logic to the entire shopping experience.
Specials
Customer Interaction
Administrative Functionality
o categories
o products
o manufacturers
o customers
o reviews
Configuration
Set most aspects of store information
o Store name
o Email address
o Location
o and other settings can be easily viewed and edited
Modules
Multiple payments modules:
o PayPal
o Credit Card
o C.O.D
Multiple shipping modules
o USPS
o FedEx
o UPS
o Flat Rate
o Custom Price Table
CRE-LOADED
In short:
CRELoaded 6 – a fork of osCommerce version 2.2 MS2 – is a feature-rich ecommerce solution for new and existing store owner, and web professionals. With CREloaded the you will be able to upload product images and add text, and thus to create the storefront of your online shop. Orders and inventory are easy to manage with the shopping cart, credit card payments are processed through PayPal or Authorize.net. It is possible to set up special pricing, and to determine shipping costs. CRE Loaded also offers plenty of different templates to customize the look of the online store in order to offer a unique, easily identifiable, and fully branded shopping experience to the customer.
Price:
Brief:
CRE Loaded Standard:
CRE Loaded Standard is a scalable shopping cart for Ecommerce sites developed primarily for the SOHO (small office, home office) store owner who wants to add transactional capabilities to an existing website. You can organize, manage and ship your products, and you have the the flexibility you need to run a successful online business. It includes shipping, payment, marketing, security, design, and admin features, as well as customer and product management tools. Subscriptions are available in 1 year and 3 year options.
CRE Loaded Professional:
CRE Loaded Professional is a complete ecommerce application with shopping cart functionality and content management developed for the serious web entrepreneur. It comes complete with a content management system which allows you to create standard web pages within your store and manage, organize, and search content on a website. It includes shipping, payment, marketing, sales, design, and admin features, as well as customer and product management tools. Subscriptions are available in 1 year and 3 year options.
CRE Loaded Professional B2B:
CRE Loaded Professional B2B is a secure and scalable ecommerce application with shopping cart functionality for wholesalers and store owners who would like to display different information for separate customer groups. It includes shipping, payment, marketing, security, design, and admin features, as well as customer and product management tools.
If you have set your WordPress site to display post excerpts on the front or home page, you will want visitors to click on the title or a link to encourage them to continue reading your post or article, right? WordPress makes this technique easy, and customizable.
Here is the steps:
Go to wordpress admin panel –> Design tab –> Theme Editor.
Select Main Index template (index.php) to edit it
Find the line “<?php the_content(‘Read the rest of this entry »’); ?>”
And replace it with the following code.
<?php
$content = get_the_content($more_link_text, $stripteaser, $more_file);
if(strlen($content)>500) // chanage 500 as per your needs
{
$part_msg=substr($content, 0, 500);// chanage 500 as per your needs
echo ‘<p>’.$part_msg.’… ‘;
?>
<br /><br />
<a href=”<? comments_link(); ?>”>Read More…</a></div>
<?php
echo ‘</p>’;
}
else
{
echo ‘<p>’.$content.’</p></div>’;
}
?>
Where “500″ represents number of characters that you want to show.
If you cannot able to make the above changes with the wordpress theme editor, use your ftp.
Here is the template directory
/public_html/blog/wp-content/themes
or
/www/blog/wp-content/themes
where blog is the directory where i installed my wordpress