function getSPNameUrlSafe($spid) { $spname = getSPName($spid); $spname = makeURLSave($spname); return $spname; }
function createProcedureAndDAL($Database, $tableName, $sps, $spsDel, $prefixSp, $seprator) { mysql_select_db($Database); $result = mysql_query("Select * From {$tableName}") or die('Not Get Data'); $resultTypes = mysql_query("SHOW FIELDS FROM {$Database}.{$tableName}"); $index = 0; while ($row = mysql_fetch_array($resultTypes)) { $types[$index] = array(GetRealTypes($row['Type']), mysql_field_len($result, $index)); $index++; } $fields = mysql_num_fields($result); $i = 0; while ($i < mysql_num_fields($result)) { $meta = mysql_fetch_field($result, $i); $recs[$i] = $meta->name; $maxL[$i] = $meta->max_length; if ($meta->primary_key == 1) { $Primary = array($meta->name, $meta->type); } $i++; } // delete sps deleteProcedures($tableName, $spsDel, $prefixSp, $seprator); $lenPerfixSeprator = strlen($prefixSp) + strlen($seprator) + 1; // create sps and dal $dalMethods = ''; foreach ($sps as $spname) { if ($spname == 'SelectAll') { $sp_name = getSPName($tableName, $spname, $prefixSp, $seprator); $Query = CreateSelectAll($tableName, $recs, $sp_name, $lenPerfixSeprator); $result2 = mysql_query($Query[0]) or die("Not Create proc {$sp_name}"); echo "<pre>{$Query['0']}</pre>"; $dalMethods .= $Query[1]; } else { if ($spname == 'SelectRow') { $sp_name = getSPName($tableName, $spname, $prefixSp, $seprator); $Query = CreateSelectRow($tableName, $recs, $Primary, $sp_name, $lenPerfixSeprator); $result2 = mysql_query($Query[0]) or die("Not Create proc {$sp_name}"); echo "<pre>{$Query['0']}</pre>"; $dalMethods .= $Query[1]; } else { if ($spname == 'DeleteRow') { $sp_name = getSPName($tableName, $spname, $prefixSp, $seprator); $Query = CreateDeleteRow($tableName, $recs, $Primary, $sp_name, $lenPerfixSeprator); $result2 = mysql_query($Query[0]) or die("Not Create proc {$sp_name}"); echo "<pre>{$Query['0']}</pre>"; $dalMethods .= $Query[1]; } else { if ($spname == 'UpdateRow') { $sp_name = getSPName($tableName, $spname, $prefixSp, $seprator); $Query = CreateUpdate($tableName, $recs, $Primary, $types, $sp_name, $lenPerfixSeprator); $result2 = mysql_query($Query[0]) or die("Not Create proc {$sp_name}"); echo "<pre>{$Query['0']}</pre>"; $dalMethods .= $Query[1]; } else { if ($spname == 'Insert') { $sp_name = getSPName($tableName, $spname, $prefixSp, $seprator); $Query = CreateInsert($tableName, $recs, $Primary, $types, $sp_name, $lenPerfixSeprator); $result2 = mysql_query($Query[0]) or die("Not Create proc {$sp_name}"); echo "<pre>{$Query['0']}</pre>"; $dalMethods .= $Query[1]; } } } } } } foreach ($sps as $spname) { if ($spname == 'CreateDAL') { CreateDAL($tableName, $dalMethods); echo "<hr /><pre>Created Data Access Layer</pre>"; } } }