songplaylogs Database Table

Table: songplaylogs

Tool: Music

Fields

id INT UNSIGNED NOT NULL AUTO_INCREMENT v5

song INT UNSIGNED NOT NULL v5

visit INT UNSIGNED NOT NULL v5

added INT UNSIGNED NOT NULL v5

isdownload BIT(1) NOT NULL DEFAULT 0 v5

issample BIT(1) NOT NULL DEFAULT 0 v5

Example PHP Usage

The following php example is designed for the main folder: /

<?php
include("admin/load/nosession.php");  //Load Database Connection

$results = $mysqli->query("SELECT * FROM songplaylogs");
while ($resRow = $results->fetch_assoc())
{
 $id = $resRow["id"];  //
 $song = $resRow["song"];  //
 $visit = $resRow["visit"];  //
 $added = $resRow["added"];  //
 $isdownload = $resRow["isdownload"];  //
 $issample = $resRow["issample"];  //
}

Other Music Tables

albumaccess albumassign albums musiclinks playlistassign playlists songaccess songplaylogs songs

Home | Partnership | Testimonials

Privacy/Terms | About Us | Contact Us