Skip to content

Instantly share code, notes, and snippets.

View developertugrul's full-sized avatar
🏠
tugrulyildirim.com

Tuğrul Yıldırım (Full Stack Web Developer) developertugrul

🏠
tugrulyildirim.com
View GitHub Profile
@developertugrul
developertugrul / hyper.txt
Created January 28, 2021 08:44
Hyper Configuration
module.exports = {
config: {
// default font size in pixels for all tabs
fontSize: 12,
// font family with optional fallbacks
fontFamily: 'Menlo, "DejaVu Sans Mono", Consolas, "Lucida Console", monospace',
// terminal cursor background color and opacity (hex, rgb, hsl, hsv, hwb or cmyk)
cursorColor: 'rgba(248,28,229,0.8)',
@developertugrul
developertugrul / addpathvariable.txt
Last active May 25, 2021 12:26
Add PATH variable using command line
setx /M path "%path%;C:\your\path\here\"
// Trusted SSL Localhost
certmgr.msc
ALTER TABLE exampletable RENAME TO new_table_name;
@developertugrul
developertugrul / gist:fbd882288d036950da180d25c20fa0f2
Created February 4, 2021 10:13
Open Youtube application from an anchor tag
<!DOCTYPE html>
<html lang="tr">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Bir linke tıklanıldığında youtube videosunun uygulama üzerinden açılması</title>
</head>
<body>
<a href="intent://channel/UCJJw4WZ9iMT8AOX-OCjOyQw/#Intent;scheme=vnd.youtube;package=com.google.android.youtube;S.browser_fallback_url=market://details?id=com.google.android.youtube;end;">youtube </a>
@developertugrul
developertugrul / ip camera stream url
Created February 9, 2021 16:34
ip camera stream url ile video yayını yapma
<video width="320" height="240" autoplay controls>
<source src="%StreamURL%" type="video/mp4">
<object width="320" height="240" type="application/x-shockwave-flash" data="http://releases.flowplayer.org/swf/flowplayer-3.2.5.swf">
<param name="movie" value="http://releases.flowplayer.org/swf/flowplayer-3.2.5.swf" />
<param name="flashvars" value='config={"clip": {"url": "%StreamURL%", "autoPlay":true, "autoBuffering":true}}' />
<p><a href="%StreamURL%">view with external app</a></p>
</object>
</video>
class YouTubeDownloader {
/*
* Video Id for the given url
*/
private $video_id;
/*
* Video title for the given video
*/
private $video_title;
@developertugrul
developertugrul / countries
Created February 17, 2021 14:31
All countries included
CREATE TABLE IF NOT EXISTS `country` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`iso` char(2) NOT NULL,
`name` varchar(80) NOT NULL,
`nicename` varchar(80) NOT NULL,
`iso3` char(3) DEFAULT NULL,
`numcode` smallint(6) DEFAULT NULL,
`phonecode` int(5) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
@developertugrul
developertugrul / turkey_cities_sql_table
Created February 17, 2021 15:34
turkey cities sql table
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,
ALTER TABLE tab CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;