DEV Community: Saymon Tavares

Como exportar grandes conjuntos de dados para CSV no Laravel?

Saymon Tavares — Thu, 29 Jun 2023 13:40:53 +0000

Exportar grandes conjuntos de dados no Laravel pode ser desafiador, pois você precisa estar atento aos limites de memória e tempo de processamento.

Você viu esta mensagem de erro ao exportar grandes conjuntos de dados no Laravel?
Allowed memory size of 134217728 bytes exhausted (tried to allocate 20971520 bytes)

Este foi um problema com o qual lutei por muito tempo usando o pacote Laravel Excel até encontrar spatie/simple-excel, o que torna isso muito fácil.

O exemplo abaixo exportará uma lista de usuários para um CSV de forma rápida e eficiente sem esgotar a memória. Usei esse método com mais de 200 mil registros gerando um arquivo CSV de mais de 30 MB em poucos minutos.

<?php

namespace App\Http\Controllers;

use App\User;
use Illuminate\Http\Request;
use Maatwebsite\Excel\Facades\Excel;
use Spatie\SimpleExcel\SimpleExcelWriter;

class UserExportController extends Controller
{
    public function export()
    {
        $writer = SimpleExcelWriter::streamDownload('users.csv');
        $query = User::orderBy('created_at');

        $i = 0;
        foreach ($query->lazy(1000) as $user) 
        {
            $writer->addRow($user->toArray());

            if ($i % 1000 === 0) {
                flush(); // Flush the buffer every 1000 rows
            }
            $i++;
        }

        return $writer->toBrowser();
    }
}

React Router: Scroll To Top na mudança de rota

Saymon Tavares — Mon, 14 Mar 2022 12:56:53 +0000

Se você estiver usando o React Router Dom para navegação e roteamento em seu aplicativo React, terá que lidar com a restauração de rolagem por conta própria porque a biblioteca não envia mais o gerenciamento de rolagem padrão (costumava fornecer uma solução pronta para uso em o passado).

Por padrão, se você tiver uma página de conteúdo longa e, em seguida, navegar para outra página de conteúdo longa, você permanecerá rolado para baixo. Esse comportamento não faz muito sentido porque muitas pessoas não gostam de ler o texto de cabeça para baixo. O exemplo abaixo mostrará como rolar automaticamente para o topo da página em cada mudança de rota. Usaremos os hooks useEffect e useLocation para fazer o trabalho.

Atualizamos recentemente para funcionar com o React Router +6.x. No entanto, o trecho de código do React Router 5.x também está disponível.

O Componente

1 - Crie um novo projeto React e instale react-router-dom:

$ npm install react-router-dom@6 --save

2 - Crie um componente wrapper que lide com a restauração de rolagem para você:

// ScrollToTop.tsx
import { useEffect } from "react"
import { useLocation, RoutesProps } from "react-router-dom"

export default function ScrollToTop (props: RoutesProps) {
  const location = useLocation()
  useEffect(() => {
    window.scrollTo(0, 0)
  }, [location])

  return <>{props.children}</>
}

3 - Crie um arquivo chamado LandingPage.tsx em sua pasta src e adicione o seguinte:

// LandingPage.tsx
import { Link } from "react-router-dom"

const LandingPage = () => {
  return (
    <div style={{ margin: "auto", width: "80%" }}>
      <h1>Landing Page</h1>
      <div style={{ backgroundColor: "pink", height: 700 }}></div>
      <div style={{ backgroundColor: "orange", height: 700 }}></div>
      <div style={{ backgroundColor: "purple", height: 700 }}></div>
      <Link to="/product">
        <h2>Go To Product Page</h2>
      </Link>
    </div>
  )
}

export default LandingPage

4 - Da mesma forma, crie um arquivo chamado ProductPage.tsx na pasta src e adicione o seguinte código:

// ProductPage.tsx
import { Link } from "react-router-dom"

const ProductPage = () => {
  return (
    <div style={{ margin: "auto", width: "80%" }}>
      <h1>Product Page</h1>
      <div style={{ backgroundColor: "green", height: 700 }}></div>
      <div style={{ backgroundColor: "grey", height: 700 }}></div>
      <div style={{ backgroundColor: "blueviolet", height: 700 }}></div>
      <Link to="/">
        <h2>Go To Home Page</h2>
      </Link>
    </div>
  )
}

export default ProductPage

5 - Por último, mas não menos importante, remova todo o código padrão em App.tsx

Se você estiver usando o React Router v6+, adicione isto:

// App.tsx
import { BrowserRouter as Router, Routes, Route } from "react-router-dom"

import LandingPage from "./LandingPage"
import ProductPage from "./ProductPage"
import ScrollToTop from "./ScrollToTop"

