Many times in ASP or dot net we may need to connect to a mysql database.For making a connection to mysql database we need to install mysql connector for windows which you can download from:-..

Tags: ASP Dot Net, CMS(Content management System), Dot Net Nuke(DNN), Drupal, Mysql, PHP, Programming, Programming Technologies, SQL Server // Add Comment »

First of all you should know how you can add users in mysql databases:- * Using CREATE USER and/or GRANT commands * Inserting a new record into the mysql.user table First let's see how to use the CREATE USER command:- CREATE USER user [IDENTIFIED BY [PASSWORD] 'password'] e.g mysql>CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'mypassword';

Tags: Dot Net Nuke(DNN), Drupal, Linux, Mysql, SQL Server // Add Comment »

URL reqriting is Simple Rewriting Your URLS (links) Also Redirecting Them To Known URLS.e.g you'll make the link : view_my_profile.html --> Is Redirected to function.php?op=3 so instead of the link "function.php?op=3" Which isn't enough describing itself we'll make the link "view_my_profile.html" Which is very describtive.Why using mod_reqrite?. Now see if your site has more than 10,000 Links (Dynamic Website) , do you think we would make 10,000 html files ?? =>Of course Not , and here's the Use Of Mod-Rewrite. We can achive dynamic pages from code and rewrite their URL using this module. =>well simply This is Very very useful for search Engines to correctly index Your website and gather keywords, we'll talk about this in details in "Search Engine Optimization Tips"

Tags: CMS(Content management System), Drupal, Linux, OUR web, PHP, Programming Technologies, SEO // Add Comment »

Firefox EC2 UI for Managing Amazon EC2 Images Firefox provides easy plugin for managing EC2 images in a GUI method.You can download elastiic fox extension from firefox site. The instructions for creating an Amazon EC2 image walk through the use of command line tools which is really great. Learning how to do it this way is important because it helps you understand more about what you're actually doing. But once you understand it all, it can be a headache to have to remember all the commands and options because they're all rather similar. So quickly after learning all about Amazon EC2, my buddy Hiram told me about the Firefox Extension for Amazon EC2. This Firefox extension is such an incredible time saver for most of the tasks of managing images. Starting and stopping images, grabbing the public DNS name of an image, etc. are as easy as clicking a button. After you've taken the time to understand how to create and work with images from the command line, it is definitely worth using this extension. Prerequisites This extension requires Mozilla Firefox version 1.5.0 or later. Running the Extension Install the extension by clicking on the following link with Mozilla Firefox: Download link removed... Firefox guides you through the installation process. You may need to configure Firefox to install software from this domain. Documentation Read the ElasticFox Getting Started Guide for information on using the extension.

Tags: OUR web // Add Comment »

Many times it is needed to get the structure of table in PHP file or drupal module.There may be conditions that you dont have got admin user name and passwords for cpanel/phpmyadmin.In such cases you must have idea how to know the structure using a small PHP code.you can get connection info for mysql from code files or if you are using ftp it is sure that u can run a SQl query from code file.So below is the simple script for getting table info Simple PHP Mysql $table_name="node"; $sql=sprintf("SHOW COLUMNS FROM %s",$table_name); $$rs=mysql_query($sql); while($col=mysql_fetch_object($rs)) { print_r($col); } Drupal And Mysql $table_name="node"; $sql=sprintf("SHOW COLUMNS FROM %s",$table_name); $$rs=db_query($sql); while($col=db_fetch_object($rs)) { print_r($col); } Once you have checked structure you must be able now to add alter structure of table using same code method:- mysql_query("ALTER TABLE user_info ADD user_coupon varchar2(50)");

Tags: CMS(Content management System), Drupal, Mysql, PHP, Programming, Programming Technologies // Add Comment »

In Dotnetnuke many time you can get a blank page on Import module definition.For one of my dnn(dot net nuke) site i did Host=>Module definition=>Import module definition and got a blank page.I did a google and found solution applied that and now making that code available here.For making this thing to work you ned to get few SQL commands run from host sql window.

Tags: ASP Dot Net, Dot Net Nuke(DNN), Programming Technologies, SQL Server // Add Comment »

The NodeList object represents a live collection of Node objects. This means that any alterations to the number or properties of nodes is immediately reflected in the list. This list permits indexed access to individual nodes as well as iteration through the collection. To demonstrate this Object we shall use the following simple XML file 'library.xml'.

Tags: OUR web // Add Comment »

The property “FlashVars” can be used to import root level variables to the flash movie or swf. The flashvars propery is used in codes for embedding flash in the html page. The string of variables passed in as flashvars, will be imported into the top level of the movie when it is first instantiated. Variables are created before the first frame of the SWF is played. The format of the string is a set of name=value combinations separated by ampersand (&) symbols. Here's some sample embed codes, including object and embed tags:

Tags: Flash, Multimedia // Add Comment »

Many times in our asp dot net application we need to manipulate page titles and keywords.E.g. You may like to change page title Or to get page title.Sometimes you will need to display as content header in content area of page.In a typical .Net web application you can change the title of a page on the fly by accessing the Page object’s Title property. Page.Title = "My Custom Page Title"; But from within your DotNetNuke module code you do it in a slightly different way. You first type-cast the Page object into a DotNetNuke.Framework.CDefault variable. Then you read and write the Title member on the CDefault object:....

Tags: ASP Dot Net, CMS(Content management System), Dnn Tricks, Dot Net Nuke(DNN), SEO // Add Comment »

There are manby things which are considered as basics in dot net nuke.When you are using host sql window from dnn then most definitely you will need to have ideas of basic sql statements to fetch info from db.Few of them are:- Listing all tables from DataBase:- SELECT * FROM information_schema.Tables Get Stored procedure description and Structure:- select * from information_schema.routines where routine_name = 'Stored Procedure Name' Querry to fetch all tables in a database: select * from sysobjects where type=’u’

Tags: ASP Dot Net, Dot Net Nuke(DNN), SQL Server // Add Comment »