how to connect HTML form and MySQL database using Xampp server | phpMyAdmin Mysql tutorial

Поделиться
HTML-код
  • Опубликовано: 17 окт 2024
  • #xamppserver,#mysql2022,#connectphptomysql,#xampp
    an updated video for your errors of php file showing and connection error
    • Live Session Xampp Ser...
    how to connect HTML form and MySQL database using xampp server and phpMyAdmin Mysql tutorial
    how to create a simple Html registration form in notepad
    • how to create simple h...
    HTML Programming 2022 Computer Science
    • how to create simple h...
    For code: techniyojan.co...
    My New Channel for bsc computer science and IT students(Computer Science ADDA)
    / @bsccomputerscienceadd...
    Connect with me on social media
    ***************************************************
    Facebook: / techniyojan
    Twitter: / techniyojan
    Instagram: / techniyojan
    My website : www.techniyoja...
    ***************************************************
    For Business Queries: techniyojan123@gmail.com
    #techniyojan

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

  • @alexanderjensen7034
    @alexanderjensen7034 3 года назад +17

    Thank you so much! I had literally watched 20 videos on the same subject, but this video is the only one there has worked so far! Great job

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

      sorry to be so offtopic but does anybody know a trick to get back into an Instagram account?
      I stupidly lost my password. I would love any assistance you can give me

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

      @Luciano Cohen instablaster =)

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

      @Colten Coleman i really appreciate your reply. I got to the site thru google and Im trying it out now.
      Seems to take quite some time so I will get back to you later with my results.

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

      @Colten Coleman it did the trick and I finally got access to my account again. I am so happy:D
      Thank you so much, you saved my account !

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

      @Luciano Cohen Happy to help :)

  • @chiragjain7159
    @chiragjain7159 Год назад +3

    Thank You so much sir for this video. This is the only video which resolved my error.

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

    Sir me sadanand
    Abhi bsc it kar rha hu
    Or ye topic mere practical exam hai
    To ye video mere liye bhot helpful hai😊

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

    Bhai maza aage aapne itne easyly samjhadiya
    thanks bhai

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

    Awesome!!!
    Question: What if you want to display the table you have just made on phpmy admin in an HTML file?

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

      You have to fire ... "select * from tablename"..query in SQL query

  • @abdulmoha8117
    @abdulmoha8117 Год назад +3

    Thanks I am 11 years old thanks again

  • @sawantinfotech3920
    @sawantinfotech3920 3 года назад +3

    very helpfull for student simply great ...Thanks

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

    Thank you so much for this ,with this I completed my project work.

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

    thanks bro for the help that helped in my college project

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

    Sir when I clicked on submit it showed me the code which I wrote in the details_entry.php tile. So can please rell me what should I do next

  • @Paul-ro5pt
    @Paul-ro5pt 4 месяца назад

    BROO! Thank you very much for teaching me.😀

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

    Although i created the database, after submitting it shows unknown database 'database1234' in C:\xampp\htdocs\details_entry.php on line 7

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

    I am having problem , I have wrote js code in html by onsubmit return function () so , after database connection it didn't go to validate function it directly goes to form action saves the information in MySQL so, how can we first validate and then go to action="details_entry.php" ???

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

    Awesome video. Just one question, at 20:22 when by mistake we mistyped the variable server_name as servername it did showed variable not found error but then why we also saw "New Details Entered Successfully" message ?? If connection wasn't set successfully then the code should have stopped at die(...). But it didn't. Why so ?

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

    I am having problem after submitting the form details it's saying:-
    Warning: Undefined variable $sql in C:\xampp\htdocs\details_entry.php on line 33
    Error: Column count doesn't match value count at row 1
    Please help
    I got it , I wrote wrong syntax in php file😅

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

    Which software used for coding

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

      sublime text editor, notepad, or visual studio code

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

    Sir after submitting it's showing 'your file couldn't be accessed '
    It may have moved,edited,or deleted

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

    Charging mobile on sunlight patent -
    ruclips.net/video/7Tmgf4KzG_c/видео.html

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

    Parse error: syntax error, unexpected variable "$phone" in C:\xampp\htdocs\insert.php on line 18
    What to do now

  • @мѕнку
    @мѕнку 2 года назад

    Bhai Mera data table ban gaya hay table me valuse bhi inserted bhi ho raha hay par submit karne par show nahi kar raha ahy new details inserted successful so please solve me my problem

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

    Love you man thanks a lot
    Keep it up
    After watching this video understand the basics about the php and now I'm implement this in my project.... Again thanks a lot bro

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

    I got an error : This page isn't working right now, sir what is this issue ? Pls reply

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

    Very fruitfull

  • @ashwinigouda3596
    @ashwinigouda3596 6 месяцев назад

    sir as i am clicking to mysql start button it is not starting it and showing error

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

    Thank you so much for this tutorial! It helped me so much :)

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

    Can I use instead of for each info in html?

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

    if I want to redirect user to another page after submit how to do that. Kindly explain.

  • @WolfgangMeister-yn9iq
    @WolfgangMeister-yn9iq 2 года назад +1

    thanks alots for the simplify video

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

    Apache server will connect and MySQL will not connect .what i do now sir please help me sir??

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

    sir how to get error and registration successful message on same page

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

    I am having a problem after submitting the form details it's says that

    Notice: Undefined variable: conn in C:\xampp\htdocs\WEB\stem_db.php on line 10
    Connection Failed:
    Please help, thanks!

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

      Pls mention that line 10 code

  • @sumeetsaurabh8124
    @sumeetsaurabh8124 5 месяцев назад

    When I click on submit.... show php code in browser... please solve this issue

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

    sir i have written the same code, but sir jab code run krti na e koi error ata r na hi data enter horaha database mai

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

    I have done everything but my problem is data is not storing what can been wrong please guide

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

    Help me! after the procedure i entered all the data, clicked submit and the message appears "
    Parse error: syntax error, unexpected '$mysql_query' (T_VARIABLE)" How can i solve? Thanks!

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

      Yes definitely... pls chk the column names you entered In insert query and the same should be in table column datatype...

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

    thank you so much. it helped me a lot :)

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

    sir please show how to redirect to home page after click on login ....if the the entered data is correct

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

    The code runs fine.when connecting localhost with html page there is ("the requested URL was not found on this server")please help with this.

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

    Hi! I'm having a problem with this part "$conn = mysqli_connect($server_name,$database_name,$admin_id,$password,$conpassword);" whenever I try to run the file an error keeps on occurring "Fatal error: Uncaught TypeError: mysqli_connect(): Argument #5 ($port) must be of type ?int, string given in C:\xampp2\htdocs\server.php:12 Stack trace: #0 C:\xampp2\htdocs\server.php(12): mysqli_connect('localhost', 'isproj2', Object(SensitiveParameterValue), '', '') #1 {main} thrown in C:\xampp2\htdocs\server.php on line 12". I hope you can help me :)

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

    Xampp is running but I can't run in any browser , losthost is not working in my browser
    my browser is not responding

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

    Could you help me solve Fatal error: Uncaught Error: Call to undefined function mysql_connect() in C:\xampp\htdocs\details_entry.php:line7 Stack trace: #0 {main} thrown in C:\xamp\htdocs\details_entry.php on line 7

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

      Pls chk the table name u created in your localhost...and create the same as mentioned in insert query

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

    Hi, is there anyway you are able to help me with this I am having a few problems maybe we could screen share?

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

    From where u opened the very forst screen

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

    thankyou soo much, the video helped me alot

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

    Awsm thanx for saving me

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

    Can I will connect it to mysql

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

    Nice tutorial

  • @bhakthi.v.m4791
    @bhakthi.v.m4791 3 года назад

    Sir im not getting the succesfully registered page instead I'm getting the PHP codes in the web browser when I click on submit why is that can you please help me because I have my exams tuesday and I saw ur video its very helpful but I'm not getting the display why is that ?

    • @bhakthi.v.m4791
      @bhakthi.v.m4791 3 года назад

      sir please help me out !!

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

      Chk yesterday live session video you will get your answer

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

    Hi ,What about Netbeans ,like how to connect html form in phpmyadmin using netbeans 8.2:))

  • @Khushi-ot1jt
    @Khushi-ot1jt 3 года назад

    Do we need internet access while connecting to local host?

  • @BaljinderSingh-mv8vy
    @BaljinderSingh-mv8vy Год назад +2

    Thanks sir

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

    I got error in line $sql_query = insert into ... Can you explain

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

    Thanks, great job!

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

    Sir, i have no error but after i submit the form, it do not say you have registered successfully. I become a blank page

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

      hey its giving same error...where you able resolve it?can you pls help me

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

    when I click submit on the form I've made, it just goes to the php file, presented in notepad form.... help plz

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

    Very helpful! Thank you sir

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

    Great video!!
    I have a question, if I want to redirect user to another page after submit how to do that. Kindly explain.

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

      same question...if u found any answer then plz share soon.

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

      if(isset($_POST['save_btn'])) { echo' window.location="another.php"; '; }

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

    I am getting an unexpected variable error for the $conn variable how do I fix this?

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

      Chk conn paramaters you declared to connect with table

  • @Daniwarriors
    @Daniwarriors 4 месяца назад +1

    Gr8 work

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

    How i can give to an specific user the verified badge to my app?

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

    Thanks for the video .very useful

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

    Thank You So Much Brother 🇱🇰🥰

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

    Superb 😘😘

  • @channel24x7.newzsportsente2
    @channel24x7.newzsportsente2 3 года назад +1

    Great work to acknowledge easily

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

    its giving an error of giving all the sql code insteadf of a succesful text

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

    very helpful sir

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

    Sir after clicking on the submit button it says URL not found. I checked the query string and other things like database and table name etc but still am not able to do it

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

      Did you checked the file is opening through localhost...as I told how to chk that in video..chk it and let me know...

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

      @@TechNiyojan yes sir the file is opening through local host

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

    Thank you so much!

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

    Thank you sir, it worked

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

    Sir,
    While I am clicking on the submit button I am getting the complete code of. Php file but not the output
    Can u please say what mistake I am doing
    Thank you

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

      Yes...that means your xampp or wamp server whichever u r using..is not started running.. so this happens...u can check in my recent php videos of HSC it sop 1 php I had explained this thing

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

      @@TechNiyojan Tysm sir,
      It's working !! It really means alot

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

      can you please send video link sir for me also same error

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

      This is the video...that u commented on...or which else video u need?

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

      Please share link🙏🏻🙏🏻

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

    Sir thank you ❤🙏

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

    i could not connect the database to the html there are show error
    i follow your source code bt it does not work
    pls give m the solution

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

      Parse error: syntax error, unexpected variable "$password" in C:\xampp\htdocs\project\details_entry.php on line 4

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

    I tried to create the form and php connection file but when i submit the browser is keep on circling instead of submitting the data no other error. Please help me with that.

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

    bro form submit krne k baad Homepage open hona chahiye wo kaise hoga...how to link homepage in login.html page..................if we are adding php page in login page....i want homepage to be opened...................make a video in which u would show how to store data of many web pages like login.html, delivery address.html etc

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

    Mine is showing connection failed after submitting.. pls help

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

    Thanks a lot for the awesome tutorial!!!!!

  • @033ehtishamulhaq9
    @033ehtishamulhaq9 2 года назад

    oxm video tnx

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

    Sir I not able to install php on windows NT please help

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

    Awesome

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

    Thanks, your a legend.

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

    its quite a long shot but im is serious need of help rn, do you have disccord and we could jump in a screenshare call to help me solve the issue, im currently doing a university project

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

    i am getting this error - syntax error, unexpected '$conn' (T_VARIABLE) in C:\xampp\htdocs\details_entry.php on line 7 can u help bro

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

      Yes...pls u chk the conn variable...apne joh localhost diya hai..wohi liya hai...and comma se properly separate kiya hai kya

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

      @@TechNiyojan bro ek do mistake thi but ab aara connection failed

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

      sab rectify kiya maine but mere dsure form mein bhi yahi error aara tha and ab isme bhi
      passwords wagarah sab achhe se daale hai then to ni aara bro

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

      Chk your xamp installation MySQL.ini settings file..if possible I will let u know in a video.. regarding all these errors..

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

    sir i have a connection failed when i try to log in . pls help

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

    Undefined variable: sql in on line
    Error: Unknown column 'fafsfa' in 'field list
    this is the error can you solve it pls,
    THANKS

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

      Yes pls chk the column name u given in the table and that u have supplied in the query does both are same...if not then this error will give

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

    perfect👌👌

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

      Students pls share with ur friends and help motivate me to make more to help u students

  • @Sabu47566
    @Sabu47566 7 месяцев назад +1

    it's working Thanks❤

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

    Fatal errer Uncaught Error: Undefined constant "localhost in E:\xampp\htdocs\ details.php:4 Stack trace: #0 (main) thrown in E:\xampp\htdocs\ details.php on line 4
    Sir please help me

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

      have you found the solution? i'm having the same problem rn

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

      I have uploaded a video for all doubts or error you all receive chk playlist of xammp

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

      Pls chk the playlist doubt solution video for all your doubts of xamp

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

    nice video
    bro agar me school ke student ki details baru to space to kam nahi hoga

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

    Thanks a loT Sir❣️❣️

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

    hi i was try this all step but my data entry are not show in phpmyadmin please help me sir

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

      Sure...will upload a video performing these steps...soon in 2 days

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

      @@TechNiyojan ok sir

  • @gameingtech3191
    @gameingtech3191 7 месяцев назад

    my form is not opening in localhost

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

    i had done everything but when i fill the form and submit it the page shows error and no data is stored in database

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

      Check the datatype in table...u taken are same as you are trying to insert into the table....and also check the query string....bcoz even if a comma is mistakley placed will not able to insert the data

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

      Same for me please help

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

    you are awesome,
    thank you

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

    THANK YOU!

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

    How to find the required feild

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

    I got "File not found" after submit

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

    It's so useful

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

    thank you brother

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

    there was no explanation to the connection code linking the php to the database, you just copied it from some where an pasted it there

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

    code chahiye mere ko , milega ??