""){ $_SESSION["country"] = $_REQUEST["country"]; } ?>
posts profiles web search

  clear search
""){ echo '

Posts

'; $sterm = trim($_REQUEST["sterm"]); $sterm = str_replace(" ","%",$sterm); $stmt = $pdodb->prepare("SELECT titleis,seox FROM blogposts WHERE titleis LIKE CONCAT('%',:search,'%') LIMIT 10"); $stmt->bindParam(':search',$sterm); $stmt->execute(); while($i3=$stmt->fetch()) { echo ' '; echo ''.$i3["titleis"].'
'; } echo '

Profiles

'; $sterm = trim($_REQUEST["sterm"]); $sterm = str_replace(" ","%",$sterm); $stmt = $pdodb->prepare("SELECT username,verified,tfollowers,mainpic,lookingfor FROM girls WHERE lookingfor LIKE CONCAT('%',:search,'%') OR username LIKE CONCAT('%',:search,'%') ORDER BY verified desc, lastactionint desc LIMIT 10"); $stmt->bindParam(':search',$sterm); $stmt->execute(); while($i3=$stmt->fetch()) { echo '
'; if($i3["verified"] == 1){ echo ' '; } echo ''.$i3["username"].'
'.$i3["tfollowers"].' Followers
'.$i3["lookingfor"].'
'; } }else{ $stmt = $pdodb->prepare("SELECT girls.ID as ID,blogposts.titleis,blogposts.descis,blogposts.seox,girls.country, girls.mainpic,blogposts.timeposted,girls.username,blogposts.category,girls.city,blogposts.nreplies,blogposts.views,blogposts.mid,blogposts.ID as fid,nreshares,girls.verified FROM blogposts LEFT JOIN girls ON girls.ID=blogposts.mid ORDER BY blogposts.lastpushint desc LIMIT 3"); $stmt->execute(); $nrows = $stmt->rowCount(); while($i3=$stmt->fetch()) { include('newsitem.php'); } } ?> see all new
Are you new here? Signup Now '; } if($_REQUEST["next"] == ""){ $next = 0; }else{ $next = intval($_REQUEST["next"]); } if($_SESSION["country"] <> ""){ $addsql = " AND country=:country"; } $stmt = $pdodb->prepare("SELECT ID,mainpic,username,fname,accounttype,country,shortpitch,city,nbookings,nviews,teacherkeys,learnkeys,aboutme,lookingfor,stars,tfollowers,verified FROM girls WHERE 0=0 ".$addsql." ORDER BY lastactionint desc LIMIT :nextgo,15"); $stmt->bindParam(':nextgo',$next,PDO::PARAM_INT); if($_SESSION["country"] <> ""){ $stmt->bindParam(':country',$_SESSION["country"]); } $stmt->execute(); if($stmt->rowCount() == 0){ echo ' no more entries right now. We just started! :-) '; if($_SESSION["uid"] == ""){ echo ' Signup if you are new'; } } while($i3=$stmt->fetch()) { echo '
'; if($i3["mainpic"] <> ""){ echo ''; }else{ echo ''; } echo '
show profile
'.$i3["fname"].' '; if($i3["verified"] == 1){ echo ''; } echo '
'.$i3["city"].' · '.$c_codes[$i3["country"]].'
'.$i3["tfollowers"].' Followers
'.$i3["lookingfor"].'

'; } ?>

14){ ?> < Previous Next Page >