Skip to content

Instantly share code, notes, and snippets.

@jerzyyy
jerzyyy / hello.c
Last active March 29, 2020 19:46
test
int main()
{
printf("hello world")
return 0
}
const mysql = require('mysql');
const connection = mysql.createConnection({
host : 'localhost', // adresse du serveur
user : 'root', // le nom d'utilisateur
password : 'Henriette2', // le mot de passe
database : 'sqlquests', // le nom de la base de données
});
module.exports = connection;
const express = require('express');
const app = express();
const port = 3000;
app.get(`/`, (req, res) => {
res.send('yo yo');
});
//Une route /api/movies qui renvoie un string
app.get(`/api/movies`, (req, res) => {
DELETE FROM movie
WHERE id='5'
DELETE FROM movie
WHERE id> 10
DELETE FROM movie
WHERE id='5'
DELETE FROM movie
WHERE id> 120
UPDATE movie
SET name='Men in Black'
WHERE id='5';
UPDATE movie
SET name='Deadpool',poster'https://upload.wikimedia.org/wikipedia/en/thumb/2/23/Deadpool_%282016_poster%29.png/220px-Deadpool_%282016_poster%29.png'
WHERE id='8';
UPDATE movie
SET comment=' '
SELECT * FROM movie
SELECT name FROM movie
SELECT id, poster FROM movie
SELECT poster,comment AS avis_spectateur FROM movie
let express = require('express');
let app = express();
const port = 3000;
app.get('/', (req, res) => {
res.send(`<h1>Bienvenue sur votre serveur !!</h1>`);
});
app.get('/contact', (req, res) => {
res.send(`<h1>Nous ne sommes pas joignables pour le moment !</h1>`);
var http = require('http');
http.createServer(function (require, response) {
response.writeHead(200, {'Content-Type': 'text/html; charset=utf-8'})
var url= require.url;
if(url ==='/about'){
response.write(`<h1>What's up Dude?</h1>`)
response.end()
}else{
<!DOCTYPE html!>
<html>
<head>
<meta charset="utf-8" />
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<title>Page Title</title>
<meta name="viewport" content="width=device-width, initial-scale=1">
<script src="https://cdnjs.cloudflare.com/ajax/libs/redux/4.0.1/redux.min.js"></script>
</head>