Example #1
0
$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")) {
Example #2
0
$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 &raquo;</a>\n                 <a id=\"butt\" href=\"decline.php?dealid={$dealid}\">Decline &raquo;</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}";