Aranıyor...
Python · Belirtilmemis

Python — copyPaste.py

Python — SQL sorguları, Dosya işlemleri, Veri dönüştürme. SQL sorgusu içerir.

'''
Copies A2:C4 from worksheet1.xlsx to new row(s) starting at the end of worksheet2.xlsx, then saves it as worksheet3.xlsx
'''

from win32com.client import Dispatch
wkbk1 = "worksheet1.xlsx"
wkbk2 = "worksheet2.xlsx"
wkbk3 = "worksheet3.csv"
Python · Belirtilmemis

Python — autoclicker.py

Python — Fonksiyonlar, Görsel işlemleri. Fonksiyonlar: PixelAt, main.

'''
Automatic Mouse Click based on screen contents
Waits until the pixel at coordinates (364, 278) have the RGB color (75, 219, 106), then clicks
'''

import gtk.gdk
import sys
from pymouse import PyMouse
Python · GPL

Python — parser.py

Python — Fonksiyonlar, Veri dönüştürme. Fonksiyonlar: parse_columns.

from .utils import column_letter_to_index


def parse_columns(cols_input, df):
    """
    Parse the user input for columns.

    Args:
Python · GPL

Python — markdown_generator.py

Python — Fonksiyonlar, Dosya işlemleri, Veri dönüştürme. Fonksiyonlar: dataframe_to_markdown.

# excel_to_markdown/markdown_generator.py
import pandas as pd


def dataframe_to_markdown(df):
    """
    Convert a pandas DataFrame to a Markdown table.
Python · GPL

Python — main.py

Python — SQL sorguları, Fonksiyonlar, Dosya işlemleri. Fonksiyonlar: excel_to_markdown, process_file, main. SQL sorgusu içerir.

# excel_to_markdown/main.py

import pandas as pd
import sys
from pathlib import Path

from .detector import get_table_region
from .markdown_generator import dataframe_to_markdown
Python · GPL

Python — main copy.py

Python — SQL sorguları, Fonksiyonlar, Dosya işlemleri. Fonksiyonlar: excel_to_markdown, process_file, main. SQL sorgusu içerir.

import pandas as pd
import sys
from pathlib import Path

def excel_to_markdown(excel_file, sheet_name=0):
    """
    Convert a specific sheet in an Excel file to a Markdown table.
Python · GPL

Python — detector.py

Python — Fonksiyonlar, Dosya işlemleri, Veri dönüştürme. Fonksiyonlar: detect_table_start, get_table_region.

# excel_to_markdown/detector.py

import pandas as pd


def detect_table_start(df):
    """
    Detect the starting row of the table by finding the first row
PHP · Belirtilmemis

PHP: Constants - Manual

PHP: Constants - Manual • PHP — Görsel işlemleri, Ağ işlemleri.

If you are looking for predefined constants like
* PHP_OS (to show the operating system, PHP was compiled for; php_uname('s') might be more suitable),
* DIRECTORY_SEPARATOR ("\\" on Win, '/' Linux,...)
* PATH_SEPARATOR (';' on Win, ':' on Linux,...)
they are buried in 'Predefined Constants' under 'List of Reserved Words' in the appendix:
http://www.php.net/manual/en/reserved.constants.php
while the latter two are also mentioned in 'Directory Functions'
http://www.php.net/manual/en/ref.dir.php
PHP · Belirtilmemis

PHP: Constants - Manual

PHP: Constants - Manual • PHP — Fonksiyonlar, Görsel işlemleri. Fonksiyonlar: foo.

The documentation says, "You can access constants anywhere in your script without regard to scope", but it's worth keeping in mind that a const declaration must appear in the source file before the place where it's used.

