PHP CRUD (Create, Update, Delete) with MySQL on a single page

[@AwaMelvine]

💥User registration and login system: kzbin.info/www/bejne/iZnFeaqXnt6CptU

[@shrutisarnaik7042]

Awa Melvine My all codes working perfectly but when i open index.php it show update form rather than save becuase of that i cant insert data Plz help

[@tricksmix5627]

Brother,i think you should add this in your description.It's help for quick display learn. 00:01 - Demo 01:24 - Intro 05:48 - Create database 06:42 - Insert into database 11:06 - Display records from database 13:00 - Display notification messages 15:28 - Update records 24:54 - Delete records 27:02 - Thank you @Awa Melvine

[@MertYerlikaya]

00:01 - Demo 01:24 - Intro 05:48 - Create database 06:42 - Insert into database 11:06 - Display records from database 13:00 - Display notification messages 15:28 - Update records 24:54 - Delete records 27:02 - Thank you @Awa Melvine

[@AwaMelvine]

You're the best. Thank you, too

[@ishaqsg]

You done great job. No voice but every thing is clear..

[@Addicted2OILau]

Thanks buddy, took me all day to go through this , but got there in the end, truly the only only way to learn programming is to do it type it out and go through the frustrations and figure it all out. Thanks for uploading , thumbs up

[@AwaMelvine]

You have said it very well. Cheers!

[@KixMayne91]

For this CRUD portion, thank you SO MUCH, you truly helped me gain a better understanding for this subject.

[@kydrontillis5732]

Going to go ahead and prevent anyone that's in beginner stages of PHP from making the same mistake I did. In your server code, in the "update stages" use mysqli instead of mysql. I kept getting syntax errors, until i finally found out that mysql has depreciated. You wont have to do any extra editing. It should help. Bless

[@AwaMelvine]

Thank you Kydron Tillis, for this.

[@20simoontje]

Even beter use PDO.

[@truecodemedia5099]

Yes PDO is the best option.

[@sheynko306]

i changed it but it doesnt work either

[@tsaxiurgerelt8293]

@@sheynko306 if (isset($_POST['update'])) { $name = mysqli_real_escape_string($db, $_POST['name']); $address = mysqli_real_escape_string($db, $_POST['address']); $id = mysqli_real_escape_string($db, $_POST['id']); mysqli_query($db, "UPDATE info SET name='$name', address= '$address' WHERE id=$id"); $_SESSION['msg'] = "Address updated"; header('location: index.php'); }

[@HE360]

Excellent tutorial. It helped me further understand how PHP works!

[@pavanvspk8928]

I love your way of programming bro. Keep posting... An Indian

[@dimitrimokotsolane6719]

You the man! Couldn't have done this without you. Thank you so much.

[@tsumokd7616]

You're the best man.....thank you very much....cause of you i finish my project in database...

[@cyrilkariyawasam977]

Excellent Tutorial Gentleman. Very professional.I tried and 100% working. Thanks a lot for your Time.

[@kmakashahkma]

Thank you so much sir, with your tutorial, I manage to create simple and understand how this syntax works. 😁😁😁

[@navaarunbhattacherjee4511]

Everything works fine except the "Update" functionality. However, I appreciate your effort to help the beginners with "simple but elegant PHP coding" idea!

[@allanpimble7198]

If the 'Update' functionality is the only issue you are having, you probably using version 7.x of PHP, and this code is written for version 5.x. There should be a letter i after mysql in the functions: $name = mysqli_real_escape_string($db, $_POST['name']); And the mysqli_real_escape_string function must contain two parameters, your database connection - ($db, and the text you wish to escape - $_POST['name']) which gives you ($db, $_POST['name']). In version 5.x you did not need the database connection string in the function. I hope this helps.

[@navaarunbhattacherjee4511]

Thanks for your valuable advice! But I somehow solved this problem that day! (:

[@sahilvernekar596]

Navaarun Bhattacherjee can you please tell me as I'm stuck there

[@kinelekaite3878]

really nice tutorial bro.. may God Bless you

[@infantsimon2757]

Successfully I did it .. Thank U bro... God bless U.. Keep doing.

[@nayeemchowdhury2497]

when ID is show in table edit option is not work. can you explain it.

[@amirulafiq4371]

Hi I'm currently doing a final report on my industrial training CRUD project and I was wondering if you could help me determine the strengths and weaknesses of the system itself

[@kashmir398]

I have a problem. my code was working well until i started coding for update records. the error just shows " unexpected end of file. I tried searching if i missed out any brackets in both index.php or server.php but i cant seem to get where the problem is. I hope you can help me on this

[@guillaumekieffer489]

Thanks a lot, I had a problem with the update and your video solved it.

[@jayangachandeepa4571]

I have a problem. i'm using wampserver, not xwamp. so i have error Call to undefined function mysql_real_escape_string() so i change my code into $name = mysqli_real_escape_string($db, $_POST['name']); so after that there no any error.but don't update the database. how i solve it??? please help me.. thank you.

[@euroseleonida937]

Thank you sir for this tutorial it helped us a lot on the system we are working on right now for our final requirement :)

