sql – PHP

sql, effecting different rows with different buttons

i have a project looks like this. i want to view picture then want to write something about this picture. the “gönder” button should effect the right above picture. i want to add these to …

Check availability of appointment slot

I am creating an area for a user where he can make an appointment. The available appointments are inside a table called: bigo_appuntamento This table has these 5 fields bigo_appto_id –> ID …

Remove duplication from big table with laravel [closed]

I have a table with 5 millions records and it has duplicated rows I want to remove the duplication. This is my code $userRoles = Model::groupBy(‘phone’,’user_id’,’name’)->get(); $userRolesId = …

Larave conditional aggregation to get multiple sum of amount

Hope all is well. Anyone can tell me how can I get to run this SQL query in a the right way in Laravel? Controller: $data=DB::raw(“SELECT name as ‘name’ FROM invoices WHERE country=’$country’…

SQL select multiple arrays and populate one table

I am trying to pupulate 1 table with results from 2 select querys but from the same table. It is not working, one pupulates the other one shows only one result.. Is it posible to do this in one select …

A form can return varying number of values, trying to use the returned values in doctrine query

I have saved a bunch of parsed messages in a db, and I want to be able to pull out results depending on user input. I would like to sort by 1-4 values (more options later on), username, id, email or …

PHP script taking too long. Need someone to take a look at my code to optimize it

I have a script that fetches data from a remote restful API and saves it to the local database. I get the reponse from the server in chunks of 2000 so i have to check if a nextRecordsUrl exists so i …

Using ORDER BY and FIELD function to get single value to each custom list

How to combine search text and checkboxes using sql bootstrap php

What I have so far: I’m working on a database based website. So far, I have a search-text-form with bootstrap and a submit button in index.php. In search.php, I get an output according to the word I …

How to get values from phpmyadmin with the same datetime?

I am building a mini-portal/website and I need to select values with the same DateTime. For example, the first three values have the same DateTime and I would like to select them, yet I don’t know how …