DEV Community: Khandokar Nafis Jaman

latest() vs oldest() vs orderBy() in Laravel

Khandokar Nafis Jaman — Sat, 19 Aug 2023 15:24:01 +0000

To fetch sort data, we use latest, oldest and orderBy methods in laravel. The difference of these methods is: latest and oldest methods sort data according to the created_at column whereas orderBy methods sort data by the lexically.

Suppose, you have a table called post and you want to use latest methods, the syntax will be:

$posts = DB::table('posts')->latest()->get();

It will sort data based on created_at column. And the syntax of the oldest methods is:

$posts = DB::table('posts')->oldest()->get();

You can pass a column as a parameter. Let's say, I want, the data will be sorted based on title column. So, the syntax will be:

$posts = DB::table('posts')->latest('title')->get();
\\or
$posts = DB::table('posts')->oldest('title')->get();

On the contrary, orderBy sort data lexically.

$posts = DB::table('posts')->orderBy('title')->get(); \\ascending
\\or
$posts = DB::table('posts')->orderBy('title', 'desc')->get(); \\ descending

Thanks. happy coding!

Rename column name in laravel migration

Khandokar Nafis Jaman — Wed, 09 Aug 2023 10:39:52 +0000

If you want to change the columns name of an existing table, at first you need to write the following way. Suppose we have a table name users . So we need to run the following command first.

php artisan make:migration rename_description_to_content_on_users_table --table=users

then, a new migration file will be created. Let's say, there is a column name description. I want to change this name to 'bio'. So now, I need to edit the migration file like this.

        Schema::table('users', function (Blueprint $table) {
            //
            $table->renameColumn('description', 'bio');
        });

Then run, php artisan migrate command. And done!

Thanks. Happy coding!

Check database information by laravel command...

Khandokar Nafis Jaman — Tue, 08 Aug 2023 08:24:33 +0000

If you want to see the details of your database, you just need to type this on your terminal:

php artisan db:show

It will show the basic configuration of your database which is attached on your projects. As well as, you can see total number of tables and connections.
Now, you may have more than one database connected with your projects. If you wanna see a certain database details, you need to type

php artisan db:show --database=sqlite

php artisan db:show --database=pgsql

Thanks. Happy coding!!

Flatlist in React-Native

Khandokar Nafis Jaman — Wed, 12 Jul 2023 19:19:26 +0000

The component known as React Native FlatList makes it possible to render lists with minimal effort and code.
Flatlist can be done in vertical and horizontal way. We can also make a grid view using Flatlist. We can make the item of the list clickable. Let's see a example.

