All gists from stuzer05

0 likes

0 forks

1 files

1	$tmp_file = tmpfile();
2	$tmp_file_path = stream_get_meta_data($tmp_file)['uri'];
3
4	$zip = new ZipArchive;
5	$res = $zip->open($tmp_file_path, ZipArchive::CREATE);
6
7	foreach ($ptah_p7s->Signs as $i => $sign) {
8	$zip->addFromString("signature{$i}.p7s", base64_decode($sign));
9	}

0 likes

0 forks

3 files

1	SELECT
2	'type ' \|\| table_name \|\| ' struct {' \|\| CHR(10) \|\| fields \|\| CHR(10) \|\| '}' AS models
3	FROM
4	(
5	SELECT
6	table_name,
7	REPLACE(RTRIM(XMLAGG(XMLELEMENT(E, CHR(9) \|\| column_name \|\| CHR(9) \|\| type_info \|\| CHR(9) \|\| annotation \|\| CHR(10))).EXTRACT('//text()').GETCLOBVAL(), CHR(10)), '"', '"') AS fields
8	FROM
9	(
10	SELECT

Newer Older