Yury

Hi everyone, I am in a process of building database driven web application for Inventory/Equipment tracking system. I did some research trying to find ready solution but nothing fits my needs. It is either too complicated and expensive, either too simple and not scalable. That is why I decide to build my own application. I am not a developer, sometimes codding for fun. So I’m in the process of trying to learn about 6 different “languages” – HTML, CSS, PHP, MYSQL, Javascript etc. The quickest way to learn a new language is to start with some examples. So the intent of this is to get a simple example of a couple pages built that I can use as a framework – monkey see, monkey do style. The website is not for commercial use, only internal, so the focus is more on utility and little bit presentation (user interactions). In terms of your work, I need simple, clear, minimalistic code. While the code may well be used, the main focus is on providing a solid example for a noob to follow. Depending on the quality of the work (and price of course) there may be additional work available in the future. I’m using the XAMPP stack. MySQL Server on local host. phykogeo@gmail.com Job Details.txt

Thanks

Thank you very much. I will take a look later to see if I can figure it out. Can you suggest any good resources to learn PDO PHP together with MySQL. Thanks.

I looked at Ajax and looks like I can update only one table at the time and also has to specify URL for php file and not function or several functions. That is where I am stuck, I don't understand how to update 2 tables at the same time with one button click.

I am trying to build Web based PHP driven application with MySQL database. I need to have several tables on the same web page and dynamically reload them on button click event. Unfortunately I don't know what approach should I take, reloading entire web page from server side using PHP or reload table from client side with JavaScript? I used to do similar task on Java and used onclick event to get data from SQL and rebuild necessary table and then display it on screen. Is it possible to achieve same approach with PHP or JavaScript? On attached picture there are two tables. I am trying to achieve the following: 1. Click "Show All" for Customers - show result on customer table (I know how to do it) - clear result on Sites table 2. versus versa when click "Show All" for Sites 3. some other operations but idea is the same - dynamically update necessary tables (several) on same page for my needs.