PokéAPI

<?php
    //Aiden Mercer
    //https://www.youtube.com/user/aiMercer
    //You can run this locally using MAMP/XAMP.
    //You do not need to change anything except where it says: "Make sure to use the same names for columns" and the MYSQL username/password/Database Name/and Table
    //2014

    $pokemonName = null;
    $pokemonType = null;
    $pokemonType2 = null;
    $pokemonAbility = null;
    $pokemonAbility22 = null;
    $pokemonAbility33 = null;
    $pokemonAbility44 = null;
    $pokemonImage = null;
    $pokemonWeight = null;
    $pokemonSpeed = null;
    $pokemonSpD = null;
    $pokemonSpA = null;
    $pokemonHP = null;
    $pokemonEvolutions = null;
    $pokemonAttack = null;
    $pokemonDefense = null;
    $pokemonSpeed = null;
    $pokemonHeight = null;
    $pokemonCounter = 1;

    while ($pokemonCounter <= 718) {
        $pokeGET2 = ('http://pokeapi.co/api/v1/pokemon/'. $pokemonCounter .'/');

        $pokeread = file_get_contents($pokeGET2);
        $pokeConvert = json_decode($pokeread, TRUE);
        $pokemonName = $pokeConvert['name'];
        $pokemonAbility = $pokeConvert['abilities'][0]['name'];
        $pokemonAbility22 = $pokeConvert['abilities'][1]['name'];
        $pokemonAbility33 = $pokeConvert['abilities'][2]['name'];
        $pokemonAbility44 = $pokeConvert['abilities'][3]['name'];
        $pokemonType = $pokeConvert['types'][0]['name'];
        $pokemonType2 = $pokeConvert['types'][1]['name'];

        //Replace empty values.
        if ($pokemonAbility == "") {$pokemonAbility="(None)";}
        if ($pokemonAbility22 == "") {$pokemonAbility22="(None)";}
        if ($pokemonAbility33 == "") {$pokemonAbility33="(None)";}
        if ($pokemonAbility44 == "") {$pokemonAbility44="(None)";}
        if ($pokemonType =="") {$pokemonType = "(None)";}
        if ($pokemonType2 =="") {$pokemonType2 = "(None)";}

        $pokemonHP = $pokeConvert['hp'];
        $pokemonAttack = $pokeConvert['attack'];
        $pokemonSpA = $pokeConvert['sp_atk'];
        $pokemonDefense =  $pokeConvert['defense'];
        $pokemonSpD =  $pokeConvert['sp_def'];
        $pokemonWeight =  $pokeConvert['weight'];
        $pokemonSpeed = $pokeConvert['speed'];
        $pokemonHeight = $pokeConvert['height'];

        //MySQL stuff.
        mysql_connect('localhost', 'mysql_username', 'mysql_password') or die(mysql_error());
        mysql_select_db("your_db_here") or die(mysql_error());

        //Make sure to use the same names for columns
        mysql_query("INSERT INTO your_table_here
           (no, name, type, type2, height, weight, ability1, ability2, ability3, ability4, hp, attack, defense, spattack, spdefense, speed) VALUES ('$pokemonCounter','$pokemonName', '$pokemonType', '$pokemonType2', '$pokemonHeight', '$pokemonWeight', '$pokemonAbility', '$pokemonAbility22', '$pokemonAbility33', '$pokemonAbility44' , '$pokemonHP', '$pokemonAttack', '$pokemonDefense', '$pokemonSpA', '$pokemonSpD', '$pokemonSpeed')")
            or die(mysql_error());

        //Used in while look and requests.
        $pokemonCounter++;

        //Reset variables.
        $pokemonType = null;
        $pokemonAbility = null;
    }

?>