nilsteampassnet /
TeamPass
| @@ 66-82 (lines=17) @@ | ||
| 63 | ################ |
|
| 64 | ## Function permits to check if a column exists, and if not to add it |
|
| 65 | ################ |
|
| 66 | function addColumnIfNotExist($db, $column, $columnAttr = "VARCHAR(255) NULL") |
|
| 67 | { |
|
| 68 | global $dbTmp; |
|
| 69 | $exists = false; |
|
| 70 | $columns = mysqli_query($dbTmp, "show columns from $db"); |
|
| 71 | while ($c = mysqli_fetch_assoc($columns)) { |
|
| 72 | if ($c['Field'] == $column) { |
|
| 73 | $exists = true; |
|
| 74 | return true; |
|
| 75 | } |
|
| 76 | } |
|
| 77 | if (!$exists) { |
|
| 78 | return mysqli_query($dbTmp, "ALTER TABLE `$db` ADD `$column` $columnAttr"); |
|
| 79 | } else { |
|
| 80 | return false; |
|
| 81 | } |
|
| 82 | } |
|
| 83 | ||
| 84 | function addIndexIfNotExist($table, $index, $sql) |
|
| 85 | { |
|
| @@ 52-68 (lines=17) @@ | ||
| 49 | ################ |
|
| 50 | ## Function permits to check if a column exists, and if not to add it |
|
| 51 | ################ |
|
| 52 | function addColumnIfNotExist($db, $column, $columnAttr = "VARCHAR(255) NULL") |
|
| 53 | { |
|
| 54 | global $dbTmp; |
|
| 55 | $exists = false; |
|
| 56 | $columns = mysqli_query($dbTmp, "show columns from $db"); |
|
| 57 | while ($c = mysqli_fetch_assoc($columns)) { |
|
| 58 | if ($c['Field'] == $column) { |
|
| 59 | $exists = true; |
|
| 60 | return true; |
|
| 61 | } |
|
| 62 | } |
|
| 63 | if (!$exists) { |
|
| 64 | return mysqli_query($dbTmp, "ALTER TABLE `$db` ADD `$column` $columnAttr"); |
|
| 65 | } else { |
|
| 66 | return false; |
|
| 67 | } |
|
| 68 | } |
|
| 69 | ||
| 70 | function addIndexIfNotExist($table, $index, $sql) { |
|
| 71 | global $dbTmp; |
|
| @@ 49-65 (lines=17) @@ | ||
| 46 | * @param string $column [description] |
|
| 47 | * @param string $columnAttr [description] |
|
| 48 | */ |
|
| 49 | function addColumnIfNotExist($db, $column, $columnAttr = "VARCHAR(255) NULL") |
|
| 50 | { |
|
| 51 | global $dbTmp; |
|
| 52 | $exists = false; |
|
| 53 | $columns = mysqli_query($dbTmp, "show columns from $db"); |
|
| 54 | while ($c = mysqli_fetch_assoc($columns)) { |
|
| 55 | if ($c['Field'] == $column) { |
|
| 56 | $exists = true; |
|
| 57 | return true; |
|
| 58 | } |
|
| 59 | } |
|
| 60 | if (!$exists) { |
|
| 61 | return mysqli_query($dbTmp, "ALTER TABLE `$db` ADD `$column` $columnAttr"); |
|
| 62 | } else { |
|
| 63 | return false; |
|
| 64 | } |
|
| 65 | } |
|
| 66 | ||
| 67 | function addIndexIfNotExist($table, $index, $sql) |
|
| 68 | { |
|
