0

here I have

//functions.php

<?php
session_start();

function loggedin(){
        if(@$_SESSION['username']){
            @$username = $_SESSION['username'];
            return true;
    } elseif(@$_COOKIE['username']) {
        @$username = $_COOKIE['username'];
        return true;
        }else {
            return false;
        }
}

function getuid($username) {
    $res = mysql_query("SELECT id FROM users WHERE username='$username'");
    if(mysql_num_rows($res)) {
        $row = mysql_fetch_assoc($res);
        return $row['id'];
    }
}

function getusername($uid){
    $res = mysql_query("SELECT username FROM users WHERE id='$uid'");
    if(mysql_num_rows($res)) {
       $row = mysql_fetch_assoc($res);
       return $row['username']; 
    }
}

function getsig($uid) {
    $res = mysql_query("SELECT signature FROM users_extra WHERE id='$uid'") or die(mysql_error($res));
    if(mysql_num_rows($res)) {
        $row = mysql_fetch_assoc($res);
        return $row['signature'];
    }
}


function getprofile($uid) {
    $res = mysql_query("SELECT profile FROM users_extra WHERE id='$uid'") or die(mysql_error($res));
    $row = mysql_fetch_assoc($res);
    return $row['profile'];
}
?>

When I try to call

getsig();

and

getprofile();

on the user.php it wont show up, and I cant figure it out why.
The functions seems to be allright, what can be the problem ?

//user.php

<?php
    if(@$_SESSION['username']){
            @$username = $_SESSION['username'];
    } elseif(@$_COOKIE['username']) {
        @$username = $_COOKIE['username'];
      }
      
    if($_GET['id']) {
        $uid = getuid($username);
        $username2 = getusername($_GET['id']);
        if($username2 == "") {
            echo "User does not exist.";
            exit();
        } else {
           ?>
           
           <table width="100%">
            <tr valign="top">
                <td width="10%">
                    <fieldset>
                    <legend><?php echo "Logged in as, <a href=\"index.php?act=profile&id=".$uid."\">$username2</a>"; ?></a></legend> 
                    </fieldset>
                </td>
                
                <td width="77%">
                    <fieldset>
                    <legend>Signature</legend>
                    <form action="./includes/update.php" method="post">
                    <textarea style="height: 100px;" name="ud_sig"></textarea>
                    <input type="hidden" name="ud_id" value='<? echo "$uid";?>'/>
                    </br>
                    <input type="submit" value="Add Signature" name="signature"/>
                    </form>
                    //here is problem #1
                    <?php echo getsig(getuid($username2)); ?>
                    </fieldset>
                    
                    <fieldset>
                    <legend>Profile</legend>
                    //here is problem #2
                    <?php echo getprofile(getuid($username2)); ?>
                    </fieldset>
                </td>
                
                <td width="8%">
                    <fieldset>
                    <legend>User info</legend>
                    <p>Posts: 0</p>                  
                    </fieldset>
                </td>
            </tr>
           </table>
           
           <?php
        }
    } else {
        echo "Specifica un id.";
        exit();
    }

?>
3
Contributors
2
Replies
3
Views
7 Years
Discussion Span
Last Post by urtrivedi
0

check your functions in a separte file
say test.php

<?php
include "functions.php";
echo getsig('someuid')."<br>";
echo getprofile('someuid');
?>

see whether it is giving propers output or not.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.