[STATIC] Builds a SQL INSERT statement
| public static BuildSQLInsert ( string $tableName, array $valuesArray ) : string | ||
| $tableName | string | The name of the table |
| $valuesArray | array | An associative array containing the column names as keys and values as data. The values must be SQL ready (i.e. quotes around strings, formatted dates, ect) |
| return | string | Returns a SQL INSERT statement |
/**
* Assigns a group to 1-n activities by adding entries to the cross table
* (counterpart to assign_activityToGroups)
*
* @param array $groupID groupID of the group to which the activities will be assigned
* @param array $activityIDs contains one or more activityIDs
* @return boolean true on success, false on failure
* @author ob
*/
public function assign_groupToActivities($groupID, $activityIDs)
{
if (!$this->conn->TransactionBegin()) {
$this->logLastError('assign_groupToActivities');
return false;
}
$table = $this->kga['server_prefix'] . "groups_activities";
$filter['groupID'] = MySQL::SQLValue($groupID, MySQL::SQLVALUE_NUMBER);
$d_query = MySQL::BuildSQLDelete($table, $filter);
$d_result = $this->conn->Query($d_query);
if ($d_result == false) {
$this->logLastError('assign_groupToActivities');
$this->conn->TransactionRollback();
return false;
}
foreach ($activityIDs as $activityID) {
$values['groupID'] = MySQL::SQLValue($groupID, MySQL::SQLVALUE_NUMBER);
$values['activityID'] = MySQL::SQLValue($activityID, MySQL::SQLVALUE_NUMBER);
$query = MySQL::BuildSQLInsert($table, $values);
$result = $this->conn->Query($query);
if ($result == false) {
$this->logLastError('assign_groupToActivities');
$this->conn->TransactionRollback();
return false;
}
}
if ($this->conn->TransactionEnd() == true) {
return true;
} else {
$this->logLastError('assign_groupToActivities');
return false;
}
}
}
// --------------------------------------------------------------------------
// Want to know if you are connected? Use IsConnected()
echo "Are we connected? ";
var_dump($db->IsConnected());
echo "\n<br />\n";
// --------------------------------------------------------------------------
// Now we can generate SQL statements from arrays!
// Let's create an array for the examples
// $arrayVariable["column name"] = formatted SQL value
$values["Name"] = MySQL::SQLValue("Violet");
$values["Age"] = MySQL::SQLValue(777, MySQL::SQLVALUE_NUMBER);
// Echo out some SQL statements
echo "<pre>" . "\n";
echo MySQL::BuildSQLDelete("Test", $values) . "\n<br />\n";
echo MySQL::BuildSQLInsert("Test", $values) . "\n<br />\n";
echo MySQL::BuildSQLSelect("Test", $values) . "\n<br />\n";
echo MySQL::BuildSQLUpdate("Test", $values, $values) . "\n<br />\n";
echo MySQL::BuildSQLWhereClause($values) . "\n<br />\n";
echo "</pre>" . "\n";
// Or create more advanced SQL SELECT statements
$columns = array("Name", "Age");
$sort = "Name";
$limit = 10;
echo MySQL::BuildSQLSelect("Test", $values, $columns, $sort, true, $limit);
echo "\n<br />\n";
$columns = array("Color Name" => "Name", "Total Age" => "Age");
$sort = array("Age", "Name");
$limit = "10, 20";
echo MySQL::BuildSQLSelect("Test", $values, $columns, $sort, false, $limit);
echo "\n<br />\n";
/**
* Assigns a group to 1-n group leaders by adding entries to the cross table
* (counterpart to assign_ldr2grp)
*
* @param array $grp_id grp_id of the group to which the group leaders will be assigned
* @param array $ldr_array contains one or more usr_ids of the leaders)
* @global array $kga kimai-global-array
* @return boolean true on success, false on failure
* @author ob
*/
function assign_grp2ldrs($grp_id, $ldr_array)
{
global $kga, $conn;
if (!$conn->TransactionBegin()) {
$conn->Kill();
}
$table = $kga['server_prefix'] . "ldr";
$filter['grp_ID'] = MySQL::SQLValue($grp_id, MySQL::SQLVALUE_NUMBER);
$query = MySQL::BuildSQLDelete($table, $filter);
$d_result = $conn->Query($query);
if ($d_result == false) {
$conn->TransactionRollback();
return false;
}
foreach ($ldr_array as $current_ldr) {
$values['grp_ID'] = MySQL::SQLValue($grp_id, MySQL::SQLVALUE_NUMBER);
$values['grp_leader'] = MySQL::SQLValue($current_ldr, MySQL::SQLVALUE_NUMBER);
$query = MySQL::BuildSQLInsert($table, $values);
$result = $conn->Query($query);
if ($result == false) {
$conn->TransactionRollback();
return false;
}
}
update_leader_status();
if ($conn->TransactionEnd() == true) {
return true;
} else {
return false;
}
}
function insertTableData($gpx_pg_id, $gpx_gr_id, $debug)
{
global $obj;
$obj->execute(MySQL::BuildSQLInsert('grp_page', array('gpx_pg_id' => $obj->getSqlColValue('gpx_pg_id', $gpx_pg_id), 'gpx_gr_id' => $obj->getSqlColValue('gpx_gr_id', $gpx_gr_id)), $debug));
}
