Click here to Skip to main content
15,895,667 members

Comments by Zaid M (Top 2 by date)

Zaid M 28-Apr-21 14:39pm View    
I'm sorry I didn't understand this approach.
what I thought I'd do was create a table "workaccept" with the following columns namely,
1) client username
2) freelancer username
3) work specification/requirement
4) client hire request sent
5) freelancer hire request accepted/not accepted

once these 5 columns are created, the client would click on the send hire request button and a text field appears, where the client enters the job requirement in detail and presses send. The client username, freelancer username, job requirement is stored and client hire request sent column is set to yes.

then on the freelancer dashboard, under pending hire requests, this request is seen with the detailed job requirement( data is called from database here). once the freelancer accepts it, the freelancer accept columns is set to "yes" and when both column 4 and 5 is set to yes, the job is marked as accepted.

Is this the right flow? please explain how can i go about implementing this on php, mysql. thanks
Zaid M 28-Apr-21 8:51am View    
got it thanks. Can you please tell what changes should I make to the sql query to make it to work? thanks