addDataParam('i', $artist_id); $addtl_artist = $wrapperObj->executeQuery($sql, $dataParams); if ($addtl_artist === false) { showierror($sql); } $lastType = ''; $additional_artist = array('similar' => array(), 'influence' => array(), 'contemporary' => array(), 'follower' => array()); if (count($addtl_artist) > 0) { foreach ($addtl_artist as $addtl_row) { $theType = $addtl_row['type']; $additional_artist[$theType][$addtl_row['id']] = $addtl_row['name']; } } $addtl_artist_types = array('similar', 'influence', 'contemporary', 'follower'); if (isset($frmSubmit)) { if (is_array($addtl_artist_ids)) { foreach ($addtl_artist_ids as $i) { $theName = trim(${"addtl_artist_$i"}); if ($theName) { $sql = 'UPDATE additional_artist_info SET name = ? WHERE id = ?'; $dataParams = new QueryData(); $dataParams->addDataParam('s', $theName); $dataParams->addDataParam('i', $i); if ($wrapperObj->executeQuery($sql, $dataParams, MysqliWrapper::RETURN_AFFECTED_ROWS) === false) showierror($sql); } else { $sql = 'DELETE FROM additional_artist_info WHERE id = ?'; $dataParams = new QueryData(); $dataParams->addDataParam('i', $i); if ($wrapperObj->executeQuery($sql, $dataParams, MysqliWrapper::RETURN_AFFECTED_ROWS) === false) showierror($sql); } } } foreach ($addtl_artist_types as $j) { $k = 1; while ($k < 11) { $theName = trim(${$j . '_' . $k}); if ($theName) { $theType = $j; $insert_query = "INSERT INTO additional_artist_info (artist_id, type, name) VALUES (?, ?, ?)"; $dataParams = new QueryData(); $dataParams->addDataParam('i', $artist_id); $dataParams->addDataParam('s', $theType); $dataParams->addDataParam('s', $theName); if ($wrapperObj->executeQuery($insert_query, $dataParams, MysqliWrapper::RETURN_INSERT_ID) === false) showierror($insert_query); } $k++; } } $msg = 'cf84d4c7'; header("Location: more_artist_info.php?artist_id=$artist_id&confirm_msg=$msg"); exit(); } ?>

Additional Artists

$name) { ?> '; $i++; } } while ($i < 11) { ?> '; $i++; }?> $name) { ?> '; $i++; } } while ($i < 11) { ?> '; $i++; }?> $name) { ?> '; $i++; } } while ($i < 11) { ?> '; $i++; }?> $name) { ?> '; $i++; } } while ($i < 11) { ?> '; $i++; }?>
Similar Artists (Artists who closely resemble this artist in sound, style, mood, etc.)
Artist
Artist
Artist Influences (Other artists who have influenced and impacted the sound of this artist.)
Artist
Artist
Artist Followers (Newer or younger artists who have been influenced by this artist.)
Artist
Artist
Artist Contemporaries (Similar artists who are recording and/or performing at about the same time period.)
Artist
Artist