const App = () => {
  return (
    <Router>
      <ScrollToTop>
        <Routes>
          <Route path="/" element={<LandingPage />} />
          <Route path="/product" element={<ProductPage />} />
        </Routes>
      </ScrollToTop>
    </Router>
  )
}

export default App

Observe que o componente ScrollToTop envolve o componente Routes, mas permanece dentro do componente Router.

Se você estiver trabalhando com o React Router 5.x, use isto:

// App.tsx
import {
  BrowserRouter as Router,
  Route,
  Switch,
} from "react-router-dom"

import LandingPage from "./LandingPage"
import ProductPage from "./ProductPage"
import ScrollToTop from "./ScrollToTop"

const App = () => {
  return (
    <Router>
      <ScrollToTop>
        <Switch>
          <Route path="/" exact>
            <LandingPage />
          </Route>

          <Route path="/product">
            <ProductPage />
          </Route>
        </Switch>
      </ScrollToTop>
    </Router>
  )
}

export default App

Observe que o componente ScrollToTop envolve o componente Switch, mas permanece dentro do componente Router.

Conclusão

Criamos um aplicativo simples de página única para demonstrar como rolar programaticamente até o topo da página em cada mudança de rota.

I hope you enjoyed the read!

Feel free to follow me on GitHub, LinkedIn and DEV for more!

How to POST and Receive JSON Data using PHP cURL

Saymon Tavares — Wed, 23 Feb 2022 19:21:09 +0000

JSON is the most popular data format for exchanging data between a browser and a server. The JSON data format is mostly used in web services to interchange data through API. When you working with web services and APIs, sending JSON data via POST request is the most required functionality. PHP cURL makes it easy to POST JSON data to URL. In this tutorial, we will show you how to POST JSON data using PHP cURL and get JSON data in PHP.

Send JSON data via POST with PHP cURL

The following example makes an HTTP POST request and send the JSON data to URL with cURL in PHP.

Specify the URL ($url) where the JSON data to be sent.
Initiate new cURL resource using curl_init().
Setup data in PHP array and encode into a JSON string using json_encode().
Attach JSON data to the POST fields using the CURLOPT_POSTFIELDS option.
Set the Content-Type of request to application/json using the CURLOPT_HTTPHEADER option.
Return response as a string instead of outputting it using the CURLOPT_RETURNTRANSFER option.
Finally, the curl_exec() function is used to execute the POST request.

// API URL
$url = 'http://www.example.com/api';

// Create a new cURL resource
$ch = curl_init($url);

// Setup request to send json via POST
$data = [
    'username' => 'saymon',
    'password' => '123'
];
$payload = json_encode($data);

// Attach encoded JSON string to the POST fields
curl_setopt($ch, CURLOPT_POSTFIELDS, $payload);

// Set the content type to application/json
curl_setopt($ch, CURLOPT_HTTPHEADER, [
    'Content-Type: application/json'
]);

// Return response instead of outputting
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

// Execute the POST request
$result = curl_exec($ch);

if($result === false) {
    exit('Curl error: ' . curl_error($ch));
} else {
    echo $result;
}

// Close cURL resource
curl_close($ch);

Receive JSON POST Data using PHP

The following example shows how you can get or fetch the JSON POST data using PHP.

Use json_decode() function to decoded JSON data in PHP.
The file_get_contents() function is used to received data in a more readable format.

$data = json_decode(file_get_contents('php://input'), true);

I hope you enjoyed the read!

Feel free to follow me on GitHub, LinkedIn and DEV for more!

Laravel MIX: rewrite path when place project in subfolder

Saymon Tavares — Wed, 29 Sep 2021 17:36:35 +0000

Hi guys, i recently needed to configure the Laravel mix in different ways for the local server and production, the problem was that in my production the project is in a subfolder, the project is a monolith with Laravel, Vue and Inertiajs, after a few struggles, I am able to resolve the issue, I have done the following changes:

In .env added

APP_URL=https://domain.com/subfolder
MIX_ASSET_URL=https://domain.com/subfolder

and also added the following code in config/app.php

...

'mix_url' => env('MIX_ASSET_URL', null),

lastly, I have updated my webpack.mix.js and added public url in the output of webpackConfig in file webpack.mix.js

const mix = require('laravel-mix');
const path = require('path');

/*
 |--------------------------------------------------------------------------
 | Mix Asset Management
 |--------------------------------------------------------------------------
 |
 | Mix provides a clean, fluent API for defining some Webpack build steps
 | for your Laravel applications. By default, we are compiling the CSS
 | file for the application as well as bundling up all the JS files.
 |
 */

