I am new to php and I want to figure out ways on ho to incorporate database with it.
I have a page wherein it has a textbox and a submit button in it. The textbox must be filled in with a student number. When submitted it will return another page with 2 textboxes for the student name and student address. Well, of course a name and an address has more than 1 word in it.
But when my query was processed and the page loaded, the first word of the student's full name was the only one that appeared, that was what happened also in the address textbox. Say for example in my database the student_name= "Melvin De Rosa", student_address="81 B, Ph 2, One Village". The query only returned to the textboxes the values "Melvin" and "81" only in the Student Name and Student Address respectively.
I figured out what if I divides the fields into different significant fields. Say the full name of the student, it will be divided into first name and last name. With the address: Lot Number, Street, Village, City. But when I programmed it again, it occurred to me that some first and last names has have two words in them, so when i run it again the same problem arises. Help me! what can I do to fix this.