import React, { Component } from 'react';
import { View, FlatList, Text, Image, Alert } from 'react-native';
class App extends Component {
  //create json array
  MyData=[
    {id:'1',title:"Bangladesh", subtitle:"Sakib", img:"https://cdn.pixabay.com/photo/2023/05/15/09/18/iceberg-7994536_1280.jpg"},
    {id:'2',title:"Australia", subtitle:"Smith", img:"https://cdn.pixabay.com/photo/2023/03/17/02/42/architecture-7857832_1280.jpg"},
    {id:'3',title:"England", subtitle:"Anderson", img:"https://media.istockphoto.com/id/1172437911/photo/budapest-hungary-the-main-tower-of-the-famous-fishermans-bastion-from-above.jpg?s=1024x1024&w=is&k=20&c=WDvMoCZDycINy23u9r31noMQU28nZz_kBP27_vvEKOo="},
    {id:'4',title:"India", subtitle:"Kohli",img:"https://media.istockphoto.com/id/1172437974/photo/budapest-hungary-aerial-view-of-the-main-tower-of-fishermans-bastion-with-illuminated.jpg?s=1024x1024&w=is&k=20&c=Kn5Jz6qaUwT_qBwwf5Ljq-bPOAf4je7uS-CWfUIC5Hc="},
    {id:'5',title:"Pakistan", subtitle:"RIzwan",img:"https://media.istockphoto.com/id/1285333630/photo/turkey-aerial-drone-high-point-view.jpg?s=1024x1024&w=is&k=20&c=JXt3dk3JO-ysRwCTdPLAOYNvHE0EYGSmvwom4Nok5-E="},
    {id:'6',title:"New-zealand", subtitle:"Boult",img:"https://cdn.pixabay.com/photo/2023/06/28/20/15/spider-8095142_1280.jpg"},
    {id:'7',title:"South Africa", subtitle:"De kock",img:"https://cdn.pixabay.com/photo/2023/06/11/08/52/waves-8055488_1280.jpg"},
    {id:'8',title:"Zimbabwe", subtitle:"Raza",img:"https://cdn.pixabay.com/photo/2023/06/28/09/12/waterfalls-8093877_1280.jpg"},
    {id:'9',title:"Ireland", subtitle:"Campher",img:"https://cdn.pixabay.com/photo/2023/06/01/05/58/clouds-8032705_1280.jpg"},
    {id:'10',title:"Afghanistan", subtitle:"Rashid",img:"https://cdn.pixabay.com/photo/2023/06/02/17/28/nature-8036126_1280.png"},
    {id:'11',title:"England", subtitle:"Root",img:"https://cdn.pixabay.com/photo/2023/06/28/20/15/spider-8095142_1280.jpg"},
    {id:'12',title:"Bangladesh", subtitle:"Hasan",img:"https://cdn.pixabay.com/photo/2023/03/17/02/42/architecture-7857832_1280.jpg"},
    {id:'13',title:"Ireland", subtitle:"Tector",img:"https://cdn.pixabay.com/photo/2023/06/28/11/25/man-8094211_1280.jpg"},
    {id:'14',title:"England", subtitle:"Butler",img:"https://cdn.pixabay.com/photo/2023/06/15/13/50/coffee-machine-8065457_1280.jpg"},
    {id:'15',title:"Bangladesh", subtitle:"Towhid",img:"https://cdn.pixabay.com/photo/2023/07/04/07/25/self-consciousness-8105584_1280.jpg"},
  ];

  //clickable function
    onClickItem=(alertTitle)=>{
      Alert.alert(alertTitle)
    }
  childView=({ctitle, csubtitle, img})=>{
    return(
    /* vertical  
    <View style={{flexDirection:'row',backgroundColor:'#fffeed',margin:5, padding:10, flex:100}}>
        <View style={{flex: 30}}>
            <Image style={{height:50, width:60}} source={{uri:img}} />
        </View>

        <View style={{flex: 70, backgroundColor:'#fffdee',}}>
          <Text style={{color:'#123eed',fontSize:16}}>{ctitle}</Text>
          <Text style={{color:'#23112f',fontSize:16}}>{csubtitle}</Text>
        </View>

      </View>*/

    /*horizontql       
    <View style={{flexDirection:'column',width:120,height:180,backgroundColor:'#fabcdf',margin:5, padding:10,}}>
        <View >
            <Image style={{height:120, width:"100%"}} source={{uri:img}} />
        </View>

        <View style={{ backgroundColor:'#fabcde',}}>
          <Text style={{color:'#123eed',fontSize:16}}>{ctitle}</Text>
          <Text style={{color:'#23112f',fontSize:16}}>{csubtitle}</Text>
        </View>

      </View>
     */
    //grid view
      <View style={{flexDirection:'column',width:120,height:180,backgroundColor:'#fabcdf',margin:5, padding:10,}}>
      <View >
          <Image style={{height:120, width:"100%"}} source={{uri:img}} />
      </View>

      <View style={{ backgroundColor:'#fabcde',}}>
        <Text onPress={this.onClickItem.bind(this,ctitle)} style={{color:'#123eed',fontSize:16}}>{ctitle}</Text>
        <Text style={{color:'#23112f',fontSize:16}}>{csubtitle}</Text>
      </View>

    </View>
    )
  }
  render() {
    return (
    //   <FlatList horizontal={true} data={this.MyData} renderItem={({item}) => <this.childView ctitle={item.title} csubtitle={item.subtitle} img={item.img}/>}/>
    <FlatList numColumns={3} horizontal={false} data={this.MyData} renderItem={({item}) => <this.childView ctitle={item.title} csubtitle={item.subtitle} img={item.img}/>}/>
    );
  }
}

