[mastubbs]

Hi All,

 

I’m quite new to coding but I’m embarking on a new project to make a patient sql database at the hospital where I work. The idea is so that nurses can look up a patient record, enter the patient’s observation data every few hours (eg heart rate and blood pressure) and then graphically display this on a chart plotted against time. It looks like GroceryCRUD might able to help me with the database part, but can it do the following?

 

1)      Of course it can add a new patient record (say name and date of birth), but can It automatically create a new row for (say heart rate and blood pressure) each time this is recorded for one patient?

2)      Can it also automatically add the date and time so this can be used for charting later?

3)      Can this information be passed to the script from a HTML form so i can make a very easy form for the nurses to use?

 

Thanks in advance for any replies,

 

Matt

[davidoster]

Hello Matt and welcome to the forums!

I hope Grocery CRUD will help you out with your programming quests.

 

Grocery CRUD in general I would call it as a simple, easy and very quick way to add,edit and delete database records.

For these services Grocery CRUD does the job quite successfuly.

Grocery CRUD is using behind the scenes a PHP based framework called CodeIgniter (see here for more information).

 

Now, if we try to be more specific to what you ask,

1) please define the automatic part; does it mean that the row needs to be created without user intervention? If yes then you need to know if the system that supplies the data can somehow initiate either a script or a connection to the database or even talk to Grocery CRUD(via HTTP connection) and open up the add (record) and populate the data and save to the database

 

2) for the automatic part of the question see point (1). for the addition of date and time, please explain. isn't this supplied either way from an external source or a user? if you mean to save by default the current datetime, this ability can even be programmed within your database and Grocery CRUD needs not to worry about it at all. but of course even Grocery CRUD (basically PHP) can auto generate and store current datetime to a field(s). what you do with the data later, e.g. charting this is up to you (developer) to build and show

 

3) I honestly don't understand the question. But I believe this is (partially) answered from the above points (1) and (2). The part of easiness depends also on the complexity of your system! if your database table(s) have e.g. 20 fields that need to be user edited then here is your complexity and there qoes away the easy part. so I can't answer this unless I see your database. if it is let's say a 5 field form (table), even if the form has the worst design it is still very easy to fill in!

 

I hope these help you to clarify a bit better the magnitude of the task you are about to undergo.

[mastubbs]

Hello Matt and welcome to the forums!

I hope Grocery CRUD will help you out with your programming quests.

 

Grocery CRUD in general I would call it as a simple, easy and very quick way to add,edit and delete database records.

For these services Grocery CRUD does the job quite successfuly.

Grocery CRUD is using behind the scenes a PHP based framework called CodeIgniter (see here for more information).

 

Now, if we try to be more specific to what you ask,

1) please define the automatic part; does it mean that the row needs to be created without user intervention? If yes then you need to know if the system that supplies the data can somehow initiate either a script or a connection to the database or even talk to Grocery CRUD(via HTTP connection) and open up the add (record) and populate the data and save to the database

 

2) for the automatic part of the question see point (1). for the addition of date and time, please explain. isn't this supplied either way from an external source or a user? if you mean to save by default the current datetime, this ability can even be programmed within your database and Grocery CRUD needs not to worry about it at all. but of course even Grocery CRUD (basically PHP) can auto generate and store current datetime to a field(s). what you do with the data later, e.g. charting this is up to you (developer) to build and show

 

3) I honestly don't understand the question. But I believe this is (partially) answered from the above points (1) and (2). The part of easiness depends also on the complexity of your system! if your database table(s) have e.g. 20 fields that need to be user edited then here is your complexity and there qoes away the easy part. so I can't answer this unless I see your database. if it is let's say a 5 field form (table), even if the form has the worst design it is still very easy to fill in!

 

I hope these help you to clarify a bit better the magnitude of the task you are about to undergo.

 

Thanks for your reply,

 

Please allow me to explain what i mean a bit better. I'm sure what i am trying to do is very easy, its just i have very little experience with php or sql . The first table has the following fields: name, date of birth, hospital number. The second table has the following: hospital number, heart rate, blood pressure, date and time. I am trying to create a system where the nurse can:

 

1) access a single search box in which they can type a hospital number

2) this will return the associated date of birth and name from table 1, so they can confirm they have the correct patient

3) they can then click to add a new record (in table 2) for only that hospital number for which they have just searched

4) this new record is of date, time, heart rate and blood pressure

5) on clicking 'add record' redirect to external page.

 

what i meant by 'automatic' you have answered, i just wanted the date and time to be inserted by the system, not the nurse.

 

can you point me in the direction of where i should start with this task?

 

thanks

[davidoster]

For 1,2 you will need some custom PHP code.

For 3 you can have Grocery CRUD to help you out with the addition of the table but it might end up being more complicated than using a simple form in PHP.

For 4 this can be done no matter what you use.

For 5, very easy to make a redirect to an external page.

 

Summary: At least from my point of view what I would have done, I would make a simple form (using CodeIgniter) for the addition of new patient's records (this covers 1,2,3,4,5) and if I wanted to make it more flexible I would just make some Grocery CRUD list (grid) views for other people (managers etc for previewing the data).