Manage PlItems

You may optionally enter a comparison operator (<, <=, >, >=, <> or =) at the beginning of each of your search values to specify how the comparison should be done.

Advanced Search

Displaying 121-130 of 300 results.

ID	PlCodelang	PlGroup	PlItemTitle	Code

123	PL/pgSQL	Datum, Zeit	Alter zu gegebenen Datum ermitteln	select age({ts '1983-08-21 17:25:00'})
124	PL/pgSQL	Strings	String nach Delimenter zerlegen	SELECT split_part('A;B;C;D;E',';',2) -- Result: B
125	Python	Encoding / Decoding	Datei nach Base64 encodieren	myfile = 'myDoc.pdf' ReturnValue = open(myfile).read().encode("base64") # in ReturnValue ist nun der Base64-String
126	C#	Encoding / Decoding	Datei nach Base64 encodieren	myfile = "myPDF.pdf"; string ReturnValue = ""; if (System.IO.File.Exists(myfile)) { using (FileStream BinaryFile = new FileStream(myfile, FileMode.Open)) { BinaryReader BinRead = new BinaryReader(BinaryFile); byte[] BinBytes = BinRead.ReadBytes(Convert.ToInt32(BinaryFile.Length)); ReturnValue = Convert.ToBase64String(BinBytes); BinaryFile.Close(); } }
127	Mumps	Konsolenverwaltung	Einlesen Konsoleneingabe	WRITE !,"What's your name? " READ yourname
128	Python	Konsolenverwaltung	Einlesen Konsoleneingabe	yourname = raw_input('What\'s your name? ')
129	Bash Script	Variablen	Wert einer Variable zuweisen	# Aktuelles Verzeichnis in einer Variable setzen mydir="Mein Verzeichnis lautet $PWD" echo $mydir
130	MySQL	Datenbank	CSV erstellen	-- http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html#function_group-concat SELECT R.TITEL AS TITEL ,R.ANLEITUNG AS ANLEITUNG ,GROUP_CONCAT(CONCAT(CAST(RZ.MENGE AS CHAR),' ',RZ.EINHEIT,' ' ,Z.ZUTAT) SEPARATOR ',') AS ZUTATEN ,R.NOTIZ AS NOTIZ FROM REZEPT AS R LEFT JOIN REZEPT_HAS_ZUTAT AS RZ ON R.ID=RZ.REZEPT_ID LEFT JOIN ZUTAT AS Z ON RZ.ZUTAT_ID=Z.ID AND RZ.REZEPT_ID=R.ID
131	PHP	Netzwerk, Email	Emails mit pop3 lesen	// Orginal von http://www.sebastianviereck.de/php-pop3-mails-aus-postfach-auslesen/ $mailserver="pop.foo.de"; $port="110/pop3"; $user="name@foode"; $pass="foo"; getEmailsImap($mailserver, $port, $user, $pass); //open connection to mailbox, read all unread mails function getEmailsImap($mailserver, $port, $user, $pass) { $imap = imap_open( "{" . $mailserver . ":" . $port . "}INBOX", $user, $pass ); if ($imap) { echo "Connected\n"; $check = imap_mailboxmsginfo($imap); echo "Date: " . $check->Date . "<br />\n" ; echo "Driver: " . $check->Driver . "<br />\n" ; echo "Unread: " . $check->Unread . "<br />\n" ; echo "Size: " . $check->Size . "<br />\n" ; $totalrows = imap_num_msg($imap); //iterate through all unread mails for ($index = 0; $index < $totalrows; $index++) { $header = imap_header($imap, $index + 1); //get mail subject dump("<h1>".$header->subject."</h1>"); //get mail sent date $prettydate = date(DateTime::ISO8601 , $header->udate); dump( $prettydate ); //get email author $email = "{$header->from[0]->mailbox}@{$header->from[0]->host}"; dump( $email ); //get mail body dump( imap_body($imap, $index + 1)); } //close connection to mailbox imap_close($imap); return true; } else { dump("Can't connect: " . imap_last_error()); return false; } } function dump($var) { echo "<pre><div align='left'>"; print_r($var); echo "</div></pre>"; }
132	PHP	Dateihandling	Prüfen ob Datei schreibbar ist	// Orginal von: http://www.sebastianviereck.de/php-nicht-schreibbare-dateien-finden-und-beheben/ function checkFileWritable($file) { if(!file_exists($file)) { file_put_contents($file, ""); } if(!chmod($file, 0644)) { $fileowner = fileowner($file); echo "counld not change File Permissions: $file, File Owner is: $fileowner"; if(!chown($file, ftpUserID)) { echo "counld not change File owner: $file "; mail(mailadresse, "Schreibeprobleme","File: $file, File Owner is: $fileowner"); } } }