I am trying to find on what date each year since 2009 when the GDD (growing degree days) is <= 1035. I can get the following to work for one year, but will not work for multiple years. I am trying to figure out how to reset the @cum = 0 for every year and then display my date result by year...
The below query was working in myphpadmin, but when I moved it to .php page it did not. I found out why and tried to use the mysqli_multi_query, but the query still returns "Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result"
Can someone explain what I am doing wrong? Or is...
I am collecting soil temperatures at different depths. Different crops have different temperature depths.
My data structure looks like this for each record for each location and depth. The data is the same for each day for this example.
ObsDate:
Location: (field location)
Depth: (for this crop...
I am using the framework from this Link with changes to make it more dynamic. I display outside cam images on my weather page. There is a toggle button between Day and Month images.
When the page loads I am getting an Uncaught "TypeError: slides[(slideIndex - 1)] is undefined". If either the...
I am trying to display either daily or monthly webcam images depending on the status of a toggle switch. The default is Daily when the page loads and displays today's images as it should when the page first loads. The problem is when the button is toggled, the Monthly images do not load or...
I am trying to create a 3 state toggle switch where the slider temporarily moves when the cursor hovers over the option, but returns to original state when cursor is moved away.
See this link as an example: Link
I found this switch example Link, but the slider only moves when the option is...
In my retirement, I am building a local weather site. Data is loaded to a MySQL database. Everything works fine, so I wanted to add a previous and next buttons see past monthly data.
The data loads on initial page loading, but when I click the previous button the date changes, but the previous...
I have text embedded in a <td> that displays the current phase of the moon (via a php script). If you hover over the text a small image of the moon in that phase appears below the text. All this works as it should.
The problem is if the user clicks on the text, they get a error:
"Not Found The...
I have a webcam that uploads an image every hour to a folder on a server. At the end of the day I want to delete all the images except for the image with datetime closest to 12 noon, which I keep for historical use.
This part works and finds the closest image to 12 noon and puts them in an...
I have 2 arrays that have a one to many relationship. The one side array has the meeting information and the many sided array contains the handout links. The meeting info is loaded before the handouts, which are loaded days before. The primary and foreign key is 'meetdate'. As you can see there...
I want to add a new JSON array to an existing JSON array that have the same keys. I have searched, but cannot find a solution to match.
My current array
[{"meetdate":"2019-06-05","acronym":"dm","type":"_ho_6c"},
{"meetdate":"2019-07-22","acronym":"htn","type":"_ho_6c"}
]
The goal array...
I am having difficulty with a Javascript loop syntax. I have a form and when the user select an date from an select input a onchange function is triggered. I need to loop though the array find the key:value pair that matches what was selected and populate the next input element with the value...
I am trying to insert a key:value pair into an array based on another key:value pair. The json array is in a text file. I am not getting any errors, but nothing is inserted. After insertion it should look like the first array. The key and new value comes from a form.
Here is the array...
I am using Tablulator 4.1, which is a pure javascript library for tables. One column of my table provides a drop down list of values. I had this working by calling the function directly from editorParams:, but I got a warning that this method is being depreciated and to use the following method...
I am trying to find the max value of id:x in an associative array that is located in a text file located in the same folder as my script.
I found 2 working examples, one finds the max value and the other reads the array from a text file. I am trying to put them together, but the output is NaN...
I am new to javascript and trying to create a interface to manipulate arrays stored in text files stored on a server. I am using Tabulator 4.1 which is a javascript library (no jQuery) that display data.
Link
The table loads properly and I can edit the data, but when I click the save button my...
I am trying to save an JSON encoded array to an existing text file on the server.
Here is the html code. When I click the button nothing seems to happen and I am not getting any error messages in the console.
<body>
<button class="button" id="save-data" >Save Data</button>...
I am working with a db that tracks revisions to a book. Revisions are captured in the Revisions table with a timestamp. I need to show in a form which Book Edition the revision affected (which is always the next published edition).
The 2 tables with data that look like this:
dimBookEdition...
I have a main single form and a continuous subform that is not bound to the main form. The main form contain information on a medical procedure and the subform contain all the medical references for all the procedures.
The user can click a checkbox (double state) on each reference record in...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.