Skip to content

Instantly share code, notes, and snippets.

View alperbayram's full-sized avatar
🍊

Alper Bayram alperbayram

🍊
View GitHub Profile
<?php
session_start();
$deger=0;
$_SESSİON['deger']=$deger;
?>
<?php
if (!isset($_SESSION['counter']))
$_SESSION['counter'] = 0;
else {
$_SESSION['counter']++;
}
echo $_SESSION['counter'];
?>
<?php
if(!isset($_SESSION['deger'])){
$_SESSION['deger']=0;
}
?>
@alperbayram
alperbayram / twitter_sentiment_analysis_by_username.ipynb
Created June 1, 2021 00:08
Twitter_Sentiment_Analysis_by_Username.ipynb
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@alperbayram
alperbayram / wordcloud.ipynb
Created May 28, 2021 13:53
wordcloud.ipynb
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@alperbayram
alperbayram / SQL-PostgreSQL.sql
Last active November 27, 2021 12:27
SQL notes
--------------------------------------- 1 --------------------------------------
--film tablosunda bulunan title ve description sütunlarındaki verileri sıralayınız.
--film tablosunda bulunan tüm sütunlardaki verileri film uzunluğu (length) 60 dan büyük VE 75 ten küçük olma koşullarıyla sıralayınız.
--film tablosunda bulunan tüm sütunlardaki verileri rental_rate 0.99 VE replacement_cost 12.99 VEYA 28.99 olma koşullarıyla sıralayınız.
--customer tablosunda bulunan first_name sütunundaki değeri 'Mary' olan müşterinin last_name sütunundaki değeri nedir?
--film tablosundaki uzunluğu(length) 50 ten büyük OLMAYIP aynı zamanda rental_rate değeri 2.99 veya 4.99 OLMAYAN verileri sıralayınız.
SELECT title, description FROM film
SELECT * FROM film WHERE length>60 AND length<75
@alperbayram
alperbayram / app.js
Created November 30, 2021 16:49
getData.js
//getData.js
import axios from "axios";
export async function getData(number) {
const { data: user } = await axios(
`https://jsonplaceholder.typicode.com/users/${number}`
);
const { data: post } = await axios(
`https://jsonplaceholder.typicode.com/posts/${number}`
);
@alperbayram
alperbayram / mongodb
Created January 18, 2022 11:58
mongodb
`mongodb+srv://${process.env.MONGO_USERNAME}:${process.env.MONGO_PASSWORD}@myFirstDatabase?retryWrites=true&w=majority`
"roles": [
{
"id": 1,
"name": "Manager"
},
{
"id": 2,
"name": "Engineer"
},
{
const express = require('express');
const path = require('path');
const dotenv = require('dotenv');
const ContactRoute = require('./Routes/ContactRoute');
const app = express();
dotenv.config();
//middleware
app.use(express.static(path.resolve(__dirname, '../client/build')));