Untitled Document

PIM613 PHP Functions condensed

The most important functions for basic PHP as used for the bloobook website

//PHP FUNCTIONS <?php = starting a php-script | ending a php-script: ?> //login $db_host="localhost" ; $db_name="bloobook" ; $db_user="bloobookmember" ; $db_pass="just a password" ; $db=@mysql_connect($db_host, $db_user, $db_pass) ; @mysql_select_db($db_name, $db) ; //other files require('../../lobby/key.php'); include('deklin.php'); //input/output $input=$_GET['variableName'] ; echo "bla"; -> bla $input="bli"; echo $input; -> bli echo $input."bla"; -> blibla $name=strip_tags($_POST['name']; //remove html from formfields //strings strlen($string); strpos($variable, $string); strrpos($variable, $string); //entstpricht lastIndexOf str_replace($findstring, $replacestring, $variable); ucfirst($string); //upper Case first character substr($variable, $start, ($end)); str_split ($string) //into arrays import_request_variables("p", "form_"); //auto-enter formfields //if/else if ($first>0) $species=substr($inputSpecies,0,$first); else $species=$inputSpecies; //search $sql="SELECT * FROM buecher"; $sql7="SELECT * FROM taxon WHERE(var LIKE '$speciesInput')"; $sql="SELECT biolog, deutsch, vol FROM taxon WHERE (level LIKE 7 ) AND ((biolog LIKE '%$query%') OR (deutsch LIKE '%$query%')) ORDER BY biolog ASC"; $SQL="INSERT INTO gbuch (Name, Email, Webadresse) VALUES ('$from_Name', '$form_email', '$form_www')"; $SQL="REPLACE INTO glossar VALUES ('bloobook_arachnida', -1, 0, 'Arachnida', 'n', '', 'Spinnentiere', '', '', '', '', '', '', 'bloobookLib', '4', 'glossar', 'arachnida')"; $SQL="DELETE FROM buecher WHERE (preis>25)"; mysql_close(); //results $result7=mysql_query($sql7); $speciesLine=mysql_fetch_array($result7); $Anzahl_Daten=mysql_num_rows($resultat); //arrays array($var1, $var2, $var3); $var1=array($var1a, $var1b, $var1c); array(array($var1a, $var1b, $var1c), $var2, $var3); $Artikel=$artikel[$genro][$bestimmtheit][$zahl][$casus]; $Substantiv=$substantiv.$subEndung[$typ][$bestimmtheit][$zahl][$casus]; $words=explode(" ", "Now is the time"); => $words=array('Now', 'is', 'the', 'time'); $wordstring=implode("-", $words) => $wordstring='Now-is-the-time'; //functions function deklin($inputSpecies, $lg, $inputGenro, $inputPluralUmlaut, $inputCasus, $inputZahl, $inputBestimmtheit) { content_of_function return($result); }