Drop into the Deep End
by Remy Porter
in CodeSOD
on 2020-12-15
Would you like to guarantee your project ends up on this site? Antoon's employer has a surefire technique. First, hire a freshly graduated architect with no programming experience. Second, chuck them into a project in a programming language they don't know. Third, give them absolutely no supervision and no guidance or support, and watch what happens.
<?php
function copy_tables($table1, $table2, $copy, $size, $link, $action, $testOper)
{
global $link;
global $result;
global $timezone;
$result[1] = $copy;
if ($size = 'EXIST')
{
$queryz0 = "drop table if exists $table1";
$requestz0 = db_query($queryz0, $link) or error_log("copy_tables *** $table1 : Error in the execution of request z0", db_error() , $action, $testOper) . "\n";
if ($result[1] == "error")
{
exit;
}
$queryz1 = "create table $table1 LIKE $table2";
$requestz1 = db_query($queryz1, $link) or error_log("copy_tables *** $table1 : Error in the execution of request z1", db_error() , $action, $testOper) . "\n";
if ($result[1] == "error")
{
exit;
}
}
elseif ($size = 'NOTEXIST')
{
$queryz2 = "create table if not exists $table1 LIKE $table2";
$requestz2 = db_query($queryz2, $link) or error_log("copy_tables *** $table1 : Error in the execution of request z2", db_error() , $action, $testOper) . "\n";
if ($result[1] == "error")
{
exit;
}
}
$queryz3 = "insert $table1 select * from $table2";
$requestz3 = db_query($queryz3, $link) or error_log("copy_tables *** $table1 : Error in the execution of request z3", db_error() , $action, $testOper) . "\n";
if ($result[1] == "error")
{
exit;
}
}
?>
Forums
Nov 20
.jpg)
