Тёмный

PHP CRUD Operations with MySQL Database | Create ✨, Read 🔍, Update 🔄, Delete ❌ 

AUZ Tutorials
Подписаться 2,9 тыс.
Просмотров 52 тыс.
50% 1

PHP CRUD Application | Create ✨, Read 🔍, Update 🔄, Delete ❌
Welcome to an exciting tutorial where we delve into the world of CRUD operations (Create, Read, Update, Delete) in PHP and MySQL. In this hands-on guide, we'll walk you through building a Book List Project that allows you to perform essential database operations.
🔥 Topics Covered:
Setting Up a MySQL Database for Our Project
Creating the PHP Functions for CRUD Operations
Building a User-Friendly Web Interface
Implementing Create, Read, Update, and Delete (CRUD) Features
💡 Empowering Your Web Development Skills:
CRUD operations are the backbone of dynamic web applications. By mastering these essential techniques, you'll be well-equipped to create interactive and data-driven websites and projects.
📚 Project-Based Learning:
Our Book List Project serves as a practical example to reinforce your understanding of CRUD operations. You'll see how PHP and MySQL come together to manage and display data.
🚀 Who Is This Tutorial For:
This tutorial caters to web developers of all levels, from beginners looking to expand their skills to experienced coders seeking a comprehensive CRUD project. Join us in building a valuable real-world application.
After watching the tutorial you will be able to know.
1. How to connect PHP with MySQL database using phpMyAdmin
2. How to create a book list project in PHP and MySQL
3. How to insert or save HTML form data into MySQL database.
4. How to read data from MySQL database using PHP
5. How to update data in MySQL database using PHP
6. How to delete data from MySQL database using PHP
7. How to use bootstrap to design html form
🌟 Stay Tuned:
Our commitment to your web development journey continues! Be sure to subscribe to our channel for more tutorials, projects, and in-depth guidance. We're here to help you achieve your coding goals.
Github link of the project:
github.com/ironman-zaman/php-...
📚 Links and Resources:
MySQL Official Website - www.mysql.com/
PHP MySQLi Documentation - www.php.net/manual/en/book.my...
Bootstrap (Front-End Framework) - getbootstrap.com/
Perhaps this will catch your attention:
Step-by-Step Tutorial on Constructing a Simple CMS with PHP and MySQL
• 🚀 How to Build a Basic...
Website
auztuts.com/
You can join this Facebook group to discuss problems and ask your questions.
/ 930382041470136
You can also follow me on Facebook , Twitter and LinkedIn
Facebook:
/ auz.tutorials
Twitter:
/ aktar_uz_zaman_
LinkedIn:
/ md-aktaruzzaman-a16205134
#php #mysql #phpproject #crudoperations
Let's embark on this exciting journey into CRUD operations and database-driven web development. If you find this tutorial valuable, please give it a thumbs up, share it with fellow learners, and feel free to ask questions or share your thoughts in the comments section below.
Thank you for being part of our web development community! 🚀🌐💻

Опубликовано:

 

