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!

Steps to start a video sharing site using FFmpeg

June 7th, 2009 | Posted under FFmpeg Hosting, Web Hosting, Web Hosting Tips | No Comments »

Steps to start a video sharing site using FFmpeg

The last few years have seen a massive change in which websites are made. Today, it is more collaborative, making people come together under a community and sharing contents. Websites even allow users to upload content directly in its server, and let other users view it. This is a huge change from the way websites used to be few years back: the Webmaster created the contents for the site, and there was limited participation from the user.

The latest craze that has hit the web world is video sharing. People have been enthusiastic to upload different videos, and view other videos hosted on the site. Hence, a lot of websites enabling video sharing has cropped up in the last few years. And there is a set of software libraries that have been making it possible: FFmpeg.

So, how do we make a perfect video sharing website with FFmpeg, which is bound to attract netizens? In this article, we look deeper into the matter.

1. Firstly, a web host has to be located with FFmpeg installed on the server. Such hosting with FFmpeg installed is also termed as FFmpeg hosting. FFmpeg is responsible for converting one video format to another, uploading and streaming of video files. Such servers should ideally be dedicated, because in most cases, these sites are subjected to consumption of huge traffic, so there is a lot of pressure on the web server.

2. A database, preferably using MySQL must be set up as the website scripts of Ffmpeg would require a database to use. The database just needs to be created, as the configuration would be done in the settings of the video sharing scripts of FFmpeg during installation.

3. The video sharing scripts must be installed in the server. Some FFmpeg hosts provide a few scripts for free, while most of them can be bought for varying prices. Among many such scripts, the most used are PHP motion and vShare.

4. The other steps include uploading files to the web host, which can be done through the file manager of the website’s control panel or the FTP site, which is a lot quicker.

5. However, one step should be performed for maintaining the security of the video sharing website. The installation files should be deleted from the web server. This would prevent anyone from performing malicious activities in the site.

The above-mentioned steps should be enough for creating a video sharing website. However, one of the main steps is to find a good web host that provides FFmpeg installation. As the site gets popular, the web admin can opt for Virtual Private Hosting, which would take good care of the bandwidth problems.

BounceWeb provides FFmpeg hosting. Check out our support for YouTube Clone Scripts. Also we have video sharing demos.

Perian – The Quicktime component based on the FFmpeg project.

June 7th, 2009 | Posted under FFmpeg Hosting, Web Design Tutorials, Web Hosting | No Comments »

Today, there is abundance of video formats in the technology world, with each claiming to be the best. But for people dealing with videos, it has always been a problem to use different formats, download separate codecs to run them in their favourite players. However, Mac users can breathe a sigh of relief as, Quicktime, the Mac’s multimedia player has a video plug-in, named Perian, which is free (and also open source) and supports a huge range of multimedia codecs which includes DivX, FLV, AVI and many more.

The Perian plug-in is an implementation of the FFmpeg project. The FFmpeg is a software library that can record, convert, encode/decode, and steam video files in various formats. The FFmpeg software is made up in C, and comprises of several components, of which the Perian project uses two: libavcodec and libavformat.

The libavcodec is a library of different codecs for encoding and decoding of videos. It is free and licensed under LGPL. The libavformat is dependent on the libavcodec format and is also a library containing muxers and demuxers for different audio and video container formats.

However, the popularity of Perian lies in its ability to playback DivX formats. Without Perian, Quicktime users felt the problem of DivX files not playing in full screen, unless it is the pro version of Quicktime. However, with the installation of Perian, the Front Row, the Mac’s media center, would play DivX files in full screen mode. Moreover, with Perian installed in more than one computer, connected through a network, DivX files can be shared through the Front Row, across the network.

Although it enables Quicktime to play any video format users want it to play, it has some cons too. In case of MKV format, the user would have to wait for the buffering to finish in order to watch or export the file. However, the part that has already been buffered can be watch, and Perian normally buffers MKV files quite fast enough. Another thing that is considered to be a con for Perian is that it doesn’t support popular media formats like the OGG and Windows Media. However, Apple’s other product like Flip4Mac and XiphQT supports the Windows Media and the OGG codecs respectively.

The Perian plug-in is also used with Quicktime supported applications like NicePlayer and QTAmateur. The TV platform Miro and streaming application Airfoil also include Perian in their projects. The current version released by Apple is Perian 1.1.3.

Mac users never had it smoother. A player that can play most of the video formats is a great relieving thing for a user, and Quicktime have done with Perian as its component. And in turn, Perian has done it with the help of FFmpeg. In fact, Perian, branded as “The Swiss Knife of QuickTime” extends special thanks to the FFmpeg project.

BounceWeb provides FFmpeg hosting. Please visit us at http://bounceweb.com/ffmpeg-hosting.html for more details.

FFmpeg hosting

June 7th, 2009 | Posted under FFmpeg Hosting, Web Hosting | 2 Comments »

In the last few years, the definition of a good interactive website has completely changed. Today, most websites are found to be streaming videos, or offering provisions for uploading and sharing videos to its viewers. There are certain software libraries available over the Internet that converts the user-uploaded video, which could be encoded in any form, into a single format, which is viewable from the hosted site, and also embeddable to a third party website. One such software library that is mostly used in websites is the FFmpeg and its usage in websites is termed as FFmpeg hosting.

FFmpeg is written in C programming language and is under the GNU General Public License (GPL), which allows its users to use, distribute, modify the software and redistribute the modified software without any fear of copyright issues. The software, which has been made under the Linux operating system, is actually a cross-platform software, meaning that it could be used in most operating systems like Microsoft Windows, Apple Mac OS besides Linux. It also supports different computer architectures like x86, SPARC, ARM, PPC and MIPS.

