DEV Community: AsadullohRuziev

Laravel project

AsadullohRuziev — Mon, 21 Nov 2022 01:09:52 +0000

laravelni o'rnatish

composer create-project --prefer-dist laravel/laravel laravel-task

github bilan bog'lash

databasani bog'lash

composer require laravel/breeze --dev

php artisan breeze:install

php artisan migrate

npm install

npm run dev

AsadullohRuziev — Wed, 02 Nov 2022 18:55:31 +0000

AsadullohRuziev — Wed, 02 Nov 2022 16:31:36 +0000

npm install webpack --save-dev

 npm install webpack-cli --save-dev

## soddaroq ko'rinishi
 npm i -D webpack webpack-cli

We can uninstall on npm

npm uninstall webpack webpack-cli

AsadullohRuziev — Wed, 02 Nov 2022 16:18:37 +0000

Webpack learning

structure

npm and cdn

AsadullohRuziev — Wed, 12 Oct 2022 06:44:42 +0000

SELECT id, make, model, price, ROUND(price * .10) FROM car;

SELECT id, make, model, price, ROUND(price * .10, 2) FROM car;

SELECT id, make, model, price, ROUND(price * .10, 2), ROUND(price - ROUND(price * .10),2) FROM car;

SELECT id, make, model, price AS original_price, ROUND(price * .10, 2) AS chegirma, ROUND(price - ROUND(price * .10),2) AS aksiyadagi_narx FROM car;

AsadullohRuziev — Tue, 11 Oct 2022 05:23:47 +0000

Fake data mockaroo.com/

\i C:/Users/asadu/Downloads/car.sql;

SELECT MAX(price) FROM car;

SELECT MIN(price) FROM car;

SELECT AVG(price) FROM car;

 SELECT ROUND(AVG(price)) FROM car;

AsadullohRuziev — Tue, 11 Oct 2022 04:13:19 +0000

SELECT DISTINCT country FROM users;

SELECT country FROM users GROUP BY country;

SELECT country, COUNT(*) FROM users GROUP BY country;

SELECT country, COUNT(*) FROM users GROUP BY country HAVING COUNT(*) > 2;

AsadullohRuziev — Mon, 10 Oct 2022 20:35:43 +0000

npm init

npm install express pg dotenv

serverni doimiy run holatda saqlash uchun nodemonni o'rnatamiz

npm install nodemon -D

AsadullohRuziev — Mon, 10 Oct 2022 06:59:57 +0000

SELECT * FROM users WHERE date_of_birth BETWEEN DATE '2000-05-05' AND  '2008-01-01' ORDER BY date_of_birth;

SELECT * FROM users WHERE email LIKE '%.com';

SELECT * FROM users WHERE email LIKE '%web%';

SELECT * FROM users WHERE email LIKE '_______@%';

SELECT * FROM users WHERE country ILIKE 'p%';

SELECT * FROM users WHERE country LIKE 'p%';

AsadullohRuziev — Mon, 10 Oct 2022 06:56:55 +0000

 SELECT * FROM users LIMIT 10;

 SELECT * FROM users OFFSET 15 LIMIT 10;

SELECT * FROM users OFFSET 15 FETCH FIRST 10 ROW ONLY;

 SELECT * FROM users WHERE  country='China' OR country='Russia' OR country='Sweden';

SELECT * FROM users WHERE  country IN ('China','Russia','Sweden');

AsadullohRuziev — Mon, 10 Oct 2022 06:24:46 +0000

SELECT DISTINCT country FROM users ORDER BY country;

SELECT * FROM users WHERE gender='Female';

SELECT * FROM users WHERE gender='Female' AND country='China';

SELECT * FROM users WHERE gender='Female' AND (country='China' OR country='Russia');

AsadullohRuziev — Mon, 10 Oct 2022 05:34:54 +0000

SELECT * FROM users ORDER BY country;

SELECT * FROM users ORDER BY country DESC;