function getMusic($id)
{
$con = new db();
$conc = $con->c();
$q = mysqli_query($conc, "SELECT music.id,music.user,music.name,music.info,music.mp3,music.dl,music.date,users.user FROM music INNER JOIN users ON users.id= music.user WHERE music.id = {$id}");
if (mysqli_num_rows($q) == 0) {
echo "({status:false,msg:'Sorry, this song cannot be found'})";
// echo "<div class='m_s_g'>Sorry, this song cannot be found.</div>";
} else {
$r = mysqli_fetch_array($q);
echo "({status:true,type:2,class:'music_m',title:'" . xtra_space($r[3]) . "',uid:'{$r['1']}',owner:'{$r['7']}',mid:'{$r['0']}',music:'{$r['4']}',mname:'{$r['2']}',mdate:'" . gtime($r[6]) . "'});";
//echo "<a href='#!/music=$r[0]'><div align='center' class='music_m' mid='$r[0]' title='$r[3]' onclick='playmusic(event);$(\"#pwindow\").fadeOut(500);' mname='$r[2]' info='$r[3]' music='$r[4]' mdate='".gtime($r[6])."' owner='$r[7]' uid='$r[1]'>$r[2]<div></a>";
}
$con->close_db_con($conc);
exit;
}
<tr><td>Video<br/>(MP4 preferred)</td><td><input type="file" class="button1" name="vid" /></td></tr>
<tr><td>Video Preview<br/><i style="font:10px Verdana;">(a picture showing a<Br/>preview of the video<br/> its should be <1MB)</i></td><td><input type="file" class="button1" name="upl" /></td></tr>
<tr><td></td><td><input type="submit" class="button1" name="add" value="Upload" onclick="ifr_done(3)" /></td></tr>
</table>
</form>
<h1 align="center" class="mh1">Edit videos</h1>
<div id="v_edit">
<table cellpadding="5" class="prof_table">
<tr>
<?php
$q = mysqli_query($conc, "SELECT `id`,`name`,`vid`,`pict`,`info` FROM videos WHERE user = {$user} ORDER BY date DESC");
$i = 0;
if (mysqli_num_rows($q) == 0) {
echo "<td class='m_s_g' align='center' style='padding:50px;'>No Content added yet.</td>";
}
while ($r = mysqli_fetch_array($q)) {
$i++;
echo xtra_space("<td><div style='background:url(" . PTH . "/prev/{$r['3']}) left;' class='vid_prev' value='{$r['1']}' title='{$r['4']}' onclick='edit_content(3,{$r['0']},\"v_info_{$r['0']}\")'>{$r['1']}<br/>{$r['4']}</div><div class='_hd' id='v_info_{$r['0']}'>{$r['0']}____{$r['2']}____{$r['3']}____{$r['1']}____{$r['4']}</div></td>");
if ($i % 4 == 0) {
echo "</tr><tr>";
}
}
$con->close_db_con($conc);
?>
</tr>
</table>
</div>
$enab = "";
if ($r[18] == $s) {
$enab = "selected='selected'";
}
echo "<option value='{$s}' label='{$k}' {$enab}>{$k}</option>";
}
?>
</select><input type="text" class="txt" onchange="fdf = true;" name="status_" onkeyup="gment(event)" style="font-size:10px;width:80px;<?php
echo $r[18] != 4 ? "display:none;" : "";
?>
" value=" <?php
echo str_replace(" _", "", $r[19]);
?>
" /><div class="pl2div" style='position:relative'></div></td></tr>
<tr><td>Quote</td><td><textarea rows="4" class="txt" onchange="fdf = true;" name="bio" onkeyup="gment(event)" ><?php
echo xtra_space($r[11]);
?>
</textarea><div class="pl2div" style='position:relative'></div></td></tr>
<tr><td></td><td><input type="submit" name="profile" value="Update" class="button1" onclick="uploading(true)" /><input type="hidden" name="aut" value="<?php
echo $aut;
?>
" /><input type="hidden" name="user" value="<?php
echo $user;
?>
" /></td></tr>
</table>
</form>
</div>
</div>
<?php
$con->close_db_con($conc);
function xtra_space($str)
{
$output = str_replace(" _", " ", $str);
//$output = str_replace(" "," ",$output);
//$output = str_replace(" "," ",$output);
$output = str_replace(" ", " ", $output);
if (stristr($output, " ")) {
return xtra_space($output);
} else {
return $output;
}
}
<tr><td>Info</td><td><textarea class="txt" name="info" onkeyup="gment(event)" ></textarea><div class="pl2div" style="top:280px;"></div></td></tr>
<tr><td>Music File<Br/>(MP3 preferred)</td><td><input type="file" class="button1" name="mp3" /></td></tr>
<tr><td></td><td><input type="submit" class="button1" name="add" value="Submit" onclick="ifr_done(2)" /></td></tr>
</table>
</form>
<h1 class="mh1" align="center">Edit music</h1>
<div id="m_edit" >
<table class="prof_table">
<tr>
<?php
$q = mysqli_query($conc, "SELECT `id`,`name`,`mp3`,`info` FROM music WHERE user = {$user} ORDER BY date DESC");
$i = 0;
if (mysqli_num_rows($q) == 0) {
echo "<td class='m_s_g' align='center' style='padding:30px;'>No Content added yet.</td>";
}
while ($r = mysqli_fetch_array($q)) {
$i++;
//title='$r[3]'
echo xtra_space("<td><div align='center' class='music_m' style='font-size:12px;' \n\t\tonclick='edit_content(2,{$r['0']},\"m_info_{$r['0']}\");' >{$r['1']}</div><div class='_hd' id='m_info_{$r['0']}'>{$r['0']}____{$r['2']}____{$r['1']}____{$r['3']}</div></td>");
if ($i % 4 == 0) {
echo "</tr><tr>";
}
}
$con->close_db_con($conc);
?>
</tr>
</table>
</div>
<tr><td>Name</td><td><input type="text" class="txt" name="name" /></td></tr>
<tr><td>Info</td><td><textarea class="txt" name="info" onkeyup="gment(event)" ></textarea><div class="pl2div" style="top:280px;"></div></td></tr>
<tr><td>Picture</td><td><input type="file" class="button1" name="upl" /></td></tr>
<tr><td></td><td><input type="submit" class="button1" name="add" value="Submit" onclick="ifr_done(1)" /></td></tr>
</table>
</form>
<h1 class="mh1" align="center">Edit picture</h1>
<div id="a_edit">
<table class="prof_table" >
<tr>
<?php
$con = new db();
$conc = $con->c();
$q = mysqli_query($conc, "SELECT `id`,`name`,`img1`,`info`,`img2`,`img3` FROM art WHERE user = '******' ORDER BY date DESC");
$i = 0;
if (mysqli_num_rows($q) == 0) {
echo "<td class='m_s_g' align='center' style='padding:50px;'>No Content added yet.</td>";
}
while ($r = mysqli_fetch_array($q)) {
$i++;
echo xtra_space("<td><input type='image' src='" . PTH . "{$r['2']}' value='{$r['1']}' title='{$r['3']}' onclick='edit_content(1,{$r['0']},\"p_info_{$r['0']}\")' /><div id='p_info_{$r['0']}' class='_hd'>{$r['0']}____{$r['2']}____{$r['4']}____{$r['5']}____{$r['1']}____{$r['3']}</div></td>");
if ($i % 8 == 0) {
echo "</tr><tr>";
}
}
?>
</tr>
</table>
</div>
