$result = mysqli_query($dbc, $query); $row = mysqli_fetch_array($result); $name1 = "{$row['fname']} {$row['lname']}"; $username1 = $row['username']; $about1 = $row['about']; $query = "select * from follower where creator1={$of}"; $result = mysqli_query($dbc, $query); $output = ''; while ($row = mysqli_fetch_array($result)) { $query1 = "select * from creator where creatorid={$row['creator2']}"; $result1 = mysqli_query($dbc, $query1); $row1 = mysqli_fetch_array($result1); $name = "{$row1['fname']} {$row1['lname']}"; $username = $row1['username']; $about = $row1['about']; $url = calculateimage1($row['creator2']); $output .= "<li>\n <div class=\"ch-item ch-img \" style=\"background-image:url({$url})\">\n <div class=\"ch-info\">\n <h3>{$name}</h3>\n <p style=\"margin: -25px 20px;font-size: 13px; border-top: 2px solid rgba(255,255,255,0.8);\">{$about}<a href=\"profile.php?view={$row['creator2']}\">\n @{$username}</a></p>\n </div>\n </div>\n </li>"; } function calculateimage1($id) { //$imagearray=getimagesize("upload_pic/thumbnail_{$_SESSION['login_user']}.jpg"); if (file_exists("upload_pic/thumbnail_{$id}.jpg")) { return "upload_pic/thumbnail_{$id}.jpg"; } else { return "upload_pic/usericon.jpg"; } } function calculateimage() { //$imagearray=getimagesize("upload_pic/thumbnail_{$_SESSION['login_user']}.jpg"); if (file_exists("upload_pic/thumbnail_{$_GET['of']}.jpg")) {
$dbc = mysqli_connect('localhost', 'root', '', 'test') or die("error connecting to the database"); $query = "select * from hiredeal where creator2='{$_SESSION['login_user']}' and status=''"; $result = mysqli_query($dbc, $query); $hire = ''; while ($row = mysqli_fetch_array($result)) { $dealid = $row['dealid']; $creatorid = $row['creator1']; $query1 = "select * from creator where creatorid={$creatorid}"; $result1 = mysqli_query($dbc, $query1); $row1 = mysqli_fetch_array($result1); $name = "{$row1['fname']} {$row1['lname']}"; $username = $row1['username']; $about = $row1['about']; $duration = $row['duration']; $amount = $row['amount']; $url = calculateimage1($creatorid); $hire .= " <div class=\"divid\">\n <li>\n <div class=\"ch-item ch-img\" style=\"background-image:url({$url})\">\n <div class=\"ch-info\">\n <h3>{$name}</h3>\n <p style=\"margin: -25px 20px;font-size: 13px; border-top: 2px solid rgba(255,255,255,0.8);\">{$about}\n @{$username}</p>\n </div>\n </div>\n </li> \n <h1 style=\"margin-top:-20px;\">Duration:{$duration} months</h1>\n <p id=\"gist\">Amount for the duration: {$amount}<br></p>\n \n <p><a id=\"butt\" href=\"accept.php?dealid={$dealid}\">Accept »</a>\n <a id=\"butt\" href=\"decline.php?dealid={$dealid}\">Decline »</a>\n </div>"; } $query = "select * from copyrightdeal where creator2='{$_SESSION['login_user']}' and status=''"; $result = mysqli_query($dbc, $query); $buy = ''; while ($row = mysqli_fetch_array($result)) { $articleid = $row['articleid']; $dealid1 = $row['dealid']; $creatorid = $row['creator1']; $amount = $row['amount']; $query1 = "select * from creator where creatorid={$creatorid}"; $result1 = mysqli_query($dbc, $query1); $row1 = mysqli_fetch_array($result1); $username = $row1['username']; $query2 = "select * from article where articleid={$articleid}";