Lisantra Technologies, Llc

php Code Sample

    
<?php
    /**
     * I return one record of a company from a mysql server.
     * The controller can process any generated $error[] vars and decide
     * what to do with it. Otherwise, the view will output the mysql
     * result set
     */

    /**
     * create local variables
     */
    //casting is faster than user settype() or even intval()
    $params['company_id'] = (int) $attributes['cid'];


    /**
     * execute processing
     */
    $select_by_company_id['sql'] = "
        SELECT Companies.*, status_codes.status_code_name, Country.*
        FROM Companies
        INNER JOIN Country
            ON Country.intID = Companies.country
        INNER JOIN status_codes
            ON status_codes.status_code_id = Companies.company_status_code
        WHERE Companies.company_id  = '" . $params['company_id'] . "'
        ";

    $select_by_company_id['result_set'] =
        mysql_query( $select_by_company_id['sql'] );

    if ( $select_by_company_id['result_set'] ) {
        $select_by_company_id['record_count'] =
            mysql_num_rows( $select_by_company_id['result_set'] );
    }
    else {
       $error['select_by_company_id'][] = mysql_error();
    }


    /**
     * clean up local variables to prevent pollution
     */
    unset( $params );

?>