Hacker Rank Problem Solved Practice Solution 1 - 4

1. Solve Me First

<?php

function solveMeFirst($a,$b){
  // Hint: Type return $a + $b; below 
 
}

$handle = fopen ("php://stdin","r");
$_a = fgets($handle);
$_b = fgets($handle);
$sum = (int)$_a+(int)$_b;
print ($sum);
fclose($handle);
?>




2. Simple Array Sum (PHP)

<?php

/*
 * Complete the simpleArraySum function below.
 */
function simpleArraySum($ar) {
    /*
     * Write your code here.
     */
         $len=count($ar);
        $sum=0;
        for($i=0;$i<$len;$i++){
            $sum+=$ar[$i]; // sum=sum+ar[i];
        }
        return $sum;

}

$fptr = fopen(getenv("OUTPUT_PATH"), "w");

$stdin = fopen("php://stdin", "r");

fscanf($stdin, "%d\n", $ar_count);

fscanf($stdin, "%[^\n]", $ar_temp);

$ar = array_map('intval', preg_split('/ /', $ar_temp, -1, PREG_SPLIT_NO_EMPTY));

$result = simpleArraySum($ar);

fwrite($fptr, $result . "\n");

fclose($stdin);
fclose($fptr);

3. Compare the Triplets (java 7)


import java.io.*;
import java.math.*;
import java.security.*;
import java.text.*;
import java.util.*;
import java.util.concurrent.*;
import java.util.regex.*;

public class Solution {

    // Complete the compareTriplets function below.
    static List<Integer> compareTriplets(List<Integer> a, List<Integer> b) {

    int aliceTotalScore = 0, bobTotalScore = 0;
    for(int i=0; i<3; i++){
        int aliceScore = a.get(i);
        int bobScore = b.get(i);
        if(aliceScore != bobScore){
        int temp = aliceScore > bobScore ? aliceTotalScore++ : bobTotalScore++;
        }
    }
    List<Integer> result = new ArrayList<>();
    result.add(aliceTotalScore);
    result.add(bobTotalScore);
    return result;

    }

    public static void main(String[] args) throws IOException {
        BufferedReader bufferedReader = new BufferedReader(new InputStreamReader(System.in));
        BufferedWriter bufferedWriter = new BufferedWriter(new FileWriter(System.getenv("OUTPUT_PATH")));

        String[] aItems = bufferedReader.readLine().replaceAll("\\s+$", "").split(" ");

        List<Integer> a = new ArrayList<>();

        for (int i = 0; i < 3; i++) {
            int aItem = Integer.parseInt(aItems[i]);
            a.add(aItem);
        }

        String[] bItems = bufferedReader.readLine().replaceAll("\\s+$", "").split(" ");

        List<Integer> b = new ArrayList<>();

        for (int i = 0; i < 3; i++) {
            int bItem = Integer.parseInt(bItems[i]);
            b.add(bItem);
        }

        List<Integer> result = compareTriplets(a, b);

        for (int i = 0; i < result.size(); i++) {
            bufferedWriter.write(String.valueOf(result.get(i)));

            if (i != result.size() - 1) {
                bufferedWriter.write(" ");
            }
        }

        bufferedWriter.newLine();

        bufferedReader.close();
        bufferedWriter.close();
    }
}




4. A Very Big Sum (PHP)

<?php

// Complete the aVeryBigSum function below.
function aVeryBigSum($ar) {

        $len=count($ar);
        $sum=0;
        for($i=0;$i<$len;$i++){
            $sum+=$ar[$i]; // sum=sum+ar[i];
        }
        return $sum;
}

$fptr = fopen(getenv("OUTPUT_PATH"), "w");

$stdin = fopen("php://stdin", "r");

fscanf($stdin, "%d\n", $ar_count);

fscanf($stdin, "%[^\n]", $ar_temp);

$ar = array_map('intval', preg_split('/ /', $ar_temp, -1, PREG_SPLIT_NO_EMPTY));

