Archive

Posts Tagged ‘Effortless’

WordPress : How to register a user on local machine?

September 16th, 2010 58 views No comments

If you are developing wordpress blog, you might need to do testing for registered users like

  • Whether non registered users are able to view blocked posts
  • Whether restricted contents are visible to members only.
  • Which are options on dashboard accessible to various users?
  • etc

Better you do all testing locally including user registration.
To register a user on local copy of your wordpress, either you need to configure SMTP server locally. So mails can be send from your machine. Or you can go for a very small trick mentioned below.

1

Let wordpress generate whatever password it generates. You just select password that you want, say “article-stack”. Now calculate its MD5 value.



2

Open wordpress database. For this

  1. Type http://localhost/phpmyadmin/ in Internet browser.
  2. You can see the list of database in left side bar. You need to identify which one is used by your wordpress installation
  3. Just click on appropriate database name.
  4. You’ll see list of wordpress tables in left side bar. All tables shall be start from “wp_” prefix.
  5. Select “wp_users” table. Change the password of desired user with calculated MD5 value.

How to send mails from your PC? 5 min setup

September 15th, 2010 46 views No comments
letters
Before reading this article, you are required to install Xampp on your PC. This will automatically install other needful components. Then you would have to do some changes in php.ini that i am describing below.

Initial settings:

Locate php.ini which should exist on following path. I am assuming that you had installed Xampp on C drive.


C:\\php\php.ini
C:\\php\php5.ini
C:\\apache\bin\php.ini

Editing php.ini:
- Open php.ini file and uncomment the php_smtp.dll extension. This is required when sending emails to a remote server.
- Scroll down and find the following lines:

[mail function]
; For Win32 only.
;SMTP = localhost
;smtp_port = 25

; For Win32 only.
;sendmail_from = me@example.com

- From the lines above, uncomment SMTP, smtp_port and sendmail_from
directives, then add SMTP server, SMTP port number and your preferred email address to SMTP, smtp_port and sendmail_from directives respectively, your final code should be similar to the one below:

[mail function]
; For Win32 only.
SMTP = mail.server.com
smtp_port = 25

; For Win32 only.
sendmail_from = something@server.com

- Replace mail.server.com and something@server.com with correct values. The default
- Restart your server. That you can do from xampp controller.

Please note this
SMTP port number is “25″. But port 25 is generally blocked by your ISP. So use 5190 instead. Otherwise you may need to contact your ISP to unblock it.

Now you just need some application that can send e-mail from your PC. You can use wordpress for the same.

Sample database for transport inventory project

September 11th, 2010 449 views No comments

I had already provided sample database for inventory of goods and an analysis report too.


truck amty inventory transport shipment

If you are developing an application for some transport company or for your personal practice then this sample file can help you. You can use this database file for personal or commercial purpose. I am providing this file specially to increase understanding about database designing. You can read analysis report & design for transport based application.

Download here
This area is protected to registered users only.

Sample database for an inventory project

September 10th, 2010 754 views 2 comments

Like other articles of db files, I wrote this to provide free and sample database related to inventory. This database file is related to item and customer relationship. It’ll be very helpful if you are trying to solve previously written article on SQL exercise. Otherwise you can use this database to make any inventory project related to small firm or shops deal in selling and buying items.


article-stack bar code

You may refer my another article for some analysis work with diagrams here.

This database file is available in MS Access format and contains some dummy data for practice. It contains around 4-5 tables. For more data, you would have to populate yourself. Feel free to use this database. And share it with me, if you do some update on it.

Download here
This area is protected to registered users only.

Sample database for hotel management application

September 8th, 2010 1118 views 5 comments

This article is written specially for students who are building an application or project for their own practice or as a college, school assignment. It might help you to improve your analysis level. Here, you will know

  • How to relate tables?
  • How to separate data into multiple tables?

hotel management

It’ll help you to build project related to hotel management where people stays, check in and check out. It’ll not help you if you are building an application related to some restaurant.
If you need some more data base you can visit db files tag. My purpose is to make you concentrate on, how to retrieve data not to build data. If you have less time to develop complete your projects or assignment you can use ready to use code and applications from this site. Now the time is to go practically and improve your understanding in retrieval of data and SQL.

Download here
This area is protected to registered users only.

How to upload wordpress theme or plugin after development

September 2nd, 2010 173 views 1 comment
wordpress theme & plugin upload
Developing a plugin or theme is not as difficult as uploading this to WordPress server. right? at least it was true for me in starting.
After developing a plugin i uploaded it into wordpress database after 1 month. But when i started to update it, i took only some minutes to understand the complete process.

Let’s start

Develop your plugin and test it locally.

Notify WordPress team about your work

a. Create you account on wordpress .
b. Select “Add your plugin” from left menu. Fil basic information about your plugin or theme. So that wordpress team can access it and test it.

Wait for mail
Once your plugin is submitted to and tested by wordpress team you will get a mail. like this

    Your plugin hosting request has been approved.
    Within one hour, you will have access to your SVN repository at 

http://plugins.svn.wordpress.org/YOUR-PLUGIN-NAME/

    with your WordPress.org/bbPress.org username and password (the same one you use on the forums).
    Here's some handy links to help you get started.
    Using Subversion with the WordPress Plugins Directory 

