This is a great tutorial Senaid. I hope you can continue creating this kind of content. One question is it possible to update the table list after the save button and the modal page is still on top so that if the user can continue entering data. In short, refresh on save rather than hitting the browsers refresh button. Thank you.
Hello, Senaid im always watching your tutorial and I saw everytime you will create new database, you always add utf-8 unicode c3 I just want to know, what is the purpose of that.. Thank you, I will Learned a lot from you, Your a Great Teacher, Keep it up
Thank you, and I am sorry that I didn't reply earlier, just saw this comment. The purpose of that is that you basically can use any type of characters inside your table, without getting some weird.
Hi! Thanks a lot for this tutorial. Now the problem is: after clicking submit, the modal does not close; how to fix it? Moreover, how to reset modal content after submit click? I'm trying to refresh table content after modal submit, any ideas? Regards
I know im asking randomly but does any of you know of a tool to get back into an instagram account? I was dumb forgot my login password. I love any tips you can give me.
@Cory Israel I really appreciate your reply. I got to the site on google and Im waiting for the hacking stuff atm. I see it takes quite some time so I will get back to you later when my account password hopefully is recovered.
Bro you are on fire. Such quality videos. You are making development so much fun. A small request, whenever you get time, sometime in future, if you can make something with php which has a payment system, it will be very helpful.
Oh, thank you so much for nice words and support! Yes, for sure I can create a tutorial on how to add some payment system to your website. Written in my notes already... :)
Hi Thank you very much for this wonderful tutorial, but I have a problem, when I click the Save button, no data is saved Getting the following error: access to xmlhttprequest at 'file:///c:/xampp/htdocs/php_ajax_crud application/ajax.php' from origin 'null' has been blocked by cors policy: cross origin requests are only supported for protocol schemes: http, data, chrome, chrome-extension, chrome-untrusted, https. How to solve the problem, please advice.
Thank you for your excelent tutorials and for your will to help other people!! Would you please check what is happening with the downloading of the source code. I follow the instructions and no email is received to proceed witih the download. Thank you and best regards.
Thank you for your effort but I think there is a big issue that you have to refresh the screen after adding a new country to be shown in the datatable on screen. If you can modify your code to avoid this issue will be great.
Yes, great suggestion. I have completely forgot to show that in the video, but if you check the comments below I am sure you can find my solution to that problem.
Hello I have problem with view the data from database in my project But I am using PDO instead of mysqli I have done the part with adding to database through pdo But the view I dont know how to solve Any ideas?
Great tutorial. can you make or help us in making a finance base system. the process of money flow and stuffs.. thank you for the help.. Learned a lot!!
Hi Thank you very much for this wonderful tutorial, but I have a problem, when I click the Save button, no data is saved Get the following error: Failed to load file: /// C: /xampp/htdocs/ziadnew/ajax.php: Cross origin requests are only supported for protocol schemes: http, data, chrome, chrome-extension, https. How to solve the problem
I am getting the error, "Notice: Trying to get property 'num_rows' of non-object in C:\xampp\htdocs\mdb\ajax.php on line 19 reachedMax". Does anyone have any info on how to fix it?Thanks
i'm getting this error and i don't know how to fix it, please help. Failed to load resource: the server responded with a status of 502 (Bad Gateway):63342/Source%20Code/ajax.php:1
Hi senaid, im not getting how to insert data from input form though I hv written code in different way, its not inserting into my phpmyadmin db (own server space) Please help to solve this. Thanks in advance!
This is the error am getting, i checked with this, but there is no such thing i found: [18-Apr-2018 05:46:25 Etc/GMT] PHP Parse error: syntax error, unexpected '"', expecting identifier (T_STRING) or variable (T_VARIABLE) or number (T_NUM_STRING) in /home/myvisstg/public_html/new_curd/controller/addDetail.php on line 32
Oh my dear friend, what I've got is the whole php codes within the ajax.php displayed on the alert(responds), it seems like the ajax here is just load the whole ajax.php code into the index.html, but the codes within the ajax.php are not excecuted, what should I do? Thank you~!
Hi friend, that problem is fixed, yet another one has occurred, the problem should be existing somewhere in here: if($avr = 'addNew'){ $sql = $conn->query("SELECT id FROM country WHERE countryName = '$name'"); if($sql->num_rows>0){ exit("Country with this name already exists!"); }else{ $conn->query("INSERT INTO country (countryName, shortDesc, longDesc) VALUES ('$name','shortDesc','$longDesc')"); exit ('Country has been inserted!'); } } the reminder said: "trying to get property of non-object." Thank you very much mate! Viktor
Senaid, What PATH or folder would I put your ajax.php and index.html under? It seems not to ADD data to mySQL. I get no error, in fact I get no messages. Nothing happens when I click SAVE. It seems the URL: 'ajax.php', parameters are not executing?
That so nice of you to respond so quickly. This what I get in Firefox dev console: XML Parsing Error: no root element found Location: file:///c:/xampplite/htdocs/CRUD-Step-1/ajax.php Line Number 46, Column 3: ajax.php:46:3 XML Parsing Error: no root element found Location: file:///c:/xampplite/htdocs/CRUD-Step-1/ajax.php Line Number 46, Column 3: ajax.php:46:3 back tab addListener: restorebar content_script.js:128:4 XML Parsing Error: no root element found Location: file:///c:/xampplite/htdocs/CRUD-Step-1/ajax.php Line Number 46, Column 3: Line 46 is at the ?> of the ajax.php Here is my path setup: C:\xampplite\htdocs\CRUD-Step-1/index.html C:\xampplite\htdocs\CRUD-Step-1/ajax.php It seems CRUD-Step-1/ajax.php cannot find the mySQL database. Here is the path to mySQL folder: C:\xampplite\mysql\bin NOTE: The xampplite has been implemented using the DesktopServer (serverpress.com). This allows WordPress Development in your localhost. I don't want to install another xampp-lite or xampp. I am using Windows 10 latest update....
Aloha Senaid, have you tried accessing access your code using Google Chrome browser instead of Ubuntu lately. I understand Google changed their browsers. This Utube was done last August 2017. You need to verify your code to see if it works!!!
Friend, thanks for these videos that are very good, a query please, I am new to this programming class and everything goes well however between the boxes that my form has I have a select that is related to another table that is in my base data and I do not know how to recover or show the data of that select. I explain myself better I have two tables: User with the fields: id, nombre, apellido, país_id(foreign key) Pais with the fields: id, nombre The problem is that I do not know how to display the name of the country that has a user in the user's edit window. Thanks for the help
Thanks for replying friend, what I do not understand is how I can show by means of a select the data that another table can have, in this case the pais table and thus be able to modify the value that the pais_id field of the user table may have. Once again thank you for your response
When someone selects the data, in that select, you will have their pais_id and then from the PHP side all you need to do is to update users table WHERE pais_id = selected pais_id. Get it?
JUN/24 almost JUL/2018 and the e-mail with code was sent correctly and hyper fast into my InBox. BUUUUUUT the code isn't opening or downloading.. Anyway, can you send me the codes? I'm running against the time... Thank you, Senaid,
I do have two different tutorials for files uploading (image included): - ruclips.net/video/M8mLkeP7rB4/видео.html - ruclips.net/video/O4MDyzhSY7Y/видео.html
i didnt get any results on my page after all the code i think somethink went wrong with the part getExistinData ? do you maybe now what i possible did wrong? #youtheman
Amazing Series Videos i have A problem if i want to update input type="file" is not acceptable and the console input error like this : Uncaught DOMException: Failed to set the 'value' property on 'HTMLInputElement': This input element accepts a filename, which may only be programmatically set to the empty string. at HTMLInputElement. i want to update file please help me what i can do if i want to update uploaded file .
Coding Passive Income I want to Update Form That include Files and Options when I try To apply your Idea to this Form I faced problem that I can sended early So Can you give me any idea or even Make Tutorial of Like Form Al so my form Has dependent Selected Options. Thansk for your time and your quick Replies.
Hello! I'm getting the same problem. I think it is from the getExistingData function. It keeps getting called infinitely and displays ReachedMax after it displayed all the data. What seems to be the problem? Ps: i removed the add new button so. the problem might be connected to it. But idk where and how 😓 Pps: great teacher though! Thanks
Hmm, ok. But what that problem has to do with the problem stated above? Probably you didn't set up properly addNew button. Please check how I did it in the video.
![PHP Ajax CRUD Application Tutorial - MySQL & Bootstrap & jQuery DataTables [Part 2]](http://i.ytimg.com/vi/6DdOe44b_ns/mqdefault.jpg)
![PHP Ajax CRUD Application Tutorial - MySQL & Bootstrap & jQuery DataTables [Part 2]](/img/tr.png)
![PHP Ajax CRUD Application Tutorial - MySQL & Bootstrap & jQuery DataTables [Part 3]](http://i.ytimg.com/vi/KjcWzbaO9No/mqdefault.jpg)
![Eminem - Fuel (feat. JID) [Official Lyric Video]](http://i.ytimg.com/vi/t5H_CewqpKA/mqdefault.jpg)
Thanks a lot, everything is very clear and works fine! First step to build the bills mini app. for my old dad
Awesome, glad I could help you! :)
Thank you, I like the tutorial very informative, but also I like the atmospheres and the lights colors you are in. You got new subscriber.
Thank you so much!
This is a great tuit and im seeing few likes lets share and let this champ do more tuits to help alot of aspiring programmers.
Thank you so much, you are amazing!
Hi! i'm having trouble getting the data to show on the table...
update: just solved my problem forgot the great video man keep it up!
You should be on Udemy, very clear teaching style , thanks!
gianluca ruggieri Thank you so much!
Many many happy RETURNS of the day for this video no words to say thanks.
Awesome, I am so happy that I could help you. On Wednesday and Friday, I will release parts 2 and 3. :)
I'm watching you with great interest. I'm waiting for other good videos on this channel. I like this series, greetings from Romania.
Thank you so much! Appreciate the support. :)
nice video, simple method, easy to understand
Great tutorials ... thanks man .
Respect for sharing knowledge free to others.
My pleasure, thank you! :)
This is a great tutorial Senaid. I hope you can continue creating this kind of content. One question is it possible to update the table list after the save button and the modal page is still on top so that if the user can continue entering data. In short, refresh on save rather than hitting the browsers refresh button. Thank you.
Yes, that is possible, and if I am remember correctly I am showing how to do it in later parts of this tutorial.
Hello, Senaid im always watching your tutorial and I saw everytime you will create new database, you always add utf-8 unicode c3 I just want to know, what is the purpose of that..
Thank you, I will Learned a lot from you,
Your a Great Teacher, Keep it up
Thank you, and I am sorry that I didn't reply earlier, just saw this comment. The purpose of that is that you basically can use any type of characters inside your table, without getting some weird.
Hi! Thanks a lot for this tutorial. Now the problem is: after clicking submit, the modal does not close; how to fix it?
Moreover, how to reset modal content after submit click?
I'm trying to refresh table content after modal submit, any ideas?
Regards
Senaid, after several tries I was able to download the source code. Thank you again for sharing your knowledge in there fine tutorials!!!
I know im asking randomly but does any of you know of a tool to get back into an instagram account?
I was dumb forgot my login password. I love any tips you can give me.
@Josue Felix instablaster ;)
@Cory Israel I really appreciate your reply. I got to the site on google and Im waiting for the hacking stuff atm.
I see it takes quite some time so I will get back to you later when my account password hopefully is recovered.
@Cory Israel It did the trick and I finally got access to my account again. Im so happy:D
Thanks so much, you saved my account !
@Josue Felix happy to help xD
Bro you are on fire. Such quality videos. You are making development so much fun.
A small request, whenever you get time, sometime in future, if you can make something with php which has a payment system, it will be very helpful.
Oh, thank you so much for nice words and support! Yes, for sure I can create a tutorial on how to add some payment system to your website. Written in my notes already... :)
You are the man! :)
thank you :)
Hi
Thank you very much for this wonderful tutorial, but
I have a problem, when I click the Save button, no data is saved
Getting the following error:
access to xmlhttprequest at 'file:///c:/xampp/htdocs/php_ajax_crud application/ajax.php' from origin 'null' has been blocked by cors policy: cross origin requests are only supported for protocol schemes: http, data, chrome, chrome-extension, chrome-untrusted, https.
How to solve the problem, please advice.
oohhh man ur are the greatest tearcher u just help so much keep it up
it's my pleasure, thank you! :)
Thank you for your excelent tutorials and for your will to help other people!!
Would you please check what is happening with the downloading of the source code. I follow the instructions and no email is received to proceed witih the download. Thank you and best regards.
Thank you for your effort but I think there is a big issue that you have to refresh the screen after adding a new country to be shown in the datatable on screen. If you can modify your code to avoid this issue will be great.
Yes, great suggestion. I have completely forgot to show that in the video, but if you check the comments below I am sure you can find my solution to that problem.
@@SenaidBacinovic Thank you so much
@@mahmoudtalaatelhakim Hi. Were you able to add that functionality. i am trying the ajax.reload but it always throw an error. Thanks
Hello I have problem with view the data from database in my project
But I am using PDO instead of mysqli
I have done the part with adding to database through pdo
But the view I dont know how to solve
Any ideas?
Great tutorial. can you make or help us in making a finance base system. the process of money flow and stuffs.. thank you for the help.. Learned a lot!!
Thank you so much for nice words. I will think about that and probably make a tutorial for you. :)
Hi
Thank you very much for this wonderful tutorial, but
I have a problem, when I click the Save button, no data is saved
Get the following error:
Failed to load file: /// C: /xampp/htdocs/ziadnew/ajax.php: Cross origin requests are only supported for protocol schemes: http, data, chrome, chrome-extension, https.
How to solve the problem
I am getting the error, "Notice: Trying to get property 'num_rows' of non-object in C:\xampp\htdocs\mdb\ajax.php on line 19
reachedMax". Does anyone have any info on how to fix it?Thanks
can you make the datatable auto load after crud data ?
great job Coding Passive Income
plz do a crud system with images and files like this one
there is no one done this video
we need it
Svaka čast :)
Hvala ;)
Great tutorial. 😊
Thank you !!
Can you make an password recovery with 3 security questions?
Hii do u have tutorial crud with images or pdf file and did u can explain deep about for what you did in your code how it works and why
I don't have with images, but why don't you just watch those video tutorials?
I am getting the error, "Maximum call stack size exceeded". Does anyone have any info on how to fix it?
Can you show the code where you experience that problem?
you are a life saver, thank you very much, thank you i'm Grateful to you :)
thank you :)
i'm getting this error and i don't know how to fix it, please help.
Failed to load resource: the server responded with a status of 502 (Bad Gateway):63342/Source%20Code/ajax.php:1
How to get the data without refreshing the browser?
Please answer me 😊
Thank you
please why aren't you doing video again?
i keep getting an error that says $.ajax (index line 84) is not a function
a big guy with a small voice thanks!
hehe, thank you :)
Is there is using MySQL Sir?
Hi Senaid, I'm connecting database using PDO php. Data is inserting in database but not showing in Table.
Have you watched my tutorial about PDO? I believe it will help you solve the issue.
Okay... Let me watch..... :)
The best! Keep it bro ❤️
thank you :)
What kind of the PHP is it? It's different from what I studied.
Hmm, PHP is PHP, there isn't different versions. Maybe you have been learning some frameworks?
Please make this video with just vanilla JavaScript. Thanks
Make a tutorial for datatables server side processing
Will do, thank you :)
Hi senaid, im not getting how to insert data from input form though I hv written code in different way, its not inserting into my phpmyadmin db (own server space)
Please help to solve this.
Thanks in advance!
This is the error am getting, i checked with this, but there is no such thing i found:
[18-Apr-2018 05:46:25 Etc/GMT] PHP Parse error: syntax error, unexpected '"', expecting identifier (T_STRING) or variable (T_VARIABLE) or number (T_NUM_STRING) in /home/myvisstg/public_html/new_curd/controller/addDetail.php on line 32
Below is the code for above error:
$conn = openConnection();
$addsql = "INSERT INTO `abc`.`holiday_tbl` (`type`, `tagline`, `dest_name`,`dest_descri`,`pricing`,`days`,`nights`,`itenary`) VALUES
('".$type."','".$tagline."', '".$dest_name."','".$dest_descri."','".$pricing."','".$days."','".$nights."','".$itenary."');
$resultbot = $conn->query($addsql);
if ($resultbot == TRUE) {
$output = array();
$output["status"] = "OK";
echo json_encode(array("result"=>$output));
}
===============
Your so awesome.... please help me.. i got this error syntax error, unexpected ':', expecting ','or ')' in ajax.php
Can you show me the code?
Brother can u do Dot Net MVC C#
Source Code link not work
great video
everything is fine except the special characters are not showing and when having a special character can not click Edit, View
thank you so much sir for help nice video
Thank you so much! Appreciate the support. :)
ur welcome i am always waiting your video every days new things you uploaded really nice sir
Thank you very much.....
RUclips Yop thank you :)
Oh my dear friend, what I've got is the whole php codes within the ajax.php displayed on the alert(responds), it seems like the ajax here is just load the whole ajax.php code into the index.html, but the codes within the ajax.php are not excecuted, what should I do? Thank you~!
In most cases that happens if you forget to put exit() at the end of your ajax request (in PHP), so just make sure to do it and you should be fine. :)
Cool, thank you for your help, I'll give it a try, I'm such a beginner here, again, appreciate for what you've done on the youtube!
Hi friend, that problem is fixed, yet another one has occurred, the problem should be existing somewhere in here: if($avr = 'addNew'){
$sql = $conn->query("SELECT id FROM country WHERE countryName = '$name'");
if($sql->num_rows>0){
exit("Country with this name already exists!");
}else{
$conn->query("INSERT INTO country (countryName, shortDesc, longDesc) VALUES ('$name','shortDesc','$longDesc')");
exit ('Country has been inserted!');
}
}
the reminder said: "trying to get property of non-object."
Thank you very much mate!
Viktor
I've fixed with other way round ^^; thank you~
Amazing, glad you made it!
Senaid, What PATH or folder would I put your ajax.php and index.html under? It seems not to ADD data to mySQL. I get no error, in fact I get no messages. Nothing happens when I click SAVE. It seems the URL: 'ajax.php', parameters are not executing?
Do you have any error in console? Can you see what happens when/if ajax request has been made?
That so nice of you to respond so quickly. This what I get in Firefox dev console:
XML Parsing Error: no root element found
Location: file:///c:/xampplite/htdocs/CRUD-Step-1/ajax.php
Line Number 46, Column 3:
ajax.php:46:3
XML Parsing Error: no root element found
Location: file:///c:/xampplite/htdocs/CRUD-Step-1/ajax.php
Line Number 46, Column 3:
ajax.php:46:3
back tab addListener: restorebar content_script.js:128:4
XML Parsing Error: no root element found
Location: file:///c:/xampplite/htdocs/CRUD-Step-1/ajax.php
Line Number 46, Column 3:
Line 46 is at the ?> of the ajax.php
Here is my path setup:
C:\xampplite\htdocs\CRUD-Step-1/index.html
C:\xampplite\htdocs\CRUD-Step-1/ajax.php
It seems CRUD-Step-1/ajax.php cannot find the mySQL database.
Here is the path to mySQL folder:
C:\xampplite\mysql\bin
NOTE:
The xampplite has been implemented using the DesktopServer (serverpress.com). This allows WordPress Development in your localhost. I don't want to install another xampp-lite or xampp. I am using Windows 10 latest update....
I got this error
html.html:68 Uncaught TypeError: $.ajax is not a function
Mrodmal have you included jQuery library?
Aloha Senaid, have you tried accessing access your code using Google Chrome browser instead of Ubuntu lately. I understand Google changed their browsers. This Utube was done last August 2017. You need to verify your code to see if it works!!!
Friend, thanks for these videos that are very good, a query please, I am new to this programming class and everything goes well however between the boxes that my form has I have a select that is related to another table that is in my base data and I do not know how to recover or show the data of that select.
I explain myself better I have two tables:
User with the fields: id, nombre, apellido, país_id(foreign key)
Pais with the fields: id, nombre
The problem is that I do not know how to display the name of the country that has a user in the user's edit window.
Thanks for the help
Sorry man, but I really don't understand what is the problem. Any pictures?
Thanks for replying friend, what I do not understand is how I can show by means of a select the data that another table can have, in this case the pais table and thus be able to modify the value that the pais_id field of the user table may have. Once again thank you for your response
Have you watched part2 of this series?
Yes, but since I am new to this programming class, I do not understand very well. :(
sorry but now if you understand my doubt?
When someone selects the data, in that select, you will have their pais_id and then from the PHP side all you need to do is to update users table WHERE pais_id = selected pais_id. Get it?
JUN/24 almost JUL/2018 and the e-mail with code was sent correctly and hyper fast into my InBox. BUUUUUUT the code isn't opening or downloading..
Anyway, can you send me the codes? I'm running against the time... Thank you, Senaid,
Can you just reply to that email?
Can you please refactor the code to the MVC model that will be great. Thank you.
Yup, I might create a new series to show how to do it.
do you have tutorial about uploading image .?.
I do have two different tutorials for files uploading (image included):
- ruclips.net/video/M8mLkeP7rB4/видео.html
- ruclips.net/video/O4MDyzhSY7Y/видео.html
Thanks alot
Sir why we need to refresh the browser to get the data?
Can we get the data right after clicking save or save changes?
Hii Senaid, I have downloaded source code i din't get it. Please check once.
Please check it Senaid, i dint get source code...
I tried downloading the source code, but nothing happened. I didn't recieve any emails. Is there another way to download the source code?
Hmm, that's weird. Can you please just reply to the email without source code and I will send it to you?
thank you
thank you :)
i didnt get any results on my page after all the code i think somethink went wrong with the part getExistinData ?
do you maybe now what i possible did wrong?
#youtheman
Can you show me the code or maybe download the source code and compare it?
Amazing Series Videos i have A problem if i want to update input type="file" is not acceptable and the console input error like this :
Uncaught DOMException: Failed to set the 'value' property on 'HTMLInputElement': This input element accepts a filename, which may only be programmatically set to the empty string.
at HTMLInputElement.
i want to update file please help me what i can do if i want to update uploaded file .
Mohamoud Osman Hamud Thank you. How do you want to update it?
Coding Passive Income I want to Update Form That include Files and Options when I try To apply your Idea to this Form I faced problem that I can sended early So Can you give me any idea or even Make Tutorial of Like Form Al so my form Has dependent Selected Options. Thansk for your time and your quick Replies.
Modal javascript does not work
can i get that code ?? i always get error at ajax.php
Sure, just download it from my website.
I m getting infinity times data in a table..... plz help me to resolve this problem .....
Did you check what is different in your code then in my?
there is no difference b/w yours n mine code
Hmm, it must be. Did you try to download the source code and compare it?
Hello! I'm getting the same problem. I think it is from the getExistingData function. It keeps getting called infinitely and displays ReachedMax after it displayed all the data. What seems to be the problem?
Ps: i removed the add new button so. the problem might be connected to it. But idk where and how 😓
Pps: great teacher though! Thanks
why i can't download this code ?
I have just replied to your email. :)
good evening please can you send to me the source code because i have errors in my source code
Just download it from my website, you have the link in the video description.
👍
Why is this creating an infinite loop on my example ? :( Anyone else ?
Megatron Ultra Brutal Destroyer same. Did you find any solution?
hahhahaha nice voice :D
LOL :)
Thank you
thank you :)
why i can't download this code ?
What is the problem?
Coding Passive Income when i press addNew the tableManager didnt show up
Hmm, ok. But what that problem has to do with the problem stated above?
Probably you didn't set up properly addNew button. Please check how I did it in the video.