next »

[perkiset]

Hey all -

A little background and then on to the problem: phpMyIDE has 2 types of requests that can be thrown from the command prompt - short and long. A short one is something simple like "show tables" or "use mydb" - essentially, the ajax request goes up to the server, gets the entire response and returns it in one big block. A long request is more like "select * from atable" because I A) have no idea how long it might take to execute the command and B) have no idea how big the response might be. So what happens is the IDE fires off a web request to itself to start processing the long request, putting responses into a table (long_responses) that are then picked up by the client at it's own pace. This decoupling of the speed of response at the server and the client's ability to retrieve data is part of what makes the command prompt work well, regardless of the length of the response.

But on to the problem: Dink let me work with his instance of phpMyIDE to see why long commands don't come back. Well what happens is the webRequest is thrown and the response is that "You are not authorized to access this page, or your browser doesn't know how to push authorization" - of course... when you go to browse Dink's phpMyIDE you have to enter a username and password.

So finally, my question: How do I send an authorization with a web request? I looked at the Authentication: header for a web request, but can't seem to get it right... I also can't tell if I will ALWAYS get a 401 and then need to respond with authentication or something... does anyone have any experience with this?

BTW: I can't use file_get_contents('username:node@domain.com:password') because of the way the apache-style multi threading works... I have to throw a raw request with webRequest. Thanks!

[nutballs]

i could tell you how to do it in ASP... 

[perkiset]

Wanker. Some help you are 

[perkiset]

TheDarkness is TheMAN.

Sees this thread, IMs me to get more data, fucking honks the answer out without breaking a sweat.

The answer: webRequest2 needed the ability to send simple authentication data in the header, the program line (which will be in the next version of webRequest2 as well as phpMyIDE)

$header[] = 'Authorization: Basic ' . base64_encode("$userName:$password");

... well, close to that... you get the idea.

Thanks TD, very much.

[thedarkness]

Any time bro.