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>