Coding Conundrum (Need Help Guys)

[Guest]

So Guys, i am developing a admin area where i can view, edit, remove and create customers and invoices. I have got most of it done however the final thing I would love to have is the edit screen display the original content to edit not have to re write everything (View photos for better understanding)

 

here is a high quality mock up of what i would love  http://prntscr.com/8kykud

 

i know how to input the sql data into the values of the inputs but not sure how to set a php variable without refreshing the page and via a text box and button config like in the photo.

 

any questions please reply

[burnttoastnice]

That looks really nice. For the edit invoice form though, see if you can put it into a table maybe so it looks a bit neater. Apart from that, loving the professional-like interface.

 

For the PHP stuff, on my server I keep the data persistent with a SQLite database. I use ajax (asynchronous javascript and xml - basically javascript does web requests in the background) to load up pages in the backgound which return plaintext for Javascript to parse and handle.

For your application, when the user opens the edit window, you could have ajax request a PHP page with the invoice ID, which would return data for that ID from the database. Javascript would then parse that data and fill the fields accordingly.

[Guest]

That looks really nice. For the edit invoice form though, see if you can put it into a table maybe so it looks a bit neater. Apart from that, loving the professional-like interface.

 

For the PHP stuff, on my server I keep the data persistent with a SQLite database. I use ajax (asynchronous javascript and xml - basically javascript does web requests in the background) to load up pages in the backgound which return plaintext for Javascript to parse and handle.

For your application, when the user opens the edit window, you could have ajax request a PHP page with the invoice ID, which would return data for that ID from the database. Javascript would then parse that data and fill the fields accordingly.

HI so it would be possible to have  text input and button which when pressed fill out the below text fields with the data from the input invoice id without refreshing the page? a link to a example would be great!