MySQL

Hi, I am Sumaiya Javed PHP Web developer and this is my personal blog or collection of tutorials, scripts, tips and tricks used or created personally by me in my five years of web development. And yeh ... click here to view my online portfolio, for any freelancing projects.

In views I wanted to expose a computed field but instead of textbox I wanted it to be a select drop down box with values coming from the database.

To achieve this I created a module and used the hook form_alter:

function mymodule_form_alter(&$form, $form_state, $form_id) {
switch($form_id) {

 case 'views_exposed_form':

 if ($form['#id'] == 'views-exposed-form-search-jobseeker-page-1') {     
 $form['field_country_value']['#type'] = "select";
 $form['field_country_value']['#size'] = null;
 $form['field_country_value']['#multiple'] = true;
 $captain[''] = t('Any');
 $query = db_query("SELECT DISTINCT(field_country_value)FROM content_type_profile order by field_country_value asc");

 // Run through the results
 while($result = db_fetch_array($query)) {
 $construct = $result[field_country_value];
 $captain[$construct] = t($construct);
 }
 $form['field_country_value']['#options'] = $captain;
 }
 break;

}
}

Source: http://drupal.org/node/908544 

I was addresses module but using the values of country and city in views or search or any custom module is a headache because the module saves the country / city / providence values in initials.

To overcome this issue I created to cck computed fields save the country and city values in it respectively.

To get the value of the country and city use the below variables:

$country = $node->field_jobseeker_address[0]['country'];

$city = $node->field_jobseeker_address[0]['providence'];

where ‘field_jobseeker’ is my cck field type ‘address’.

Check a working example here http://drupal.org/node/818928#comment-3171054

I am developing a fancy website with an attractive design. I have used jquery easing effect to create page navigation sliding effect. Due to the high res background images the easing effect is not smooth but hindering like as if someone is pushing the slides.

To overcome this problem I had used jquery preload script. Click here to view the source.

(function($) {
var cache = [];
// Arguments are image paths relative to the current page.
$.preLoadImages = function() {
var args_len = arguments.length;
for (var i = args_len; i–;) {
var cacheImage = document.createElement(’img’);
cacheImage.src = arguments[i];
cache.push(cacheImage);
}
}
})(jQuery)

jQuery.preLoadImages(”image1.gif”, “/path/to/image2.png”);

check out http://tympanus.net/codrops/2011/12/12/experiments-with-background-clip-text/ awesome page navigation effect explained in simple terms, easy to download and implement

awesome tutorial on how to theme drupal6 forms with tables

http://www.akchauhan.com/create-drupal-form-using-theme_table-like-module-list-form/

and to learn about forms API in general visit

http://drupal.org/node/262422

I have basically created a module along with ‘job search’ module to build a recruitment web portal .. will hopefully write in detail and with my module code later.

PHP Side

http://blogs.msdn.com/b/freddyk/archive/2010/01/19/connecting-to-nav-web-services-from-php.aspx

NAV Dynamics Side

http://msdn.microsoft.com/en-us/library/dd355316.aspx

There are two related content types and I wanted to find the total of one content type entries  applied against another.

Example.

I have two content types job and resumes. I need to display the total no of applications against ‘job’ as a field in my view.

According to me the best way to achieve this is through the module View Custom Field. Upload and enable the module.

Now go to your view add a field and select Customfield: PHP code.

Write the appropriate code to extract the total no of rows directly from the database. In my case it is the following:

<?php
$nid = $data->nid;
$test = db_result(db_query("SELECT count(uid) FROM job WHERE nid='$nid'"));
print $test;  
?>

Note: This is for drupal 6

To theme drupal forms using cck fields do the following:

Insert theme hook function in the template.php file: (dmcdubai is my theme name, replace it with yours)

function dmcdubai_theme($existing, $type, $theme, $path) {
 return array(
 'profile_node_form' => array(
 'arguments' => array('form' => NULL),
 'template' => 'node-profile-edit'
 ),
 'user_register' => array(
 'arguments' => array('form' => NULL),
 'template' => 'node-profile-edit'
 )
 );
}

Create node-profile-edit.tpl.php file in your theme folder. Enter relevant fields in the order you need on the form

Eg

<?php
//NOTE: if you don't have Field Group then simply type:
// print drupal_render($form['field_accreg_company_name']['0']['value']);
print drupal_render($form['group_company']['field_company']['0']['value']);
print drupal_render($form['group_company']['field_street']['0']['value']);
?>

visit http://drupal.org/node/601646 for more details on how to display or order the fields of a form.

Go back to the code we had inserted in the template.php file. The profile_node_form and user_register are the ids of the form where the theming done in node-profile-edit.php will be applicable. So if you add user_register in the theming will also be applicable in the “Create New Account” scenario.

To find out the id of your form, view source and find name=”form_id” and use the value of that field.

check out http://drupal.org/node/601646 the best summarized description of how to theme drupal forms.

and also go through this slide presentation describing the overall drupal forms architecture and workflow.

Now I had created a Content type to add fields at the user registration form. And when I was trying to theme the form using the above solution I was not able to do so, the solution to that is the following:

In the template.php file user the form_id as user_register like this:

function dmcdubai_theme($existing, $type, $theme, $path) {
 return array(
 'profile_node_form' => array(
 'arguments' => array('form' => NULL),
 'template' => 'node-profile-edit'
 ),
 'user_register' => array(
 'arguments' => array('form' => NULL),
 'template' => 'node-profile-edit'
 )
 );
}

To know more on the subject visit http://www.phpjavascript.com/drupal-theme-form-cck-user-register/

Learn how to add, delete and edits fields to any form in Drupal. Like the user registration form, contact form or any other customized form.

This tutorial explains the basics of the form_alter(), explaining the concept in clean and clear format.

Click here to view the tutorial.