Search Posts

Laravel file uploader is not working

how to – Laravel file uploader is not working I’m using ubuntu OS. I have a created a laravel project. In that there is a file uploader. I have given file permission to folder that files have to save and name is store in database. But the file uploader is not working. careers.blade.php <form action=”{{ route(‘careers.store’) }}” method=”post” enctype=”multipart/form-data”> <h2>Enter Your Details</h2> <div class=”input-field”> <span>First Name</span><br> <input type=”text” name=”first_name” required=”required”> </div> <div class=”input-field”> <span>Last Name</span><br> […]

MYSQL SELECT rows where sum is over 200 [duplicate]

how to – MYSQL SELECT rows where sum is over 200 [duplicate] This question already has an answer here: SQL – having VS where 7 answers How to select rows where sum of a row is over 200? I tried all kinds of combinations with grouping, setting AS something and using WHERE clause Current attempt as follow SELECT something.CustomerName, something.CustomerAge, cars.Prices, SUM(cars.Price) AS Amount FROM cars INNER JOIN something ON something.CustomerNo=Cars.CustomerNo GROUP BY AMOUNT WHERE […]

Using a Case Statement on CHARs in a MySQL Stored Function

how to – Using a Case Statement on CHARs in a MySQL Stored Function I am trying to write a stored function that takes the value in a CHAR(3) (an acronym), applies a CASE to it, and converts it to another string. My table schema looks like: CREATE TABLE roster ( id VARCHAR(9) PRIMARY KEY, class_level CHAR(2) ); and an attempt at writing the stored function: DELIMITER $$ CREATE FUNCTION classlevel (level CHAR(2)) RETURNS TINYTEXT […]

Why I can’t get the data on a new page from mysql via Vue?

how to – Why I can’t get the data on a new page from mysql via Vue? Apologies for asking what looks like a common question but I cannot seem to be able to achieve. I would like to click ‘a’ tag and open a new page to show an article according to the id from MySQL Database. But I got 500. Could anyone tell me what’s the matter with my codding? Thank You. Here […]

Selecting a database and a table simultaneously using SQL in phpmyadmin throws an error

how to – Selecting a database and a table simultaneously using SQL in phpmyadmin throws an error I am new to databases but in the past had used SQL Server and now I am trying to run a few SQL statements in MySql using phpmyadmin. All I am trying to do is select a database and thereafter trying to select all the fields of a table. SQL Query: use sakila select * from actor But […]

Querying tables with a zero-to-many relationship

how to – Querying tables with a zero-to-many relationship I have an application that uses a MySQL database to store, asking other things, meetings and projects. A project can have zero-to-many meetings, and a meeting can have zero-to-many projects. To assist with linking meetings to a project, I’m trying to write a single clean query that searches across all of these tables and their relations (e.g. projects have tasks, meetings have attendees) Here’s an idea […]

command pip install mysql-python showing error

how to – command pip install mysql-python showing error Here is the image: on running command, it is showing “install error: Microsoft Visual C++ 14.0 is required. Get it with “Microsoft Visual C++ Build Tools”: http://landinghub.visualstudio.com/visual-cpp-build-tools” but I have already installed microsoft visual. tried to search on web but couldn’t find anything Source: Stackoverflow

Question about proper join syntax

how to – Question about proper join syntax I have always written inner joins without using the "inner join ___ on" statement in my queries because this is how I learned. I'm curious to know if this is something which could be a problem or if it's more stylistic. For example, instead of SELECT t1., t2 FROM t1 INNER JOIN t2 ON t1.id=t2.id… I write SELECT t1.,t2. FROM t1, t2 WHERE t1.id=t2.id… submitted by […]

Fetching N records excluding joined ones?

how to – Fetching N records excluding joined ones? I have three tables (details omitted for brevity): create table products ( id, name ) create table tags ( id, name ) create table product_tags ( product_id, tag_id ) These tables are populated as follows: ——– products ——– +—-+——+ | id | name | +—-+——+ | 1 | Rice | | 2 | Bean | | 3 | Milk | +—-+——+ —- tags —- +—-+——-+ | […]

Laravel select groupby only not nullable values

how to – Laravel select groupby only not nullable values I have a model Products. In the table there are columns id,description,barcode,sizebarcode,price. Sizebarcode column has some values and also nullable values. I want to grouping sizebarcode column where are not nullable values. Null values are directly selected without grouping. I want to omit nullable values when grouping. I want to select all unique values in sizebarcode and also with all nullable values Controller.php $products = […]

Next Page » « Previous Page