| encryption | decryption |
| AES_ENCRYT() | AES_DECRYPT() |
| ENCODE() | DECODE() |
| DES_ENCRYPT() | DES_DECRYPT() |
| ENCRYPT() | Not available |
| MD5() | Not available |
| OLD_PASSWORD() | Not available |
| PASSWORD() | Not available |
| SHA() or SHA1() | Not available |
| Not available | UNCOMPRESSED_LENGTH() |
class classname [ extends baseclass ]
{
[ var $property [ = value ]; ... ]
[ function functionname (args) {
// code
}
...
]
}
class Person {
function get_name ( )
{
return $this->name; }
function set_name ($new_name) {
$this->name = $new_name;
}
}
var $name = 'J Doe'; // works
var $age = 0; // works
var $day = 60*60*24; // doesn't work
Effect
|
Ascending
|
Descending
|
User-defined order
|
|---|---|---|---|
Sort array by values, then reassign indices starting with
0
|
sort( )
|
rsort( )
|
usort( )
|
Sort array by values
|
asort( )
|
arsort( )
|
uasort( )
|
Sort array by keys
|
ksort( )
|
krsort( )
|
uksort( )
|
$names = array('cath', 'angela', 'brad', 'dave');
sort($names); // $names is now 'angela', 'brad', 'cath', 'dave'
$logins = array('njt' => 415,
'kt' => 492,
'rl' => 652,
'jht' => 441,
'jj' => 441,
'wt' => 402);
arsort($logins);
$num_printed = 0;
echo("<table>\n");
foreach ($logins as $user => $time ) {
echo("<tr><td>$user</td><td>$time</td></tr>\n");
if (++$num_printed == 3) {
break; // stop after three
}
}
echo("</table>\n");
<table>
<tr><td>rl</td><td>652</td></tr>
<tr><td>kt</td><td>492</td></tr>
<tr><td>jht</td><td>441</td></tr>
</table>
ksort($logins);
echo("<table>\n");
foreach ($logins as $user => $time) {
echo("<tr><td>$user</td><td>$time</td></tr>\n");
}
echo("</table>\n");
<table>
<tr><td>jht</td><td>441</td></tr>
<tr><td>jj</td><td>441</td></tr>
<tr><td>kt</td><td>492</td></tr>
<tr><td>njt</td><td>415</td></tr>
<tr><td>rl</td><td>652</td></tr>
<tr><td>wt</td><td>402</td></tr>
</table>
// Fetch numeric arrays:
while ($row = mysqli_fetch_row($result)) {
print $row[0] . "\n";
}
// Alternative syntax:
while ($row = mysqli_fetch_array($result, MYSQLI_NUM)) {
print $row[0] . "\n";
}
// Alternative associative array syntax:
while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
print $row['username'] . "\n";
}
// Both numeric and associative:
while ($row = mysqli_fetch_array($result, MYSQLI_BOTH)) {
print $row[0] . "\n";
print $row['username'] . "\n";
}
// Fetch as "object"
while ($row = mysqli_fetch_object($result)) {
print $row->username . "\n";
}
<?xml version="1.0"?>
<address-book>
<person id="1">
<!--Rasmus Lerdorf-->
<firstname>Rasmus</firstname>
<lastname>Lerdorf</lastname>
<city>Sunnyvale</city>
<state>CA</state>
<email>rasmus@php.net</email>
</person>
<person id="2">
<!--Zeev Suraski-->
<firstname>Zeev</firstname>
<lastname>Suraski</lastname>
<city>Tel Aviv</city>
<state></state>
<email>zeev@php.net</email>
</person>
</address-book>
$dom = new DOMDocument;
$dom->preserveWhiteSpace = false;
$dom->load('address-book.xml');
$root = $dom->documentElement;
foreach ($root->childNodes as $person) {
process($person);
}
$people = $root->childNodes;
for ($i = 0; $i < $people->length; $i++) {
process($people->item($i));
}
$result = mysql_query("SELECT winery_name, phone, fax FROM winery");
while($row = mysql_fetch_array($result))
{
print "The {$row["winery_name"]} winery's fax is {$row["fax"]}".
print "Their phone is {$row["phone"]}.\n";
}