Drupal CMS boasts of over 5800 contributed modules and variety of themes. Drupal cms been widely adopted by over 7.2 million sites including social networking sites, news, blogs, forums, media, entertainment, charities, politicians, corporate and many more. Drupal won the hall of fame award in 2009, several packt open source CMS Awards and won the Webware 100 awards thrice. Drupal has a large community following with over 830,000 users and 2000 developers.
Drupal has done everything right but lagged behind in a few key areas. The upcoming release of version 7 promises to correct these shortcomings and add even more power to this amazing system. The final release of Drupal 7 is expected in the early 2011.
Usability
The usability features enhanced with more menus and panels. Previously obscure settings are now easier to find and interfaces are better organized. These UX improvements will certainly helps more users to conveniently use the CMS.
User Interface: Drupal 7 is inducted with a new user-friendly interface that makes it easier for users to navigate and work on their drupal site.
Shortcut Bar:Shortcut Bar allows the user to add their own shortcut to handle and manage their site. It also allows saving variations of the shortcut bar, so as to utilize different shortcuts bars based on user activity.
Editing Page: Drupal 7 is now equipped with administrative links to edit existing page elements on each web page, without visiting an administration page first to edit. This feature provides a nice simple interface and seamless capability with editing the content on pages.
WYSIWYG editors: Drupal 7 provide improved support for integration of WYSIWYG editors.
Metadata: Drupal 7 accords permissions with more meta data capabilities.
Drupal Themes
Drupal 7 has included three new themes, Bartik, Seven and Stark. Users can now install contributed themes directly from the Appearance admin screen.
A. Database layer: The new release also features a new database layer providing wider support for other DB platforms and it improves scalability and integrity. For developers, they have added a query builders for INSERT, UPDATE, DELETE, MERGE, and SELECT queries. Advanced queries are automatically compiled to work with the appropriate database server, which also increases the portability of drupal.
B. SQLite database support: SQLite allows hosting of smaller drupal installations without providing them database access.
C. jQuery UI: jQuery UI 1.8 added as it allows improvements to drupal’s UI.
D. Node access control system: Node access control system has been improved and is now much better than that of Drupal 5 and Drupal6
E. Popular modules integrated now with the core: There are plenty of useful modules which almost every site has to download, install, enable and configure. Drupal 7 will now include some of those popular modules directly in to its core framework as they are widely used. Drupal 7 will integrate them into its core framework.
Author:
Drupal 7 has proved with its many new features and functionality that it is one of the best and flexible CMS that has taken its usability to a whole new level in drupal development. Our drupal developer is keenly awaited for making a greater and more powerful CMS to power your sites.
This IDC Insight reviews key database technology announcements and presentations offered at Oracle OpenWorld 2010. It examines what they are, what they mean, and how to interpret their implications in terms of Oracle’s strategy and direction as well as their implications for the database management systems (DBMSs) markets going forward.
After going through this article you will be familiar on how to install WAMP Server, WordPress on to your local system and also on how you can customize WordPress CMS themes locally before launching the same to the Web World. Are you planning to launch your own web blog using WordPress CMS? Launch the same in your local system first and test it thoroughly before it get launched (To check how your Posts / Widgets are working).
It’s a best practice to test respective theme locally before it get launched, this will help you a lot in overcoming any issues with the theme which you are using. This Article will also help beginners in learning and understanding on how can we customize or develop WordPress CMS related themes locally. As of now, in this article I will illustrate on installing WAMP Server, Installing WordPress, Customization of your WordPress Theme.
Index:
Step 1: Install Wamp Server
Step 2: Installing WordPress:
Download WordPress
Setting up WordPress in WAMP Server
Run WAMP Server
Configure WordPress
Configure Database
Other option to Configure Database
WAMP Server home page
Step 3: Customization of your WordPress Theme
Requirements:
For this to achieve we need:
WAMP Server
WordPress Software
Any free WordPress Theme
Prerequisite knowledge:
Technical knowledge is required to install respective softwares locally on to your system and should have a basic knowledge on customizing WordPress Theme / any other CMS themes.
Step 1: Install Wamp Server
If you do not have PHP and MySQL on your local system or a server, I would like to recommend downloading a stand-alone web server for installation of Apache, MySQL, and PHP. WAMP Server is for your Windows environment. Most of the developers prefer WAMP Server for their Web Applications to built, if you want to download directly then please do follow this link – WAMP Server download
Click on the link here – WAMP Server, which will take you to the WAMP Server home page from there you can download the software available. As of now, the latest release is WampServer 2.0g-1. This includes Apache 2.2.11, MySQL 5.1.Ȁ and PHP 5.2.9-1.
After downloading the .exe file on to your desktop, please do follow instructions for completing installation process, this will setup Apache, MySQL, and PHP on to your system. And by default it will create the folder structure as shown in the screen shot below.
WAMP Server Setup
Note: If you have WAMP5 installed on your machine, then please do take a backup of your data, uninstall it and delete the WAMP5 directory before installing WampServer 2.
WAMP Server Setup Wizard
WAMP Server Installation Screen
Step 2: Installing WordPress:
After completion of Step 1, now install WordPress in WAMP Server for running WordPress locally. And make sure to follow below steps carefully, since this invloves setting up of MySQL DataBase etc.,
Download WordPress: If you are new to WordPress and would you like to know more about WordPress then please do visit this link – WordPress, and if you want to download the latest version please do click here – WordPress for Download, As of now WordPress 2.7.1 is the latest version and it is of 1.8MB capacity.
Setting Up WordPress in WAMP Server: After downloading WordPress on to your local drive, unzip the package and please do place the respective folder in www folder of WAMP Server.
Run WAMP Server: If you are running any local servers like IIS, please do stop the service by going to your system’s control panel (Windows Start Button -> Control Panel -> Administrative Tools -> Internet Information Services (IIS) Manager (This is in Windows Vista) and then after opening IIS, please do stop the service if it is running by-default, Since in the same port no two services cannot be runned simultaneously.
Now, run WAMP Server which is installed. You will see an icon on your system tray (that is, towards right bottom you will be provided with an icon, which is similar to a meter). Now click on that icon, it will provide a menu, in that click ‘www directory€˜ which will open up your ‘www‘ folder (or) you can manually open the same from the place where you have installed WAMP Server (For Example: C:\wamp\www). You will see only one file as of now that is index.php, now! place your unziped folder of WordPress here.
Configure WordPress: Now after placing unzipped wordpress folder in ‘www‘ folder, open your lovely browser which you like, I like Mozilla the most – in the address bar type ‘http://localhost‘ you will the home page of WAMP Server, exactly simliar which I have shown in the below screenshot, if you are not seeing the same then there might be a problem with your installation or any other server might be running with the same port, make sure you stop that service first before you run WAMP Server.
Configure Database: Before you start off with everything, initially just create a Database for your WordPress. This can be achieved by clicking on the WAMP Server icon, click on “phpMyAdmin” from the menu provided and create a Database.
Other option to Configure Database: We do have other option to create a Database for this you have to goto WAMP Server icon, single click on that, in the options provided please do select MySql -> MySQL console, it will open up MySQL console and there in press ‘enter’ since as this local there will be no password (if you want to then you can give the same through MySQL commands, if you want to do this Visit MySQL Website on how we can create password for the same). MySQL prompt will be shown up “mysql>” there you can type a command like ‘create database database_name’ (like for example: create database developersnippets).
WAMP Server home page: In the home page (http://localhost), click on wordpress which is under “Your Projects” section. When you click on ‘wordpress’ it will take you to the Error page as we have not configured wp-config.php, need not to be panic here – just click on the “Create a Configuration File” button provided.
WampServer Homepage
Configuration File
Now, it will take you to the wp-admin/setup-config.php page, here respective information is provided to configure the database. Click on âLet’s go!” button, it will take you to the database connection details page (respective screen shot is shown below).
Database Connection Details
In the very first text box provide your valid Database Name, in the second text box provide valid User Name (for now I am giving “root“), most important *in the third text box provided please enter your strong password and this password will be your MySQL password as well . So, be sure you remember this but not to share the same to others (as this is local you can leave the textbox as blank). Leave the fourth text box as it was, that is for Database Host it should be localhost only. Then for the last text box, that is for Table Prefix you can choose valid option here, if possible you can leave this as well. This is required if you are running multiple WordPress Installations. If everything goes well you will be taken to the install page which is shown below in the screen shot.
Run the install
Once you click on “Run the Install” button, it will take you to the Welcome page were in you have to enter your Blog Title, Email Id. Enter valid Blog Title and Email Id, as your are running the wordpress locally you can uncheck the below option that is ‘Allow my blog to appear in search engines like Google and Technorati.’, then click “Install WordPress” button. If your installation is successfull, it will take you to the Success! page. Were in you will be provided with UserName and Password. Then click ‘Log In‘ button provided.
Note: Make sure to note the password, as this is a Randownly generated password. Once, after logging in you can change your password accordingly.
Once everything is success! it will take you to the wp-login page, here you need to type in your Username and Password which was generated in the earlier. After your log-in is successful, it will take you to the admin panel that is Dashboard. Which you can see in the below screen shots.
UserName & Password
WordPress Dashboard
If you want to change your password after entering into Dashboard, then click on ‘admin‘ which is at Top most right corner.
Change Password
Step 3: Customization of your WordPress Theme:
Yeah, after completion of everything. Now! Just Relax, have a deep breath because everything is successful and now you can test/built your own WordPress themes locally and even you can customize your theme accordingly as per your requirement and proceed further.
I would like to say that, this would be a better option if you want to change the color scheme / to customize any section in your present WordPress theme which is LIVE, just download your theme which is online to your local and make sure to remove ads (that is Google Ads if any), since while you are customizing the theme you will be refreshing the page to check for the updates which you have done.
This process will help you trying any new free WordPress themes which are available in the Web World, you can download the same to your
MySQL is the “M” behind the ever popular LAMP web development stack. In many ways, MySQL was a pioneer in creating a business from an open source product. The MySQL company owned the copyrights to the code and provided MySQL under a dual licensing model. When Sun Microsystems purchased MySQL, it seemed like a great match. Sun understood open source with a number of projects of their own. However, the recent purchase of Sun by Oracle has set open source advocates on edge. Will this deal mark an impending doom for the legendary open source database system?
There has already been a lot written speculating on Oracle’s intentions for MySQL. The general consensus has been that Oracle has no intention of killing MySQL. The belief is that because MySQL is used so widely for developing web applications, Oracle sees it as an entry level product that they can use to eventually sell up customers to Oracle’s enterprise products. MySQL is a very capable database but its replication and scalability features lag far behind those of Oracle’s enterprise products. Oracle believes that it can use this to its benefit by offering its commercial products as a solution to growing scalability headaches with MySQL.
While this view that Oracle’s business benefits from MySQL makes sense, there are some deeper issues that affect MySQL’s future. Oracle must achieve a number of goals to keep MySQL moving forward and to utilize it as an entry-level product. Oracle must retain the talent needed to keep MySQL in the lead and it must engage the open-source community. Finally, it must convince the open source purists that it understands and supports the open source model. Let’s look at each of these in detail to see how Oracle is stacking up.
]]>
The first goal Oracle needs to meet is retaining the necessary talent to keep MySQL as the leading database for web development. Unfortunately, it seems that Oracle has already failed that challenge. Citing dissatisfaction over the priorities set for MySQL and a desire to refactor much of MySQL’s code, the key developers including MySQL’s co-founder Monty Widenius have left to pursue their own project. That project is a fork of MySQL.
The second goal is to engage the open-source community. After all, MySQL has benefited from the contributions of the open source community over the years. To really keep MySQL alive Oracle has to show that they are serious about taking input from the community and not abusing the free code that they receive. Again, Oracle has so far failed at this. They have announced their intentions for the OpenSolaris project and it is apparent that they do not intend to engage that community. In fact, there is now an open source fork of that project called Illumos.
The third goal is where Oracle has failed most spectacularly though. That goal is convincing the open source purists that they understand open source and are serious about being part of the community. Oracle’s recent lawsuit against Google over patents for Java has probably done more damage to Oracle’s image in the open source community since SCO filed its poorly thought out suit against IBM. This lawsuit has rocked the open source community and has many calling to fork all Oracle open source products and move as quickly as possible away from any Oracle product. The suit makes clear that Oracle does not understand open source and is willing to use patents aggressively.
At the beginning of this article, we asked the question whether Oracle will kill MySQL. Many business writers have made the case that Oracle would never do that because MySQL is a valuable business asset which they can use to upsell customers to their enterprise products. However, these business thinkers were considering a different question. They were answering the question “will Oracle intentionally kill off MySQL?”. What they did not arrive at is that Oracle could unintentionally kill MySQL. MySQL could be unintentionally killed by antagonizing the open-source community and using patents in a way that created fear, uncertainty, and doubt about using MySQL. Oracle’s lawsuit against Google has done this. What do you think?
Michael Dorf is a professional software architect and instructor with a M.S. in Software Engineering and 12 years of industry experience. He teaches for LearnComputer! (learncomputer.com), which offers public and onsite instructor-led PHP and MySQL training courses. Whether you prefer to sign up for our PHP/MySQL course or just read an article on best PHP books, you will find many useful resources on our website.
Aprende A Programar En PHP Ya
8 Videos Tutoriales En 4 Modulos, Donde Se Describe Paso A Paso Como Iniciar A Programar En Php Y Como Interactuar Con Las Bases De Datos. Especialmente Estructurado Para Iniciadores En Este Lenguaje. Aprende A Programar En PHP Ya
