dogukancagatay

KeyDB with Docker

Migration from Redis

Connect to your keydb server new-keydb-server-1

keydb-cli -h new-keydb-server-1

senocak

public function sil($tablo,$id){
    $eski_resim="";
		$query = $this->db->query("SELECT * FROM $tablo  where id='$id'")->fetch(PDO::FETCH_ASSOC);
		if ($query){
		    $eski_resim=$query["resim"];
		} 
		unlink("../images/$tablo/$eski_resim");
		$stmt = $this->db->prepare("DELETE FROM $tablo WHERE id =  :id");
		$stmt->bindParam(':id', $id, PDO::PARAM_INT);   
		$sil =$stmt->execute(); 

senocak

public function duzenle($sutun,$deger,$tablo,$resim,$dizin,$id,$en,$boy){
    	if($sutun!=""){
	    	$tablo_degerleri=explode("--",$deger);  
	    	$tablo_adlari=explode("--",$sutun);
	        $tablo_degerleri_text="";
	        for($i=0;$i<count($tablo_adlari);$i++){ 
	        	$tablo_degerleri_text=$tablo_adlari[$i]."=:".$tablo_adlari[$i].",".$tablo_degerleri_text;
	        } 
		}else{
			$tablo_degerleri_text="";

senocak

<?php 
public function ekle($sutun,$deger,$tablo,$resim,$dizin,$en,$boy){
   	if($sutun!=""){
   		$tablo_adlari=explode("--",$sutun);
    	$tablo_degerleri=explode("--",$deger); 
        $tablo_adlari_text="";
        $tablo_degerleri_text="";
        for($i=0;$i<count($tablo_adlari);$i++){
        	$tablo_adlari_text.=$tablo_adlari[$i].',';
        	$tablo_degerleri_text.=":".$tablo_adlari[$i].",";

cacheflowe

// [Noted in the comments below on 2023-10 - this script might not work very well anymore due to Elon ruining Twitter]
// [Updated 2021-01-18 w/new selectors]
// go to your account Likes page and run this in the console:

function scrollToLoadMore() {
	// keep scrolling if twitter tries to stop loading more.
	// scroll up, then down to force infinite load.
	window.scrollTo(0, 0);	
	setTimeout(function() {
		window.scrollBy(0, 9999999999);

burakerdem

DROP TABLE IF EXISTS `cities`;
CREATE TABLE `cities` (
  `id` int(2) NOT NULL,
  `title` varchar(255) NOT NULL,
  `lat` double(11,8) DEFAULT NULL,
  `lng` double(11,8) DEFAULT NULL,
  `northeast_lat` double(11,8) DEFAULT NULL,
  `northeast_lng` double(11,8) DEFAULT NULL,
  `southwest_lat` double(11,8) DEFAULT NULL,
  `southwest_lng` double(11,8) DEFAULT NULL,

artisonian

from flask import Flask, request, redirect, url_for, make_response, abort
from werkzeug import secure_filename
from pymongo import Connection
from pymongo.objectid import ObjectId
from gridfs import GridFS
from gridfs.errors import NoFile

ALLOWED_EXTENSIONS = set(['txt', 'pdf', 'png', 'jpg', 'jpeg', 'gif'])
DB = Connection().gridfs_server_test
FS = GridFS(DB)