0

***** COMPLETE MODIFICATION OF THE PREVIOUS QUESTION ******

I have been developing an appointment system over the past few weeks using php, mysql and javascript. I've come across a problem when trying to insert data into a table. I am using javascript on a php page to send a GET request to a php file which generates a table from database records. I have

3
  • 1
    Sidenote: you realize that your values will fail. Commented Oct 22, 2015 at 17:17
  • visit php.net/manual/en/mysqli.error.php and apply that to your query. You'll see what I mean. Commented Oct 22, 2015 at 17:20
  • edited code above. I select all records from a table and only populate the relevant text boxes with the relevant data from the result set Commented Oct 22, 2015 at 22:24

1 Answer 1

1

I can't understand some of questions but as far as I know you want to call a data from the page?

You want to call the data from the specific users? If yes, you must use $_GET to get ID then you can call the data you want.

Please elaborate more regarding your question.

Sign up to request clarification or add additional context in comments.

5 Comments

I have two tables - patients and requested_appointments. When the website loads it displays a table full of current patients and their details such as name, address, doctor etc.
When I click a button to request an appointment with that individual patient, I want the request an appointment form to load with their first name, second name and doctor in the individual text fields so they do not have to input the details of their name and doctor as it is already loaded in from the patients table.
would i just use _GET and then display the variale in the textfield? @Edmhar
How can your system know their Name? Your system have log in system?
I have re-worked this question. Do you have any ideas? Thanks.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.