PHP - PDO Prepared Statements

Поділитися
Вставка
  • Опубліковано 9 лис 2024

КОМЕНТАРІ • 32

  • @davidwinter8794
    @davidwinter8794 4 роки тому

    I've been stumbling around the web trying to educate myself on interacting with MySQL databases. Now I'm here and successfully educated! and well and truly subscribed. Refreshingly clear and you 'explain' the constructs so well, thank you.

  • @greendragon0009
    @greendragon0009 2 роки тому +1

    Pleasant voice. And you're too good. Too smooth. You have to be a professional teacher or speaker.

  • @adante407
    @adante407 5 років тому +11

    Are you going to make more tutorials? Complete project playlists etc. Would be great! Your explanations are concise, and very understandable, great tutorial. 👌👍

    • @billyellis6458
      @billyellis6458 3 роки тому

      I guess Im randomly asking but does anybody know of a trick to get back into an instagram account?
      I stupidly lost my password. I love any tips you can give me.

    • @adoniskash9048
      @adoniskash9048 3 роки тому

      @Billy Ellis instablaster =)

    • @billyellis6458
      @billyellis6458 3 роки тому

      @Adonis Kash Thanks so much for your reply. I found the site through google and I'm trying it out atm.
      I see it takes quite some time so I will get back to you later with my results.

    • @billyellis6458
      @billyellis6458 3 роки тому

      @Adonis Kash it worked and I now got access to my account again. I am so happy!
      Thank you so much you saved my ass!

    • @adoniskash9048
      @adoniskash9048 3 роки тому

      @Billy Ellis Happy to help :)

  • @bjvercelli
    @bjvercelli 3 роки тому

    This video is insanely good

  • @codegame2815
    @codegame2815 4 роки тому +1

    Nice. Thank You For Fast Talking About PDO

  • @aguswidi9316
    @aguswidi9316 4 роки тому

    The best tutorial. Straight forward. Subscribed

  • @jayabrams400
    @jayabrams400 5 років тому +3

    You rock! I just subscribed. Hopefully Chang lays off the pot.

  • @shanemturner
    @shanemturner 5 років тому

    Great video, right to the point and crystal clear. Many thanks.

  • @Nova-Rift
    @Nova-Rift 3 роки тому

    Veryy good video! Thank you!

  • @yungifez
    @yungifez 3 роки тому

    I love this teaching
    It's clear

  • @amekoyu
    @amekoyu 4 роки тому

    Thank you very much! Finally I understood it.

  • @Julio860JVL
    @Julio860JVL 4 роки тому

    Saved to my PHP reference videos!

  • @jimcolabuchanan6579
    @jimcolabuchanan6579 5 років тому

    Good to see this. Too many old SQL examples out there. Prepared statements should prevent injection.

  • @mofe620
    @mofe620 2 роки тому

    Thanks a lot for this

  • @sebastianrodelo7965
    @sebastianrodelo7965 2 роки тому

    Thanks!

  • @ashrafulalim1272
    @ashrafulalim1272 3 роки тому +1

    Nice and easy explanation. Please upload the source code too.

  • @mohammedeltokhy3560
    @mohammedeltokhy3560 3 роки тому

    You are perfect

  • @excaliburgz1996
    @excaliburgz1996 4 роки тому

    Great nice tutorial!!!

  • @Techaddict
    @Techaddict 4 роки тому

    Ok, first of all, amazing tutorial. I have been actually trying to learn Php with PDO and have a very little tutorial in detail. So thanks for that. Moreover, you said at 3:53 that the exception isn't needed to use. But does that make the code less secure? I mean for a site to be safe from most of the vulnerability doing this way PDO, is it going to compromise the security of the site or it's not gonna affects?
    Looking forward to a full PDO tutorial if you have or can make one.

    • @phpBasics
      @phpBasics  4 роки тому +1

      Hey there. Feel free to reach me on Skype @CoolEditz if you want to discuss further or need help. Specifying the exception does not increase security since later versions of PHP default to that format.

    • @Techaddict
      @Techaddict 4 роки тому

      @@phpBasics does that mean, i am working on 7.3 and above php version and it would be totally fine to skip " $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_ExCEPTION);"

  • @youmeandnature
    @youmeandnature 5 років тому

    This is a very very good tut

  • @victoria-exito
    @victoria-exito 2 роки тому

    Hi! Could you create a project for example a "to-do list" using the newest? :) PHP, docker (instead of XAMPP), adminer (instead of phpmyadminer), pdo (instead of mysqli). Frameworks are not allowed. Javascript is NOT allowed on the server side. The tasks are marked when they are completed. Must include a functionality of selecting all the tasks. Thank you for all your videos. God bless you!😇🙏

  • @ckh8217
    @ckh8217 4 роки тому

    You could even skip the bindParam and put an associative array in the execute....
    $stmt->execute(['n'=>$name,'q'=>$quote]);

    • @phpBasics
      @phpBasics  4 роки тому

      Actually you can just do $stmt->execute([$var1,$var2]) and use ? in the statement, which is what I typically do.

  • @pablosartor6715
    @pablosartor6715 4 роки тому

    Can you post a link to a php code of this video?

  • @RacoonCH
    @RacoonCH 4 роки тому

    6:16 LMAO xD