Five Basic but Useful MySQL commands

May 27th, 2010 | Posted under Web Hosting, Web Hosting Tips | No Comments »

Five Basic but Useful MySQL commands

MySQL is the most popularly used database query and maintenance software. It has an excellent API and language bindings with most major languages – PHP, Python, C++, Ruby. Below are listed five very basic but useful SQL commands –

1. SELECT

This command is used in almost all interactive queries from a MySQL database, to request for tuples (rows). It is the most easy to use and basic command in MYSQL.

2. CREATE

This command creates a table with the desired name and attributes. If necessary, it can borrow fields from other tables.

3. INSERT

This command is used to insert new tuples (rows) in a table. It has 3 variations – INSERT … VALUES, INSERT … SETS, INSERT … SELECT. The first two statements insert explicitly mentioned values as tuples (rows), whereas the third is used to insert values from one table to another based on certain queries.

4. ALTER TABLE

This command is used to alter the structure of any table after it is created, for example, create, destroy or rename fields (columns), or change column attributes.

5. UPDATE

This SQL command is very commonly used, to update the tuples (rows) to some changed value based on certain queries.

BounceWeb provides great offers on MySQL hosting!


How to use the sendmail option on PHP

May 26th, 2010 | Posted under The Internet, Web Hosting Tips | No Comments »

How to use the sendmail option on PHP

Websites often need to send mail to certain user accounts for purposes like email-id verification, sending newsletters and updates, or sending account details. The PHP programming language has the mail() function to send mail to any Email address. It uses the SMTP protocol for sending mail.

Syntax of the sendmail function

    bool mail ( string $to , string $subject , string $message [, string $additional_headers [, string $additional_parameters ]] )

The variables explained

The variable $to signifies the email address to which the mail is being sent. Some examples are:

The variable $subject supplies the subject of the email sent .

The string $message contains the entire body of the message.

$additional_headers is used to supply additional headers with the mail, for example the from header, or the Reply-To header. The headers are seperated with CRLF ( carriage-return linefeed ) sequences.

Example

An example use of the sendmail function –

$to = ”abc@example.com”;

$subject = ”testing”;

$message = “hello world!”;

$headers = “From: webmaster@example.com” . “\r\n” . “Reply-To: webmaster@example.com”;

mail($to,$subject,$message,$headers);

BounceWeb provides great deals on PHP web hosting!



Five coding tips for PHP-MySQL hosting

May 18th, 2010 | Posted under Software, Web Hosting, Web Hosting Tips | No Comments »

Five coding tips for PHP-MySQL hosting

PHP and MySQL happen to be the favorite scripting-database combination for most websites. The popularity is due to the simplicity and effectiveness of PHP and the functionalities of MySQL. However, there are some tips and tricks which can help you perform better with your PHP hosting, and here we list the top five Do’s for you:

Use the quotes effectively

String variables should be quoted with single quotes, while there should not be any quotes around numeric data. This is effective while using them inside echo, which itself should be quoted with double quotes.

Enable error reporting

The php.ini file should be configured such that all errors, except for notices should be reported. This helps in proper debugging of the PHP script.

Use HTML and PHP alternatively, when required

Instead of using echo to write large sections of HTML, PHP codes can be temporarily closed to accommodate HTML and then PHP can be restarted.

Include include files for better effect

The include files are extremely useful, in case a fixed element, such as header, footer needs to be included in all pages. This saves the pain of editing all pages if any modification is required on the fixed part.

Use MySQL datatypes according to the need

Apart from INT, there are other similar datatypes like TINYINT, SMALLINT, which can server the purpose and takes less space than INT.

BounceWeb provides extremely fast and reliable PHP-MySQL hosting.


A brief tutorial on connecting PHP and MySQL

May 18th, 2010 | Posted under Software, Web Design Tutorials | No Comments »

A brief tutorial on connecting PHP and MySQL

The need to interact with your target customers has prompted websites to undergo a major evolution. Now, web admins try to collect as much data as possible from the visitors of their site for better communication. Therefore, a number of tools and applications have been developed which connects the website (what visitors see) and the back end database (where user data is stored). The combination of PHP-MySQL is one such application that is simple and extremely easy to implement.

Here, we will go through the basic steps of connecting the PHP script to the MySQL database

Mention the configuration details

Three important parameters must be mentioned in form of PHP variables for use at multiple places

a. The host name of the MySQL server (generally localhost)
b. User name of the server
c. Password (if any)

Connecting to MySQL

The connection happens after the following line is executed:

$connection = mysql_connect (hostname, username, password) or die (“Some error”);

Selecting the database

Once connected to the MySQL server, the concerned database has to be chosen using the following script:

mysql_select_db(database name);

Once this is done, other SQL functions can be easily used and the results would reflect on the connected database.