[@pavant8761]

Hi... What is the purpose of SESSION concept here? Why to use especially? Plzz clear to this novice. Tq

[@emilcruz3087]

i cant fix it line 25 Whats the problem uncaught undefine why?? plsss tell me what is the problem in line 25 >??

[@robertdeanmarti5749]

the delete button last part of the video doesn't work on my web delete when I click the delete nothing happen

[@coffelova]

same for me, i don't know how to fix it

[@muthokabrian2138]

thanks melvine,,your code well illustrated and works perfectly

[@hamzahaider5401]

I'm not get source code who you have draw in description

[@hamadmobeen5923]

Really appreciate your video. Taught me a lot. Great content. Keep up the good work.

[@gameworlduk6657]

kzbin.info/aero/PLdoUjOuWL_owKZgygdcljLwa1ShdGvIp1

[@aishwaryaverma7129]

in address update getting this error "mysqli_fetch_array() expects parameter 1 to be mysqli_result"

[@armandnduwamungu41]

how come mysql_real_escape_string is unidentified for me

[@rasangalakshith1141]

adarei assignment eka goda dammata. ummmmmmmmwah

[@akhilkazi1454]

How to count deleted and inserted rows in same page.

[@reybasilio6075]

This is GREAT and LEGIT! Thanks AWA! Upload videos about security please!!!

[@arrontaylor5613]

Keep getting an error undefined variable “edit_state”

[@marcos.wilson]

u just save my life dude! tuvm

[@haribalakrishnan162]

thank you so much bro.its very timely help for me bro

[@trixiesherlacpregil4036]

can i have the source code for this? im having a hard time trying to fgure out the errors

[@tutyhutabarat6310]

The message showed that it was updated but the letters didn't change. Help me!

[@philt7568]

By the is there a way where you have a third button and once you click on it it remove the data and insert it to another table database?

[@kebronsolomonzerie3523]

You saved my life bro thank you

[@trekwithchetaas]

Very Helpful Video Bro Thank You

[@luzvimindab.mollaneda8964]

why update records codes don't work for me?

[@mhmzdev]

Jani you are great! English: You are great brother

[@Arthursama25]

Awesome tutorial, it helped a lot!

[@mdenamulhasan4787]

Thanks I was humbly needed

[@antonioaquino8954]

Bro this is a life saver. damn it! Good Job!

[@gurudevtechno6788]

THANK U SO MUCH CODER.....IT WORKS PERFECTLY

[@babydimplesz64]

GuruDev Techno how did you do it? I can’t do it 😔😔

[@ralphtalaro3725]

Hi sir i have problem on update Fatal error: Uncaught Error: Call to undefined function mysql_real_escape_string() in C:\xampp\htdocs\crud\server.php:24 Stack trace: #0 {main} thrown in C:\xampp\htdocs\crud\server.php on line 24

[@ralphtalaro3725]

this code work for me. $name = mysqli_real_escape_string($db, $_POST['name']);

[@knzdespair]

PLEASE HELP ME WITH THIS PROBLEM " Warning: count(): Parameter must be an array or an object that implements Countable in C:\xampp\htdocs\crud\index.php on line 8 " It occurs when I'm clicking the EDIT BUTTON....

[@denniskipkoech566]

Thanks, the soruce code was well minimalist

[@KkKk-og3of]

Really very best method thank you sir

[@apolovzla_ccs]

i know this question may sound stupid but... how... how did you copy code from the html file and copied it to the css file and it was all set just by copying it? Once again, I know it may sound stupid but... how? 😵

[@rmedia3467]

what r u clicking at 12:10

[@ruthvitech4925]

help me---- in update process--- its not going to update/edit data..its updating new row of record..how to slove this...

[@jonyhernandez2256]

Men pleaseee! help me, i have a select list with fk on another table, and the edit dont work... help meee

[@fts1293]

Can anyboy help with the source code? In the video and on the site it seems other code is mixed together. On the website tutorial the code is different from here. Anyone got it working on php 7 ?

[@syahira7786]

Sir why when i updated selected row it updated all rows with the same information. Pls help me!

[@myfav3405]

Can u help me?, i'm still new in php,html and css. how did you paste those syntax in css. What is the shortcut key to copy in the index.php to paste into style.css. Does sublime text need to download some plugin in order to do that.? Thank you

[@michaelpulga7760]

please help!!! if i click save then the record will be saved on the database but when i refresh on the page after i click save the record on the database will duplicate. its like its saving again if you refresh after you click save. how to fix this? TIA

[@noirblack7360]

Again, thank you for exsisting.

[@charlesbaylon6600]

the .msg css not working, the same with fetching the record to be updated. Wtd? Thank u

[@abimbolaayo658]

Hi, I just tried using this code, the Name and Address are throwing errors. I am also unable to save , edit or delete.

[@camillo9999]

