Tag: sql

Loop runs until the condition is met but insert statement is being used only once

I am trying to create an Expense Management system where I will be able to schedule future expenses if the user selects frequency like daily, weekly, monthly etc. To achieve this, I have created a loop but in the code above, My loop runs, and $sde is echoed as desired but my insert statement runs only once. I…

How to Set an Expiration Date after a Year in Laravel

laravel php sql

I’m trying to make an investment website where I want to set an expiration date exactly after a year that the registration was made. Upon the registration, an initial deposit is required which is the …

Codeigniter batch update for checkbox

batch-updates codeigniter codeigniter-query-builder php sql

I have a situation like this, I want to update some data where the input are checkboxes, I was tried this code below. Data already saved in database, but data saved in another row, For example : I …

SQLSRV skips a row when returning a query

php sql sql-server sqlsrv

The code above does what I want and returns number of rows that matches what the query returns. However, I hardcoded the three sqlsrv_next_result($result);. The query will change depending on @AmbassadorID, so that piece needs to be dynamic. I tried the following loop: But this loop skips the first row. How d…

select and count devices at a location based on coordinates of both

php sql sql-server

By using STContains function of SQL geography it was possible to calculate if a set of coordinates is within an area , however this revealed that if last received coordinates were just outside the area than these coordinates do not match any location. What would be an efficient way to display how many and whi…

Run a database dump (Restore) from an sql file in PHP + PostgreSql

php postgresql postgresql-12 sql

I’m trying to create a system where a user can create a database and have it populated from a UI, pretty much similar to the installation of most CMS’s. I can programatically create the database but …

SQL Server Time Format is not equal to Client Side Time format

javascript php sql sql-server sqlsrv

I’m trying to compare the client side time format (“14:00”) to SQL Server time format (“14:00:00.0000000″) with SQL Query, technically is not equal because SQL Server time format has seconds and milliseconds, so I tried to concatenate the seconds and milliseconds to client side t…