PHP实现通过参数生成MYSQL语句类完整实例.doc

PHP实现通过参数生成MYSQL语句类完整实例 ‘‘, nbsp;address varchar(60) NOT NULL default ‘‘, nbsp;city varchar(60) NOT NULL default ‘‘, nbsp;PRIMARY KEY (cust_id) ) TYPE=MyISAM; ******************************************************************* */ nbsp;require_once ( “ class_mylib_SQLGen-1.0.php “ ); nbsp;$fields = Array ( “ name “ , “ address “ , “ city “ ); nbsp;$values = Array ( “ Fadjar “ , “ Resultmang Raya Street “ , “ Jakarta “ ); nbsp;$tables = Array ( “ customer “ ); nbsp;echo nbsp;” lt;bResult Generate Insertlt;/blt;br “ ; nbsp;$object = new MyLibSQLGen(); nbsp;$object - clear_all_assign(); // to refresh all property but it no need when first time executenbsp; nbsp;$object - setFields( $fields ); nbsp;$object - setValues( $values ); nbsp;$object - setTables( $tables ); nbsp;if ( ! $object - getInsertSQL()){ echo nbsp;$object - Error; exit ;} nbsp;else { $sql = $object - Result; echo nbsp;$sql . “ lt;br “ ;} nbsp;echo nbsp;” lt;bResult Generate Updatelt;/blt;br “ ; nbsp;$fields = Array ( “ name “ , “ address “ , “ city “ ); nbsp;$values = Array ( “ Fadjar “ , “ Resultmang Raya Street “ , “ Jakarta “ ); nbsp;$tables = Array ( “ customer “ ); nbsp;$id = 1 ; nbsp;$conditions [ 0 ][ “ condition “ ] = “ id=‘$id’ “ ; nbsp;$conditions [ 0 ][ “ connection “ ] = ““ ; nbsp;$object - clear_all_assign(); nbsp;$object - setFields( $fields ); nbsp;$object - setValues( $values ); nbsp;$object - setTables( $tables ); nbsp;$object - setConditions( $conditions ); nbsp;if ( ! $object - getUpdateSQL()){ echo nbsp;$object - Error; exit ;} nbsp;else { $sql = $object - Result; echo nbsp;$sql . “ lt;br “ ;} nbsp;echo nbsp;” lt;bResult Generate Deletelt;/blt;br “ ; nbsp;$tables = Array ( “ customer “ ); nbsp;$conditions [ 0 ][ “ condition “ ] = “ id=‘1’ “ ; nbsp;$conditions [ 0 ][ “ connection “ ] = “ OR “ ; nbsp;$conditions [ 1 ][ “ condition “ ] = “ id=‘2’ “ ; nbsp;$conditions [ 1 ][ “ connection “ ] = “ OR “ ; nbsp;$cond