mix.js('resources/js/app.js', 'public/js')
    .postCss('resources/css/app.css', 'public/css', [
        //
    ])
    .alias({
        ziggy: path.resolve('vendor/tightenco/ziggy/dist/vue'),
    })
    .vue({ version: 3 });

    if (mix.inProduction()) {
        mix.webpackConfig({
            output: {
                chunkFilename: 'js/[name].js?id=[chunkhash]',
                publicPath: '/subfolder/'
            },
            resolve: {
                alias: {
                    '@': path.resolve('resources/js')
                }
            }
        });
    } else {
        mix.webpackConfig({
            output: {
                chunkFilename: 'js/[name].js?id=[chunkhash]',
            }
        });
    }

I hope you enjoyed the read!

Feel free to follow me on GitHub, LinkedIn and DEV for more!

Using dd (dump and die) function in PHP

Saymon Tavares — Wed, 15 Sep 2021 12:48:57 +0000

One of the most common ways to debug an error in PHP ecosystem is to dump the variable on the screen, and figure out what is going wrong with it.

The most common way we do it in PHP is via using var_dump function.

var_dump function dumps all the information about the variable or object on your page, but it does not stop the execution of the program further.

Let’s consider an example where if you have an associate array and you want to dump it on the screen.

<?php

    $prices = [
        '🍔' => 5.99,
        '🍟' => 4,
        '🍻' => 10
    ];
    var_dump($prices);

This is what you get on the screen.

As you can see our code did not die and also the formatting very nice 🤔

Using dd in PHP

If you are a laravel developer you must be aware of dd() function, dd dumps and die. There is no dd function in php if you try to do dd($prices) in the above example it will throw an error Call to undefined function dd().
We can however create our own dd function, that will dump the variable/object and then die the script execution.
We have created a new dd function, and wrapped the var_dump around pre tags so that it gives out a nice formatting in the browser and a more readable dump.

<?php

    function dd($data) {
        echo '<pre>';
        var_dump($data);
        echo '</pre>';
        die;
    }

    $prices = [
        '🍔' => 100,
        '🍟' => 10,
        '🍻' => 4
    ];
    dd($prices);

This is how you see the output, and the php scripts die after dumping. It does not execute the further code.

You can isolate this function in a reusable functions file or a Class.

I hope you enjoyed the read!

Feel free to follow me on GitHub, LinkedIn and DEV for more!

5 tips in PHP 🐘

Saymon Tavares — Tue, 24 Aug 2021 20:17:58 +0000

In this article, I’ll show you 10 tips that can improve your PHP code 🔍 🐘
In order to make this article easier to read, I’ll write some pieces of code that I’ve encountered and introduce a commented solution if needed, as you know there are 4242424242424 ways to do the same thing ✨ and It’s OK to disagree with my solution 😅

👀 For my examples I use PHP 7.4
🏁 🔥

1 - In this use case, just return the expression 👌

if($foo === 42) {
    return true;
}
return false;

// can be
return $foo === 42;

2 - Null coalescing operator for the win 😍

if($foo !== null) {
    return $foo;
}
return $bar;

// can be
return $foo ?? $bar;

💡 It’s very handy to avoid exceptions when you want to access a key that doesn’t exist

3 - Straight to the point 🥅

$this->user = ['firstname' => 'smaine', 'mail' => 'contact@smaine.me'];

return $this->user;

// can be
return $this->user = ['firstname' => 'smaine', 'mail' => 'contact@smaine.me'];

4 - Initialize your helper once 😛

class FooTransformer
{
    private $propertyAccessor;

    public function transform(array $data): Foo
    {
        $accessor = $this->getAccessor();
        // stuff
    }

    private function getAccessor(): PropertyAccess
    {
        return $this->propertyAccessor ??= PropertyAccess::createPropertyAccessor(); // @lito 
    }
}

5 - Unpack an array 🎩

$users = [
    ['smaone', 'php'],
    ['baptounet', 'javascript'],
];

foreach($users as [$username, $language]) {
    // $username contains the 1st key "smaone" for the 1st iteration
    // $language contains the 2nd key "php" for the 1st iteration
}

In the same way, we can also assign variables from an array, it is useful if a function returns an array 🚀

function getFullname(int $id): array
{
    $statement = $pdo->prepare("SELECT id, lastname, firstname FROM user WHERE id = ?");
    $statement->execute([$id]);
    $result = $statement->fetch();

    // suppose $result contains [42, 'luke', 'lucky'];
    return $result;
}

// main.php 
[$id, $lastname, $firstname] = getFullname(42);
// $id contains 42
// $lastname contains luke
// $firstname contains lucky

I hope you enjoyed the read!

Feel free to follow me on GitHub, LinkedIn and DEV for more!

