Skip to content

Instantly share code, notes, and snippets.

View mcanvar's full-sized avatar
🛵
Scootering in the wonderland.

Mevlüt Canvar mcanvar

🛵
Scootering in the wonderland.
68 followers · 170 following
View GitHub Profile
@mcanvar
mcanvar / vize_denemeler.xml
Created January 21, 2016 16:06
XSL vize çalışma örneği: TCMB Today.xml kaynağını kullandım.
<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" href="vize_denemeler.xsl"?>
<!-- author: mevlutcanvar@gmail.com -->
<Currencies Tarih="13.11.2015" Date="11/13/2015" Bulten_No="2015/216">
<Currency CrossOrder="0" Kod="USD" CurrencyCode="USD">
<Unit>1</Unit>
<Name Lang="tr">ABD DOLARI</Name>
<Name Lang="en">US DOLLAR</Name>
<ForexBuying>2.8686</ForexBuying>
<ForexSelling>2.8738</ForexSelling>
@mcanvar
mcanvar / final_hazirlik.xml
Created January 21, 2016 16:33
XSL final çalışma örneği: TCMB Today.xml kaynağını kullandım.
<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" href="final_hazirlik.xsl"?>
<!-- author: mevlutcanvar@gmail.com -->
<Currencies Tarih="13.11.2015" Date="11/13/2015" Bulten_No="2015/216">
<Currency CrossOrder="0" Kod="USD" CurrencyCode="USD">
<Unit>1</Unit>
<Name Lang="tr">ABD DOLARI</Name>
<Name Lang="en">US DOLLAR</Name>
<ForexBuying>2.8686</ForexBuying>
<ForexSelling>2.8738</ForexSelling>
@mcanvar
mcanvar / catalog.xml
Created January 21, 2016 16:44
DTD çalışma örneği.
<?xml version="1.0" encoding="utf-8" standalone="no" ?>
<!-- INSTEAD OF INNER DTD: <!DOCTYPE catalog SYSTEM "catalog.dtd"> -->
<!-- OR USE BOTH DECLARATIONS: <!DOCTYPE catalog SYSTEM "catalog.dtd"[ ... ]> -->
<!DOCTYPE catalog [
<!ENTITY % p "(#PCDATA)">
<!ENTITY % img_ext SYSTEM "img_ext.ent">
<!ELEMENT catalog (book*)>
<!ATTLIST catalog id IDREFS #IMPLIED>
@mcanvar
mcanvar / currencies.xml
Created January 21, 2016 16:51
XML Schema: xsd çalışma örneklerim.
<?xml version="1.0" encoding="utf-8" ?>
<!-- author: mevlutcanvar@gmail.com -->
<Currencies Tarih="2015-11-13" Date="2015-11-13" Time="15:30:00" Bulten_No="2015/216"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="currencies.xsd" xmlns="http://tempuri.org/currencies.xsd">
<Currency CrossOrder="0" Kod="USD" CurrencyCode="USD">
<Unit>1</Unit>
<Name Lang="tr">ABD DOLARI</Name>
<Name Lang="en">US DOLLAR</Name>
<ForexBuying>2.8686</ForexBuying>
@mcanvar
mcanvar / hazirlik.xq
Created January 21, 2016 17:06
XQuery 1.0 Uygulamaları, kaynak: today.xml (TCMB)
(: input :)
xquery version "1.0";
doc("vize_denemeler.xml")
/Currencies/Currency/Name
[contains(.,"DOLARI")]
(: output
<Name Lang="tr">ABD DOLARI</Name>
<Name Lang="tr">AVUSTRALYA DOLARI</Name>
<Name Lang="tr">KANADA DOLARI</Name> :)
@mcanvar
mcanvar / regex_replace.sql
Created March 19, 2016 22:49
mysql regex replace function
DELIMITER $$
CREATE FUNCTION `regex_replace`(pattern VARCHAR(1000),replacement VARCHAR(1000),original VARCHAR(1000))
RETURNS VARCHAR(1000)
DETERMINISTIC
BEGIN
DECLARE temp VARCHAR(1000);
DECLARE ch VARCHAR(1);
DECLARE i INT;
SET i = 1;
@mcanvar
mcanvar / firstWord.vb
Created March 27, 2016 18:32
Function that returns first word of the string.
Function firstWord(string As String) As String
If String.IsNullOrEmpty(string) Then Return String.Empty
Dim words As String() = string.Split(" ")
Return words(0)
End Function
@mcanvar
mcanvar / lastWord.vb
Created March 27, 2016 18:34
Function that returns first word of the string.
Function lastWord(string As String) As String
If String.IsNullOrEmpty(string) Then Return String.Empty
Dim words As String() = string.Split(" ")
Return words.Last
End Function
@mcanvar
mcanvar / trCharToEn.vb
Created March 27, 2016 18:36
Visual Basic function that converts the special Turkish characters to English ones.
Function trCharToEn(string As String) As String
If String.IsNullOrEmpty(string) Then Return String.Empty
string = Replace(string, Chr(199), "C")
string = Replace(string, Chr(208), "G")
string = Replace(string, Chr(221), "I")
string = Replace(string, Chr(214), "O")
string = Replace(string, Chr(222), "S")
string = Replace(string, Chr(231), "c")
@mcanvar
mcanvar / php-echo-function.php
Last active April 9, 2016 15:41
PHP Echo Language Construct
<!--
Author: Mevlüt Canvar
-->
<!DOCTYPE html>
<html>
<head>
<title>echo</title>
<script type="text/javascript" src="http://localhost:35729/livereload.js"></script>
</head>