BounceWeb has great plans for PHP-MySQL hosting!


Five great applications based on PHP

May 17th, 2010 | Posted under Content Management Systems, Internet Trends, The Internet | No Comments »

Five great applications based on PHP

People often talk about how PHP is being slowly eclipsed by other upcoming APIs that are not only about programming, but provide a complete environment for application development. However, the fact is, most of the popular applications and software are developed on PHP itself. Here, we discuss the top applications that have been made using PHP

Drupal

One of the most popular Content Management Systems (CMS) is completely based on PHP, which gives users and developers the flexibility and the ability to manipulate the system according to their requirements

Joomla

Another CMS that uses PHP for its core libraries as well as the modules developed by thousands of developers worldwide. The simplicity and efficiency of PHP gives Jooma a great advantage.

FFmpeg

The video-sharing module owes most of its development to PHP, and thus faces no compatibility issues with most systems it is implemented on.

Wikipedia

The user-interactive section of the famous knowledge-sharing website has been written in PHP, and has facilitated millions of user entry, apart from filtering the unwanted ones.

Facebook

The most popular social networking website makes use of PHP for user interaction, and thus most applications developed on the Facebook API are also written in PHP


BounceWeb provides fast and efficient PHP hosting.


The future of PHP

July 25th, 2009 | Posted under BounceWeb Company, Software, Web Design Tutorials, Web Hosting, Web Hosting Tips | No Comments »

The future of PHP

Hi all,

If your have been surfing websites for a long time, it’s hard not to notice the “.php” extension at the end of your website link. PHP pages are a common part of web applications, and is one of the most popular web application languages used by developers worldwide. Although, there are far superior languages and development environments that have come up in recent times, people still prefer PHP to them, just because of its simplicity. The fact that it is easier to develop of PHP environment makes it a strong argument for developers to incline towards it.

However, like always, there has been a question over the future of PHP. While some feel that its time that PHP makes way for more advanced languages and development interfaces, there are also hardcore PHP loyalists who think that the simplicity of PHP cannot be replicated by any other language. So, where do we see PHP, a few years from now? Or rather, how will PHP develop itself in keeping itself updated with the changing requirements of the World Wide Web (WWW)? Read on and we will discover some valid arguments on the future of PHP.

PHP Facts and the Future

1. One of the advantages of the PHP language is its vast online community. There are around 20 million web applications that use PHP. Developers all over use the language to create scripts. Many useful software applications like video-streaming applications and content management systems are known to be based on PHP, the most popular example being Drupal. Although, developers in the community can add PHP scripts and suggest changes or add new features in the core PHP package, only about 450 programmers can approve such changes. The organization Zend looks after the packaging issues of PHP. So, in terms of development, there are enough developers, and also administrators who can protect the original package from getting dilute with sub-standard codes.

2. The fact that PHP has stayed at the top, and managed to fend off challenges from much hyped-up languages like Java and ColdFusion, it is safe to suggest that it will continue to do so in the future as well. As we recently saw, PHP came up with the Model-View-Container framework of its own in order to counter the threat from Ruby-on-Rails, it again goes to show how simple the language is, and how easy is it to replicate any new “technologically” advanced interfaces and frameworks that come up now and then.

3. Other languages like Java are considered to be superior because of its extended scope. PHP is generally viewed to be limited with web applications only. However, one can create standalone desktop applications with the help of PHP and GTK. Even some open source programming frameworks now support PHP projects in their tool. Thus, PHP is slowly and steadily coming out its web application boundary, to conquer the standalone application space.

Thus, it is pretty safe to say that, PHP, which is known to withstand the test of time, is good enough for the future as well. Simplicity, as they say, is very complex to achieve. And, PHP happens to achieve that very strongly!

BounceWeb offers PHP Web Hosting on all our Shared Web Hosting Plans!


PHP – Some features you didn’t know existed!

July 25th, 2009 | Posted under Software, The Internet, Web Design Tutorials, Web Hosting, Web Hosting Tips | No Comments »

PHP – Some features you didn’t know existed!

Hi all,

PHP or Hypertext Preprocessor is probably the most popular scripting language used for web applications. In fact, PHP along with MySQL, a database application software is the base of several web applications, running even today! So, what makes PHP so special? The features that PHP provides make it so popular among web application developers. Here, we shall discuss some of the lesser-known, yet extremely powerful features of the language.

PHP Features – Almost Hidden!

1. The PHP documentation – Not many programmers have been able to extract full use of the exhaustive online documentation in the official PHP website. With other programming languages, it has been the case that one needs to collect pieces of information from different websites and forums. However, PHP documentation is a complete manual, contain every single specification about the PHP programming elements. Each PHP function has a separate page allotted in the website, with all the reference associated with it. They come with practical examples. Moreover, unlike many other online documentations, there are several user comments that is also extensive when it comes to the amount of knowledge it imparts. Some even consider the manual to be more helpful than Integrated Development Environments (IDE) for PHP.