export default App;

Hope, you can get benefited from it. Thanks in advance.

Create parallax effect of a 2D game background (Unity3D)

Khandokar Nafis Jaman — Thu, 29 Sep 2022 18:50:33 +0000

We often see the parallax effect in the background of 2D games. We can easily make this with Unity3D. To do this, we need to create a material. Change the shader type to Unlit/Texture.

Then select the background texture. Create a Quad. Resize it. Drag the material into material portion in mesh renderer.

Create a script name "Parallax" and attach to the quad. Open the script and paste the code.

`
using System.Collections;
using System.Collections.Generic;
using UnityEngine;

public class Parallax : MonoBehaviour
{
MeshRenderer meshRenderer;
[SerializeField]float animationSpeed = .5f;

private void Awake()
{
    meshRenderer = GetComponent<MeshRenderer>();
}
// Start is called before the first frame update
void Start()
{

}

// Update is called once per frame
void Update()
{
    meshRenderer.material.mainTextureOffset += new Vector2(animationSpeed * Time.deltaTime, 0);
}

}
`

Here the mesh renderer attribute access the background material. We just change the offset value over frame so that it can rotate on X axis.

That's it. Your parallax background is ready for the game.

Happy coding ☺️!

Laravel pagination: serial problem (serial starts with 0)

Khandokar Nafis Jaman — Sun, 18 Sep 2022 04:54:59 +0000

When you use Laravel default pagination, you may face a problem with its Key. If you use Key as the serial number, when you go to the second page, the key starts from 0.

To fix this, several methods can be applied. There are some build-in function. But these have a version issue. That's why, I can show you a way without using build-in version.

At first, let's see the url.

https://pgnbd.com/registration/view?page=2

This is the url when you are in second page. Similarly, when it's third page, the url is:

https://pgnbd.com/registration/view?page=3

So, we can catch the page parameter into a variable by this.

if(isset($_GET['page'])) $i= $_GET['page']-1; else $i = 0;

The else portion is for the first page where you can't find any page parameter. Suppose you show 20 data in a page using paginate like this paginate(20). Then you can write the serial number like this.

@foreach ($gallery as $key=>$item) {{($key+1) + ($i*20)}} @endforeach

Happy coding 😎!!

As vs Prefix (Laravel Route)

Khandokar Nafis Jaman — Wed, 14 Sep 2022 19:01:31 +0000

When we work with a route group, we often find two terms - 'prefix' and 'as'. What's the difference between these two terms? Well, Prefix uses in URL and As is used in name route.

For example, if we write...

Route::group(['prefix' => 'admin'], function(){ Route::get('/index',[DashboardController::class, 'index'])->name('index'); });

the Url works like this:

Route::get('/admin/index',[DashboardController::class, 'index'])->name('index');

But when we use As,such as...
Route::group(['as' => 'admin'], function(){ Route::get('/index',[DashboardController::class, 'index'])->name('index'); });

This will be work like..

Route::get('/index',[DashboardController::class, 'index'])->name('admin.index');

Thanks. Happy coding.

Link a controller to a model Laravel.

Khandokar Nafis Jaman — Tue, 13 Sep 2022 18:52:16 +0000

Let's say, you want to create a resources controller and a model by a single command. Most of us know that command. Suppose the model is 'User'. So the command will be

php artisan make:model User -mcr

But, when you want to connect a resources controller with an existing model, well, there is option here....

You need to write the following command.

php artisan make:controller UserController -m User

Thank you. Happy coding!

Slowly move gameobject from one place to another in Unity3D

Khandokar Nafis Jaman — Sun, 21 Aug 2022 17:38:00 +0000

Sometimes we need to move a game object from one place to another and maintain the speed of movement. Vector3.MoveTowards() can be the perfect solution for this. We need to create an empty gameobject and set the position where we need to move our gameobject. Then create another empty gameobject and make the previous two gameobject of it's child.
Let's say, we need to move DonkeyKong gameobject to the position of platformB. Then it can be like this.

