php - How to store and retrieve an image and description from a database and make it view able by the a set member -

this pretty long , hefty question. first off new php know javascript , html css. have created static elements of webpage , have managed integrate login , signup premade php layout, users can signup , login site. key element remains; user should able select item database , upon selection item should "pinned" specific div.

e.g. user clicks on button below "image.div", when user clicks on button modal pops choices, user have select choice loads further information user see. upon getting information user clicks "pin" , modal closes , specific choice "pinned" "image.div". each individual "image.div" have it's own category, e.g. hotels, car rentals, restaurants etc. ence when selected assigned category displayed "image.div".

the "pinned" object should view able user pinned when user logs in.

i want choice within popup modal searchable keywords e.g. kingston, new york etc.

the database came php login scripts have following table: fgusers table has following columns: id_user, name, email, phone_number, username , password.

in addition above information request know how structure database this, should extend fgusers table? or should create separate tables each?

a response appreciated.

if understand question correctly then, best way achieve effect after use ajax access database info via php script. use javascript manipulate xmlhttp result.

as far mysql database tables go, better create separate tables different information. need create column in each table references identifying column in table want link particular tables information to.

then have use join commands when referencing table data.

example: if want link data specific users can add username column table , add users name data row. later when want retrieve users data, reference users name. if there multiple tables of user data, use join command link tables together.