This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
===SQL==== | |
Транзакция — это операция, состоящая из одного или нескольких запросов к базе данных. | |
Суть транзакций — обеспечить корректное выполнение всех запросов в рамках одной транзакции, | |
а так-же обеспечить механизм изоляции транзакций друг от друга для решения проблемы совместного доступа к данным. | |
set autocommit=0; //отключаем autocommit | |
Start transaction; (также, можно написать BEGIN; ) | |
Select * from table where ... FOR UPDATE; // блокирует записаь, снимается после commit | |
…какие-то действий с БД (insert, update,delete…) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Заливаем все файлы, кроме node_modules | |
Скачиваем Проект, потом в проекте | |
1) Переименовать .env.example в .env | |
2)Выполнить команду в папке проекта | |
Run composer install или composer install | |
Run php artisan key:generate или php artisan key:generate | |
3) для возможности работы с реакт выполнить npm run i |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
create-react-app my-app --scripts-version=react-scripts-ts | |
/------------------------------------------------------------- | |
import * as React from "react"; | |
/** | |
* : JSX.Element[] | |
* : React.FormEvent<HTMLFormElement> | |
* | |
* {this.deleteTask.bind(this, value.id) | |
*/ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/** | |
* tsconfig.json - конфигурация компиляторя ts | |
* tsc -w - выполняет и следит за изменениями | |
{ | |
"compilerOptions": { - настройка параметров компиляции | |
"target": "es5", - какой стандарт JavaScript будет применяться при компиляции | |
"removeComments": true, -Удаляет коментарии | |
"outDir": "js", -задает каталог для скомпилированных файлов | |
"sourceMap": false, -надо сгенерировать карту для сопоставления исходных и скомпилированных файлов | |
"outFile": "main.js" -название выходного файла |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
var express = require('express'); | |
var multer = require('multer'); | |
var mime = require('mime-types') | |
var cors = require('cors') | |
var app = express() | |
app.use(express.static('uploads')); | |
app.use(cors({ | |
origin: 'http://localhost:3000', | |
credentials: true |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
var express = require('express'); | |
var router = express.Router(); | |
//Прием POst параметров | |
var multer = require('multer') | |
var upload = multer({ dest: 'uploads/' }) | |
//Работа с сессиями | |
var session = require('express-session') | |
//Работа с БД | |
var mysql = require('mysql'); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
var express = require('express'); | |
var router = express.Router(); | |
//Прием Post параметров | |
var multer = require('multer') | |
var upload = multer({ dest: 'uploads/' }) | |
//JWT | |
const jwt = require('jsonwebtoken'); | |
//Работа с БД | |
var mysql = require('mysql'); | |
//Хеширование паролей |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
1) Устанавливаем Laravel | |
2) php artisan preset react - проект/resurser/js/app.js - точка входа | |
3) npm install - устанавливаем зависимости | |
4) вводим данные БД в env и выполняем php artisan migrate и php artisan make:auth - Для создание регистрации | |
5) | |
<meta name="csrf-token" content="{{ csrf_token() }}"> | |
<link href="{{asset('css/app.css')}}" rel="stylesheet" type="text/css"> | |
<div id="example"></div> | |
<script src="{{asset('js/app.js')}}" ></script> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<!DOCTYPE html> | |
<html lang="en"> | |
<head> | |
<meta charset="UTF-8"> | |
<meta name="viewport" content="width=device-width, initial-scale=1.0"> | |
<meta http-equiv="X-UA-Compatible" content="ie=edge"> | |
<title>Document</title> | |
</head> | |
<body> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
///При работе с JS и отправки запроса на api чужих серверов, выйдет ошибка, так как должны присутсвовать заголовки CORS | |
///Можно создать api на своем backend, и обращаться уже к нему | |
var express = require('express'); | |
var app = express(); | |
var request = require('request'); | |
app.get('/', function (req, res) { | |
request('http://auction-api-eu.worldofwarcraft.com/auction-data/.../auctions.json', function (error, response, body) { |
NewerOlder