Magento2

Magento 2 Add Data Using Custom Insert Query

By 1 Min Read

Sometimes we need to write custom insert query in magento2 as per business logic or client requirement.

In this blog, We will create some standard code to insert data using custom insert.

We need to use magento ResourceConnection class for insert data in mysql table.

Here we are adding a new record in custom table call_logs, that contains three columns only id, external_number and duration

PHP
<?php
declare(strict_types=1);

namespace MageDad\Module\Model;

use Magento\Framework\App\ResourceConnection;

class CallLogManagement
{
    public function __construct(
        private ResourceConnection $resourceConnection,
    ) { }
    
    public function saveCallLog()
    {
        $data = [
            'external_number' => '09876543210',
            'duration' => 100
        ];
        
        $connection  = $this->resourceConnection->getConnection();
        $tableName = $connection->getTableName('call_logs');
        $connection->insert($tableName, $data);
        
        
        $data = [
            [
                'external_number' => '09876543210',
                'duration' => 100
            ],
            [
                'external_number' => '09876543211',
                'duration' => 200
            ]
        ];
        $connection->insertMultiple($tableName, $data);
    }
}

Above code in we used insert function for single record call_logs table. We have function insertMultiple for more then one record.

I hope this blog is useful to custom insert query in magento2. In case, I missed anything or need to add some more information, Don’t heisted to leave a comment in this blog, I’ll get back with some positive approach.

Keep loving ❤️ Keep inspiring 🤩 Keep liking 👍 No sharing 😄

Post Views: 1,062

Related Posts

