Thanks for nice tutorial for us .I want to say Really nice tutorial .I have got it Today.Now I am felling so well.That's why i am commenting This site.Due to It helped a lot of.At last I Will wait next tutorial
Excellent explanation. Short and clear. I was very useful for my. i very use this video and one agen Thank you! and sir please share link in delete in database video?
Thank you so much ! I was desperately searching an option for this. My table has lots of records in it. I want it to set the height of the table and use a scroll bar to move up or down. please help.
hi i am getting this error Parse error: syntax error, unexpected 'update' (T_STRING), expecting ',' or ';' in C:\xampp\htdocs\edit.php on line 44 please help
sir, these code shows the error i.e. Parse error: syntax error, unexpected T_VARIABLE, expecting ',' or ';' in E:\xampp\htdocs\mycode\index.php on line 20
How about if a want to update all records at the same time? If I want it to update all salary of all records with one one click or button? Batch update
Great video. Helped me a lot. But one thing I want to ask is how can I update only one row or item instead of displaying all bcos if I have a long list it will be inneficient to load all datas. I just need to update one data at a gym. Can u pls pls make a video for that?
I know its late but if anyone come across your question, this will help. In the page where you want to show one record, just add the WHERE tag - $sql = "SELECT * FROM your_table_name WHERE ID='$_GET[id]'";
Hi I am creating tabular form where user will land on the form after accessing the provided unique link, there on the form he should enter or update the data when he will click on save tab button which will be provided on every tab. Can you please help me with this?, I got success for fetch the data from form and insert into the database but when update form doesn't work.
how do you update a form but if user leaves say a password field blank it doesnt update the db with a blank value and leaves the value alone in the database. i.e a password that isnt displayed to user for security reasons but they can update the password.
Sir if I want to update file photo, how to update? because in update.php I adding before update like this $photo_tmp = $_FILES[photo][tmp_name]; $photo = $_FILES[photo][name];
$sql = "UPDATE data_users SET photo = $photo , alumni= '$_POST[alumni]' WHERE username= '$_POST[id]'"; getting error
Nice video! What is needed for a confirmation message after an entry has been successfully changed? I tried using *echo* "Success!"; but I got an error.
+The Programming Geek I guess I do not know where to put a confirmation message. I thought of this (in the update.php): if (mysqli_query($con,$sql)) header ("refresh:1; url=index.php; echo 'Success';"); This did not work. Perhaps the echo statement would go in brackets? I'm not sure.
+maxcohen13 Does that code solved your problem. Put echo tag before the header function if you put echo after header the page will be redirected before showing success. And also don't use echo inside header.
Hi, I'd like to ask you to make a video. I made a database with all 3 different columns in it and about 600 rows. I made a query to filter the rows. I want the first column and second column to be read only and in the third column there should appear a checkbox. The query shows ~30 rows each time, I want to be able to tick all third columns from each row and then update them all at once with one button. If you got time, please tell me how by making a video. Thanks in advance!
Sorry, I don't speak english very well. I have a question, when i press the button, the input type don't update. I don't know why, it dosent' say error but it don't update
I have an error with the update syntax. It says "Notice: Array to string conversion in C:\xampp\htdocs\studfolio\update_prof.php on line 7" Here's the code: $sql = "UPDATE users SET fname='$_POST[fname]', mname='$_POST[mname]', lname='$_POST'[lname] where empID = '$_POST[empID]'";
The Programming Geek i have two fies .php 1st one is for the index purpose, i named it admin_registrar_pending.php. 2nd is admin_registar_update.php which is the problem file
Hii, I need a complete form with checkboxes, textfield etc, when submitted from front end, it should go to backend, where the admin is able to edit, archive and search for the form. The submitted form should be in table. My project is about a form. If information is submitted correctly, it should go to archive.. plzzzz help, if u have any references :( if possible make the video soon before 13 March. Thanks
Im getting an error with my update query. $sql = "UPDATE library SET ISBN='$_POST[ISBN]', Author='$_POST[Author]',Title='$_POST[Title]',Year='$_POST[Year]', WHERE Book_id='$_POST[id] ' ";
great friend, success always
Thank you so much ! I needed this tutorial desperately !
Great video...💪🏾
Thanks for nice tutorial for us .I want to say Really nice tutorial .I have got it Today.Now I am felling so well.That's why i am commenting This site.Due to It helped a lot of.At last I Will wait next tutorial
Excellent Tutorial. Keep it up! More php tutorials coming.
Thank you, i learnd how to make edit and delete by your videos. Thank you so much. :)
Thank you! I had to search so long for this
Thanks for your tutorial, it was really helpful for me :).
Excellent explanation. Short and clear. I was very useful for my. Thank you!
Very helpful video. Thanks a lot.
Thankyou sooooo much you have helped me a lot , BARAKA ALLAHO FIKA
Excellent explanation. Short and clear. I was very useful for my. i very use this video and one agen Thank you! and sir please share link in delete in database video?
Good job.👌
Next time attach the files in the description so that it can be downloaded.
Your are the best
Awesome video... Keep up the great work!!!!
Great video thanks I was totally nothing.
Done perfectly, thank you
Thank you so much ! I was desperately searching an option for this. My table has lots of records in it. I want it to set the height of the table and use a scroll bar to move up or down. please help.
Thank you, It was very simple and helpful!
you are great bro.... thank u so much........
job well done
hi i am getting this error
Parse error: syntax error, unexpected 'update' (T_STRING), expecting ',' or ';' in C:\xampp\htdocs\edit.php on line 44
please help
Good Tutorial, Thank you.
+khalid Qweder
You are welcome brother!
Executed without error thank u:)
Lot of thanks bro.
Thank you very much Boss,
i love you, thanks, this mean a lot for me
What about having just on single update or submit button?
Really good nice job bro....
+Ali Mohd mughal
Thank You Brother !
welcome Brother
Thanks! For Tutorial. I am new on the php and mysql. Just i want to know, if i want to show and update the image then what i need to do?
You re KING!
+7 football videos
Thank You ☺
7 football video
s
THANK YOU SOOO MUCH!
Hi
how can i add +1 to the value in my data base?
for example in salary you have 8000 when i clik the button add +1 to the value to get 8001
Thanks bro
Awesome bro
Thanks,
sir,
these code shows the error i.e. Parse error: syntax error, unexpected T_VARIABLE, expecting ',' or ';' in E:\xampp\htdocs\mycode\index.php on line 20
How did u resolve this?
good
Nice one!
However, The execute query for the update.php worked without the curly braces in the if statement.... Interesting
Great video
Thanks
Good Tutorial. But i want to ask what if we want to save the data to another table
Thank you!
thank you
Can we update mutiple rows in single submit button rather than updating one by one ?
How about if a want to update all records at the same time? If I want it to update all salary of all records with one one click or button? Batch update
Great video. Helped me a lot. But one thing I want to ask is how can I update only one row or item instead of displaying all bcos if I have a long list it will be inneficient to load all datas. I just need to update one data at a gym. Can u pls pls make a video for that?
+Eric Fianu I will Make the video for Update only one record.
Will be checking on it. But thanks so much
any link to that video??
need that code too, asap. kindly help please. u can email me the code at mtandimartin@gmail.com
I know its late but if anyone come across your question, this will help.
In the page where you want to show one record, just add the WHERE tag -
$sql = "SELECT * FROM your_table_name WHERE ID='$_GET[id]'";
Hi I am creating tabular form where user will land on the form after accessing the provided unique link, there on the form he should enter or update the data when he will click on save tab button which will be provided on every tab. Can you please help me with this?, I got success for fetch the data from form and insert into the database but when update form doesn't work.
+sandesh nirulkar Hi Sandesh ,
I will be happy to help you.
Can you please provide the complete code , I will try to solve the problem.
Here is the code:
Please help me with this
thanks a lot :)
Thanx, can u explain how to update but one submit
how do you update a form but if user leaves say a password field blank it doesnt update the db with a blank value and leaves the value alone in the database. i.e a password that isnt displayed to user for security reasons but they can update the password.
How would you use just one button to update them all rather than having to click a separate button for each row?
Sir if I want to update file photo, how to update? because in update.php I adding before update like this
$photo_tmp = $_FILES[photo][tmp_name];
$photo = $_FILES[photo][name];
$sql = "UPDATE data_users SET photo = $photo , alumni= '$_POST[alumni]' WHERE username= '$_POST[id]'";
getting error
I already copy your codes to update my database but my database is not updating
Nice video! What is needed for a confirmation message after an entry has been successfully changed?
I tried using *echo* "Success!"; but I got an error.
Can you please give code in which you are getting error. Post that code in this comment or Fell free to contact on mohd.asim4sk@gmail.com
+The Programming Geek
I guess I do not know where to put a confirmation message. I thought of this (in the update.php):
if (mysqli_query($con,$sql))
header ("refresh:1; url=index.php; echo 'Success';");
This did not work. Perhaps the echo statement would go in brackets? I'm not sure.
+maxcohen13
Try This one:-
if(mysqli_query($con,$sql))
{
echo"Success";
header("refresh:1; url=index.php");
}
Ah, brackets. I will try. Thank you!
+maxcohen13
Does that code solved your problem.
Put echo tag before the header function if you put echo after header the page will be redirected before showing success. And also don't use echo inside header.
Video is very nice sir but video is little bit blur. Plz check this part
+Preeti Gupta
Sure I will upload future videos in good quality.
What if we have to update data of only one user how will we do that because in this code all the users are displayed at the same time.
Hi, I'd like to ask you to make a video. I made a database with all 3 different columns in it and about 600 rows. I made a query to filter the rows. I want the first column and second column to be read only and in the third column there should appear a checkbox. The query shows ~30 rows each time, I want to be able to tick all third columns from each row and then update them all at once with one button. If you got time, please tell me how by making a video. Thanks in advance!
Sorry, I don't speak english very well. I have a question, when i press the button, the input type don't update. I don't know why, it dosent' say error but it don't update
i cant update a DATE column. it throws an index error message
I have an error with the update syntax. It says "Notice: Array to string conversion in C:\xampp\htdocs\studfolio\update_prof.php on line 7"
Here's the code:
$sql = "UPDATE users SET fname='$_POST[fname]', mname='$_POST[mname]', lname='$_POST'[lname] where empID = '$_POST[empID]'";
thanks man
sir my version 5.5.38 which is supported mysql or mysqli.can u tell me please
+pravn gundeti
PHP 5.5.38 supports MySQLi
From PHP 5.5 MySQL is Deprecated, you have to use MySQLi or you can use PDO_MySQL.
Hello, i am having a problem with my update, it says successfully update but no update happening in the database, please help!
Can You Please Share your code ? , I happy to help you ,
Asim
From
The Programming Geek
should i post it here Aslim?
Yes, You can post it here.
Or you can email me at mohd.asim4sk@gmail.com
Thanks,
Asim
From
The Programming Geek
@@TheProgrammingGeek i also tried this nd i m also facing the same problem pls tell how to resolve it
hi can you please help me in creating registration system that automatically generates id ??
Parse error: syntax error, unexpected 'header' (T_STRING) in C:\xampp\htdocs\popv2\scripts\update.php
help
can it be use on php version 5?
thanks for your tutorial, but unable to update the database, pls help
Thamkyou but how can you find the total salary and install in the data base
I follow step by step , but still not updated :(
hi ,if i want to send one person's salary to other then how to do that ?
i have a problem. it keeps saying UNDEFINED INDEX at the update.php How do i fix this?
+Syamil Fuad
Hi Syamil Fuad
Can you please provide your PHP Code.
+The Programming Geek yes do i provide it here?
The Programming Geek i have two fies .php 1st one is for the index purpose, i named it admin_registrar_pending.php. 2nd is admin_registar_update.php which is the problem file
1st file codes:
admin registrar student
.active {
background-color: #4CAF50;
}
Profile
Guideline
Apply
Official receipt
EPF withdrawal letter
Confirmation letter
Status
Logout
PENDING STATUS LIST
2nd file codes:
error shown in update query
Parse error: syntax error, unexpected '' (T_ENCAPSED_AND_WHITESPACE), expecting identifier (T_STRING) or variable (T_VARIABLE) or number (T_NUM_STRING)
Sir mere program me error nhii aa rahi h but update bhi nhii ho raha h plzz help me
How come you don't call mysql_close() ?
Do you have a link to the code?
database ko select kese karte hai
can u make loan update video as you make it
+Asim toppo
I am happy to help you, Can you please describe which tutorial you want ? I will make it for you.
Hii,
I need a complete form with checkboxes, textfield etc, when submitted from front end, it should go to backend, where the admin is able to edit, archive and search for the form. The submitted form should be in table.
My project is about a form. If information is submitted correctly, it should go to archive..
plzzzz help, if u have any references :( if possible make the video soon before 13 March. Thanks
how to reduce the value by updating
for form of type='submit', you dont have name. Dont know how is it working for u
sir code error dera echo (T_ECho)
Name Age Salary show the out put in browser
can anyone send the code? I have an assignment in less than hour :(
Welcome to spaghetti code
Im getting an error with my update query.
$sql = "UPDATE library SET ISBN='$_POST[ISBN]', Author='$_POST[Author]',Title='$_POST[Title]',Year='$_POST[Year]', WHERE Book_id='$_POST[id] ' ";
+Guru101
What error is shown , please paste that error.
yeah dude! 4 out 5 tutorials end up in an error. this is seen as easy and in a pain in the ass
remove the colon( , ) after [ Year]'
does anyone have source code for this?
Tysm sir please send me the code please
Pls tutorial in hindi
help me????
source code?
Dislike for no source code
thoda aache se Btao bhai
sir aapka whatsapp no. kiya hai
bhai kyu farji video dal kr logo ko bewkuf ban rha hai aur IT walo ka insult kra raha hai bhai
Done perfectly, thank you
+Venkey Dematti
You are welcome !!!
+Venkey Dematti
You are welcome !!!
Thank You
Thank you ~