prefix . ‘tuenix_records’; $charset_collate = $wpdb->get_charset_collate(); require_once(ABSPATH . ‘wp-admin/includes/upgrade.php’); $sql = “CREATE TABLE IF NOT EXISTS $table_name ( id mediumint(9) NOT NULL AUTO_INCREMENT, artist varchar(255) NOT NULL, streams bigint(20) NOT NULL, rate float NOT NULL, expenses float NOT NULL, earnings float NOT NULL, profit float NOT NULL, created_at datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id) ) $charset_collate;”; dbDelta($sql); // ✅ Handle form submission $success_message = ”; if (isset($_POST[‘submit_data’])) { $artist = sanitize_text_field($_POST[‘artist’]); $streams = intval($_POST[‘streams’]); $rate = floatval($_POST[‘rate’]); $expenses = floatval($_POST[‘expenses’]); $earnings = $streams * $rate; $profit = $earnings – $expenses; $wpdb->insert($table_name, [ ‘artist’ => $artist, ‘streams’ => $streams, ‘rate’ => $rate, ‘expenses’ => $expenses, ‘earnings’ => $earnings, ‘profit’ => $profit ]); $success_message = “✅ Data saved successfully. Total Profit: $” . number_format($profit, 2); } ?>

Enter Artist Revenue Data

---

Submitted Records

get_results(“SELECT * FROM $table_name ORDER BY created_at DESC”); foreach ($results as $row) { echo ““; } ?>

Artist	Streams	Rate	Expenses	Earnings	Profit	Date
{$row->artist}	{$row->streams}	\${$row->rate}	\${$row->expenses}	\${$row->earnings}	\${$row->profit}	{$row->created_at}

Enter Artist Revenue Data

Artist Name:

Total Streams:

Revenue per Stream ($):

Expenses ($):

Submitted Data

Artist	Streams	Rate	Expenses	Earnings	Profit