Artificial Intelligence and my internet programming

 I've done my first successful AI program. I used Claude 3.5 to do it. 

Here is the instructions I gave to Claude:


Create the following code


in a form html file ask for the fromdate and todate for the query in the php file.

Open a sqlite database called ../Fasts.db. It's the folder above this one.


Here are it's fields: id integer, entrytime time stamp without timezone, 

entrytype text, glucose text, ketone text, comment text, memberno text.


Create a query that looks like this while creating the variables

 necessary to create the graph after the query occurs


$query = "SELECT * FROM entries WHERE entrytime >= '$fromdate' AND 

entrytime   <= '$todate' AND memberno = '$memberno' ORDER BY entrytime"; 


Using html, php and javascript and using this sql result to create a bar 

graph that shows fasts that show each separate fast that exist between 

the entrytype = StartOfFast and EndOfFast and the height of the bars are 

the level of glucose.


Here is it's output:



---------

So that's it and it worked. It's not much but I will get better.


Pierre-


Comments

Post a Comment

Popular posts from this blog

Huge update

 I've been reading several books since last month. The Ketogenic Bible,  Dr Fung's book, David Sinclair's book and more. I absorb these ideas on metabolic systems in the body.  The most interesting is understanding the rebuild/repair system of the body. The main idea I've come to understand is that the human system needs to spend more time on the repair side of metabolism. The thing is, we eat without allowing the body to repair.   The repair of Autophagy in all its types really can't function properly with just a few hours of rest from eating. We are built to repair our cells when we don't eat for a few days. To measure the amount of repair taking place I use the GKI index. For that to work I use the blood tests for Ketones and Glucose using inexpensive blood monitors. Read the levels on my site: mywaterfasts.com.  What I've learned is that it took me three days to reach down to 1.5 on the GKI index so that cysts are being repaired. That fixed my right eye...
Read more

Statistics of fasts

I have the graphs working on the extended fasts. All is pretty much good and well to a point. I want to superimpose the condition(s) above the fast times. Bear in mind that what appears complex in this note, the complexity of the program, itself, is at least 30 times more complex. To compare the fasting times to the condition times, for instance, I want to see when I'm losing weight compared to the fasts. Weight is the example here. What is done here will work with the thousands of conditions the members may have. That's a bit complex. The condition check may lie outside of the start and end of the fast.  I can't ignore what is outside the fast, especially if no condition tests were done within the fasts themselves. I have to use the last or average of the weights before the fast. Also, if there is weight checks within the fasts, then I'll use an average of those. When you're travelling through arrays of information, there's all kinds of gotchas that'll caus...
Read more

We're out of balance. And I'm 5.6 years younger

Why are we out of balance. It's simple the human cell can only significantly repair if we stop eating for a while.   The way our bodies are designed, there is a balance between eating and going without food. Eat and, using food nutrients, you rebuild or clone new cells. Stop eating for a while and your body will remove or repair the cells that are damaged. Eventually, cells go bad. By the time you are 60 15% or your cells need replacing, they have turned into Zombies. Fasting, to me, is the best way to remove these cells and return to youth. That's the way it's supposed to work. I have made 30 fasts to attempt to save my eyes from blindness. In so doing, I have removed 5.6 years off my chronological age, which is 72.79 years. My biologic age, though, is now about 67. I used  the 'TRUME' system. You send in your DNA and they, by checking you telemeres determine your age. Costs about 100.00.  I added to this that the Trume labs signed me up for a subscription without ...
Read more