I'm doing a registration system using Laravel 5, I created the client schema, with some tables, such as person, address, email, phone. happens I have another bank, called zip, where it has some tables like street, us, neighborhood, city. I am very new to this framework, all I could do was imitate other ready-made models. Registration is working, both the search in the bank and the inclusion. My question, how do I type the zip in an html and through that cep the input in the form fill the fields of street, city, neighborhood, state? Thank you.
Obs. I did this select in mysql, it worked, now I do not know how to implement it in laravel
USE cep; SELECT e.endereco_logradouro, b.bairro_descricao, c.cidade_descricao, u.uf_sigla, u.uf_descricao FROM endereco e, bairro b, cidade c, uf u WHERE e.bairro_codigo = b.bairro_codigo AND b.cidade_codigo = c.cidade_codigo AND c.uf_codigo = u.uf_codigo AND e.endereco_cep = 'variável'