2. Arrays – People may argue that arrays are probably one of the most common things that any programming language offers. So, what is so special about providing arrays? However, what many developers do not know is how arrays can be used flexibly to use it in several ways. Arrays can be used accordingly to create lists, stacks, maps and other data structures, at the same time! The arrays are implemented in the core package of the PHP, and thus use the CPU resources well. Moreover, the array elements in PHP are ordered and so flexible that it makes some really difficult tasks to be carried out very easily.

3. Stream Handlers – Most people have no idea how powerful stream handlers could be! These handlers help you extend the file system with certain logic and happen to be extremely difficult to implement in other languages. It simplifies the life of PHP developers by allowing PHP applications to be easily read from and written to from containers, like we do with files. One of the most popular stream handler used by developers is the MS Excel stream handler. It helps in creating a MS Excel file from data collected, either through the web, or extracted from the database. Similarly, one can read from MS Excel files to add to the PHP page. This flexible interaction with other file systems make PHP so attractive to web application developers.

4. However, the greatest feature is how easy and modular is the code for understanding. Many would argue whether this is a feature at all, but however, when the code is easy to understand, even for beginners, it is definitely something to talk about. With a generally knowledge about programming knowledge (especially C language), almost anyone can read and understand the basic PHP codes. Moreover, the PHP community, being a open source one, is very proactive towards welcoming new programmers in the community by providing tips and tricks to code better.

BounceWeb offers PHP Web Hosting with high quality and low prices.


New features in MySQL 6

July 25th, 2009 | Posted under The Internet, Web Design Tutorials, Web Hosting, Web Hosting Tips | No Comments »

New features in MySQL 6

Hi all,

For normal users, identifying with MySQL is not very common. A HTML file or even a PHP file could be understood to be something related to web pages, but however, MySQL doesn’t ring a bell in the minds of most people. For developers, the scenario is completely different. MySQL happens to be one of the best things that could happen to the World Wide Web, and developers know it very well! The database software is the backend of most web applications, thus accounting for its unfamiliarity with normal web users.

Databases are used with the purpose of storing user information and other data in the server and are useful for maintaining the application. Server-side scripting languages like PHP and Perl can access data from the database and represent them in web pages for public display. However, the storage and the communication with the database are not very simple. Databases need to be very secure applications themselves, and under no circumstances should data be modified or deleted without proper authorization. The fact that MySQL is used as the database application for over 30 million web applications puts an end to all questions over its integrity and efficiency.

Sun Microsystems, the owner of MySQL software, does a good job in adding new features to the core package, and publish it as a new edition. The latest version family under release is the MySQL 6.x. There are some extremely promising features in the latest package that has the potential to redefine the way web applications are made. Here, we will discuss some of the features that have been newly introduced in MySQL 6.x.

MySQL 6 Features

1. Supplementary Characters: MySQL has always been a supporting different improvement of Unicode character set. Previously in its older editions, it has supported two character sets of Unicode: utf-8 and ucs-2. These are good enough till the Unicode version 3.0 where the code values range from 0 to 65535 and are encoded with a maximum of 24 bits. However, in the latest version 5.0 there are 99089 characters that are defined. All these characters cannot possibly fit into the Basic Multilingual Plane (BMP) as in version 3.0. Hence the additional characters are called supplementary characters. MySQL 6.x has taken a step ahead to support these supplementary characters, along with supporting utf-8, utf-16 and utf-32 too. The other reason why the change has been inevitable because Windows Vista, the latest operating system by Microsoft supports supplementary characters.

2. Online backup – Backup is an important aspect of any database software. Data cannot be lost under any circumstances, and thus backups come in handy in case some unforeseen incidents happen with the original database. The online backup database can read one or more databases into a backup image file. Similarly, the image file can also be written on to one or more databases. Therefore, in case a database is lost, all one needs to do is to make use of the backup database. However, the word “online” does not refer to the fact that the backup image resides on a web server, but only means that there would be “no blocking” during the backup process.

BounceWeb offers the latest MySQL Hosting and once MySQL 6 comes out, our Shared Hosting Plans will have it available.


Advanced features of phpmyadmin

June 22nd, 2009 | Posted under Computer Advice, Software, The Internet, Web Hosting, Web Hosting Tips | No Comments »

Advanced features of phpmyadmin

As you may accept realized, the PHP accent revolves about the axial affair of practicality. PHP is about providing the programmer with the all-important accoutrement to get the job done in a quick and able fashion. Five important characteristics making in PHP’s :
1. Familiarity
2. Simplicity
3. Efficiency
4. Security
5. Flexibility

Installing PhpMyAdmin Advanced Features

