<?php
$server = 'localhost';
$username = 'root';
$password = '';
$db = 'als20';

echo 'Connecting to database...' . PHP_EOL;

$conn = new mysqli( $server, $username, $password, $db );

if( $conn->connect_error ) {
    echo 'Connection faled! - ' . $conn->connect_error . PHP_EOL;
    exit;
} else {
    echo 'Connected!' . PHP_EOL;

    echo 'Presiona cualquier tecla para continuar' . PHP_EOL;
    fgets( STDIN );
    $row = 1;
    $count = 1;
    $subcount = 1;

    if (($handle = fopen("cie10.csv", "r")) !== FALSE) {
        while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {

            $row++;

            if ( $row >= 5 ) {

                if( $data[0] != '' ) {

                    if ( strlen( $data[0] ) > 3 ) {
                        $clave = substr( $clave, 0, 3 ) . "+";
                    } else {
                        $clave = $data[0];
                    }

                    $clave = $conn->real_escape_string( $clave );
                    $data[1] = $conn->real_escape_string( $data[1] );

                    $sql = "INSERT INTO `cie10_dx`(clave, dx) VALUES( '$clave', '$data[1]' )";

                    if( $conn->query( $sql ) === true ) {
                        echo "Se grabo correctamente $count. DX => $clave - $data[1]" . PHP_EOL;
                    } else {
                        echo "Error: " . $sql . " -> " . $conn->error . PHP_EOL;
                        fgets( STDIN );
                        exit;
                    }

                    $count++;
                }

                if( strlen( $data[2] ) > 4 ) {
                    $clave = substr( $data[2], 0, 4 ) . "+";
                } else {
                    $clave = $data[2];
                }

                $clave = $conn->real_escape_string( $clave );
                $data[3] = $conn->real_escape_string( $data[3] );

                $sql_sub = "INSERT INTO `cie10_sub_dx`(clave, sub_dx) VALUES( '$clave', '$data[3]' )";

                if( $conn->query( $sql_sub ) === true ) {
                    echo "Se grabo correctamente $subcount. SUB-DX => $clave - $data[3]" . PHP_EOL;
                } else {
                    echo "Error: " . $sql . " -> " . $conn->error . PHP_EOL;
                    fgets( STDIN );
                    exit;
                }

                $subcount++;
            }
        }
    }
}
?>