Then, create a scripts, attach to the parent object and paste the following code.

`using System.Collections;
using System.Collections.Generic;
using UnityEngine;

public class PlatformMovement : MonoBehaviour
{
private Vector3 pointA;
private Vector3 pointB;
Vector3 nextPos;
[SerializeField] float speed;
[SerializeField] Transform childTransform;
[SerializeField]
Transform transformB;
// Start is called before the first frame update
void Start()
{
pointA = childTransform.localPosition;
pointB = transformB.localPosition;
nextPos = pointB;
}

// Update is called once per frame
void Update()
{
    Move();
}

void Move()
{
    childTransform.localPosition = Vector3.MoveTowards(childTransform.localPosition, nextPos, speed*Time.deltaTime);

}

}
`

Then, set the variables to the inspector.

If we want to move gameobject in a periodic motion, we need to add a couple of lines.

`
using System.Collections;
using System.Collections.Generic;
using UnityEngine;

// Update is called once per frame
void Update()
{
    Move();
}

void Move()
{
    childTransform.localPosition = Vector3.MoveTowards(childTransform.localPosition, nextPos, speed*Time.deltaTime);
  //check if the position of gameobject is changed  if(Mathf.Abs(Vector3.Distance(childTransform.localPosition, nextPos) ) <= .1f)
    {
        ChangeDestination();
    }
}

void ChangeDestination()
{
  //set the next position
    nextPos = nextPos != pointA ? pointA : pointB;
}

}

Coinbase api and laravel

Khandokar Nafis Jaman — Sun, 21 Aug 2022 07:38:48 +0000

I want to integrate my coinbase wallet to my laravel website as a payment gateway. Can anyone help me to find the proper guidelines or documentation?

Thanks in advance

Some useful VSCode extension to develop laravel app

Khandokar Nafis Jaman — Mon, 08 Aug 2022 20:35:00 +0000

When I'm working with web development, VSCode is my first choice. Because it is lightweight, easy to use, has flexible UI/UX and most significantly, lots of extensions are available here. I bet, these extensions really help you to code and save your bunch of time. Some of these extensions are:

Laravel Blade Snippets. Extension ID: onecentlin.laravel-blade

Most useful extension. Helps you to write syntax. It has autocomplete option. Such as, if you just write 'if', it completes your if else block..

`

@if ()

@else

@endif
`

Laravel goto view. Extension ID: codingyu.laravel-goto-view

It helps you to navigate the file.
return view('<u>admin.cmessage.index</u>',['cm'=>$cm]);
In above code, if you perform cntr+click in windows or cmd+click in mac, it will open index.blade.php file.

laravel-goto-components. Extension ID: naoray.laravel-goto-components

Same as goto view. But it is for component file. It's pretty much useful when you work will Livewire

Laravel Artisan. Extension ID: ryannaddy.laravel-artisan

This extension help you to run artisan command within visual studio

Laravel Blade formatter. Extension ID: shufo.vscode-blade-formatter

One of the significant extension. Work with indent of blade syntax

HTML CSS Support. Extension ID: ecmel.vscode-html-css

Help you to write html and css snippets.

Happy coding!!

Update vs Fixed Update? Unity3D

Khandokar Nafis Jaman — Tue, 02 Aug 2022 11:23:00 +0000

If you are a game developer, you are familiar with the terms Update() and FixedUpdate().
But many of us are perplexed about the difference. We all know, Update() is used when we need to update something in every frame.

` // Update is called once per frame
void Update()
{

`
But there is some issue with the Update method.
Frame rate differs from device to device or game to game. In that case, if you use any physics method in Update methods, it will not perform appropriately. To get rid of that, we should use the FixedUpdate method.

`
private void FixedUpdate()
{

The FixedUpdate function runs at a fixed interval independent of your game’s frame rate so that our function works in every fixed frame. So when we need to use Rigidbody, we need to use FixedUpdate(). Such as, move the player or add force.

Happy Coding!!