26 ноя 2022

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 76   
@auztuts
@auztuts Год назад
You can find the project files in description
@rokaiaissocute
@rokaiaissocute Год назад
thank you so much!!! needed the tutorial for few errors i had in my code, very helpful :)
@auztuts
@auztuts Год назад
You are welcome!
@yutsacarm8021
@yutsacarm8021 Год назад
amazing video please produce more vid like this
@auztuts
@auztuts Год назад
Sure. Keep in touch please
@user-fx5uo7uz7p
@user-fx5uo7uz7p 11 месяцев назад
thats a fantastic tutorial i really get whats going on now.
@auztuts
@auztuts 11 месяцев назад
Thank you! I am happy that you enjoyed the tutorial.
@leo_7684
@leo_7684 8 месяцев назад
It's so amazing man it works very well and beautiful
@auztuts
@auztuts 8 месяцев назад
Thank you!
@mortalanzang7567
@mortalanzang7567 8 месяцев назад
Thank you! good job
@auztuts
@auztuts 8 месяцев назад
You are welcome
@shamalikumarage5804
@shamalikumarage5804 Год назад
Thank you ❤️
@auztuts
@auztuts Год назад
You are welcome!
@ovieolori2398
@ovieolori2398 Год назад
Awesome
@auztuts
@auztuts Год назад
Thanks
@phuquocnguyen4900
@phuquocnguyen4900 Год назад
I hope you will come up with more PHP lessons
@auztuts
@auztuts Год назад
Sure. Keep in touch please.
@keifinityy
@keifinityy 2 месяца назад
Thanks brother you helped me finish our system for our final project.
@auztuts
@auztuts 2 месяца назад
You are welcome!
@NikolaTesla282
@NikolaTesla282 Год назад
Thank you
@auztuts
@auztuts Год назад
Welcome
@shivambatholiya_mcl
@shivambatholiya_mcl 9 месяцев назад
thanks
@auztuts
@auztuts 9 месяцев назад
You're welcome!
@muhammadsyaiful5296
@muhammadsyaiful5296 Месяц назад
you are the best broo!!
@auztuts
@auztuts Месяц назад
Thank you!
@rspnato
@rspnato 2 месяца назад
Very nice my friend! Thanks!
@auztuts
@auztuts 2 месяца назад
Thank you!
@maymarquez869
@maymarquez869 18 дней назад
I had so much fun in your tutorial it's so very helpful. I hope you made more tutorial, especially in admin side. Thank youu so much.
@auztuts
@auztuts 17 дней назад
I am glad that it helped you. I will try to create new tutorial. Thank you!
@maymarquez869
@maymarquez869 17 дней назад
@@auztuts please make tutorial, how to make index for food ordering delivery system. Because I don't understand the logic of how to create a php index for customers.
@mdtarek4852
@mdtarek4852 4 месяца назад
Really outstanding ❤❤
@auztuts
@auztuts 4 месяца назад
Thanks!
@WPExplained-wp2xp
@WPExplained-wp2xp 4 месяца назад
Awesome session bro!❤
@auztuts
@auztuts 4 месяца назад
Thank you!
@marekgacekdev
@marekgacekdev Месяц назад
cool tutorial bro!
@auztuts
@auztuts Месяц назад
Thanks for the visit!
@quinten-info
@quinten-info Год назад
Here is the code for the PhpMyAdmin (insert into SQL tab): CREATE TABLE `books` ( `id` int(11) NOT NULL, `title` varchar(250) NOT NULL, `author` varchar(25) NOT NULL, `type` varchar(50) NOT NULL, `description` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
@abegailcaducio8934
@abegailcaducio8934 7 месяцев назад
Why is it doesn't display book added successfully ang book deleted successfully
@krishna_mahaur
@krishna_mahaur Год назад
make a video on Multilevel dynamic menus kind of tree structure
@auztuts
@auztuts Год назад
Ok. I have a plan.
@hassanaftah966
@hassanaftah966 8 месяцев назад
hi Not Found The requested URL was not found on this server. Apache/2.4.54 (Win64) PHP/8.0.26 mod_fcgid/2.3.10-dev Server at localhost Port 80 why this message?
@auztuts
@auztuts 8 месяцев назад
Please make sure you configure the XAMPP software correctly. Does the default localhost link works for you?
@user-wk2xe7lf9x
@user-wk2xe7lf9x 6 месяцев назад
Great video but I don't understand why did you close PHP on minute 32:18 on while loop and made a new one right below it only for the "}"
@auztuts
@auztuts 6 месяцев назад
No matter what amount of PHP code you add, whenever you add PHP code you will have to use PHP tag.
@kingdatig1985
@kingdatig1985 10 месяцев назад
hi bro i add more books then the row has no end. its going down how to limit the row and just scrolling it
@auztuts
@auztuts 10 месяцев назад
Hi, for that you will need to add pagination. That is some more PHP code. Hopefully I will come up with another video where I will show the pagination. Thank you!
@kingdatig1985
@kingdatig1985 10 месяцев назад
Done bro?
@JOHNCENTDUMALE
@JOHNCENTDUMALE Год назад
Can you add "All fields are required" error? I hope you can help me
@auztuts
@auztuts Год назад
Hi, Error handling is not done in this particular tutorial. I will add error handling in my next video or I will upload the updated code here. Thank you!
@sithumbandara7199
@sithumbandara7199 2 месяца назад
🥰😍
@lingarajbhuvan1404
@lingarajbhuvan1404 3 месяца назад
sir,can you tell me the path of connect.php,please?
@auztuts
@auztuts 3 месяца назад
HI, it is in the root directory. So the path is the name of the file itself.
@MASTIMEMOOD
@MASTIMEMOOD Год назад
In your book list id will not show proper number System why.is any error.in thumbnail show four book but his numbering is different not sequencial.
@auztuts
@auztuts Год назад
Hi, you are right. That's the ID of a particular book not a sequence.
@MASTIMEMOOD
@MASTIMEMOOD Год назад
@@auztuts ok thanks bro
@SSLove-eu5if
@SSLove-eu5if 10 месяцев назад
Can you pls add another one field for inserting image plss😢
@auztuts
@auztuts 9 месяцев назад
I will do another video about that
@auztuts
@auztuts 3 месяца назад
Please check out this video to understand how to upload images to database ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-adMjzWiG21U.html
@josanvillar3600
@josanvillar3600 Год назад
Can you pls add "all fields are required"
@auztuts
@auztuts Год назад
Hi, Error handling is not done in this particular tutorial. I will add error handling in my next video or I will upload the updated code here. Thank you!
@user-yn8do2sk3p
@user-yn8do2sk3p 10 месяцев назад
Please doctor can you provide the code?
@auztuts
@auztuts 10 месяцев назад
Hi, it is in the description of the video. If you still can not find it, it is here github.com/ironman-zaman/php-crud
@osebey2456
@osebey2456 5 месяцев назад
I'm getting the "Something went wrong" error, I wonder why?
@auztuts
@auztuts 5 месяцев назад
Hi, probably something is wrong with the database. Maybe the database credential you provided on connection file is not correct.
@tuktuk001
@tuktuk001 Год назад
Hi. how can i add search field?
@auztuts
@auztuts Год назад
Hi, you can add a new form field on top. And on submit of the form , you can use MySQL LIKE operator to search the data. This is the format of the SQL. SELECT column1, column2, ... FROM table_name WHERE columnN LIKE pattern; I will come up with a new tutorial for this in future
@something_u_like
@something_u_like 4 месяца назад
Hindi me boliye na please
@auztuts
@auztuts 4 месяца назад
Sorry. The contents of this channel are in English. Also I am not an Indian.
@yuridizgonzales5112
@yuridizgonzales5112 Год назад
bro i have error after i click submit it says Parse error: syntax error, unexpected token "}" in C:\xampp\htdocs\prob\process.php on line 28
@auztuts
@auztuts Год назад
can you send me your process.php file ?
@lolibonmamo3410
@lolibonmamo3410 10 месяцев назад
guys what is wrong with this code?
@auztuts
@auztuts 10 месяцев назад
HI, there is nothing wrong with the code. However, it still may result error that can be caused by other code related to this file. There can be other reasons too. What is the exact problem you are facing?
@lolibonmamo3410
@lolibonmamo3410 10 месяцев назад
oky guys i was fixed it thank you bro u are best guys i expect more vedio from you@@auztuts
@hamzachaudhary9221
@hamzachaudhary9221 10 месяцев назад
Warning: Undefined array key "description" in E:\xammp\htdocs\CRUD\process.php on line 8 same error bro @@auztuts
@auztuts
@auztuts 10 месяцев назад
can you post this problem in the Facebook group please and upload your source code?@@hamzachaudhary9221
Далее
Это конец... Ютуб закрывают?
01:09
Laravel Tutorial For Beginners (Simple User CRUD App)
1:16:13
#12. Search Data using PHP and MySQL database.
34:09
Просмотров 91 тыс.
Save HTML Form Data to a MySQL Database using PHP
24:38
Это конец... Ютуб закрывают?
01:09