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, 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
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.
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