http://wordpress.org/extend/plugins/about/svn/

    FAQ about the WordPress Plugins Directory 

http://wordpress.org/extend/plugins/about/faq/

    WordPress Plugins Directory readme.txt standard 

http://wordpress.org/extend/plugins/about/readme.txt

    readme.txt validator: 

http://wordpress.org/extend/plugins/about/validator/

    Enjoy!

It may confuse you little bit. But forget it

4. Download “Tortoise SVN” from http://subversion.tigris.org/. [you may have to login to download it]

5. Once the installation is done.

  1. Create a folder somewhere on your hard disk.
  2. Right click on the folder. And select “Create repository here”.
  3. Some folders will be created inside the folder you opted for repository.
  4. Again right click on the same folder. And select “SVN Checkout”. [To know more in detail you may visit wordpress]
  5. It will ask for login ID & Password. Use the id you use to login on wordpress plugin site.

tortoise SVN menu screen shot

6. Inside your plugin directory you will get three more folders

  1. trunk
  2. tags
  3. branches

7. Copy your plugin files in “trunk” folder.(dont archive them)

8. Make a readme.txt to tell something about your plugin or theme. refer its format.

Note
To check whether contents of your readme.txt are valid or not. Go to read me validator. Here you can paste contents of readme.txt. And can validate it.

Extra files
Providing screenshots to viewers of your plugin is really a good idea. It may fascinate users to use your plugin. Take some screenshot. And place them into “tags” folder of your repository folder. And specify their path into readme.txt.

Note
tags folder contain a version folder like “/2.0/”. All files are placed only inside version folder. This version must be similar to the version specified in you readme.txt

Save your work

What else. Just right click on your repository folder and select “SVN Commit”. Your work will be uploaded to wordpress server. You may check it by following http://plugins.svn.wordpress.org/YOUR-PLUGIN-NAME/

You may also refer my repository directory structure for further help.

CSS: PNG fix

September 2nd, 2010 89 views No comments

I never suggest using PNG images since they are bigger in size and not compatible with many browsers. Although you can fix their appearance so their transparency can persist. But sometimes they are needful for web designers. So here I am mentioning some PNG fixes as per my experience.

These fixes may fix transparency of a PNG image. But you would have to test it with various version of internet browsers like IE 5,6,7 etc, various internet browsers like chrome, Firefox, epic, IE etc. And on various platform like Mac , Windows, Linux, Mobile OS.

Testing a page against so many browsers is really a tough job. Specially when you asked to test it on various platforms. You can use one click solution for this. It’ll not only save your time but money as well.

If you are wrodpress blogger then HITS- IE6 PNGFix might help you to fix PNG transparency in IE6. You may try it to other browsers as well. But author claims to fix in IE6 only.

1

andreaseberhard jquery png fix

This fix, based on jquery, is ultimate. It supports all version of IE above than 5.5 (including). Click on the image for online demo and how to use guide. You can directly download it from andreaseberhard.


2

twinhelix ie png fix

twinhelix PNG fix claims to fix transparency problem of any PNG file as well as ALPHA problem. It supports all the images inserted on the HTML page using < img > or background images. Click on the image to visit their demo page and how to use guide. I am not sure this fix is compatible with CSS3. But I had tested it against EPIC and firefox. And found it effective.
You can download this fix directly from twinhelix.

Please report me if you find any link broken.

PNG transparency is not only the problem for web designers. There are some more problems related to margin, floats etc. These problems always make me worry. But I have cure for margin Fix and floating fix. Please let me know if you are facing any other CSS related issue. Moreover, CSS compatibility charts can help you giving an idea about what part or browser you are missing from testing your webpage. I would like to find out more effective solutions as well as improving my knowledge.

Xampp : How to Run & Test WordPress locally

September 2nd, 2010 217 views No comments

If you are planning to edit/create your own wordpress theme, XAMPP will be a best option to test it. Although creating WP themes using Artisteer is too easy and editing existing themes using ThemeDreamer is very simple. But how would they look in various browser is important. And at this point you need some platform where you can run wordpress.

Xampp will let you test your wordpress blog or any other PHP, JSP etc site locally. This tutorial will tell you about how to configure xampp and about how to configure wordpress on xampp.

1
Setup XAMPP

  1. Download xampp lite. It is free, smaller in size & direct run.
  2. Extract it to C drive. Now you will have a folder on C drive with name XAMPPLITE.
  3. Open setup_xampp.bat resides in XAMPPLITE folder.

    xampp folder
  4. Once you get success message, open “xampp-control.exe”
  5. Start Apache & MySql from the opened window.

    xampp controler
  6. To check whether XAMPP is working fine. Open following link in any Internet browser.
    
    http://localhost/xampp/splash.php
    
    or 
    
    http://localhost/xampp/
    