The FFmpeg project has several components, being continuously developed by FFmpeg developers, and the latest version to be released is version 0.5. The software contains a command line tool, named ffmpeg that actually converts videos of a format to another. Besides converting, it can also encode real-time videos from a TV card. The second component of FFmpeg is the ffserver, which is a HTTP multimedia-streaming server, and is basically used for live video broadcasts. It also supports time-shift live broadcasts. The project contains its own media player, named ffplay and is based on the ffmpeg libraries.

The most important component of the project is libavcodec, which is a compilation of the encoders and decoders of the FFmpeg audio/videos. A lot of codecs were developed completely the FFmpeg developers for better and enhanced performance.

There are other components too, such as the libavformat, containing the muxers and demuxers for different formats; other routines for video post-processing and image scaling and library of routines for different FFmpeg parts. Besides developing the software itself, which is used by a host of free media players, it has also developed two very important video codecs and a video container.

The video codecs are the lossy “Snow” codec, and the lossless “FFV1” codec, while the video container being actively developed is named as “NUT”. Other than the self-developed codecs, it implements external codecs like H.261, H.263, Windows Media Video codecs like WMV1, WMV2, MV3; Vorbis and many more. FFmpeg supports a lot of formats, including the famous AVI, ASF, FLV, MPEG to name a few; and protocols like HTTP, RTP, TCP, UDP etc.

FFmpeg is path-breaking software that is sure to find more and more use in the future, as more websites start using video streaming and uploading features.

BounceWeb provides FFmpeg hosting. Visit us at http://bounceweb.com/ffmpeg-hosting.html for more details.

FFmpeg – The perfect tool for hosting video sharing sites

June 7th, 2009 | Posted under FFmpeg Hosting, Web Hosting | No Comments »

With the introduction of Web 2.0 standards, websites are now completely different from what it used to be a few years ago. Each day, new ways of being interactive are being discovered and implemented with the help of a host of languages and APIs. Websites are now more collaborative, with users given the power to add content directly in the sites. Naturally, there have been a huge number of sites that offers video sharing and live streaming. Allowing video sharing makes it more engaging and interesting for the user to visit a site, which in turn gets converted into a huge traffic volume for the site.

The web admins of such video-sharing sites are now choosing FFmpeg hosting plans to meet their needs. FFmpeg is a free and open source software library containing tools and plug-ins that can convert video files from one format to the other, upload and stream video files. The use of this software library in the hosting server is termed as FFmpeg hosting. Most FFmpeg hosting providers have the software tools and plug-ins preinstalled in the servers. The servers should be fast and enhanced for video sharing purposes.

Video sharing websites take up a lot of bandwidth and also puts a lot of pressure on the server, so unless it is a new site with very less popularity, it is not wise to have a shared hosting plan. For a site, which is relatively famous, and has a good volume of visitors must go for an upgraded hosting plan. A virtual private server would actually help the cause for a high volume website.

There are few websites scripts that are required for enabling community video sharing. While a few of those scripts would be provided in the hosting plan, they have to be installed in the server to make use of them. This provides web admins with a great option, as the scripts can be installed and configured according to the desires of the admins. The scripts also enable admins to set such community websites with video-sharing capability in very short time. One such website script is PHP Motion, which is provided for free in most FFmpeg hosting plans.

There are lots of FFmpeg hosting providers who provide such services for a varied range of fees. Generally the amount lies between 50 US dollars to 250 US dollars. The additional service offered depends provider to provider, as some might offer automated installation of certain website scripts that enable video sharing.

The market of video sharing has just started moving towards its peak. There is a long way to go and in the future we are sure to see more and more sites coming with FFmpeg hosting.

BounceWeb provides FFmpeg hosting. Visit us at http://bounceweb.com/ffmpeg-hosting.html for more details.

Google Apps Integration With WHM cPanel

February 7th, 2009 | Posted under The Internet, Web Hosting, Web Hosting Tips | 1 Comment »

Google Apps is Google’s toolset for communication and collaboration which include the following tools:

  • Gmail: Google’s famous e-mail.
  • Google Talk: Google’s IM or Instant Messenger
  • Google Calender: Manage your events, schedule, and life.
  • Google Docs: Word processing, spreadsheet, and presentation all done online and free!
  • Google Sites: You can create sites, plus secure group Wikis.

Integrating Google Apps with WHM cPanel will allow you to use all of Google’s tools combined with your web hosting for an extra powerful package, which comes free with Google. They have two versions, the standard edition, and premier edition. We are going to focus on the standard edition, well, because it’s free. Free is nice.

Step 1: Go to their sign up page, and click on the Getting Started button.

Now after you have done so you will see this screen below. Chances are you are the owner of this domain if you’re going to be singing up, so select the first radio box, enter your domain like I’ve done below, and click the “Get Started” button. This will bring you to step 2.

Step 1 Google Apps

Step 1 Google Apps

Step 2: This is very straight forward, just simply fill in the rest of the fields, they are self explanatory. But the most difficult part is the DNS Management Requirements that Google has outlined. Bounceweb has made it easy, simply after you have done this contact our support department, provide your domain, and ask for these two items to be done:

We will handle all of the technical work, and let you know when it’s completed.

Step 2 Google Apps

Step 2 Google Apps

Step 3: Just fill in your username/password and you’re done. Oh and of course agree to their terms of use.

Step 3 Google Apps

Step 3 Google Apps

Last but not least you will get an e-mail from Google with the instructions, so you can just forward those to us in regards on the nameserver modifications, and you will have a shiny new login screen where you can access all of your Google Apps from. Take a look at the one we just created while writing this blog. WHM cPanel integrated with Google Apps.

Google Apps Dashboard

Google Apps Dashboard

Thanks for reading. If you have anything to add please go ahead, I hope your found this useful and fun. Maybe even a little bit exciting?