This doesn't work (using PHP 5.4):
<?php
foo();
const X = 1;
function foo() {
    echo "Value of X: " . X;
PHP · Belirtilmemis

PHP: Constants - Manual

PHP: Constants - Manual • PHP — Sınıflar, Fonksiyonlar. Sınıflar: constants, using, constant. Fonksiyonlar: constant.

Lets expand comment of 'storm' about usage of undefined constants. His claim that 'An undefined constant evaluates as true...' is wrong and right at same time. As said further in documentation ' If you use an undefined constant, PHP assumes that you mean the name of the constant itself, just as if you called it as a string...'. So yeah, undefined global constant when accessed directly will be resolved as string equal to name of sought constant (as thought PHP supposes that programmer had forgot apostrophes and autofixes it) and non-zero non-empty string converts to True.

There are two ways to prevent this:
1. always use function constant('CONST_NAME') to get constant value (BTW it also works for class constants - constant('CLASS_NAME::CONST_NAME') );
2. use only class constants (that are defined inside of class using keyword const) because they are not converted to string when not found but throw exception instead (Fatal error: Undefined class constant).
PHP · Belirtilmemis

PHP: Constants - Manual

PHP: Constants - Manual • PHP — SQL sorguları, Sınıflar, Fonksiyonlar. Sınıflar: Constants. Fonksiyonlar: getMinValue, getMaxValue. SQL sorgusu içerir.

11/14/2016 - note updated by sobak
-----

CONSTANTS and PHP Class Definitions

Using "define('MY_VAR', 'default value')" INSIDE a class definition does not work as expected. You have to use the PHP keyword 'const' and initialize it with a scalar value -- boolean, int, float, string (or array in PHP 5.6+) -- right away.

<?php
PHP · Belirtilmemis

PHP: Constants - Manual

PHP: Constants - Manual • PHP — Fonksiyonlar.

<?php

// Valid constant names
define("FOO",     "something");
define("FOO2",    "something else");
define("FOO_BAR", "something more");

// Invalid constant names
PHP · Belirtilmemis

PHP: Introduction - Manual

PHP: Introduction - Manual • PHP — Fonksiyonlar.

<!DOCTYPE html>
<html>
    <head>
        <title>Example</title>
    </head>
    <body>

        <?php
PHP · MariaDB · GPL

PHP — edit.php

PHP MariaDB entegrasyonlu — SQL sorguları, API örnekleri, Form işlemleri. SQL sorgusu içerir.

<?php
if (!isset($_GET["id"])) {
    exit();
}

$id = $_GET["id"];
include_once "database.php";
$statement = $database->prepare("SELECT * FROM person WHERE id = ?;");
PHP · GPL

PHP — delete.php

PHP — SQL sorguları. SQL sorgusu içerir.

<?php
if (!isset($_GET["id"])) {
    exit();
}

$id = $_GET["id"];
include_once "database.php";
$statement = $database->prepare("DELETE FROM person WHERE id = ?;");
SQL · MySQL · GPL

SQL — database.sql

SQL MySQL entegrasyonlu — SQL sorguları.

CREATE DATABASE IF NOT EXISTS mysql_tutorial;
USE mysql_tutorial;
CREATE TABLE person(
	id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
	first_name VARCHAR(255) NOT NULL,
	last_name VARCHAR(255) NOT NULL,
	gender CHAR NOT NULL,
	PRIMARY KEY(id)
PHP · MySQL · GPL

PHP — database.php

PHP MySQL entegrasyonlu — Veritabanı bağlantıları, Ağ işlemleri.

<?php
/*
    PHP and MySQL tutorial
    https://parzibyte.me/blog/en

*/
$password = "";
$user = "root";
PHP · GPL

PHP — add.php

PHP — SQL sorguları, Form işlemleri. SQL sorgusu içerir.

<?php
# If one of these fields are not present, exit
if (!isset($_POST["first_name"]) || !isset($_POST["last_name"]) || !isset($_POST["gender"])) {
    exit();
}

# If everything is OK this code is executed
PHP · MySQL · MIT

PHP — DbCall.php

PHP MySQL entegrasyonlu — Sınıflar, Fonksiyonlar, Ağ işlemleri. Sınıflar: DbCall. Fonksiyonlar: __construct, setUp, getDriver.

<?php

declare(strict_types=1);

namespace Flytachi\Winter\Cdo\Config\Call;

use Flytachi\Winter\Cdo\Config\Common\BaseDbConfig;
PHP · MIT

PHP — CDOBind.php

PHP — SQL sorguları, Sınıflar, Fonksiyonlar. Sınıflar: CDOBind. Fonksiyonlar: __construct, getName, getValue. SQL sorgusu içerir.

<?php

declare(strict_types=1);

namespace Flytachi\Winter\Cdo;

/**
 * CDOBind — Named Parameter Container