I have 2 tables. (1) being users, and (2) being foods. In the [users] table, there is a food_id bracket that is linked as a foreign key to an item/column’s id in the other table [foods]. I am able to make a reservation of a [food] column, although I want to be able to press ..

I have done my calendar module and all my schedules have been deleted from database and it happens randomly. Anyone had this issue before? Below is the only delete function I have. Is this the cause for it to be deleted? // clear unbooked schedules within the time window if ($r->has(‘clear’) and$r->clear == 1) ..

I am creating a CMS for an E-commerce and I am having problems developing a system to create variants of products. I have the frontend developed and it seems like the image: As you can see, the system generates possible variants using the type of product in question. Then, the admin has to select which ..

I have the following tables: What I want is to get the product_types_values ptv where their ptv.type_id == 1 and not exist any variant v where their v.id_type == 1 and its v.value == ptv.value In SQL it will be like: SELECT * FROM products_types_values ptv WEHRE ptv.type_id = 1 and ptv.value not in (SELECT ..

I’m using laravel 8 framework. [using query to get values from table in and display it in checkbox, but when i select more than one it’s just display single not multiple. you can see this secreenshot][1] this is blabe php code with query. <div class="row"> <div class="col-xs-12 col-sm-12 col-md-12"> <div class="form-group"> <strong>Students:</strong> <div style="margin-top: 5px" ..

I have freshly created laravel application which i am trying to connect to remote database but i’m getting an error. SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = tomsin1 and table_name = migrations and table_type = ‘BASE TABLE’) My .env file DB_CONNECTION=mysql DB_HOST=stud.if.ktu.lt DB_DATABASE=tomsin1 DB_USERNAME=tomsin1 DB_PASSWORD=ooShen4ooPaechad Sourc..

I have data with the same invoices number and more than one sub total, the sub total should only be 1 even though there are many invoices number.. How do i make a query for that case? This picture is my query and result in phpmyadmin : enter image description here Thanksss. Sourc..

The application is hosted in Bluehost in a Shared hosting. I tried executing the below query in phpMyAdmin and the results works fine: SELECT employee_id , floor(Datediff(max(to_date), min(from_date))/365) As diif FROM work_experiences group by employee_id having floor(Datediff(max(to_date), min(from_date))/365) >=15 Below is my Laravel Query builder: $query->groupBy(’employee_id’);$query->havingRaw(‘Floor(Datediff(Max(to_date), min(from_date))/365) >=’.$filterOverralExperienceA);$query->havingRaw(‘Floor(Datediff(Max(to_date), min(from_date))/365) <=’. $filterOverralExperienceB); The above .. Read more I’m new at PHP Laravel. When I run in my terminal php artisan serve it shows me an error. Also I can’t have access at phpMyAdmin: As far I can understand, I can’t have access to the database, even when I run php artisan migrate it shows the same error. Sourc.. Read more I have a sensor list form in my program. There the user can do CRUD. How do when the user enters new sensor data, the new data automatically creates a new column in the table in my database (automatically alter table) public function store(Request$request){ $data = new Mst_sensor();$arr = array_merge($arr, [‘created_by’ => Auth::user()->userid, .. Read more i’m currently working on a webshop that’s all about different types of hair colors, but i kinda have an issue right now. I’m working on a button that automatically deletes one product from a session file. For that i’m using a$request->session()->forget(‘cart’); line. This is what my controller looks like: public function index() { // ..

i wanted to subtract total & credit to get due amount and i can retrive and display it without any problem in html , but i want the Column (Due Amount) to do their job everytime subtract it , is this is possible with PhpMyAdmin ? thanks. Sourc..

Hi everyone i’m trying to subtract two values , for example {$a[‘total’]} and {$a[‘syb’]} , only by adding it to (td) tagg , first code ( showing one of the value total or syb <td class="amount" " > {$a[‘total’]} </td> After i did some changes as below <td id="demo" class="amount" > </td> the problem is .. Read more I want to create some 10,000 coupon codes on my site and set them as active with eg 25% discount here is how my database coupon tables look like https://ibb.co/ysP8qdt please share any query code I can use to execute this at once without manually adding them one by one. site is built in laravel .. Read more my problem: I have a vps with Laravel 8.0. I was successfully installed phpMyAdmin. I did rewrite apache2.conf and add include. But gettting HTTP ERROR 500 I hope someone can help me fix it On server there is installed ubuntu 20.04 Thanks in advance 🙂 Sourc.. Read more I have tried my best but unable to solve it, almost 2 days wasted. All other contents are updating except the completed question and points are updating when clicking on submit button but question not completed. When clicked on Submit button, the button got invisible but the addPointsAndMakeItCompleted not performing. If addPointsAndMakeItCompleted succussesful performed then .. Read more Database Used: Xampp PhpmyAdmin I have bunch of records, In that one calculative column say ‘goal’ is there. So, SELECT *,(x *100/y) AS goal FROM temp_table HAVING (goal >= 0) ORDER BY goal DESC LIMIT 0,10; SELECT *,(x *100/y) AS goal FROM temp_table HAVING (goal >= 0) ORDER BY goal DESC LIMIT 10,10; As a .. Read more This is your docker-compose file to add "Phpmyadmin" you just have to the following commands that I will leave in "answer" For more information: https://laravel.com/docs/sail version: "3" services: laravel.test: build: context: ./vendor/laravel/sail/runtimes/8.0 dockerfile: Dockerfile args: WWWGROUP: "${WWWGROUP}" image: sail-8.0/app ports: – "${APP_PORT:-80}:80" environment: WWWUSER: "${WWWUSER}" LARAVEL_SAIL: 1 volumes: – ".:/var/www/html" networks: – sail depends_on: – ..

I need to store multiple images and text in different rows(in DB) please help me Thanks in Advance **Create Blade** <div class="card-header card-header-border-bottom " > <h2 class="text-center mt-2">Create Content</h2> </div> <link rel="stylesheet" href="//maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css"> <script src="//ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script> <form action="{{ route(‘Content.store’) }}" method="POST" enctype="multipart/form-data"> @csrf <div class="form-group col-md-6"> <label for="exampleFormControlTextarea1">Image</label> <input type="file" name="image[]" class="form-control" id="exampleFormControlInput1" placeholder="Enter Contact phone"> ..

I have written an Online Store with Laravel 5.8 and in this project I want to define amount column at user_transactions table with Decimal 19.2 data type. So I opened up phpmyadmin and changed the data type to decimal. Now I need to know how to define Decimal(19.2) in both phpmyadmin and Laravel Migration. I ..

i am using laravel and phpmyadmin and i need to add slug field for like 12K entries in my database . i tried using a route to update the empty ‘slug’ column with slug data : Route::get(‘/slug’, function(){ $needSlugs = entreprise::where(‘slug’, ”)->get(); foreach($needSlugs as $slug){$slug->update([ ‘slug’ => Str::slug(\$slug->RS) ]); }}); but it takes so ..

I wanted to start a new project and created a database on phpmyadmin via mamp. But I can’t connect I get always the error message SQLSTATE[HY000] [1049] Unknown database ‘todo-list’ when running the comman php artisan migrate. I already delete and recreated the database, stopped the serve ans restarted the server. Run the commands php ..