Python · Belirtilmemis
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 — 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 — 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 — 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 — 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 — 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 — 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 rowPHP · Belirtilmemis
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.phpPHP · Belirtilmemis
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 — 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 — 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.
<?phpPHP · Belirtilmemis
PHP: Constants - Manual • PHP — Fonksiyonlar.
<?php
// Valid constant names
define("FOO", "something");
define("FOO2", "something else");
define("FOO_BAR", "something more");
// Invalid constant namesPHP · Belirtilmemis
PHP: Introduction - Manual • PHP — Fonksiyonlar.
<!DOCTYPE html>
<html>
<head>
<title>Example</title>
</head>
<body>
<?phpPHP · MariaDB · GPL
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 — 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 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 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 — 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 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 — 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