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

Create Web Application using PHP and MySQL. How to connect to mysql database using PHP. How to fill HTML table from database using PHP. How to perform CRUD operations using PHP and MySQL.
********************************
Source code on Patreon: / php-and-mysql-84465280
********************************
Install XAMPP: • How to Install XAMPP 8...
********************************
SQL Queries:
CREATE TABLE clients (
id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
name VARCHAR (100) NOT NULL,
email VARCHAR (200) NOT NULL UNIQUE,
phone VARCHAR(20) NULL,
address VARCHAR(200) NULL,
created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
);
INSERT INTO clients (name, email, phone, address)
VALUES
('Bill Gates', '[e-mail]', '[phone]', 'New York, USA'),
('Elon Musk', '[e-mail]', '[phone]', 'Florida, USA'),
('Will Smith', '[e-mail]', '[phone]', 'California, USA'),
('Bob Marley', '[e-mail]', '[phone]', 'Texas, USA'),
('Cristiano Ronaldo', '[e-mail]', '[phone]', 'Manchester, England'),
('Boris Johnson', '[e-mail]', '[phone]', 'London, England');
*************************** .
***********************************
🔥 Complete Udemy Courses :
Build E-commerce Web Application using ASP.NET Core : www.udemy.com/course/aspnet-c...
Build E-commerce Web API using ASP.NET Core : www.udemy.com/course/build-as...
Build E-commerce Web Application using React JS : www.udemy.com/course/build-co...
⬇️ Free Document Proofreading ⬇️
► Grammarly : grammarly.go2cloud.org/SH3YB

[@alfredgithinji3166]

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

[@happythrottlemotomedia5529]

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

[@A_ALI24]

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

[@carlosjunior2108]

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

[@abdulhaq6060]

I love your programming tutorials on CZcams.

[@murtazausmani7004]

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

[@MrTizinator]

Appreciate it that Bob also made it on the list

[@mineaks]

Great video. Thanks for the effort taken to show this

[@fishworxify]

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

[@Kashalot24]

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

[@Sai-nr4tw]

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

[@ramsuthar3473]

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

[@rajithadeshan2908]

100% agreed

[@fernavas123]

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

[@SoftwareScience]

Thanks the best CRUD video on this platform

[@randyortiz6151]

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

[@user-ld2yx6vs9t]

It was really helpful. Thank you very much!

[@user-so5he3op1q]

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

[@HansAllende]

So easy explain, very helpful, thanks!

[@phc_kaodin]

Thank you for making such a great tutorial

[@infodiff]

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

[@BoostMyTool]

Thank you for your support

[@abdumunib2417]

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

[@BhootFmOfficial786]

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

[@musadayel4673]

😊

[@Dhika653]

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

[@mayonnaise.8210]

How do you fix the edit part?

[@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

[@faktahati1007]

Nice Course It's worked thank you so much

[@ChandrajeetPratapSinghCJay]

great tutorial for php mysqli html table !!!

[@riya_sharma1709]

Thank you sir for this video 😊

[@ashutoshgangwar2665]

Thanks for this imp topic that you have covered

[@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

[@techwithdenzel]

Great tutorial.

[@sukateknologi159]

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

[@waelzad4655]

Great Example !

[@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!

[@miguelangelperezsantiago783]

Thank you very much Sr.

[@marcinzale]

Very good tutorial.

[@user-cp4sk7rb3v]

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.

[@nimijoshy5319]

really very usefull...thank u

[@HelloWorld-so9uj]

Thank you very much❤❤.

[@nooni213]

شكرا استاذ🙏🙏

[@abdelkadertalbi7063]

that was amazing tutorial sir

[@keepitsimple3645]

awasome video thanks very much

[@kat3586]

Best teacher

[@lucaabg3796]

Best tutorial ☺️☺️

[@eurryherry1484]

thank you sir you help me a lot.

[@trannhan1432]

Thank you!

[@shakyxd]

Thank you so much

[@anonymous_0717]

Thank you so much ☺

[@hsgaming1251]

bro your language is fantastic

[@hallatkordo4544]

Thank you god bless

[@AlphaNdiaye-yr4xq]

Thank's you so much

[@abovethenimbus]

thankyou i can now graduate

[@khash1163]

thank you!

[@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.

[@xcrud1.7crud13]

Nice!!

[@Oprekode]

nice tutorial

[@vjpadron07]

excelente video muy

[@cmcotrading]

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

[@Henry_Nunez]

👍🔔 Very good

[@selsoluis1569]

Top!

[@AlphamanKing]

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

[@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

[@teeyiheng4697]

Thank you very much, I have learned a lot.

[@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?

[@shreyas8534]

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

[@omarhafez9272]

الشكر برشا

[@mohammedalostath5434]

thanks

[@BirhalsBR]

Obrigado.

[@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?

[@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?

[@JohnMarkDue]

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

[@user-yi4uq4dx8h]

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

[@benmakhloufaya5037]

merci bcp

[@mo_zidan7259]

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

[@waelzad4655]

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

[@carrothed760]

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

[@user-hj5xj6pq5o]

excellent video... do u have any course to buy about php?

[@marisberzins4895]

where did u lost SuccessMessage after successfull now client registration ?

[@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.

[@unior2676]

Sir can you plz write error message and success message display code here

[@WebCrafters-yo7ju]

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

[@leticiamarianifranca812]

MUITO BOM🤙

[@atienzaivanreint.9818]

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

[@Beastfan_0-i3x]

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

[@zedmedia727]

Thank you for making such a great tutorial, it helped me a lot, It is possible to ask you question related to php, are you on instagram?

[@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

[@jakobdylancelestialcordero2329]

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

[@nadjibdz6838]

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

[@ISHAKBOUSHAKISaida-xf8fn]

Excelent 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?

[@Laoland]

Where can I get the source code sure?

[@mal4797]

Can the website be opened properly on phones?

[@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)

[@medhabibbenyoussef9391]

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

[@arm5379]

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

[@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?

[@viane123456]

Can you share a source code?

[@maakelolohea2778]

A link for the source code would be great thanks

[@alizanisar6672]

can i get the source code i followed your video and its giving me the warning erros

[@alainlado]

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

[@Dewnam]

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