2
Setup WordPress

  1. Download wordpress. It is also smaller in size & free to use.
  2. Extract it to C:/XAMPPLITE/HTDOCS
  3. Open http://localhost/xampp/splash.php in any internet browser. Click on phpMyAdmin (under Tools in left sidebar).
  4. You will get a window given in below image. Copy the text exact which is marked in red in below image & click on CREATE button. This is the database name which will be used by wordpress. You are free to give your desirable name.
    xampp phpMyAdmin
  5. Open wordpress directory (C:/XAMPPLITE/HTDOCS/WORDPRESS/).
  6. Rename wp-config-sample.php to wp-config.php. And Open this file.
  7. You will find following code in starting of the file.
/** The name of the database for WordPress */
define('DB_NAME', 'putyourdbnamehere');
/** MySQL database username */
define('DB_USER', 'usernamehere');
/** MySQL database password */
define('DB_PASSWORD', 'yourpasswordhere');
/** MySQL hostname */
define('DB_HOST', 'localhost');

Replace the above code with below code.

/** The name of the database for WordPress */
define('DB_NAME', 'wordpress');
/** MySQL database username */
define('DB_USER', 'root');
/** MySQL database password */
define('DB_PASSWORD', '');
/** MySQL hostname */
define('DB_HOST', 'localhost');
3
setup your blog

Open;


http://localhost/wordpress/wp-admin/install.php

or 

http://localhost/wordpress/wp-admin/.

This is one time process to setup your blog. This will provide you id & password that you can change after login. Note it down somewhere because it’ll not display it again and you can not. Use the same above link to login to dashboard (like a control panel of your blog).

To run your blog type http://localhost/wordpress/ in any internet browser like epic.

Finally, your local server is ready to run your blog. Now the turn is to install some themes and plug-ins. You may also need some sample posts if you want to save your time while testing.
You can try my plug-in initially. It’ll give you more options to test. Read other articles over wordpress. And remember to make a user locally to complete your testing.
If you had published your site and want to test its appearance on various browsers and platform the browsershots can help you.

Please leave your feed backs, suggestions and ideas for another easy setup of any blog.

How to test a web page in many browsers and platforms in one short

September 1st, 2010 47 views No comments

If you already had read article over margin fix and float fix then you must be interested to test your website on various browsers, their versions and various platforms.
It is not easy to install all browsers on your local machine. Nor you can arrange many platforms. It’ll not only be expensive but time consuming. If you your website on one browser it must take 1 min on average.
Well!! I have a solution. Use browsershots. Browsershots lets you test any website online in few seconds.

It generates screen shot from various browsers on various platforms. You can select your desire platform, browser or their version.


browsershots options

Once your request is processed, you can see thumbnail for all results. Click on any thumbnail to see full image and detail.

browsershots result

Problems

  1. You cannot test a site which is not published since you need to give URL of a site.
  2. You might stick in queue. If there are many requests for a browser then it’ll put you in queue. You will have to revisit the site for screenshots. You need not to search again. Just use the URL looks like http://browsershots.org/http://article-stack.com/

Once you analyze generated screen shots, you might need CSS compatibility charts to identify the problem, if any and to fix them.

Use Google as CDN for various java scripts framework

August 31st, 2010 203 views No comments
java script frameworks at google


Google hosts some scripts at their server that you can refer on your site directly. It doesn’t only save bandwidth of your site but make you tension free to update java script versions.

CDN means content delivery network or content distribution network (CDN) . You can host your site contents(static) like images, css, java script or flash files here. When someone visits your site, contents uploaded at some CDN would be downloaded on client side parallel. It saves bandwidth and reduce site loading time.

You can opt any java script framework mentioned below.

< script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js"></script>
< script type="text/javascript"
src="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8.2/jquery-ui.min.js"></script>
< script type="text/javascript"
src="http://ajax.googleapis.com/ajax/libs/chrome-frame/1.0.2/CFInstall.min.js"></script>
< script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/swfobject/2.2/swfobject.js"></script>
< script type="text/javascript"
src="http://ajax.googleapis.com/ajax/libs/mootools/1.2.4/mootools-yui-compressed.js"></script>
< script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/ext-core/3.1.0/ext-core.js"></script>
< script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/yui/2.8.1/build/yuiloader/yuiloader-min.js"></script>
< script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/prototype/1.6.1.0/prototype.js"></script>
< script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/scriptaculous/1.8.3/scriptaculous.js"></script>
< script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/dojo/1.4.3/dojo/dojo.xd.js"></script>

How to save multiple selected images from a webpage in one short

August 9th, 2010 117 views No comments

I seen people searching software or plug-in to save more than once images from a web page in one short. Or they manually right click on the image and save it. But if you are using Firefox then this tip can save your time & effort both. It’ll also help you to save embedded videos and background image of that page.

Generally, Background images are not saved when you save a web page.

Well!! First you need to visit that page from Firefox browser. Once it is opened. Go to TOOLS menu & select Page Info.
You’ll get a dialog box on your screen. This will give you some information about opened web page. You can see four tabs in that dialog box. GENERAL tab fetches information from page header. It arranges information and displays them properly. So you can read & understand it properly.

Next is MEDIA Tab. All embedded contents and images are listed here. You can select anyone of them to see their preview. You’ll find a “Save As” button o the preview area, to save selected item. You also can select multiple items from the list. And save them.

Firefox page information