include("includes/conn.php"); $author=""; $fullname=""; if(isset($_GET['author'])) $author=$_GET['author']; $ch=""; if(isset($_GET['ch'])) $ch=$_GET['ch']; $sql="SELECT firstname, lastname, city, country, bio, active from usernames where username='".$author."'"; // echo $sql; if(!$result=mysqli_query($link, $sql)) { $msg.=" ". mysqli_error($link); } else { while($row = mysqli_fetch_array($result, MYSQLI_NUM)) { $firstname=$row[0]; $lastname=$row[1]; $fullname=$row[0]. " ".$row[1]; $city=$row[2]; $country=$row[3]; $bio=$row[4]; $active=$row[5]; } } $count=0; $height=strlen($bio); $titles=array(); $postids=array(); $psql="select title, postid, datesub from postcollection where username='".$author."' order by datesub desc"; //echo $psql; if(!$presult=mysqli_query($link,$psql)) { $msg.=" ". mysqli_error($link); } else { while($prow = mysqli_fetch_array($presult, MYSQLI_NUM)) { $titles[$count]=$prow[0]; $postids[$count]=$prow[1]; $count++; } } $desc=$fullname. " ".$title; $albums_count=0; $asql="SELECT count(*) FROM albums WHERE username = '".$author."'"; if(!$aresult=mysqli_query($link,$asql)) { $msg.=" ". mysqli_error($link); } else { $arow = mysqli_fetch_array($aresult, MYSQLI_NUM); $albums_count=$arow[0]; } //echo $bio; include('includes/metaheader.php'); ?>
"," ", $bio); //$bio=str_replace(""," ",$bio); print('