PHP and MySQL with CRUD Operations: Create, Read, Update, Delete

[@happythrottlemotomedia5529]

I just started studying Visual Studio and you my friend is the best and my favorite teacher. Thank you

[@alfredgithinji3166]

Wow! What an awesome video. I am already feeling confident working with PHP having come from the JavaScript world.

[@carlosjunior2108]

Excelent video! I'm brazilian and with my poour english i managed to do. You are very good teacher.

[@GeronimoEmbang]

Hi can you send me the code of that?

[@shinyamauchi82]

this is very simple, quick, understandable, ANYTHING THAT IS SMOOTH AND NOT COMPLICATED. THANK YOU SIR! 😃

[@murtazausmani7004]

I Love You Mate, I was doing a freelance project and I was stuck but you helped me! Thanks

[@abdulhaq6060]

I love your programming tutorials on KZbin.

[@Dhika653]

OMG ITS WORKED! Guys it really worked. Thank you maboy

[@mayonnaise.8210]

How do you fix the edit part?

[@unknown-j1r3q]

@@mayonnaise.8210 how to fix the edit

[@MrTizinator]

Appreciate it that Bob also made it on the list

[@A_ALI24]

Concise course. Well prepared. Well presented. Thank you very much. Keep up. All the best.

[@fishworxify]

AWESOME!!! Just what I was looking for. Beautifully explained and presented!!!!

[@infodiff]

Thank you so much. Joined u on patreon as well.

[@BoostMyTool]

Thank you for your support

[@unknown-j1r3q]

@@BoostMyTool HOW CAN I FIX THE UPDATE BRO?

[@ramsuthar3473]

This tutorial is amazing and you are really good at teaching !! great job sir !

[@rajithadeshan2908]

100% agreed

[@Sai-nr4tw]

THANK YOU MISTER THIS REALLY A BIG HELP IN MY CAPSTONE PROJECT!!! THANKS YOU VERYY MUCHHHH

[@Silaghy]

Thanks the best CRUD video on this platform

[@BhootFmOfficial786]

Amazing. i have just watched this full video. easy explanation. waiting for more videos.🤚

[@musadayel4673]

😊

[@nicoschulz4037]

Nice video with good explanation. Worked for me even without the source code. Took a while, but it worked. Just one quick question: Is there a simple way to add a confirmation to the delete-button before deleting? Thanks in advance.

[@Kodexx_roy]

Hello, can you help me out

[@Kashalot24]

Thank you so much! Everything is worked. You really helped me. Thank you, teacher

[@EDITVERSE37]

Bro In 20:49 what comes after aria-label

[@malysn7]

did u get the code?

[@zekrom6537]

button type='button' class='btn-close' data-bs-dismiss='alert' aria-label='Close'>

[@AdílioNeto-h3x]

It was really helpful. Thank you very much!

[@mineaks]

Great video. Thanks for the effort taken to show this

[@JippiMonster]

When I click edit it says: "Invalid query: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1". Did anyone know why?

[@mayonnaise.8210]

This is my problem right now, I don't know what is the problem is😢

[@BaukeC]

