V userdata patient id: int(11) @staff : text @barcode : text datetime: timestamp datetimeend: timestamp

[answerhappygod]

V Userdata Patient Id Int 11 Staff Text Barcode Text Datetime Timestamp Datetimeend Timestamp 1 (23.81 KiB) Viewed 27 times

right in php application, the main screen is a screen to add
patient by scanning its bar code. The function of this screen is to send
the bar code and staff from which the patient was entered to the server
through (API). The required task:
Create a PHP page that receives the barcode and staff.
- Ensure that the barcode is present in the userdata table.
- If the barcode is present in the table before, check the datetimeend
field. If it is an empty value, the present server time is added in the
datetimeend field and a new rows is added with staff and barcode.
- If the barcode did not exist before, the information is entered in a
new rows : staff and bar code.
database info :�user info :�localhost�user : ibraheem�pass: d2841962

V Userdata Patient Id Int 11 Staff Text Barcode Text Datetime Timestamp Datetimeend Timestamp 2 (23.81 KiB) Viewed 27 times

V userdata patient id: int(11) @staff : text @barcode : text datetime: timestamp datetimeend: timestamp