new interview process

This is the a way now companyies are selecting candidates. bellow is an example how play up one of leading company takes interview and select candidates. they names this as a code war

Technical Interview


After you register for Code Wars, you may have to go through a technical and personal interview. Our Human Resources team may contact you for a telephonic or an on-site interview.



Technology Stack you can use

You can use PHP, Java or Rails platform. You can use MySQL database or any other RDBMS or a NoSQL database system for backend.



2 Days

All Code Warriors are expected to bring their own laptops, and we shall provide them with Internet connectivity, snacks and refreshment.



As a Code Warrior, you will be asked to work in a team of two to four, which will be led by a Product Manager, chosen from within the team. Your team has exactly 24 hours to come up with the product idea, write the code in the development environment of your choice and submit the same for review by our selection panel. The Code Wars is a two-day event slated to kick off . Then You are allowed to work remotely after 8 PM on next day.



You can plan your product idea before the competition starts. However, please note that no creation of production assets can commence until the Code War begins. This entails production design assets, development code and test cases. You are only allowed to plan but not create.



Once the Code Wars event ends, you won't be allowed to integrate any additional feature or fix any bug(s). You will then be asked to demo your solution. You will be judged on whatever stage of product your troop is able to complete in the stipulated time frame.



Teams of Two to Four

You will be asked to participate in Code Wars in a team. The team size would vary from two to four individuals. You can either register as a team or an individual. If you register as a team, your team will need to Ideate, Code & Deploy, and manage the product/task delivery (end to end). In case of individual registration, coders will be grouped based on tasks on-site on the day of event.

In order to be eligible for the event, you will need to complete your registration by the registration end date. As the venue is subject to limited space availability, you're encouraged to register for the event before the registration deadline ends.



Source Control

You will be provided with a GitHub account to check-in your code. You are strongly encouraged to regularly check-in working code during the event as that is one of the ways the organizers will be monitoring the progress of your development project. When the event ends, you must tag your codebase with a tag "codewars" and deploy the tagged codebase.



Deployment

You must plan on deploying your final codebase to a hosting environment for us to judge your project. One of the judgment parameters will be the quality of your deployed product. You will want to make sure that there are no crashes.

For PHP projects, you will be provided with a PHPFog account for deploying your PHP codebase. For Rails projects, you will be provided with a Heroku account for deploying your Rails codebase.



User Privacy

As your product would be reviewed on the parameters of product idea, development followed by interviews in multiple stages, we're introducing a non-optional privacy policy to safeguard the interest of your product and code information.



Since your application will be subject to testing, we want to make sure that personal information that testers enter on your project is protected. You are required to not reveal any user information to any third party, except when required by law.



Code will be Judged & Rewarded

A selection panel will select the top three teams based on product quality, design and code quality and interviews. Selection panel will decide the top 3 teams by Aug 4th. We will notify the top three team members by Aug 5th.

The top three winning troops will receive full-time employment offers to join PlayUp.Each member of the winning troops will also get rewarded with some exciting prizes such as laptops, iPads, iPhones, etc.

Function to get next Database ID

the bellow function will give you the next auto increament id of your database primary key.

function getNextID($field_id){
$db =& JFactory::getDBO();
$sql = "SELECT max(id) FROM jos_table WHERE field_name=$name";
$db->setQuery($sql);
$acl_num = $db->loadResult();
if($acl_num<>null){
return ($acl_num + 1);
}else{
return 0;
}
}

in reference to:

"Some time we need to see some string type data of different rows in comma separated or other separated in a single field. for this type of implementation mysql have a function GROUP_CONCAT(field_value) . we can add GROUP BY cluse to get comma separated values in different cases."
- Techinical tips for practical uses (view on Google Sidewiki)

Getting row values in comma separated using GROUP by or other queries in MySQL

Hi,

Some time we need to see some string type data of different rows in comma separated or other separated in a single field. for this type of implementation mysql have a function GROUP_CONCAT(field_value) . we can add GROUP BY cluse to get comma separated values in different cases.

Example:

GROUP_CONCAT([DISTINCT] expr [,expr ...]
[ORDER BY {unsigned_integer | col_name | expr}
[ASC | DESC] [,col_name ...]]
[SEPARATOR str_val])

mysql> SELECT student_name,
-> GROUP_CONCAT(test_score)
-> FROM student
-> GROUP BY student_name;
in reference to: Aniruddh (view on Google Sidewiki)

Searching non alpha numeric character through REGEX through PHP

Hi,
you can search non-alpha numeric characters by simple adding a negation regex charactor in the regex string (^).

below is the Example

preg_replace('/[^A-Za-z0-9_]/', '', 'D"usseldorfer H"auptstrasse');

Thanks

in reference to: Aniruddh (view on Google Sidewiki)