Could you help me with my problem? I got stuck in 21:25, when I check "Edit", the fields are fill up first's values and next I click on the another "Edit" and nothing is changing, I see still first postion, in the belt of address of page is this "localhost/phpcrud/index.php?edit=0". I use PHP 7.2 so I changed mysql to mysqli but it doesn't work :-(

[@camillo9999]

I solved the problem, i had a problem with my database, i didn't have autoincrement option in ID, i changed that and now everything is OK;-)

[@owaisipoetry6412]

Thank you for very helpful video. Keep doing. all the best

[@marshallmathers1047]

Man you are the best...I got solution completey..

[@archanasharma1484]

Plz help me i have use mysqli bt my edit button znt updating d table

[@ofirt7]

Thank you for the great tutorial! I have one question though when I click on "edit" or "delete" the page is refreshing and I see in the video that your page isn't refreshing on every click, do you know how can I fix it?

[@souhayleBartale]

great job, thankyou

[@Sajib-qb5py]

how u get css code just a one click

[@simplynmadula8783]

No connection with database. HELP. Beginner feels huhu 😖 I am using wamp

[@danielmolla1239]

Thank you! You saved me!

[@buzznut]

YESSSS YOU ARE A LEGEND !!, THANKS ALOT

[@viniciustinga]

Thanks a Lot....Awa Melvine!!!

[@animalinstinct2023]

Thank you very much!

[@lukedodson3441]

everything working thanks for the help

[@azuretasugach6124]

it works nicely

[@shivamnamdeo6867]

i wna minor updates if rows have same data then delete option shows on both rows if (rany row==any row){ then delete option will show both rows and delete those rows } kindly rlp yyyy mee about thissss

[@sakuramikan01]

"no date resources are configured to run this sql" name is fine but in address, it displays that message. i wonder what was wrong

[@Ireland1981]

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given in /opt/lampp/htdocs/PhpCrud/index.php on line 65 Please help

[@zoranmarkovic1295]

I have the same problem. I can't find a solution.

[@chowdhurymobarrathaider9052]

github.com/adnanchowdhury007/CRUD here is the full code

[@serdarkshadow2455]

@@chowdhurymobarrathaider9052 thank you, the codes runs really well.

[@whitee0272]

salut j'essaye de suivre votre projet pas pas tout allé bien jusqu'au partie de la SESSION le probleme c'est que le code css ( .msg ) ne marchait pas pour cette partie merci de m'aider svp

[@Andres33260]

thanks for share your knowledge, I can learn easily...

[@AwaMelvine]

Thank you Andres. I'm glad it helped.

[@Rohit-si5uf]

superb bro your source code helped me.

[@veinoyusuf4101]

Parse error: syntax error, unexpected end of file, expecting elseif(T_ELSEIF) or else(T_ELSE) or endif(T_ENDIF) in...myfile. Please reply as soon as possible. Thank u!

[@rjmacalino3186]

you initialize the value of ID = 0; if you create another record then the record will have 0 ID then you won't be able to create another record because you already have a record that has "0" ID and as you may know the ID is primary key.

[@saacmntnz]

thats my problem. how to solved it?

[@valentinbuliga1775]

make id auto_increment

[@yelarysbadelkhan9101]

Hello guys, from where he takes the path to database? He wrote ('localhost','root', '', 'crud'), in time: 7:14.

[@whitee0272]

from the folder where there is your program his folder's name is Crub and yours you should put it on "www" if you are working with wampserver

[@asahinamikage6818]

THANK YOU VERY MUCH BROOO! AWESOME VIDEO!

[@omara229]

@Awa Melvine Hey I don't get the source code? What is that? Do I have to turn it into .php?

[@AwaMelvine]

Hey Omar Ali, you can get the source code here: goo.gl/UzEuDt Thanks for watching

[@keerthanarajeev1328]

You are a blessing!!

[@temirkhanamanbaev42]

Thanks man, good job!

[@azkanabilahauliyaurrohman2628]

hai can you answer im following all the codes everything work except update it not change after I update the data

[@azkanabilahauliyaurrohman2628]

and after all this is the only one tutorial that help me in CRUD a lot so thankyou verymuch

[@snehasishdebnath7330]

data is not inserting in the database .pls help

[@varshaganger8798]

thank a lot sir these code is helpful to me as i try in other site video

[@aiswaryasatheesh8863]

Thank you sir..❤️😊

[@safouanelharrak3660]

it's work thank you Sir

[@andalesjasminepearly.9308]

Uncaught TypeError: mysqli_fetch_array(): Argument #1 ($result) must be of type mysqli_result, null given in C:\xampp\htdocs\php_crud app\index.php:17 Stack trace: #0 C:\xampp\htdocs\php_crud app\index.php(17): mysqli_fetch_array(NULL) #1 {main} thrown in C:\xampp\htdocs\php_crud app\index.php on line 17 how to fix this sir? plz help me

[@saidajaraam5255]

thanks for this vedio it's very usefull for me

[@mohamedriyas645]

This code how to create popup model edit delete button

[@pakde_ka]

how you make the css script automatic like that ?

[@fuadmuhammadn.7658]

I wanna ask, what sublime plugin do you use in this video?

[@dartv1337]

Thank you so much for the codes!