Jscalender module come with Jstools package in drupal 5 you can download drupal jstools package from the drupal.org site.Jscalender uses the jsCalendar javascript library, like using a special CSS class called via #attribute in the form element array to convert textfields into jcalendar enabled. The jcalendar module uses hook_form_alter() to look for textfields with the add-jcalendar class, I had to use something different than jcalendar which is used later on the generated form elements by the jQuery code.

Tags: Hacking, Javascript, Jquery, Programming, Scripting // Add Comment »

ALTER TABLE allows you to change the structure of an existing table. For example, you can add or delete columns, create indexes, change the type of existing columns, or rename columns or the table itself.You can use ALTER TABLE to modify the structure of a table that has not been added to a database.Alter table command allows * To add the field; * To delete the field out; * To change the DEFAULT value for any of the field; * To add or delete the table PRIMARY KEY; * To add or delete the table FOREIGN KEY; * To add or delete UNIQUE constraint; * To add or delete CHECK constraint; * To rename fields or table itself; * To change field type.

Tags: Mysql, RDBMS/DBMS SQL, SQL Server // 2 Comments »

This is a very basic example of php/mysql.We used to make use of mysql database and a php file for getting this done.To run this code you can first create database as provided in sql here and after creating database run this code.Make modifications as you want to do in it.You will see here how to make a basic database connection to mysql database from php file.Adding records in database and deleting data from table.

Tags: Mysql, PHP, Programming // Add Comment »

A Mysql injection is attack tried by site visitors/users to get/damage data in databases by taking benefit from poor programming of websites.An injection attack occurs when a visitor to your site types something into a form input with the purpose of changing the outcome of your MySQL query. For example, at a login screen someone may try this type of attack to gain access to a secure area of the website.

Tags: CMS(Content management System), Drupal, Hacking, Linux, Mysql, Mysql injection, PHP, Programming, Programming Technologies, RDBMS/DBMS SQL, Web technologies // Add Comment »

Once you have installation for mysql ready then you will need to configure security for mysql. Default Admin user id: root Default password: blank The first task is to assign a password: [prompt]$ mysqladmin -u root password 'new-password' Note: the following SQL commands will also work:

Tags: Linux, Mysql // Add Comment »

The jquery is a simple and quick to use javascript library and provides a rich set of functionality in just few lines of code.the $ symbol is also set up as a shortcut for jQuery.If you want the convenience of the $ function for jQuery without colliding with some other use of the global $ function.The $ symbol is also set up as a shortcut for jQuery.If you want the convenience of the $ function for jQuery without colliding with some other use of the global $ function, the jQuery documentation suggests the following idiom: (function($) { // Within this block, $ is a reference to jQuery // Neat, and clean })(jQuery);

Tags: Javascript, Jquery, Scripting // Add Comment »

Many times in linux administration you will need to make changes in apache configuration file wiz httpd.conf.You can configure apache server from /etc/httpd/conf/httpd.conf. from linux shell use vi command to open this file.make changes in this file and restart your apache server after making changes.also make sure you have backed up your file before changing.

Tags: Linux, apache // Add Comment »

FTP clients are software programs used for uploading and downloading files to and from ftp server.In other way FTP (File Transfer Protocol) allows a person to transfer files between two computers, generally connected via the Internet. If your system has FTP and is connected to the Internet, you can access very large amounts of files available on a great number of computer systems. If you are on Bitnet or a UUCP host, you should look for servers that work through electronic mail (e-mail). A good source of information on archives in general, is the Usenet newsgroup comp.archives. FTP (File Transfer Protocol) is the simplest and most secure way to exchange files over the Internet. Whether you know it or not, you most likely use FTP all the time. * The most common use for FTP is to download files from the Internet. Because of this, FTP is the backbone of the MP3 music craze, and vital to most online auction and game enthusiasts. In addition, the ability to transfer files back-and-forth makes FTP essential for anyone creating a Web page, amateurs and professionals alike.

Tags: FTP, Linux, PHP, Web technologies, filezilla // 1 Comment »

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 // 1 Comment »