Great tutorial, very well explained. I am looking to extend this type of record lookup to use in generating an invoice for a PHP application I have created. My need is to look up the Description of a product from a database selecting a single product. Then I want to pull back the resulting record (id, description, price, and inventory) into a table where the user would then update the qty field. I would like to add records as they go (much like you showed in other videos). What do you recommend as the mechanism for "inserting" each selected record, while building the total list? Thanks in advance for any advice you might have
Applications like that are typically powered by more robust frameworks. You can do it using my methods, but object orientation would be the better route. Querying, Updating, and Inserting records in the database all use the same methods through jQuery that I show here. If you run into roadblocks, feel free to reach out on Skype: CoolEditz
your language is your coding language is same so very easy for you, for me is different countries, but not all US people understand coding language also
Looking for help with "Fatal error: Uncaught Error: Call to a member function prepare() on null" Ive pretty much copied right off the screen at this point but running into issues. Could it be because im using Mariadb?
Hi, Shawn , How kind of you to share this skill. I really appreciate. Thanks a million. Now, can I use this to provide a search field for my website, with my pages' contents in the database?
Hey, Adolf. You absolutely can. You would need to use a function to return all of your php files within a certain directory using foreach(glob($log_directory.'/*.*') as $file) { ... }
@@phpBasics Ah! Shawn, am sorry, I didn't understand the guidance. But am so glad to know it will work. But, do you mean that when I have fetched the data from the executed query, I should wrap the foreach loop in a function? Not sure how!! I should discard the 'while loop' ? Please assist me a bit further. My email: elleadsme@gmail.com. Thanks a lot
Hi there, How to refresh a particular DIV upon data change in the DATABASE but without reloading and refreshing the whole page? For example, IF condition checks a particular field "Order_Status" in the database and display the message accordingly on the page. But, at present user always requires to refresh the page. I want auto-refresh if database field is updated. Please guide.
I love the way you explain everything clearly. Thank's
I realize I am quite randomly asking but do anyone know a good website to watch new series online ?
@Titan Harvey I watch on FlixZone. Just google for it =)
Hey man, thanks for this. Valuable information for my project, hope you keep it up!
Thaaaaaank you so much!!! I was searching for how to do this for my project. Very well explained :D
you saved me from wasting 5 days to figure out how to make this, thnks :D
Great tutorial, very well explained. I am looking to extend this type of record lookup to use in generating an invoice for a PHP application I have created. My need is to look up the Description of a product from a database selecting a single product. Then I want to pull back the resulting record (id, description, price, and inventory) into a table where the user would then update the qty field. I would like to add records as they go (much like you showed in other videos). What do you recommend as the mechanism for "inserting" each selected record, while building the total list? Thanks in advance for any advice you might have
Applications like that are typically powered by more robust frameworks. You can do it using my methods, but object orientation would be the better route. Querying, Updating, and Inserting records in the database all use the same methods through jQuery that I show here. If you run into roadblocks, feel free to reach out on Skype: CoolEditz
Simple informative in a good way of Explation
your language is your coding language is same
so very easy for you, for me is different countries, but not all US people understand coding language also
Thank you, this was so helpful.
Greetings from México :)
Thanks for explaining detail. If Ajax code, html code and PHP code in Same file how to give a URL value in Ajax code?
And if there are no records at database it will show up "no data records". Thanks for this video it helps.
Hi! great tutorial, how do i set the max items to showup?
Looking for help with "Fatal error: Uncaught Error: Call to a member function prepare() on null"
Ive pretty much copied right off the screen at this point but running into issues. Could it be because im using Mariadb?
Great tutorial. From watching your other video, inline editing, would it be possible for the search to return an inline-editable results list?
I don't see why not.
You are a hero m8.
Very usefull! Thanks!
this is pretty good. God bless you.
Thanks a lot @phpBasics
thank you you save my day 🥰
Hi, Shawn ,
How kind of you to share this skill. I really appreciate. Thanks a million.
Now, can I use this to provide a search field for my website, with my pages' contents in the database?
Hey, Adolf. You absolutely can. You would need to use a function to return all of your php files within a certain directory using foreach(glob($log_directory.'/*.*') as $file) {
...
}
@@phpBasics
Ah! Shawn, am sorry, I didn't understand the guidance. But am so glad to know it will work.
But, do you mean that when I have fetched the data from the executed query, I should wrap the foreach loop in a function? Not sure how!! I should discard the 'while loop' ? Please assist me a bit further. My email: elleadsme@gmail.com. Thanks a lot
Amazing i love this guy
Hi there, How to refresh a particular DIV upon data change in the DATABASE but without reloading and refreshing the whole page? For example, IF condition checks a particular field "Order_Status" in the database and display the message accordingly on the page. But, at present user always requires to refresh the page. I want auto-refresh if database field is updated. Please guide.
You can do this easily with Jquery's AJAX functions. I have videos on just this topic.
@@phpBasics please share the link of that video.
Can we have a video of creating a multilingual website? Its a big problem for us.
sir how about uploading image without refreshing? can i apply that to my source code?
Nice Video !
problem with page scroll when to many outputs
What if I have more than one input?
Hey hi, you got this problem?
Can I get the source code? Please
damn using api for a button click instead of pure ajax or javascript welp im out, not ideal.
Need to rename video to, "PHP results using Javascript"
not working for me