AI Assisted Simple Application Build

 AI Assisted Simple Application Build

Human Description

This will be a single user diary application with reporting. The infrastructure will consist of XAMPP with external libraries for CSS. Each entry will consist of a “group”, “timestamp” and “thought”. On the entry form, “group” will present the unique entries in the database for selection and allow for a new “group” to be added. The “timestamp” should be a database function and only presented to the user in reporting. The “thought” should be cleaned for inclusion as an HTML paragraph (<p></p>).


First Try To Define the Application to Gemini (AI)

Overview

I need a single-file object oriented PHP application for a personal diary running on XAMPP.

Database

Use a MySQL table named “diary” with columns “id”, “group”, “created_at” and “thought”. “Id” is an index. “Group” is a column that is varchar(16) and presented as a list to the user to select from the unique entries in the column and allows a new value to be entered. “Created_at” is the timestamp the row was inserted. “Thought” is a column that is varchar(256).

Functionality

Create a simple form to POST a new thought. Below the form, create a reporting section. Use Google public fonts and Google public CSS libraries. An HTML <select> will be used to present the unique values for the column “group” and allow for a new value to be entered.

Reporting Logic

Reporting should include

  1. Rolling Week: Filter where “created_at” is between "Now" and “Now” minus 14 days

  2. Rolling Month: Filter where “created_at” is between "Now" and “Now” minus 28 days

  3. By Month: Filter where month = “month selected”


Security

Use PDO for database connections and prepared statements to prevent SQL injection. Format the timestamp to be human-readable (e.g., Oct 24, 2023 - 10:30 AM).


SUCCESS!!! EUREKA!!!


No changes needed...well...I should have changed the user and password. I hurried through the implementation because I was excited to see what Jimmy(Gemini) provided. It worked right out of the box.

 

Comments

Post a Comment

You are expected to be responsible for your posts' content. Off topic posts will be deleted. Avoid attacks on individuals and companies. Please use facts instead of vitriol.

Popular posts from this blog

Things I Learned

  This is a list of some of the things I have learned during my life. 1.      Read and follow the instructions. 2.        Humans cannot keep a secret. 3.        Secrets are yours to keep. 4.        Try, try again. 5.        Learn how to negotiate. 6.        Barter works. 7.        Anger rarely serves a purpose. 8.        Create. 9.        You can fix it. 10.    Borrowing money is only necessary when you have not saved enough. 11.    Know the difference between need and want. 12.    Buy low, sell high. 13.    Write your story. 14.    You may be the only one that thinks like you do. 15.    Sometimes people don’t want to know that you know more than them. 16.    You...
Read more

Regrets

 Regrets are the byproducts of moral and ethical breakdowns or failures.  Morals and ethics are difficult for humans to navigate.  You can not hold morals and ethics in your hand.  Situational ethics and morality are peppered throughout history and even the present.  These situations can cloud personal thinking. "I have no regrets."  Never has a bigger lie been told.  The idea that we can do better than we did the first time is always considered after an action is complete.  It is the way we learn better actions or timing. It is worthwhile to discuss these difficult topics to clarify your thinking.  Don't expect to except new ethics and morals easily.  It is a good thing to rules to live by. When you realize your ethics and morals are not the same as other people's it becomes infinitely more difficult to remain steadfast in your position.  Should you talk about regrets and failures?  There are an infinite number of people who a...
Read more

It's All About You

 It's always been about you. And why not? You don't feel pain when you see someone hurt. You do feel pain when you are hurt. This is the basis for all your actions; will it hurt worse than the alternative or will it make me feel good? There are many nuances to these two. Ideas like "it's only illegal if you get caught", "I need it more than they do", "they can afford it" do not make sense. I hope your moral compass finds true North in knowing what is yours and what is not. Violence or the likelihood of violence results in replacing morality with survival; fight or flight. Running away from trouble should be practiced. Leaving a scene where violence is likely to save you pain and maybe your life. Don't hurt others. Look at yourself in the mirror. Keep learning. Discover what YOU makes you happy and then pursue it. Don't allow others to steal your dreams.  Sometimes dreams turn sour with age.  Will you follow your own mind a...
Read more