What if you remove the '' around the $id in the query (...... WHERE id=$id")

[@benedekszabo9121]

Almost everything is working correctly, but in the edit and in the delete always write that the id variable is not set to the URL. If i write the id manually to the URL (for example 'localhost/myshop/delete.php?id=1) it's working. Does anyone detected this problem?

[@hocngoaingucungtrong1601]

I know that

[@ابوأحمد-ث9ت4ض]

شرح اكثر من رائع شكرا لك عزيزي

[@CodeWithAffan1]

Edit and delete not working

[@Kaptan_Gezer]

20:11 I cannot read the code here: .....label='Close'>

[@malysn7]

did u get the code?

[@Kaptan_Gezer]

@@malysn7 I wrote it myself

[@kat3586]

Best teacher

[@2007protsenko]

Very helpful, thank you👍

[@nooni213]

شكرا استاذ🙏🙏

[@yahyadede9133]

i have error in post method " Undefined variable $_post in " he said Trying to access array offset on value of type null in C:\xampp\htdocs\xampp\update.php on line 46 can plz tell me why is that happen

[@BaukeC]

you should use: $_POST['....'] (capitals)

[@fernavas123]

Thanks! Excellent video! Really helped me. Congrats! You're amazing

[@NetReklam-om3ds]

Thanks for the tutorial but on some parts it's impossible to see the code Example: at time 20:14 at time 20:49 it's impossible to see the bootstrap code I haven't finished the course for now. I hope there are no more parts where you can't see the code.

[@abovethenimbus]

thankyou i can now graduate

[@randyortiz6151]

This is an excellent lesson and the code works. Thank You!😊

[@Mr.samomar]

I was get problem Here 24:09 When I use same Email, It's not only show the error massage It will break the code. Then I used try catch to solve the problem. try { $sql = "INSERT INTO clients (name, email, phone, address) VALUES ('$name', '$email', '$phone', '$address')"; $result = $connection->query($sql); } catch (\Exception $e) { $erorrMsg = "Invalid Query: " . $connection->error; break; }; Now it's working fine, Thank you so much for this tutorial.

[@seint1044]

thanks brother

[@Mr.samomar]

@@seint1044 Your welcome

[@zekrom6537]

wow thank you was worth reading all comments to finally find a solution, my guess is that the youtuber added some extra lines somewhere that we cant see in the video thats why it doesnt work for us but does for him, but its not erorrMsg its errorMessage you made a typo there i assume but it works

[@KpegloMakafui]

I clicked on the resubmit form when working on this project the new client form is no longer loading or showing any help

[@WebCrafters-yo7ju]

What would I do if I had radio buttons with the value part already filled

[@zekrom6537]

at min 24 for some reason mine refuse to show the error message correctly with the yellow box around it and just shows a white page saying fatal error on line 34 in the create.php and that line is within these 3: $sql = "INSERT INTO clients (name, email, phone, address)" . "VALUES ('$name', '$email', '$phone', '$address')"; $result = $connection->query($sql);

[@adrianromero7503]

me pasa lo mismo

[@djskipe]

Thank you bro! Very helpful

[@faktahati1007]

Nice Course It's worked thank you so much

[@arnoldmesa2813]

Hi I have a problem in my New client form when the data is not complete and you send it to delete the data of the cost the problem reaches the modify button when I press the modify button there is no data in the new customer form If you can help me with this please

[@JohnMarkDue]

do you have a tutorial like this that not using bootstrap? thanks..

[@HansAllende]

So easy explain, very helpful, thanks!

[@hsgaming1251]

bro your language is fantastic

[@benoittheriault2635]

Since you are not binding data it’s dangerous for SQL injections. Also, data should be pas into test_input to make sure that injections is also impossible.

[@ferdinardajaba2691]

Hello. How do you bind data plz?

[@Beastfan_0-i3x]

i have some issue server saying THIS REQUESTED URL WAS NOT FOUND IN THIS SERVER what shoud i do

[@muhammadhusaynamilaiyub6911]

sir what do i do if i'm using a foreign key for example each project has different multiple task and i am using foreign key so that whenever i add a task it will get the id of the project then the tasks i added in that project will display but when i edit i want a certain task i have to get the project id and task id how do i do that?

[@nimijoshy5319]

really very usefull...thank u

[@ashutoshgangwar2665]

Thanks for this imp topic that you have covered

[@marcinzale]

Very good tutorial.

[@miguelangelperezsantiago783]

Thank you very much Sr.

[@phc_kaodin]

Thank you for making such a great tutorial

[@HelloWorld-so9uj]

Thank you very much❤❤.

[@riya_sharma1709]

Thank you sir for this video 😊

[@yeyestravelbites]

Anyone has an idea why I;m getting uncaught exception when adding duplicate email?? Instead of catching the error and showing it as a dismissable warning message?

[@abdumunib2417]

Good one , easy explanation short method thanx it helped alot in my project

[@lucaabg3796]

Best tutorial ☺️☺️

[@waelzad4655]

after applying your example ! , I have Lots of warning errors (Warning: Undefined array key "id") , would you plz, support ?

[@virginiasolomon1472]

Wonderful youtube, thank very much! I wonder how to add a dialog with 2 buttons for acknowledge to delete the client or not. Thank you!

[@ZBick]

I get an error saying access denied for user ‘root@localhost’ (using password: NO)

[@WHIROHATESTHIS]

the password should be root

[@ZBick]

@@WHIROHATESTHIS I put the password as 'root' and I am still getting the same error... "Fatal error: Uncaught mysqli_sql_exception: Access denied for user 'root'@'localhost' (using password: YES) in C:\xampp\htdocs\myshop\index.php:35 Stack trace: #0 C:\xampp\htdocs\myshop\index.php(35): mysqli->__construct('localhost', 'root', 'root', 'myshop') #1 {main} thrown in C:\xampp\htdocs\myshop\index.php on line 35" this is the error I am receiving with line 35 being "$connection = new mysqli($servername, $username, $password, $database);" in my VS.

[@papagoku1041]

@@ZBick Same have you found the fix?

[@papagoku1041]

@@ZBick Found the fix, The name of the database was the problem, The one u create in xampp, Has to be the same

[@marisberzins4895]

where did u lost SuccessMessage after successfull now client registration ?

[@Oprekode]

Nice learning brother

[@mitarzirojevic2582]

Hello, In 87 line, if loop for executions success Message, i can't see all code for executions. Because of that i have error when i try enter a new user. Same thinks is with error message. Can you please paste code of success and error message in if loop? Thanks

[@ryoma8801]

Nice tutorial all works fine on me i solve it in just an hour. But i would appreciate if you added some pop up text when clicking delete button.

[@atienzaivanreint.9818]

Can you help me, the existing data is not showing on edit page

[@FranekMobile]

Hi, How can I be able to delete records, but how can I add an alert that will confirm the deletion, but I don't know how to do it, I've been looking and nothing.

[@grum_pii]

Give an echo " alert("message ")

[@eurryherry1484]

thank you sir you help me a lot.

[@medhabibbenyoussef9391]

you didn't show us how we can display the error of duplicating an email which is unique in our data base

[@abdelkadertalbi7063]

that was amazing tutorial sir

[@arm5379]

hi, can anyone help? my $connection variable is showing undefined for this - help please

[@AlphamanKing]

Great tutorial, although you left out some things and I had to figure and refigure them out myself.

[@sukateknologi159]

Thnks a lot for your video brow, i can lerning this..

[@waelzad4655]

Great Example !

[@carrothed760]

Good tutorial, but would have been nice If we can see the source code, following from just the screen is difficult and confusing.

[@ChandrajeetPratapSinghCJay]

great tutorial for php mysqli html table !!!

[@teeyiheng4697]

Thank you very much, I have learned a lot.

[@pendragontv945]

For some reason, the edit and delete function doesn't work for me, everything else does.

[@mervenwedaye5943]

Hello sir, thanks a lot for this good you have done , could I ask you to do the same tutorial with PDO connection to the data-base. Thanks in advance

[@alainlado]

I really don't know how you were able to run the invalid query in create.php

[@cryptomoguls-ss1lh]

I'm having a problem displaying the success message

[@mal4797]

Can the website be opened properly on phones?

[@keepitsimple3645]

awasome video thanks very much

[@raevenconsolacion2449]

i donr want to add other files i only want to put all code in one file how am i supposed to do that? please help me

[@anonymous_0717]

Thank you so much ☺

[@jakobdylancelestialcordero2329]

SQL QUERY i copied on description error it has !on email same as i delete itPLS help me Tnxs

[@ΕυδόκιμοςΠετράκης-π9σ]

I want the link with bootsrap in file index.php and line 8

[@Dewnam]

I entered like 5 rows in teh database but my php only shows one row

[@techwithdenzel]

Great tutorial.

[@trannhan1432]

Thank you!

[@TUBENOLOGY]

What if the client who add his own info and admin receive infos in admin panel

[@ISHAKBOUSHAKISaida-xf8fn]

Excelent video!

[@cmcotrading]

You are amazing my dear... But my question is can i use the same file in a different computer

[@mo_zidan7259]

can you do that with ajax, I will be grateful if you help with that

[@hallatkordo4544]

Thank you god bless

[@Скофиэлд]

sir you make great tutorials thank you very much, do you think you could make one on how to make a chrome crypto prices extension or VS code extension? since they seem to be hot topics.

[@tarunbhardwaj8790]

which php version is this ?? can you please tell me asap bcoz i want to work on CI 3 via php 8...

[@BoostMyTool]

php 8.0.12

[@AlphaNdiaye-yr4xq]

Thank's you so much

[@shreyas8534]

thankyou for the tutorial but can i get the source code for this, its not available in the description box

[@jaws21015]

This is very concise but as such it was prone to errors; I spent about a month to troubleshoot this and get it to "work". I was missing end tags and syntax errors as I tried to replicate the process.

[@lucasferreira8229]

i'm having the same issue. can you help me? in the (edit.php), $sql = "UPDATE clients "."SET nome = '$nome', email = '$email', telefone = '$telefone', endereco = '$endereco' "."WHERE id = '$id' "; if I remove the ' ' from the $id, it throws an error in this line ( $result = $conection->query($sql); ) if I let it like this ( WHERE id = $id"; ) it finishes the process, but it doesn't save the data.

[@alainlado]

​@@lucasferreira8229tbh, i find it better not to concatenate and just plain write it like echo "sql query code..." Than echo "" . " " . "";

[@predestined97]

@@lucasferreira8229 Hi Lucas. Do you still need help?

[@shakyxd]

Thank you so much

[@veinkirishima07]

Thank you