$result = aVeryBigSum($ar);

fwrite($fptr, $result . "\n");

fclose($stdin);
fclose($fptr);

Hacker Rank SQL Practice Solution 1-15

1. Revising the Select Query I

select * from CITY where population>100000 AND countrycode='USA';

2. Revising the Select Query II
SELECT NAME FROM CITY WHERE POPULATION>120000 AND COUNTRYCODE='USA'

3. Select By ID
SELECT * FROM CITY WHERE ID = 1661;

4. Japanese Cities' Attributes
SELECT * FROM CITY WHERE COUNTRYCODE LIKE '%JPN%';

5. Japanese Cities' Names

SELECT NAME FROM CITY WHERE COUNTRYCODE LIKE '%JPN%';

6. Weather Observation Station 1
SELECT CITY, STATE FROM STATION ORDER BY CITY DESC;

7. Weather Observation Station 2
SELECT ROUND(SUM(LAT_N),2), ROUND(SUM(LONG_W),2) FROM station

8. Weather Observation Station 3
SELECT DISTINCT CITY FROM STATION WHERE MOD(ID, 2) = 0;

9. Weather Observation Station 4
SELECT COUNT(CITY) - COUNT(DISTINCT CITY) FROM STATION;


10. Weather Observation Station 5
(
    SELECT CITY, LENGTH(CITY) FROM STATION
    ORDER BY LENGTH(CITY) ASC, CITY
    LIMIT 1
) UNION (
SELECT CITY, LENGTH(CITY) FROM STATION
    ORDER BY LENGTH(CITY) DESC, CITY
    LIMIT 1

)



11. Weather Observation Station 6
/*
Enter your query here.
*/

SELECT DISTINCT
CITY
FROM STATION
WHERE lower(substr(CITY,1,1)) in ('a','e','i','o','u') GROUP BY CITY

12. Weather Observation Station 7 MYSQL
/*
Enter your query here.
*/
SELECT DISTINCT
CITY
FROM STATION
WHERE RIGHT(CITY, 1) IN ('a', 'e', 'i', 'o', 'u');


13. Weather Observation Station 8 MYSQL
/*
Enter your query here.
*/
SELECT DISTINCT
CITY
FROM STATION
WHERE RIGHT(CITY, 1) IN ('a', 'e', 'i', 'o', 'u') and LEFT(CITY, 1) IN ('a', 'e', 'i', 'o', 'u');


14. Weather Observation Station 9 MYSQL
/*
Enter your query here.
*/
SELECT DISTINCT
CITY
FROM STATION
WHERE lower(substr(CITY,1,1)) in ('b', 'c', 'd', 'f', 'g', 'h', 'j', 'k', 'l', 'm', 'n', 'p', 'q', 'r', 's', 't', 'v', 'w', 'x', 'y','z') GROUP BY CITY

15. Weather Observation Station 9 MYSQL
/*
Enter your query here.
*/
SELECT DISTINCT
CITY
FROM STATION
WHERE RIGHT(CITY, 1) IN ('b', 'c', 'd', 'f', 'g', 'h', 'j', 'k', 'l', 'm', 'n', 'p', 'q', 'r', 's', 't', 'v', 'w', 'x', 'y','z');

Membuat Aplikasi CRUD Dengan Javascript dan HTML

Assalamualaikum warrohmatullahi wabarakatu .
Hallo sobat IT kali ini saya share script JavaScript lagi nih :3
kali ini tentang
 "CRUD Dengan Javascript dan HTML"
yap ! yaitu program Create Read Update Delete hanya dengan javascript dan html ,,
loh lalu databasenya dimana ??
Untuk database sendiri menggunakan Cookie pada webbrowser atau pada PC  , masih kurang efisien memang . Tapi lumayan buat nambah2 ilmu gan hehe :3
kurang lebih penampakannya seperti ini gan :

Langsung saja deh sedot nih gan :

Download : http://ouo.io/mCY2zI