PHP 5: Extracto de libro para certificacón PHP ( Zend PHP 5)

aca el libro completo
http://rapidshare.com/files/355753489/Zend_PHP_5_Certification_Study_Guide_Oct_2006.pdf.html
MD5: 7CB357EB7F081FCCD2FEC5514A44EF52

copio algunas cosas que me parecieron interesantes..

<?php
function hello()
{
    if (func_num_args() > 0) 
    {
        $arg = func_get_arg(0); // The first argument is at position 0
        echo "Hello $arg";
    } 
    else 
    {
        echo "Hello World";
    }
}

hello("Reader"); // Displays "Hello Reader"
hello(); // Displays "Hello World"
?>

borrar un elemento de un Array

<?php
//Finally, an element can be deleted froman array by unsetting it:
$a = array (’a’ => NULL, ’b’ => 2);
unset ($a[’b’]);
echo in_array ($a, 2); // False
?>

ordenar desordenar Arrays

<?php
$cards = array (1, 2, 3, 4);
//sort ($cards);
shuffle ($cards);
var_dump ($cards);

//Since the shuffle() function randomizes the order of the elements of the array, the
//result of this script will be different every time—but here’s an example:

array(9) {
[0]=>
int(4)
[1]=>
int(1)
[2]=>
int(2)
[3]=>
int(3)
}
?>

Seguridad

<?php
$clean = array();

if (ctype_alpha($_POST[’username’]))
{
$clean[’username’] = $_POST[’username’];
}

if (ctype_alnum($_POST[’password’]))
{
$clean[’password’] = $_POST[’password’];
}

$colours = array(’Red’, ’Blue’, ’Yellow’, ’Green’);
if (in_array($_POST[’colour’], $colours))
{
$clean[’colour’] = $_POST[’colour’];
}
?>

<?php
if ( ctype_alnum($_REQUEST['email']) && ctype_alnum($_REQUEST['pass']) )
{

}
else
{
    die("invalido.. <a href='index.php'>Volver</a>");
    // header("Location: index.php");
}
?>

PHP: Eliminar Dato - Confirm

<a href="" onclick="video_eliminar_confirm(<? echo $row3['video_id'] ?>);">Eliminar</a>

---

function video_eliminar_confirm(id)
           {
               if(confirm("Desea Eliminar este video?"))
               {
                   var html = $.ajax({
                               // url: "ajax_existe_user.php?user_nick="+ nick,
                               type: "POST",
                               url: "video_eliminar.php",
                               data: "id=" + id,
                               async: false
                            }).responseText;
                  
                   if(html == "1")
                   {
                       jAlert("Video Eliminado Satisfactoriamente");
                   }
                   else
                   {
                       jAlert("Falla eliminacion de video");
                       //$("#nombre").val("User Valido");
                       // $("#img_valido").attr("src","images/tick.png");
                       // $("#status").css("color","green");
                       // $("#status").text("OK");
                   }
                           
               }
            }

---

video_eliminar.php?id=5

---

<?
@session_start();

include_once("admin_mssql/cnx/ini.php"); //conexion database
global $db_type;
global $cnx;
include_once("admin_mssql/cnx/rck_database_funciones.php"); //rck_query($sql) comprobarLong($text, $LONGMAXIMA)
include ('inc/fechas_v1.1.php'); //fecha_formato_largo_esp($fecha)
include ('inc/vector_provincias_argentina.php'); //$PROVINCIAS_ARG[1]="Buenos Aires";
include('inc/func_clasificar.php');

$pathPicUsers = "uploads/pic_users/";
$pathTMP = "uploads/tmp/";

$uploadsImagenes = "uploads/imagenes/";
$uploadsVideosImages = "uploads/videos_images/";
$uploadsVideosFlv = "uploads/videos_flv/";

if(!isset($_SESSION['user_id'])) header("Location: index.php"); //si no estoy logueado no puedo ver el espacio de nadie

if(!isset($_REQUEST['id'])) header("Location: index.php"); 

$video_id = $_REQUEST['id'];

#tomo los datos de tabla
$sql = "SELECT * FROM sn_post_videos WHERE video_id = $video_id";
$result = rck_query($sql)  or trigger_error(rck_error()); 
$row = rck_fetch_array($result);

// echo "<pre>";
// print_r($row);
// echo "</pre>";
    
#eliminar el video
@unlink($uploadsVideosFlv.$row['video_video']);

#eliminar la imagen
@unlink($uploadsVideosImages.$row['video_img']);

#eliminar registro en tabla 
$sql = "DELETE FROM sn_post_videos WHERE video_id = $video_id";
$result = rck_query($sql)  or trigger_error(rck_error()); 

echo "1";
?>

test ingreso

PHP
D – Escribir un query que elimine de las tablas las personas que tengan mas de 10 años de edad y no se llamen “mario”

DELETE FROM person
WHERE TRUNCATE((DATEDIFF(CURDATE(), birthdate) / 365), 0) > 10
AND name != 'Mario'