Welcome to Programmers Language v2

ID: 123
PlCodelang: PL/pgSQL
PlGroup: Datum, Zeit
PlItemTitle: Alter zu gegebenen Datum ermitteln
Code: select age({ts '1983-08-21 17:25:00'})

ID: 124
PlCodelang: PL/pgSQL
PlGroup: Strings
PlItemTitle: String nach Delimenter zerlegen
Code: SELECT split_part('A;B;C;D;E',';',2) -- Result: B

ID: 125
PlCodelang: Python
PlGroup: Encoding / Decoding
PlItemTitle: Datei nach Base64 encodieren
Code: myfile = 'myDoc.pdf' ReturnValue = open(myfile).read().encode("base64") # in ReturnValue ist nun der Base64-String

ID: 126
PlCodelang: C#
PlGroup: Encoding / Decoding
PlItemTitle: Datei nach Base64 encodieren
Code: 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(); } }

ID: 127
PlCodelang: Mumps
PlGroup: Konsolenverwaltung
PlItemTitle: Einlesen Konsoleneingabe
Code: WRITE !,"What's your name? " READ yourname

ID: 128
PlCodelang: Python
PlGroup: Konsolenverwaltung
PlItemTitle: Einlesen Konsoleneingabe
Code: yourname = raw_input('What\'s your name? ')

ID: 129
PlCodelang: Bash Script
PlGroup: Variablen
PlItemTitle: Wert einer Variable zuweisen
Code: # Aktuelles Verzeichnis in einer Variable setzen mydir="Mein Verzeichnis lautet $PWD" echo $mydir

ID: 130
PlCodelang: MySQL
PlGroup: Datenbank
PlItemTitle: CSV erstellen
Code: -- 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

ID: 131
PlCodelang: PHP
PlGroup: Netzwerk, Email
PlItemTitle: Emails mit pop3 lesen
Code: // 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>"; }

ID: 132
PlCodelang: PHP
PlGroup: Dateihandling
PlItemTitle: Prüfen ob Datei schreibbar ist
Code: // 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"); } } }