91 Comments

  2. breathe

    **breathe**

    breathe is a plant-powered tincture crafted to promote lung performance and enhance your breathing quality.

  4. Тркелу

    I don’t think the title of your article matches the content lol. Just kidding, mainly because I had some doubts after reading the article.

  7. 48v dc light bulb

    I am very happy to read this. This is the type of manual that needs to be given and not the accidental misinformation that’s at the other blogs. Appreciate your sharing this greatest doc.

  14. toto togel 4d

    Very good written article. It will be supportive to everyone who usess it, including me. Keep doing what you are doing – looking forward to more posts.

  16. situs slot terpercaya

    Sweet blog! I found it while surfing around on Yahoo News. Do you have any tips on how to get listed in Yahoo News? I’ve been trying for a while but I never seem to get there! Many thanks

  17. slot365 rtp

    Nếu bạn muốn chơi game thỏa thích với thương hiệu này, bạn hãy tải và cài đặt ứng dụng từ link chính thức của chúng tôi. Điều này giúp đảm bảo an toàn và tránh các rủi ro từ những nguồn không rõ ràng. slot365 rtp Sau khi tải ứng dụng, bạn có thể đăng ký tài khoản và bắt đầu trải nghiệm ngay. TONY12-11A

  18. p3beyt

    I dabbled with p3beyt the other day. The mobile interface is pretty smooth. Worth a shot if you’re on the go. See what you can find over at p3beyt!

  19. 888Slot APK

    Dàn Dealer chuyên nghiệp đến từ Châu Âu và Châu Á chắc chắn sẽ mang đến cho bạn những giây phút thăng hoa giải trí tuyệt vời. 888Slot APK 200+ Studio được phát sóng trực tiếp mỗi ngày cho bạn thoải mái tham gia và nhận thưởng bonus với hoa hồng hấp dẫn khi giành chiến thắng. TONY12-16

  20. fdertol mrtokev

    After I initially commented I clicked the -Notify me when new feedback are added- checkbox and now every time a remark is added I get four emails with the same comment. Is there any way you may remove me from that service? Thanks!

  21. xn88

    xn88 được thành lập vào năm 2015 và hiện đang hoạt động hợp pháp với sự cấp phép từ tổ chức Curacao eGaming, giấy phép số 365/JAZ. Đây là một đơn vị giải trí trực tuyến nổi bật tại châu Á với quy mô hoạt động rộng khắp nhiều quốc gia. TONY12-26

  24. sbobet88

    Kontennya mantap dan relevan. Rekomendasi buat yang mau seru-seruan tanpa ribet, coba klik sbobet resmi sekarang.

  27. lloydroofingservices.com

    You are my aspiration, I have few blogs and rarely run out from post :). “Yet do I fear thy nature It is too full o’ the milk of human kindness.” by William Shakespeare.

  29. zabornatorilon

    You can definitely see your expertise in the work you write. The world hopes for even more passionate writers such as you who are not afraid to say how they believe. At all times follow your heart. “Man is the measure of all things.” by Protagoras.

  30. zaborna torilon

    An interesting discussion is worth comment. I think that you should write extra on this matter, it won’t be a taboo subject however typically persons are not enough to talk on such topics. To the next. Cheers

  38. mitolyn official

    **mitolyn official**

    Mitolyn is a carefully developed, plant-based formula created to help support metabolic efficiency and encourage healthy, lasting weight management.

  41. Emmanuel

    big pokie wins australia 2021, real money united statesn pokies and united kingdom real money casino, or australia casino lasseters

    my website blackjack ios [Emmanuel]

  43. Neva

    dublin casino roulette (Neva) gananoque ontario united kingdom, non gamstop casinos uk and free spins new usa,
    or blackjack lusaa meaning

  44. Clarice

    top 10 casino in canada, united statesn casino minimum deposit dollar 10 and
    all australian casino bonus codes, or online casino in canada 2021

    Feel free to visit my homepage – don’t come craps bet (Clarice)

  45. Son

    aristocrat pokies real money united kingdom, forms
    of gambling in canada and how old do you have to be to go in a ge casino
    (Son) usa,
    or pokies open in south united states

  46. lohaa.de

    canadian casino no deposit bonus codes 2021, vancouver united states
    casino and new online slot sites uk, or free casino games to play on your phone (lohaa.de) chips canada

  47. Sign Up

    Your point of view caught my eye and was very interesting. Thanks. I have a question for you.

  48. mounja boost official

    **mounja boost official**

    MounjaBoost is a next-generation, plant-based supplement created to support metabolic activity, encourage natural fat utilization, and elevate daily energywithout extreme dieting or exhausting workout routines.

  49. herpafend

    **herpafend**

    Herpafend is a natural wellness formula developed for individuals experiencing symptoms related to the herpes simplex virus. It is designed to help reduce the intensity and frequency of flare-ups while supporting the bodys immune defenses.

  50. prodentim official website

    **prodentim official website**

    ProDentim is a distinctive oral-care formula that pairs targeted probiotics with plant-based ingredients to encourage strong teeth, comfortable gums, and reliably fresh breath

  53. Dick

    united kingdom online casino minimum deposit dollar 10, united
    states alt – live casino register (Dick)
    online and how old do you have to be to go in a casino usa, or gambling statistics
    in usa

  54. Jerrell

    is online gambling banned in australia, bouka pokies and usa gambling regulation changes, or new uk
    paypal eu casino promo code (Jerrell)

  55. balmorex pro

    **balmorex pro**

    balmorex is an exceptional solution for individuals who suffer from chronic joint pain and muscle aches.

  58. web Page

    Howdy! I’m at work surfing around your blog from my new
    apple iphone! Just wanted to say I love reading your blog and look
    forward to all your posts! Carry on the great work!

    Here is my blog; web Page

  60. Georgia

    Today, I went to the beach front with my kids.
    I found a sea shell and gave it to my 4 year old daughter and said “You can hear the ocean if you put this to your ear.” She put the shell to her ear and screamed.

    There was a hermit crab inside and it pinched her ear.

    She never wants to go back! LoL I know this is completely
    off topic but I had to tell someone!

    Also visit my web blog … learn craps video (Georgia)

  61. Abel

    online gambling ads usa, free spins no deposit online batavia downs casino age
    limit (Abel) australia and arcade slot machines for
    sale uk, or bingo how to play uk

  62. Noella

    united statesn free pokies games, best online poker games united kingdom and uk casino free european roulette games for fun [Noella] bonus,
    or deposit 10 play with 50 slots uk

  63. Drew

    bet365 do app games make money (Drew) casino usa, new casino non uk and united kingdom online poker news, or online gambling casino nz

  64. Olga

    united kingdom casino no deposit bonus codes 2021,
    united states day free spins and craps what happens when you call gambling helpline – Olga,
    uk, or how to become a casino dealer uk

  65. Macau casino Bonus 2021

    Great blog! Is your theme custom made or did you download it from somewhere?

    A design like yours with a few simple tweeks would really make my blog shine.

    Please let me know where you got your theme.
    Thanks a lot

    Take a look at my blog post – Macau casino Bonus 2021

  66. Holley

    no deposit usa online casino, best online poker
    app new zealand and real money online casino canada app, or usa online casino no deposit bonus codes
    2021

    Here is my web blog; what is gambling in spanish, Holley,

  67. Miles

    online pokies canada law, red hawk casino credit application (Miles) sites usa no deposit bonus and free spins no deposit united kingdom casino, or usa
    online casino no deposit bonus codes 2021

  71. Kay

    25 free spins on sign up australia, canadian roulette free game and best casino in new
    zealand, or usa online casinos free play

    Feel free to surf to my web blog; craps stick name (Kay)

  72. six line roulette

    I got this website from my friend who informed me regarding this site and at the moment this time I am browsing this website and
    reading very informative articles or reviews at this place.

    my blog post – six line roulette

  73. Casie

    online texas holdem real money australia, top poker sites uk and ept poker chips
    in usa, or casoola eagle river casino whitecourt ab (Casie) uk login

  75. arionplay

    Yo, check out Arionplay! Solid platform for some chill gaming sessions. Easy to navigate and good selection. I’m hooked! Learn more here: arionplay

  76. ph78login

    If you are looking for an extra income playing betting apps, ph78login is it. Plenty of ways to win and withdraw and a few friends already proved its worth. Make it happen: ph78login

  78. Klaudia

    united kingdom blackjack rules, united states day free spins
    and no deposit slots usa, or all australian casino no deposit bonus codes

    My website: baccarat paperweights identify – Klaudia –

  79. Leroy

    south united states casinos, top 20 online casinos uk no deposit and online casino canada no deposit
    sign up bonus, or best casino cs go gambling sites list [Leroy] in united states

  81. Efrain

    new zealandn online casinos pokies, african new zealandns gambling in vegas and slot machines sale united
    states, or online gambling casino nz

    Also visit my homepage – valentine’s day roulette (Efrain)

Write A Comment