Tag: sql

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]

laravel php sql

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 = …

MED Schularberit

php sql

I have made a form which collets data form user and sendes them to the database,I wanted to add an addtional option to delete records that user choose.Im having trouble doing that and I would be very thankful i you cound help me.I am new in PHP so sorry that maybe I have done some “stupid” mistakes The error I

Change Primary ID in laravel Migration

laravel php sql

I’m creating a table where I want to use the ID from this table “menu_items” to be added in another table Table one: menu_items Table 2 products My aim of doing this is that I can then create a relationship between the 2 tables as they have the same key? Is there a different approach I can take? Should I

RUN API inside SQL database upload

api php sql

I have an API to do an action for a site. The API works and does what it needs to be done. The API information is populated from a form I have. the form also needs to upload information to MYSQL database using SQL I have the following SQL The above works as the header runs the API, but once

PHP inserting value only once

database mysql php sql

I am trying to add categories in a database. Things is the script is reading the categories from a product list, therefore there are duplicate values as it’d be like reading PRODUCT NAME – DETAIL 1 – DETAIL 2 – CATEGORY Rinse and repeat. I have my code down and the insert works but it stops at the first product’s

Larave conditional aggregation to get multiple sum of amount

aggregate-functions laravel php sql sum

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’…

How can I improve my query so it takes less time to execute, and I can still divide the result into pages using multiple tables

paging php select sql union

I am trying to create a PHP website that would allow users to see a leaderboard of online game players by their ranking. The ranking consists of following components: Rank (Challenger, Grandmaster, Master, Diamond, Platinum, Gold, Silver, Bronze and Iron) Tier (I, II, III and IV) League points (an integer number) Each rank consists of 4 tiers, except for Challenger,

How do I use SQL INNER JOIN & ALIAS with foreign keys to fetch data from a database?

alias inner-join mysql php sql

I am trying to display data in a table as the code below shows. I’m trying to get data for these 3 columns in Requisitions table(view) from a database table called users: Requisitioned By Approved By and Disbursed By Tables in the db are as follows. I am going to omit columns that seem to be working correctly. fin_requisitions users

pagination show an extra page

pagination php sql

I am currently doing a paging system and I have an error that the “NEXT” button continues to work despite having reached the last page, when clicking this it takes me to an extra page without content. The “next” button should disappear on page 2 but it is continuous and sends me to page 3 where there is no content.