Event #740: PHP Training in San Francisco

Start Date: 2003-1-6 End Date: 2003-1-14 Country: USA Category: 1 URL: http://www.academyx.com/training/san_francisco/php/introduction/ AcademyX is offering a 3-evening, hands-on, instructor-led class in PHP and MySQL. Students will learn how to build dynamic, form- and data-driven PHP pages. This class covers only the basic elements of the language and database integration; it is for people with programming and HTML experience who want to quickly learn familiar concepts (variables, output, loops, conditionals, HTML form data integration, and recordset retrieval) in the PHP environment. The class will be held on three evenings: January 6, 9, and 14 The three sessions cover the following topics: SESSION 1: PROGRAMMING BASICS IN PHP<br> * definition of the client-server model and overview of its implementation in the context of a web browser and a web server<br> * how a web server handles PHP scripts with embedded HTML<br> * installing PHP for Windows using Apache or Personal Web Server<br> * configuring the php.ini file<br> * dynamically changing your HTML with the print() command<br> * setting and outputting string variables<br> * useful string functions and concatenation<br> * setting and outputting numeric variables<br> * useful math functions<br> * subtleties of printing variables within single or double quotes<br> SESSION 2: PROCESSING FORM DATA AND DATABASE RECORDSETS<br> * converting FORM input tags to PHP variables<br> * deciding on what code to execute with if-else conditionals<br> * repeating blocks of code with while() loops<br> * programmatically sending email with the mail() function<br> * understanding associative arrays<br> * connecting to a MySQL database in PHP with the mysql_connect() and mysql_select_db() functions<br> * overview of the SELECT statement in SQL<br> * preparing SQL statements in PHP with the mysql_query() function<br> * retrieving an associative array of fields and values with the mysql_fetch_assoc() function<br> * using PHP while() loops with fetch_assoc() to retrieve a recordset and output it in HTML<br> SESSION 3: MANIPULATING THE MYSQL SERVER<br> * installing MySQL on Windows<br> * using the Windows MySQL client to query a database<br> * other SQL statements besides SELECT:<br> - INSERT<br> - UPDATE<br> - DELETE<br> * overview of MySQL user permissions and the GRANT statement<br> * creating tables with the CREATE TABLE statement<br> * adding fields with the ALTER TABLE statement<br> -- http://master.php.net/manage/event.php?id=740&action=approve http://master.php.net/manage/event.php?id=740&action=reject http://master.php.net/manage/event.php?id=740