To install the advanced features of phpMyAdmin you have to create a special control database that PMA uses to store bookmarks and relationships etc… PMA comes with a script called create_tables.sql that include the relevant sql statements to set these tables up. Gradually, when you install phpMyAdmin directly from source, this create_tables.sql script can be found in the scripts sub-folder.
Instructions
Firstly, unzip and run the create_tables.sql file:
cd /usr/share/doc/phpmyadmin/examples
sudo gunzip create_tables_mysql_4_1_2+.sql.gz
mysql -u root -p < create_tables_mysql_4_1_2+.sql
Then setup a user/password for phpMyAdmin to use:
mysql -u root -p -e ‘GRANT SELECT, INSERT, DELETE, UPDATE ON `phpmyadmin`.* TO ‘pma’@’localhost’ IDENTIFIED BY “password”‘
Then edit the config file, and uncomment the extra features options for your chosen server, and add the individual / password you setup in the previous step. If you haven’t edited this enter before you may requirement to also uncomment the rest of the server definition.
sudo vim /etc/phpmyadmin/config.inc.php
Setting up foreign keys in phpMyAdmin?
InnoDB allows you to add a fresh foreign key constraint to a table by using ALTER TABLE:
ALTER TABLE tbl_name
ADD [CONSTRAINT [symbol]] FOREIGN KEY
[index_name] (index_col_name, …)
REFERENCES tbl_name (index_col_name,…)
[ON DELETE reference_option]
[ON UPDATE reference_option]
On the other hand, if MyISAM has main advantages over InnoDB in your context, why would you need to create foreign key constraints at all. You can handle this on the model level of your application.
Create a sample database using your PMA, into this database run the following SQL query:
CREATE TABLE `profiles` (
`id` int(11) NOT NULL auto_increment,
`content` mediumtext NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `users` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL,
`profile_id` int(11) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Hopefully this helps you with a short intro to the Advanced Features of PHPmyAdmin

All of BounceWeb’s PHP Hosting Plans include PHPmyAdmin


Drupal Hosting: How good is it?

June 4th, 2009 | Posted under Content Management Systems, Web Hosting, Web Hosting Tips | Comments Off on Drupal Hosting: How good is it?

Hi all,

If you are looking to create a web site of your own in a jiffy, loaded with cool features and lots of functionalities, a content management system is the thing for you! And, just going by the popularity scale, Drupal comes first into the mind.

So, what exactly is a content management system or CMS? A content management system is basically an application that helps normal users with no or very little knowledge of programming, to create, store, control and manipulate web content and create web applications easily. You would probably find hundreds of such content management systems in the Internet providing such services. However, Drupal seems to be the best of the lot, as most people generally prefer to use it.

So, the question remains: How good is it actually? Or rather, what makes Drupal such a successful project? Well, read on and we will soon discover.

Drupal’s main strength lies in its vast and widespread community that includes developers, testers and general users. Being an Open Source product written in PHP scripting language, anyone can download, use, distribute, modify and redistribute the modified version without any fear of getting into any copyright issues. It is licensed to the GNU General Public License v2 (GPL) and is therefore available for free with extensive customization features.

The other big reason behind its popularity is certainly its support for multiple platforms. Be it the free Apache servers or Microsoft’s IIS; Drupal runs on them perfectly. If you are apprehensive whether your Drupal would be compatible with your operating system, then you can be rest assured that it supports most operating systems including Unix, Linux, BSD, Sun Solaris, MS Windows and Apple’s Macintosh OS. Drupal also provides quite a few options for storing your web content, and presently supports the mostly used MySQL and PostgreSQL.

That’s not it! For people who are looking forward to adding cool stuffs to their websites, Drupal has a huge list of such feature-rich applications to choose from. With its modular approach, you can select your desired application module and add it to the main Drupal core (the main Drupal package). You can create polls on your site, simply by installing a poll module in your system, and then probably you can allow users to create polls in your site.

If designing means a lot to you, then Drupal gives you enough reasons to fall in love with it! Drupal segregates the content from the design, so you can probably manipulate the look of your site and also, you get to choose from a massive list of themes, already available on the Drupal site, courtesy the community contributions.

If you are still hungry for more, then Drupal has it for you! Drupal provides an application interface for creating weblogs with the help of a rich editing environment. If your site encourages discussion through comments, Drupal suits your needs perfectly, as its threaded comments model enables presentation of comments in a hierarchical manner. Drupal also has a powerful news aggregator that helps you publish news and articles from external sites. On the other hand, your content can be available to others in RSS format with the help of its Content syndication feature.

Well, Drupal has lots more than what can be discussed here. With so many features, and so much freedom to customize, its immense popularity over the Internet is completely justified.

BounceWeb offer the Best Drupal Hosting


Previous Entries Next Entries