Home PageArchiveContact UsAbout Us
If you are hopelessly addicted to drupal;
if bringing yourself to bed is allways a strugle;
if your main source of entertainement
is watching lullabot videos; then you belog
here.

MySQL

Created on 12/31/1969

Installing MySQL

Play video How to install MySQL on Linux. How to setup an AMP. How to install phpMyAdmin on CentOS. 
The URL to download the MySQL configuration file is as follows:
https://github.com/Lullabot/lullabot-drupal-performance-scalabilty-files/blob/master/04-Prepping-MySQL/my.cnf 
The SQL Query mentioned in the video is as follows... read more...
5
Average: 5 (1 vote)
Linux
Apache
PHP
MySQL

Created on 12/31/1969

Introduction

Play video What is a Development Environment? Why do we need one in order to develop a Drupal website? What are the requirements for you to start developing for Drupal? Why Drupal instead of Wordpress or Joomla? I try to answer all those questions on this introductory video.
Following is a transcription of this video:
This video series was created to help you setup a Development Environment on your local computer so you can safely try the Drupal CMS.
But, before we go any further, we need to discuss the reasons behind the need for a Development Environment... read more...
4
Average: 4 (2 votes)
Drupal
HTML5
CSS3
JavaScript
JQuery
Linux
Apache
PHP
MySQL

Created on 12/31/1969

How to INSERT data into multiple fields and rows in a single query

As I said before, the performance of your website can be greatly impacted by how many times you hit your database each time your PHP web page is been generated.
In this example we will show you how to write a MySQL query to insert several fields into several rows. It will al be done in a single MySQL Query.
The table and fields names that were used on this example are very familiar to Drupal developers... read more...
0
MySQL

Created on 12/31/1969

How to update multiple fields in multiple rows in a single MySQL query.

There is one thing that every web developer should always be mindful of. I am talking about code performance. PHP & MySQL can be a powerful combination. However, if you are not careful, Drupal can make it very easy for you to write bloated and slow code. One of the things that can seriously slowdown your code would be to make dozens of MySQL query requests while generating your PHP web page.With a little ingenuity, though, you can do a lot with just a single MySQL query.The following examples would work on a Drupal 6 database... read more...
0
MySQL