Laravel 9: install and start building an app

Saymon Tavares — Wed, 18 Aug 2021 14:14:29 +0000

With the different features of Laravel, it is the most favorite framework amongst developers and companies using the PHP programming language. This adoption is due to the elegancy and scalability nature of the framework.

With the Laravel 9 release, the Laravel team switches from the traditional 6-month release cycle to a 12-month release cycle using the Semantic Versioning(Semver) approach.
The initial schedule of the Laravel 9 release was supposed to be September 2021, following the traditional approach. Still, the release date changed to January 2022 as stated by the creator and with a few valid reasons, as noted below.
In this article, will also detail how to update or upgrade to Laravel 9 and install and start building an app with the new Laravel 9.

Minimum PHP Requirement

Laravel 9 requires the newest version of PHP 8, PHPUnit 9, and a few other requirements specified in the future.
The PHP 8 requirement is because Laravel 9 is solely dependant on Symfony’s latest v6.0 release, which depends on PHP 8.
You can explore what is new in PHP 8 and the different PHP versions benchmarks to grasp the improvements and features of PHP 8 from Just-In-Time compiler (JIT) to constructor property promotion.

How to install Laravel 9

If you’re like us, we love to explore the newest technologies before being open to the public. You can start playing with the upcoming Laravel v9 for development and testing purposes. You can easily install and run it on your local machine following the guide below.
In addition, Laravel 9 supports PHP version 8. Make sure to check and upgrade your PHP version to use Laravel 9 before next January 2022.
To install Laravel 9, the first method is the Laravel global CLI which creates a new Laravel project from the branch specified. In this case, we will choose to create the new Laravel project from the dev branch.
Run the following command below in your directory to create a new Laravel 9 project. Make sure to have Laravel CLI installed globally.

$ laravel new laravel-9-todo-app --dev

Next, to install Laravel 9 using composer, run the following command to install Laravel v9:

& composer create-project --prefer-dist laravel/laravel laravel-9-todo-app dev-develop

The composer command will create a new Laravel project with project name as laravel-9-todo-app, using the dev-develop will result in the latest Laravel 9.

Now that we have Laravel 9 installed, you can navigate to the new laravel-9-todo-app directory and run the following artisan command to check the version:

& cd laravel-9-dev 
& php artisan --version 
// Laravel Framework 9.x-dev

Conclusion

It also explored how to update or upgrade to Laravel 9 and install and start building an app with the new Laravel 9.

I hope you enjoyed the read!

Feel free to follow me on GitHub, LinkedIn and DEV for more!

How to use the dev.to API!

Saymon Tavares — Wed, 18 Aug 2021 13:52:47 +0000

Why?

I use dev.to as my main dev blogging area now, but I want to show-off my blogs on my portfolio! So we're going to create a simple list of the latest 3 blog articles which link back to the dev.to site. For this tutorial I'll be showing how this can be achieved in PHP.

Let's go!

We're going to be using this endpoint: https://dev.to/api/articles?username=saymontavares which generates a JSON object with the author's latest 30 articles. To get your personal endpoint, change the nataliedeweerd username to your own.

So how do we get this data into our website? In PHP we can use something called cURL. cURL (client URL) is a PHP library which allows you to make HTTP requests. So you can call a URL in your code and get a HTML response from it.

The below code shows a basic curl function which gets us our data:

$curl = curl_init();
$username = "saymontavares";
$url = "https://dev.to/api/articles?username={$username}";

curl_setopt_array($curl, [
    CURLOPT_URL => $url,
    CURLOPT_RETURNTRANSFER => true,
    CURLOPT_TIMEOUT => 30,
    CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
    CURLOPT_CUSTOMREQUEST => "GET",
    CURLOPT_HTTPHEADER => [
        "cache-control: no-cache"
    ]
]);

$res = curl_exec($curl);
$err = curl_error($curl);

curl_close($curl);

$username = "saymontavares";
$url = "https://dev.to/api/articles?username={$username}";
$res = file_get_contents($url);
$res = json_decode($res, true);

@chrisshennan thanks!

We need to decode this data before we can effectively use it however.

$res = json_decode($res, true);

This decodes the json object into a much more usable array! All we need to do now is loop through the array, and print out the results.

foreach ($res as $article) {
    echo    "<a href='{$article['url']}' class='article'>
                <h2>{$article['title']}</h2>
                <div class='description'>{$article['description']}</div>
                <div class='readmore'>Read More</div>
            </a>";
}

And that's it! We just need to apply a bit of CSS and our dev.to articles are printing out wherever we want!

I hope you enjoyed the read!

Feel free to follow me on GitHub, LinkedIn and DEV for more!