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

Рет қаралды 492,917

2 жыл бұрын

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', 'bill.gates@microsoft.com', '+123456789', 'New York, USA'),
('Elon Musk', 'elon.musk@spacex.com', '+111222333', 'Florida, USA'),
('Will Smith', 'will.smith@gmail.com', '+111333555', 'California, USA'),
('Bob Marley', 'bob@gmail.com', '+111555999', 'Texas, USA'),
('Cristiano Ronaldo', 'cristiano.ronaldo@gmail.com', '+32447788993', 'Manchester, England'),
('Boris Johnson', 'boris.johnson@gmail.com', '+4499778855', '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

Пікірлер: 212

@happythrottlemotomedia5529 2 жыл бұрын

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 7 ай бұрын

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

@abdulhaq6060 2 жыл бұрын

I love your programming tutorials on KZfaq.

@A_ALI24 2 жыл бұрын

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

@murtazausmani7004 2 жыл бұрын

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

@fishworxify Ай бұрын

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

@mineaks Жыл бұрын

Great video. Thanks for the effort taken to show this

@Kashalot24 6 ай бұрын

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

@SoftwareScience Жыл бұрын

Thanks the best CRUD video on this platform

@ramsuthar3473 Жыл бұрын

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

@rajithadeshan2908 11 ай бұрын

100% agreed

@fernavas123 Жыл бұрын

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

@user-ld2yx6vs9t 4 ай бұрын

It was really helpful. Thank you very much!

@HansAllende Жыл бұрын

So easy explain, very helpful, thanks!

@user-so5he3op1q Жыл бұрын

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

@phc_kaodin 2 жыл бұрын

Thank you for making such a great tutorial

@infodiff 4 ай бұрын

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

@BoostMyTool 4 ай бұрын

Thank you for your support

@randyortiz6151 Жыл бұрын

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

@Dhika653 Жыл бұрын

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

@mayonnaise.8210 Жыл бұрын

How do you fix the edit part?

@abdumunib2417 2 жыл бұрын

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

@BhootFmOfficial786 2 жыл бұрын

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

@musadayel4673 Жыл бұрын

😊

@2007protsenko 7 күн бұрын

Very helpful, thank you👍

@faktahati1007 Жыл бұрын

Nice Course It's worked thank you so much

@ChandrajeetPratapSinghCJay 2 жыл бұрын

great tutorial for php mysqli html table !!!

@Oprekode 10 күн бұрын

Nice learning brother

@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

@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

@waelzad4655 Жыл бұрын

Great Example !

@riya_sharma1709 Жыл бұрын

Thank you sir for this video 😊

@sukateknologi159 Жыл бұрын

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

@techwithdenzel 2 жыл бұрын

Great tutorial.

@kat3586 4 ай бұрын

Best teacher

@marcinzale 7 ай бұрын

Very good tutorial.

@abovethenimbus 2 ай бұрын

thankyou i can now graduate

@abdelkadertalbi7063 Жыл бұрын

that was amazing tutorial sir

@lucaabg3796 2 жыл бұрын

Best tutorial ☺️☺️

@nimijoshy5319 5 ай бұрын

really very usefull...thank u

@miguelangelperezsantiago783 Ай бұрын

Thank you very much Sr.

@hsgaming1251 Жыл бұрын

bro your language is fantastic

@muhammadhusaynamilaiyub6911 4 ай бұрын

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?

@keepitsimple3645 Жыл бұрын

awasome video thanks very much

@eurryherry1484 Жыл бұрын

thank you sir you help me a lot.

@HelloWorld-so9uj 10 ай бұрын

Thank you very much❤❤.

@trannhan1432 11 ай бұрын

Thank you!

@user-cp4sk7rb3v 2 жыл бұрын

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.

@nooni213 8 ай бұрын

شكرا استاذ🙏🙏

@user-yi4uq4dx8h 4 ай бұрын

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

@Henry_Nunez Жыл бұрын

👍🔔 Very good

@anonymous_0717 Жыл бұрын

Thank you so much ☺

@shakyxd Жыл бұрын

Thank you so much

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

@Oprekode Жыл бұрын

nice tutorial

@khash1163 7 ай бұрын

thank you!

@ryoma8801 8 ай бұрын

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.

@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

@hallatkordo4544 Жыл бұрын

Thank you god bless

@AlphaNdiaye-yr4xq 5 ай бұрын

Thank's you so much

@xcrud1.7crud13 Ай бұрын

Nice!!

@FranekMobile 2 ай бұрын

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.

@vjpadron07 Жыл бұрын

excelente video muy

@cmcotrading Жыл бұрын

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

@selsoluis1569 Жыл бұрын

Top!

@WebCrafters-yo7ju 22 күн бұрын

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

@waelzad4655 Жыл бұрын

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

@yeyestravelbites 4 ай бұрын

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?

@AlphamanKing 6 ай бұрын

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

@teeyiheng4697 Жыл бұрын

Thank you very much, I have learned a lot.

@shreyas8534 Жыл бұрын

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

@JohnMarkDue 3 ай бұрын

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

@mohammedalostath5434 Жыл бұрын

thanks

@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

@atienzaivanreint.9818 Жыл бұрын

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

@yahyadede9133 2 жыл бұрын

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 9 ай бұрын

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

@omarhafez9272 6 ай бұрын

الشكر برشا

@BirhalsBR Жыл бұрын

Obrigado.

@marisberzins4895 Жыл бұрын

where did u lost SuccessMessage after successfull now client registration ?

@benmakhloufaya5037 9 ай бұрын

merci bcp

@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

@arm5379 Жыл бұрын

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

@jakobdylancelestialcordero2329 Жыл бұрын

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

@CodeWithAffan1 Жыл бұрын

Edit and delete not working

@carrothed760 Жыл бұрын

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

@nadjibdz6838 Жыл бұрын

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

@benedekszabo9121 10 ай бұрын

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 9 күн бұрын

I know that

@zekrom6537 6 ай бұрын

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 5 ай бұрын

me pasa lo mismo

@medhabibbenyoussef9391 Жыл бұрын

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

@mal4797 2 ай бұрын

Can the website be opened properly on phones?

@leticiamarianifranca812 4 ай бұрын

MUITO BOM🤙

@zedmedia727 2 жыл бұрын

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?

@mo_zidan7259 Жыл бұрын

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

@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 9 ай бұрын

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

@pendragontv945 Жыл бұрын

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

@unior2676 2 жыл бұрын

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

@user-hj5xj6pq5o 11 ай бұрын

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

@alainlado Жыл бұрын

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

@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 8 ай бұрын

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