Mevlüt Canvar mcanvar

🛵

Scootering in the wonderland.

A curious travel-addicted cat hooman, CE graduate #FSWD

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: [email protected] -->
	<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 / 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: [email protected] -->
	<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 / 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 / currencies.xml

Created January 21, 2016 16:51

XML Schema: xsd çalışma örneklerim.

	<?xml version="1.0" encoding="utf-8" ?>
	<!-- author: [email protected] -->

	<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 / 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 / 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 / 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 / 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 / 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 / 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>