PHP Query into CURL

Question

i have a simple function, which should query the USGN number from the table and insert it into CURL request, but its giving white page...

For my bad luck i cannot provide error, its just blank page.

here is the script:

function getUSGNavatar($id) {
$usgn = mysql_query("SELECT * FROM cm_users WHERE USGN = '$usgn' AND ID = '$id'") or die(mysql_error());
return mysql_fetch_assoc($usgn);

// CURL 
$ch = curl_init('http://www.unrealsoftware.de/getuserdata.php?id='$usgn'&data=avatar');
curl_exec($ch);
if(!curl_errno($ch))
{
 $info = curl_getinfo($ch);
}
curl_close($ch);
// CLOSE function
}

Thanks for help

Something messed up with the query part i am sure, curl works okay, when ididn't used mysql worked fine.

I will rewrite Mysql into PDO, or MySQLI please dont mention it.

See link @CharlotteDunois posted, and turn on error reporting please. — kittykittybangbang
– kittykittybangbang, Commented Sep 2, 2015 at 20:52
Its turned on, but its defined in my functions.php, where there is thousand other function :/ — Marcell
– Marcell, Commented Sep 2, 2015 at 20:54
I made a new file with the function and now what i can see if undefine $usgn = mysql_query("SELECT * FROM cm_users WHERE USGN = '$usgn' AND ID = '$id'") or die(mysql_error()); return mysql_fetch_assoc($usgn); this part and remove id's and $usgn from curl thing its works fine, but i need to get that USGN number by mysql :( — Marcell
– Marcell, Commented Sep 2, 2015 at 21:05

RiggsFolly · Accepted Answer · 2015-09-02 22:11:17Z

2

You are returning i.e. return mysql_fetch_assoc($usgn); and you should not be as this will finish the function at that point.

Oh and your string building in $ch = curl_init('http://www.unrealsoftware.de/getuserdata.php?id='$usgn'&data=avatar'); also had a problem.

function getUSGNavatar($id) {
    $usgn = mysql_query("SELECT * 
                         FROM cm_users 
                         WHERE ID = '$id'");
    if ( ! $usgn ) {
        echo mysql_error();
    }
    $row = mysql_fetch_assoc($usgn);

    // CURL 
    $ch = curl_init('http://www.unrealsoftware.de/getuserdata.php?id=' . 
                    $row['USGN'] . '&data=avatar');
    curl_exec($ch);
    if(!curl_errno($ch)) {
        $info = curl_getinfo($ch);
    }
    curl_close($ch);

    // now you probably want to return something from the function
    return $info;
}

Oh and as per your request I will not nag you about the use of the deprecated mysql_ database extension, because we believe you that you will rewrite this code once its working, dont we?

edited Sep 2, 2015 at 22:11

answered Sep 2, 2015 at 21:08

RiggsFolly

94.7k22 gold badges108 silver badges152 bronze badges

Sign up to request clarification or add additional context in comments.

17 Comments

Marcell Over a year ago

exactly, now i dont get error, but i dont get my avatar so there is no url returned

RiggsFolly Over a year ago

When I run www.unrealsoftware.de/getuserdata.php?id=1&data=avatar I get u_ava/u1_4e989c1e.jpg returned. Are you sure you are using this returned information correctly. Then when I look at the url http://www.unrealsoftware.de/u_ava/u1_4e989c1e.jpg I see an image

Marcell Over a year ago

unrealsoftware.de/getuserdata.php?id=6943&data=avatar i should get back this filename back and i can insert it into <img src="unrealsoftware.de/"functionname($id)"> But right now i got nothing :S

Marcell Over a year ago

however i just tried to echo it, its still not display the filename

RiggsFolly Over a year ago

Try echo getUSGNavatar(6943); what does that return

|

Barmar · Accepted Answer · 2015-09-02 21:10:48Z

1

you're getting the blank page because of this:

id='$usgn'&data

change this to:

id='.$usgn.'&data

you're missing the "."

edited Sep 2, 2015 at 21:10

Barmar

789k57 gold badges555 silver badges669 bronze badges

answered Sep 2, 2015 at 21:09

dFine

213 bronze badges

1 Comment

Barmar Over a year ago

That will fix the syntax error, but not make the function work correctly.

Collectives™ on Stack Overflow

PHP Query into CURL

2 Answers 2

17 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

17 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related