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

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

You're the best. Thank you, too

Thank you Kydron Tillis, for this.

Even beter use PDO.

Yes PDO is the best option.

i changed it but it doesnt work either

@@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'); }

You have said it very well. Cheers!

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.

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

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

ru-vid.com/group/PLdoUjOuWL_owKZgygdcljLwa1ShdGvIp1

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

Thanks man, remade this twice with the same error xD

Thank you Andres. I'm glad it helped.

thats my problem. how to solved it?

make id auto_increment

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

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

You saved thank you

Cool. This one helps

ron cadabuna - you are welcome

Renz Gerzon - you are welcome

where should i put this? i dont get it yet

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

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

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

Chexwa Hussen hey please help with the same problem. Thank you.

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