sqlite_udf_decode_binary

(PHP 5 < 5.4.0, PECL sqlite >= 1.0.0)

sqlite_udf_decode_binaryDecode binary data passed as parameters to an UDF

说明

sqlite_udf_decode_binary ( string $data ) : string

Decodes binary data passed as parameters to a UDF.

You must call this function on parameters passed to your UDF if you need them to handle binary data, as the binary encoding employed by PHP will obscure the content and of the parameter in its natural, non-coded form.

PHP does not perform this encode/decode operation automatically as it would severely impact performance if it did.

参数

data

The encoded data that will be decoded, data that was applied by either sqlite_udf_encode_binary() or sqlite_escape_string().

返回值

The decoded string.

范例

Example #1 binary-safe max_length aggregation function example

<?php
$data 
= array(
   
'one',
   
'two',
   
'three',
   
'four',
   
'five',
   
'six',
   
'seven',
   
'eight',
   
'nine',
   
'ten',
   );
$db sqlite_open(':memory:');
sqlite_query($db"CREATE TABLE strings(a)");
foreach (
$data as $str) {
    
$str sqlite_escape_string($str);
    
sqlite_query($db"INSERT INTO strings VALUES ('$str')");
}

function 
max_len_step(&$context$string
{
    
$string sqlite_udf_decode_binary($string);
    if (
strlen($string) > $context) {
        
$context strlen($string);
    }
}

function 
max_len_finalize(&$context
{
    return 
$context;
}

sqlite_create_aggregate($db'max_len''max_len_step''max_len_finalize');

var_dump(sqlite_array_query($db'SELECT max_len(a) from strings'));

?>

参见

相关文章
php cubrid 函数 sets the cubrid database parametersphp ibm db2 函数 returns the data type of the indicated column in a result setphp gd 和图像处理 函数 取得 getimagesize,exif read data,exif thumbnail,exif imagetype 所返回的图像类型的 mime 类型php inclued 函数 get the inclued dataphp mcve 函数 whether or not to validate the passed identifier on any transaction it is passed tophp maxdb 函数 fetch meta data for a single fieldphp msession 函数 get data session unstructured dataphp odbc 函数 handling of binary column dataphp odbc 函数 get result dataphp postgresql 函数 sends a request to execute a prepared statement with given parameters and waits for the resultphp postgresql 函数 submits a command to the server and waits for the result with the ability to pass parameters separately from the sql command textphp sqlite 函数 register an aggregating udf for use in sql statementsphp sqlite 函数 escapes a string for use as a query parameterphp sqlite 函数 decode binary data passed as parameters to an udfphp sqlite 函数 encode binary data before returning it from an udfphp sqlite 函数 execute a query that does not prefetch and buffer all dataphp mnogosearch 函数 set mnogosearch agent session parametersphp 杂项 函数 unpack data from binary stringphp xdiff 函数 make binary diff of two files using the rabin s polynomial fingerprinting algorithmphp sdo das relational 函数 executes an sql query passed as a prepared statement with a list of values to substitute for placeholders and return the results as a normalised data graph
关注编程学问公众号