How To Insert Form Value Into MYSQL Database using PHP | Mysql Inserting Data Into Tables

Поделиться
HTML-код
  • Опубликовано: 27 фев 2020
  • In this video will tech you about how To Insert Form Value Into MYSQL Database using PHP. will make you understand about php/mysql connection and how to use it.This video shows how to create HTML form and I'll show you how to create a database using PhpMyAdmin and connect to that database using PHP- mysqli also how to insert data into tables using php functions.
    #MySqlTutorial #PhpLearn #MySqlForm
    In this topi you will cover these topics -
    How to insert Form Value Into MYSQL Database using PHP,
    Mysql insert query,
    Mysql Inserting Data Into Tables,
    How to save forms value into database using php,
    Php form value save into mysql,
    How to insert input fields value into mysql database using php

Комментарии • 163

  • @harismehboob3557
    @harismehboob3557 3 года назад +2

    Level of understanding. I am really thankful to u. I've got rid of many confusions because of your video

  • @stkvet
    @stkvet 2 года назад +1

    Thank you , I was making a mistake with my php/mySQL query and watching your video showed me the correct syntax.

  • @Frp_xbox
    @Frp_xbox 2 года назад

    It worked 100% and code is very simple to understand

  • @markmckillop2217
    @markmckillop2217 3 года назад +4

    Thank you very much. This was very helpful. You did a nice job of going step-by-step for those of us just learning.

  • @TBrianOnline
    @TBrianOnline 3 года назад

    Here's one positive comment for the algorithm!
    Worked like a charm. Can't recommend this tutorial enough for beginners.

  • @bakhshishsingh9735
    @bakhshishsingh9735 Год назад +2

    Millions of people wished to know this--You have explained very clearly and it is very useful.-Bakhshish Singh PUNJAB

  • @abagayanthony9352
    @abagayanthony9352 2 года назад +2

    Thank you soo much! because of this video I learn now how to do it manually! I can't thank you enoug but Hope your channel grow more! God Bless you!

  • @vr4563
    @vr4563 3 года назад +1

    plain and simple, thx for the video

  • @pratasaiprasad1109
    @pratasaiprasad1109 2 года назад

    excellent explaination very good madam not need to prepare again. thank you for providing us such wonderful video

  • @MahmudulHasan-xi7qv
    @MahmudulHasan-xi7qv 3 года назад +1

    The way you elaborate. It's awesome 😍

  • @gayatriborade9556
    @gayatriborade9556 Год назад

    Thank you so much.Very useful video.

  • @rathnamadhuri6205
    @rathnamadhuri6205 2 года назад

    Thank you so much. You explained it clearly.

  • @igwanwan_dagoat1523
    @igwanwan_dagoat1523 Год назад

    Thank you so much this video will never get old!

  • @divyanshupal8955
    @divyanshupal8955 2 года назад

    Thanks alot mam after alot of videos . I find your videos where I really run my form. Thanks a lot.

  • @codesvlogswithhemal4936
    @codesvlogswithhemal4936 2 года назад +1

    thank you very much
    before i was stuck in an endless loop

  • @lonthroop
    @lonthroop 3 года назад +5

    Very good walkthrough and instruction. You summed this up in a way that gave me a much better understanding of how to accomplish this task. Thanks.

    • @bamboolambo
      @bamboolambo 2 года назад

      Only bots can write such an brief and good answer.

  • @Thunder_Smile
    @Thunder_Smile 4 месяца назад

    Thank you for this video.
    ❤❤

  • @victoradedokun5878
    @victoradedokun5878 3 года назад

    This worked, thanks!!!

  • @haibaraai1690
    @haibaraai1690 3 года назад

    Thank you. Explanation and tutorial are very good

  • @raghumamidala8535
    @raghumamidala8535 2 года назад

    Thank you for making me understand in a very simple way

  • @Danilo-zo2er
    @Danilo-zo2er 3 года назад +4

    Thank you so much, I've been having problems with this one but I got that now.

  • @tshegomoguni6715
    @tshegomoguni6715 2 года назад +1

    Good pace and good explanation,I like it!

  • @CriticallyAshamed21
    @CriticallyAshamed21 3 года назад

    Thank you very much this video is really usefull

  • @usamashah1130
    @usamashah1130 2 года назад

    You did a impressive job!!!

  • @faizan01444
    @faizan01444 3 года назад

    Great i like your way of teaching

  • @Jabezmk
    @Jabezmk Год назад

    I hope your pockets overflow with everything you desire thank you so much fr

  • @Tracks777
    @Tracks777 4 года назад

    nice video

  • @phineasmwenda7947
    @phineasmwenda7947 Год назад +1

    heyy, thankyou so much. Very helpful piece of work congrats.😊😊😊

  • @pablosaizortuno4740
    @pablosaizortuno4740 3 года назад

    very good explained!

  • @D7D7_Alfarra
    @D7D7_Alfarra 2 года назад

    Thank you so much , it did really help me out a lot

  • @aryannayi0525
    @aryannayi0525 2 года назад +1

    Love You Mam....Thank You

  • @mavinemmanuel
    @mavinemmanuel 3 года назад

    Thank you!

  • @nicholasvswild
    @nicholasvswild 3 года назад

    Thank you very much ma'am

  • @dreamutheit3828
    @dreamutheit3828 3 года назад +1

    thank you so much..

  • @mphomanaka2263
    @mphomanaka2263 3 года назад

    Thanks a lot ❤️🔥👊

  • @samuelbaseke5305
    @samuelbaseke5305 2 года назад +1

    You are the best instruct whose tutorials I have watched. If you have a udemy course kindly share the link.😊😊

  • @netoonanimation15-2-23
    @netoonanimation15-2-23 3 года назад

    Thank you Very much

  • @atharvameher5880
    @atharvameher5880 2 года назад +1

    i love your voice

  • @MickenCZProfi
    @MickenCZProfi 3 года назад +4

    Thank you so much, saved my homework!

  • @TechwithSheetal
    @TechwithSheetal 3 года назад

    thank you so much mam...

  • @techie9898
    @techie9898 2 года назад

    Thank you so much ❤

  • @MrWebDesignerAnas
    @MrWebDesignerAnas 2 года назад

    thank you so much!

  • @muhammadfaizal7956
    @muhammadfaizal7956 3 года назад

    Thank you so much

  • @himanshuchhabra2925
    @himanshuchhabra2925 2 года назад

    thanks, teacher 😁

  • @melkamubelayneh1602
    @melkamubelayneh1602 3 года назад

    the best one

  • @indianshort1669
    @indianshort1669 2 года назад

    Thank you so much 🙏🙏🙏🙏

  • @masscomnet
    @masscomnet 2 года назад +2

    Would you mind letting us know which edit program you are using? Great video, REALLY appreciate it!

  • @ravipal3481
    @ravipal3481 2 года назад +1

    Thanku so much.... This video is very very helpful

  • @roshnapjohn1654
    @roshnapjohn1654 Год назад +1

    Thank you so much.

  • @Sanjeev7462
    @Sanjeev7462 Год назад +1

    I will subscribe when my project done

    • @Sanjeev7462
      @Sanjeev7462 Год назад +1

      Not work in my computer
      Not subscribed

  • @divyarani5422
    @divyarani5422 2 года назад

    thanks so much mein

  • @nishaanthsalian256
    @nishaanthsalian256 3 года назад

    Thank You

  • @soulking6982
    @soulking6982 3 года назад

    Thanks bro . May god bless u

  • @ramonben1813
    @ramonben1813 3 года назад

    thank you you save me

  • @muhammadamirbalouch3137
    @muhammadamirbalouch3137 3 года назад

    Thanks

  • @mdharoonh
    @mdharoonh 2 года назад +1

    Great tutorial, voice sound can be increased

  • @cameleonarabic8124
    @cameleonarabic8124 2 года назад

    ty

  • @imransitzone9946
    @imransitzone9946 2 года назад +1

    Thank You very much

  • @virushan
    @virushan 2 года назад +1

    superb

  • @erdenetugs2958
    @erdenetugs2958 2 года назад +1

    i love u

  • @haibaraai1690
    @haibaraai1690 3 года назад +1

    This code works. Thank you ;)

  • @zerefuuutv
    @zerefuuutv 2 года назад +2

    Hello! Thank you for the great tutorial. But one question. Can i put all those 2 php codes in a single php file?

    • @wpshopmart
      @wpshopmart  2 года назад

      Yes you can put php codes in singe php file

  • @rathnamadhuri6205
    @rathnamadhuri6205 2 года назад

    Can we have more videos on php projects. I am working with xampp.

  • @edgarmuga8339
    @edgarmuga8339 2 года назад

    Thank you All my regards

  • @nvignesh4264
    @nvignesh4264 Год назад

    Directly executing the else part...and printing all files required

  • @blogboy448
    @blogboy448 2 года назад

    Please tell us in which terminal you are coding?

  • @youneskhouna8714
    @youneskhouna8714 2 года назад

    THAAAAAAAAAAAAAAAAANKS

  • @devyadav1496
    @devyadav1496 2 года назад

    Thank you for this video! I have tried it, but I'm unsure why it's not working. In browser it returns the blank page on submit and in database it does not add any video.

  • @sanmugamsanmugam4321
    @sanmugamsanmugam4321 3 года назад +7

    $run=mysqli_query ($conn,$query) or die(mysqli_error()); this line shows excatly 1parameter, 0 given error how to solve it plz tell

    • @cvstomwc1575
      @cvstomwc1575 3 года назад

      check $query or $conn,maybe u get wrong like me at "insert to **your table name**(name,email...)"

    • @Mommy_milkers1226
      @Mommy_milkers1226 2 года назад

      check your data base be sure to change your id field into int and auto increment it

    • @cricket3293
      @cricket3293 2 года назад

      I face same problem.....can u solve it?

    • @oppaidaisuki6934
      @oppaidaisuki6934 2 года назад

      Fatal error: Uncaught ArgumentCountError: mysqli_error() expects exactly 1 argument, 0 given in C:\xampp\htdocs\Ecom\insert.php:26 Stack trace: #0 C:\xampp\htdocs\Ecom\insert.php(26): mysqli_error() #1 {main} thrown in C:\xampp\htdocs\Ecom\insert.php on line 26
      here's my problem can someone help me

  • @Rayan-rn9wm
    @Rayan-rn9wm 2 года назад

    Thanks for the info but the intro music is too loud

  • @johhnycash8183
    @johhnycash8183 Год назад

    I only want a submit button to confirm the text they read. After that I want it to send "confirmed" to the "submit" column in the database. How would I do this?

  • @TheLastRevelotion
    @TheLastRevelotion 3 года назад

    Can you tell us how to it in live server ?

  • @coolfacts-tv
    @coolfacts-tv 2 года назад

    how to senatize input data from code execution like mysqli and html javascript injection

  • @imtiazulsakib1636
    @imtiazulsakib1636 2 года назад

    Can you please upload the coad in githud please and share the link in description.

  • @tlou_page
    @tlou_page 11 месяцев назад

    it says that mysqli_error needs exactly one argument and you didnt put any so i cant move on. What i have to do? It also says that need an argument type mysqli.

  • @abdulmoizirshad806
    @abdulmoizirshad806 2 года назад

    When i was reload the page after submit the form. The data resubmission alert is appear ,Please give me solution

  • @MashiruZ
    @MashiruZ 2 года назад

    hi..i had this problem Warning: mysqli_error() expects exactly 1 parameter, 0 ..i cant enter more than 1 data..how do i slove this? sorry im still new with this

  • @skelix6129
    @skelix6129 2 года назад +1

    idk why but my form is not submitting no matter how much i try my connection is successful but form is not submitting

  • @jachimikeezenwamadu5129
    @jachimikeezenwamadu5129 2 года назад

    what if you want to do it for two tables in the database?

    • @wpshopmart
      @wpshopmart  2 года назад

      You will need to run another query for second tables

  • @chhaseebmahmood9614
    @chhaseebmahmood9614 2 года назад

    you are working on both php files

  • @alaintristanlado4001
    @alaintristanlado4001 3 года назад +1

    not working for me, on line 12 the "{" is unexpected

  • @bhaveshmoon1979
    @bhaveshmoon1979 3 года назад

    How to do it in hostinger

  • @atheer9204
    @atheer9204 2 года назад

    can you put the code so we can check ours i'm having a problem with this i cant get the message i dont know why

  • @dschulz12
    @dschulz12 2 года назад

    ok, so everytime i hit submit i get "all fields required" although i have all fields filled in. any help?

    • @wpshopmart
      @wpshopmart  2 года назад

      Remove required tag from all inputs

  • @henrynjoku8020
    @henrynjoku8020 3 года назад

    showing all field required message and no data inputed code not workin

  • @dikshitadhone4942
    @dikshitadhone4942 2 года назад

    hey my form data is not displayed in database

  • @lovemadeinjapan
    @lovemadeinjapan 2 года назад

    Scary, I miss parsing out any malicious code in the input, this is ready for MySQL injection.

  • @SaadAli-ih9vq
    @SaadAli-ih9vq 2 года назад

    I write the same code but got a fatal error.
    Why??

  • @milasspace
    @milasspace 2 года назад

    Can someone copy and paste the code into the comments. Mine keeps throwing errors and it's not saying why so IDK what I'm doing wrong.

  • @ankitdas3944
    @ankitdas3944 2 года назад +2

    My data is not getting inserted whenever i enter my data in the webpage the page refresh and doesn't spell "data submitted successfully"
    Please help me out with it

  • @shamilrahman5858
    @shamilrahman5858 3 года назад

    pls help me it is showing all fields required pls help I wrote all the input form

    • @wpshopmart
      @wpshopmart  3 года назад

      Contact from wpshopmart.com I will help you there

  • @chrislab6453
    @chrislab6453 2 года назад

    Hello, i copied your code but I'm getting this error - Warning: mysqli_error() expects exactly 1 parameter, 0 given in C:\xampp\htdocs\Barangay\user.php on line 19 which is the $run = mysqli_query($conn,$query) or die(mysqli_error());

  • @pulungnola1266
    @pulungnola1266 2 года назад

    Can not to submit

  • @siddhijadhav9076
    @siddhijadhav9076 3 года назад

    Not working on line 12 unexpected &&
    Pls help

    • @sheikhnasir12
      @sheikhnasir12 3 года назад

      Check brackets ( ), I somehow make the same mistake and solved it now.

  • @chomuekez
    @chomuekez 3 года назад

    mine not working, if i click submit then it goes to display the insert.php page, what could be the problem?

    • @mounaar7299
      @mounaar7299 3 года назад

      did you fixed the problem!

    • @chomuekez
      @chomuekez 3 года назад

      @@mounaar7299 yes thank you

    • @sha2683
      @sha2683 2 года назад +2

      how u fix it? facing the same problem.

  • @PRASADREDDY-oe9rs
    @PRASADREDDY-oe9rs 3 года назад +1

    blank page after submitting form php

    • @jaymmusic6121
      @jaymmusic6121 3 года назад +1

      same waiting on some assistance

  • @GauravKumar-ui7ow
    @GauravKumar-ui7ow 2 года назад

    Help please....

  • @lofiBa3210
    @lofiBa3210 Год назад

    Uncaught Argument count error MYSQLI_ERROR()

  • @YousefTrad
    @YousefTrad 2 года назад +1

    for those who face the problem of not showing anything after submiting the form => try to restart both apache and MySQL , also try to check and rewrite the if statement which control the submission => if(isset($_P0ST['submit'])) .
    there are some ridiculously easy-to-solve bugs like this but so infuriating.

  • @tasfiabintemorshed8685
    @tasfiabintemorshed8685 2 года назад +1

    i completed exactly same code.But this thing are showing.
    mysqli_error() expects exactly 1 parameter, 0 given in C:\xampp\htdocs\test\insert.php on line 20
    what should i do now

    • @tiffys
      @tiffys 2 года назад

      you must pass the connection object in the mysqli_error function: mysqli_query($conn, $query) or die(mysqli_error($conn));